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->_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:

Windows Automation Expert C#, Java, OOP

:::::::READ FULL AD, ATTENTION TO DETAIL IN UNDERSTANDING THE REQUIREMENTS LISTED IS KEY TO MOVING FORWARD TO ACQUIRING THIS POSITION:::::: I am looking for someone who can develop a series of automated processes on a windows machine...

Skills Required: c# java oop ftp
  • Fixed Price Project
  • Max $5
  • 4 years, 6 months left

German Speaking Project Manager In Vietnam

Hi, we are looking for a german speaking project manager in vietnam to work at the location of our software development team in vietnam. Your job will be to clarify tasks with customers and discuss directly with the team to get the software development jobs done. Please send your CV to us. Thanks T

Skills Required: german project-management
  • Fixed Price Project
  • Max $800
  • 1 year, 2 months left

This Is A Request For Any Plugin In Makers

I am useing the script this script is a good script ,there or lots of people useing this script ,but only a few mods...

Skills Required: php forum-posting
  • Fixed Price Project
  • Max $10
  • 6 months left

Html5 App

Program a html5 app with one button. When you click on the button a random sound will play. The sounds are inside the app - not streaming. The name of the sounds can be named fx sound1, sound2, sound3. I will rename, when I get the code. I have made the design - I only need the code.

Skills Required: html5
  • Fixed Price Project
  • Max $100
  • 4 years, 7 months left

Automated Email / Texts / Phone Call+Voicemail Reminder Software

This project is to build appointment confirmation software - Make a website button like this: - When you click it, it leads to a page like this: - That page would also have this:

  • Fixed Price Project
  • Max $3000
  • 4 years, 8 months left
  • Fixed Price Project
  • Max $360
  • 4 years, 9 months left

Two Peas Mobile App

I have no app creation skills, but have an idea of what I need. I need to know if it can be done, how much it could cost, and if you want to be involved and split the cost and profit. My app is related to Match...

Skills Required: mobile-app-development
  • Fixed Price Project
  • Max $100
  • 5 years left

Indie Gaming Company Looking For People/teams To Join Us

We are currently planning for 1 game as of now, and are need of experience team or people that are willing to join a team and work together. You will be working with 3D modelling/Sound, all that good stuff...

  • Fixed Price Project
  • Max $500
  • 10 months left

(Hiring) Senior Programmers

(1) Minimum four (4) years experience in developing multi-tier applications. (2) Minimum four (4) years experience in performing complex database queries, data conversion and data analysis...

  • Fixed Price Project
  • Max $50000
  • 3 days, 21 hours left

Mobile Applications Developer (Android/iOS/Cross-Platform Solutions)

Responsibilities: Mobile applications development in the team of highly skilled professionals. Requirements: Knowledge of the English language (at least intermediate level). Experience in mobile applications development will be a plus for team work...

Skills Required: java objective-c python ruby
  • Fixed Price Project
  • Max $1111
  • 1 week left

Job Details

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