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:

Poszukiwany Developer

Dzie

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

Match Mailing -- 2

MATCH MAILING Our website is built in joomla - iproperty Www.z-yachting.com Www.golf-estates.com Clients search and select favorite properties Clients fill in their search criteria: http://www.z-yachting.com/nl/contact/blijf-op-de-hoogte Name*: 2. Address: 3. Telephone: 4. E-mail*: 5...

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

Joomla Cache CSS Problems

We are having problems with CSS on our Joomla site with either stock Joomla cache or Jotcache enabled. On some page loads the fonts do not load correctly. The template is fine, but with cache enabled occasionally something seems to upset the fonts, which results in a strange looking page...

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

Virtuemart Specialst Needed For Rounding Problem

My webshop rounds ex-VAT prices to whole numbers when imported. Ex-VAT prices like 9.49 get rounded to 9, then the VAT is calculated. Big problem for pricing ofcourse. We import the products with CSV Advanced. The problem seems to be in the calculation somewhere...

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

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

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

Facebook Marketi - Open To Bidding

(f) (f) (f) (f) (f) facebook pva, non-pva, google voice account creator & seller (f) (f) (f) (f) (f) my skype id (gvseller) (gvseller1)

Skills Required: Java , JavaScript , Joomla , JSP , Linux
  • Fixed Price Project
  • $30-$250
  • 2 days, 3 hours left

Graphic Design, Logo Design, Photoshop - Open To Bidding

Am Mr.Bilawal, Managing director of Netwin groups. In my concern, the works are undertaking such as designing, graphical designing, book design, Audio and Video Editing & handling short film too...

Skills Required: HTML , Joomla , Magento , PHP , Website Design
  • Fixed Price Project
  • $30-$250
  • 2 days, 23 hours left

Add An Audio Player To A Wordpress Theme

I would like to add an audio player to a website that should be continuously playing across page. The music should not be interrupted whatsoever during page navigation...

Skills Required: CSS , HTML , Joomla , PHP , Wordpress
  • Fixed Price Project
  • $30-$250
  • 4 days, 18 hours left

I Need Attachment In Joomla Contact Form 2.5

Hi Freelancer I need attachment in Joomla contact form 2.5 for (3 attachment field) with validation extension files upload. Maximum 1 hour. Less than $10 Comment all the code for me! because transfer to the real site. Thanks

Skills Required: Joomla , PHP
  • Fixed Price Project
  • $10-$30
  • 6 days left

Print Layout - Joomla 2.5 Template -2

hello i need that: from browser file->print the layout of the print page must be www.itlavori.eu/messaggero/messaggero_ok.pdf This is the site: http://messaggeromarittimo.com/de/ thanks PS Fast delivery!

Skills Required: CSS , Joomla , PHP
  • Fixed Price Project
  • $30-$250
  • 6 days, 15 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