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:

Fix My Payment Gateway "Its Joomla Based Website"

Hello, its joomla based website. I have a website. I am using Credit card moneybookers payment gateway . That mean if client select credit card moneybookers option then client can pay from his credit card to my moneybookers . But My problem is . This gateway is not working fine.. I will send u more

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

Search Speedup On Joomla Component

I have a joomla website with music component custom built ......

Skills Required: Joomla , MySQL , PHP
  • Fixed Price Project
  • $2-$8
  • Job Expired

Joomla Template And Logo For Travel Guide Website

I am looking for someone who can deliver a Joomla template and logo for a Travel guide website...

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

Jomsocial, Jreviews And Appointment Booking Pro Config

This project is for Saginfotech: 1. Integrate Jreviews with Jomsocial so that Jomsocial profile types Vp1 thourgh Vp5 are available to be reviewed. Create accordion in Jomsocial vendor template. Only Jomsocial profile types mb1 and mb2 or members who sign up to site, can review. 2...

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

Retoques En Página Web Realizada En Joomla

Hola! Estamos buscando un programador / diseñador para realizar cambios en el diseño de una web realizada con joomla. Las especificaciones finales serán entregadas una vez elijamos al freelancer.

Skills Required: CSS , HTML , HTML5 , Joomla , Website Design
  • Fixed Price Project
  • €12-€18
  • 5 hours, 53 minutes left

Update Joomla Installation On Website - Repost

I require the Joonla installation on my website to be upgraded to the latest version. This will be a straight forward job for someone who knows how to work in Joomla.

Skills Required: Joomla
  • Fixed Price Project
  • $30-$250
  • 14 hours, 42 minutes left

New Joomla Component

I have a site based on Joomla / Yootheme. I need a custom component / search module etc to sort / view / add / edit / print / suspend used vehicles, front and backend with the option to load new vehicles individually and via csv and allow customers to compare / shortlist...

Skills Required: AJAX , CSS , HTML5 , Joomla , PHP
  • Fixed Price Project
  • $300-$950
  • 2 days, 13 hours left

Joomla Website Setup Like Fiverr.com

I am building a website like www.fiverr.com but only for technical type work with a fixed price of $250. I want this to be a simple and easy-to-use site so buyers and sellers can agree on a project with just a few clicks. I have a basic Joomla 2...

  • Fixed Price Project
  • $250-$750
  • 3 days, 17 hours left

Cargo Tracking System

DELIVERABLES: - Tracking System to track status of shipments. - To be integrated into Joomla 3.X. - Track Shipment function to track status of shipments based on Bill of Lading number. - Responsive layout for the tracking result. *****DETAILS****** Add Shipment Inputs: Bill of Lading No...

Skills Required: AJAX , CSS , HTML5 , Joomla , PHP
  • Fixed Price Project
  • $30-$250
  • 3 days, 15 hours left

Create Joomla 2.5 Website For Mobile Devices

We have a Joomla 2.5 website here: http://tinyurl.com/n7h3rxj We require this website template to be mobilized for all common mobile devices similar to the design here: http://tinyurl.com/mcxqv6

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • $30-$250
  • 6 days, 5 hours left

Job Details

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