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:

Special Effects

I'm working on a film about a girl who is bitten by a werewolf at summer camp. I don't know how to do a werewolf transformation using special effects so I will need someone to do that for me. I can provide detailed instructions on how the transformation should look...

  • Fixed Price Project
  • Max $20
  • Job Expired

Make A Software Program

I'm looking for someone who can create a program for me and I need it as soon as possible. Something like a software for all my employees in our company with virtual identification card with their photos, with a list of their work like pay slip and of course with a beautiful theme...

  • Fixed Price Project
  • Max $450
  • 3 months, 4 weeks left

I Have Many Projects

I need a programmer looking for a long term business relationship. I have many projects that need to be programmed. Mainly desktop apps. I am looking for an all around good programmer.

Skills Required: c++ css java scripting
  • Fixed Price Project
  • Max $50000
  • 4 months left

Need Desired Crew For Simulation Game...

Hello Everyone here.. I want some guys for my game who have a serious passion about creating a pc simulation game. I will offer you 5% from the game revenue( after publishing the game). There will be no monthly salary. I want some serious mad guys to invest in my game...

  • Fixed Price Project
  • Max $50000
  • 2 years, 4 months left

Lotto POS Terminal Mobile Apps

Hello, We are independent IT contractors. We have a client who runs a lotto company and need the lotto POS terminal application to be designed and developed to desktop and mobile apps that must be compatible with the latest androids and smart phones iOS...

  • Fixed Price Project
  • Max $5000
  • 3 weeks, 3 days left

Looking To Build A Photo Sharing App

Im looking for developers who are able to create an app that is able to share photos similar to instagram, and also sell things similar to ebay. I would also like a rough estimate on how much the job would cost.

  • Fixed Price Project
  • Max $50000
  • Job Expired

Request Of The Creation Of The Item Data Acquisition Tool For The Amazon.ca

I would like to request you for creating the tool which can acquire the below item information while utilizing the AmazonAPI. The searching should be able to be carried out in the entire Amazon.ca categories...

  • Fixed Price Project
  • Max $120
  • 1 month, 2 weeks left

Need Desired Crew For Simulation Game...

Hello Everyone here.. I want some guys for my game who have a serious passion about creating a pc simulation game. I will offer you 5% from the game revenue( after publishing the game). THERE WILL BE NO MONTHLY SALARY. I want some serious mad guys to invest in my game...

  • Fixed Price Project
  • Max $50000
  • 2 years, 4 months left

Hard Working Senior Android Develope

No Companies, Individuals ONLY Mobile Software company that has been operating for over two years looking for a hard working senior developer to join our team. Only apply if you are looking for long term work, we want people that intend to spend at least 1 year or more with us...

Skills Required: android-app-development
  • Fixed Price Project
  • Max $10000
  • 1 year left

RoR Developer

A bit about the environment this person would work in. Our platform comprises of 3 rails apps, 1 JS app (build on Ember.js), Commercial Java App we don't have source for but tightly integrate with our main Rails app. It's definitely more complex than your regular stand-alone rails app...

Skills Required: javascript ruby-on-rails
  • Fixed Price Project
  • Max $45000
  • 1 year, 1 month left

Job Details

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