MySQL Fatal Error: Out Of Memory, When Using One Script

Hallo all,

I have Web Shop (8000 articles) and recently we buy one additional B2B script.
This B2B script have job that import every day items from our supplier to our web shop automatically, in one time, 8000 articles.
This import we make every day manually on 09:00h in the morning and this job is only 10min (maybe less).

This script have problem to work, from 3 times, he succeed one times to import (we are on shared server). Server have some limitation.
We complain to hosting company, and they transfer our web to another server, also shared. And now B2B script do not wok at all.

Programmer which build this script do not know why is not importing, on the same server exist another site, with the same B2B script, which working good (programmer tell me). I want to help my programmer and me, but I do not know how.

Inside this B2B script, we have two different supplier from where we make import articles manually.

That I make shorter as possible.
We have Joomla 1.5.25 and Virtuemart 1.1.8.
On live site, in PHP.INI is disabled Error Display and is hard to see why is not importing.
Then, I install server locally on my laptop, and make enable error display in php.ini, and discover this:

When I try to import articles from my first Supplier A, after 3 seconds I receive this error:

**************************************
Fatal error: Call to undefined function curl_init() in C:xampphtdocsciuxadministratorcomponentscom_b2bimportscriptsasbis.php on line 42
**************************************

when I try to make import of second supplier B, after click on import button, I wait for import 3 minutes and then he report this:

***************************************************************
Fatal error: Out of memory (allocated 42467328) (tried to allocate 9437164 bytes) in C:xampphtdocsciuxlibrariesjoomladatabasedatabasemysqli.php on line 239

Fatal error: Maximum execution time of 30 seconds exceeded in C:xampphtdocsciuxlibrariesjoomlasessionstoragedatabase.php on line 82

Fatal error: Maximum execution time of 30 seconds exceeded in C:xampphtdocsciuxlibrariesjoomlasessionstoragedatabase.php on line 51
**************************************************************

then I make this changes in php.ini, increase from 30sec. to max_execution time = 600 (recomandation of my programer),

try again to import, and now I wait 5 minutes, and server report this:

************************************
Fatal error: Out of memory (allocated 42729472) (tried to allocate 9699308 bytes) in C:xampphtdocsciuxlibrariesjoomladatabasedatabasemysqli.php on line 239
************************************

now without maximum execution time error, but also not work.

In Joomla, this line 239 is this:

*********************************
function query()
{
if (!is_object($this->_resource)) {
return false;
}

// Take a local copy so that we don't modify the original query and cause issues later
$sql = $this->_sql;
if ($this->_limit > 0 || $this->_offset > 0) {
$sql .= ' LIMIT ' . max($this->_offset, 0) . ', ' . max($this->_limit, 0);
}
if ($this->_debug) {
$this->_ticker++;
$this->_log[] = $sql;
}
$this->_errorNum = 0;
$this->_errorMsg = '';
$this->_cursor = mysqli_query( $this->_resource, $sql ); // this is that line 239

if (!$this->_cursor)
{
$this->_errorNum = mysqli_errno( $this->_resource );
$this->_errorMsg = mysqli_error( $this->_resource )." SQL=$sql";

if ($this->_debug) {
JError::raiseError(500, 'JDatabaseMySQL::query: '.$this->_errorNum.' - '.$this->_errorMsg );
}
return false;
}
return $this->_cursor;
}
************************************

Now, this is two problem which need to repair.
Thank You in advance.

Search All Jobs:

Transfer Product From A Virtuemart To A Virtuemart Site

I like someone to transfer all the products from a Joomla site to a new installation of a Joomla site... The old site is Joomla [url removed, login to view] and Virtuemart 1.1.3 stable to Joomla [url removed, login to view] and VirtueMart 2.6.6 I like to transfer all the products (with the photos)

Skills Required: Joomla , Virtue Mart
  • Fixed Price Project
  • $30-$250
  • Job Expired

2 Tasks In My Site

Required to operate the k2 component of my site without the name of the URL is displayed (component / k2 and? Itemid ..) The English home page has an image disorganized also have to put right. Attached pictures to understand.

Skills Required: Joomla , MySQL , PHP
  • Fixed Price Project
  • $10-$30
  • Job Expired

PSD To Joomla Template -- 2

I am looking for somebody who can convert PNG files to a responsive Joomla template. The template must be pixeltrue, the pages; frontpage, product page, contact page, blog page the other pages follows the design. The template must be in all module positions dynamic. Attached only the frontpage.

Skills Required: CSS , HTML , Joomla , PHP , XML
  • Fixed Price Project
  • $30-$250
  • Job Expired

Joomla 3 With K2Store As Catalog.

- need a responsive Joomla 3 site with K2 Store only as catalogue for now, (registered users see price, but shopping capabilities will be available in the future) - layout pages (intro, category page, product page ) all designed, just need to adapt to joomla framework...

Skills Required: Graphic Design , HTML , Joomla , PHP , Website Design
  • Fixed Price Project
  • €30-€250
  • Job Expired

Joomla Template Needed "

We need a Joomla template done based on a mockup The successful candidate must know how to set-up joomla on a web server as well as create error free CSS/XHTML joomla templates that can be edited via joomla. Must be Clean coded and Uploaded Quick turn around is required, if successful applicant do

Skills Required: Joomla
  • Fixed Price Project
  • $30-$250
  • Job Expired

Migrate From Joomla 1.5.22 To Joomla 3 Site

Migrate Joomla [url removed, login to view] site to a Joomla 3 site. It must work perfectly. If you do an exception job there will be further work available. Time wasters with no previous experience or without positive feedback need not apply.

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • $10-$30
  • Job Expired

Georeferenciacion De Poligonos Y Puntos En Joomla

Requiero graficar dentro de un mapa de google, los poligonos y los puntos dentro de los poligonos de las coordenadas que tomo en campo con el GPS, y hacer que esta informacion se pueda exportar a KML, KMZ, Shape File y CSV. La informacion debe ser compatible con las principales aplicaciones de GIS,

Skills Required: Cartography & Maps , Geolocation , GPS , Joomla , PHP
  • Fixed Price Project
  • $30-$250
  • Job Expired

Customize Joomla Templates And Extension

This project is to install and customize a commercial Joomla template for Joomla 3. In addition, we require a calendar and events extensions to be installed. Commercial template will use Vertex framework. Calender and events modules are required to list events we will be informing our users.

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • $250-$750
  • Job Expired

2 Sided Marketplace

Hi, I am wanting to develop a website that allows two sides of a market to upload their own profiles. This data must be managed by Joomla (or similar) and be in French and English (initially)...

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • $10-$1000
  • Job Expired

Joomla : Fixes And Updates To Custom Payment Plugin For Akeeba Subscriptions - Repost

We need some changes made to a custom payment plugin which has been created for Akeeba Subscriptions. The plugin is working for one subscription level but now needs some additional changes made to allow it to work with a second subscription level...

Skills Required: Joomla , PHP
  • Fixed Price Project
  • £20-£250
  • Job Expired

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • $30-$100
  • Start Date
  • 03/19/2012 08:42:52 AM
  • Job Status
  • Job Expired