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:

C/C++/Java Trainer/Professional

Bhavya InfoTech Hiring Trainer/Software Engineers (Fresher/Experienced) Salary Offered : Best in the Industry Last Date of Apply : 23rd February 2013 Job Role : Trainer / Software Programmer Qualification : Tech Graduate / Post Graduates (BE/BTECH/MCA) Skills : Strong programming skills..

Skills Required: c++ java .net training
  • Fixed Price Project
  • Max $140
  • 3 weeks, 2 days left

Creating A New MMORPG - Need Workers (URGENT).

Basically, I need help making the mmorpg (as i can't make it myself and im looking for some workers to be part of the company:) ). Like making the models, enviroments, site, coding etc. And when the game gets profit, i will give some of the profit for whoever is working in the company...

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

Highly Skilled IOS Or Android Designed

Need a custom mobile app made quickly I need someone who is very experience in coding for iOS or Android to créate a feature rich, nice looking, mobile app. I need an app about a videogames/bar, I mean an app which provides information to the costumer about events, location, promotion etc....

Skills Required: basic cocoa objective-c
  • Fixed Price Project
  • Max $500
  • 5 years, 3 months left

I Have Many Projects, In Need Of A Programmer.

I have many projects in general, web apps, desktop apps, website creation etc. I need a programmer that is skilled in many things. *****You MUST have access to a bank account WITH ONLINE BANKING!!!** I cant stress that enough because some of my work will require readily access to a bank account with

  • Fixed Price Project
  • Max $50000
  • 3 weeks, 1 day left

Creating A New MMORPG - Need Workers/ Partners (URGENT).

Basically, I need help making the mmorpg (as i can't make it myself and im looking for some workers to be part of the company:) ). Like making the models, enviroments, site, coding etc. And when the game gets profit, i will give some of the profit for whoever is working in the company...

  • Fixed Price Project
  • Max $5
  • 2 years left

The Making Of A Great Idea (I Think)

Hi! I am an 22 year old real-estate student from Norway and I have an idea for an application for Android/iOS. I do not have a technical backgroud, none experience from making apps, neither do I have the money to invest in this idea...

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

SQL/Dextrity Programmer

Microsoft Dynamics Great Plains installation and support knowledge. Troubleshooting knowledge in Dextrity programming SQL Programing is a must SSRS (SQL server Reporting service) Implementation knowledge Crystal report knowledge Great Plains 2013 Web Client implementation...

  • Fixed Price Project
  • Max $4000
  • 5 years, 7 months left

Looking For Mobile Application Submitters/Uploaders!

Do you have a developer account at iTunes, Google Play, and Windows? Do you want to partner with a new startup application design service and earn money to help us get our users applications uploaded to these marketplaces? Then we need you! Our users generally don't have time to set up user..

  • Fixed Price Project
  • Max $120
  • 2 months, 1 week 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
  • 7 months, 2 weeks left

Full-time App Developer - IOS, Android, Cocos 2D, And Corona A Must!

Eagle App Company is looking for a full-time developer with the capability of building robust and smooth running applications that don't break. If you think you are that person, please send us your resume...

  • Fixed Price Project
  • Max $1500
  • 3 months, 3 weeks left

Job Details

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