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:

Create A Joomla Extension For A Hockey Pool

I need to; -Create Teams -Add 12 players by team (2 type of players) -Once the team created the we need to be able to add the player's points by someone with manager rights -The players points have points attributed (ex; 1 goal = 2 pts, 1 assist = 1 pts and the goalie have a point system too) -I

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

Twitter Module For Joomla!

I need a working twitter module for Joomla, have one but it does not work as well and keeps falling out alot. I just need it to work and look professional in theme with the website.

Skills Required: Joomla
  • Fixed Price Project
  • £20-£250
  • Job Expired

Search Function ( Select Boxes For Online Shop In Joomla) & URL-redirection

Hi there, i have posted before the same project. I'm reposting it again, because there was missing some information. i need someone who can make A) professional search select boxes for a online shop, which was created in joomla. This has to be done as fast as possible (3-4 days)...

Skills Required: CSS , eCommerce , HTML , Joomla , PHP
  • Fixed Price Project
  • €50-€250
  • Job Expired

Finish Off Website

Hi. I am looking for someone to finish off my website as i dont have time to do so. What i have done. Installed Joomla Setup pages Created contact form this is only a 4 page basic site What i need to do is: Adjust items to layout fix up anything that isnt right (alignment, boxes etc)

Skills Required: Graphic Design , HTML , Joomla , PHP , Website Design
  • Fixed Price Project
  • $10-$30
  • Job Expired

Joomla Authentification Using API

I want to create a gaming community that will use Joomla 3, Kunena, and Alphauserpoints components. As template I'll use Purity III. What I need from you is to create a CMP(or modify the one attached to this project) that will use the Steam API to register users...

  • Fixed Price Project
  • $30-$250
  • Job Expired

Convert A Joomla Website To Wordpress

Looking to convert/migrate an existing client site from Joomla 2.5 (2,600 articles) to Wordpress 3.2 - essential to maintain navigation, url link structure, banners and images. A wordpress site with the same template design will already have been created and installed...

Skills Required: Joomla , MySQL , PHP , Wordpress
  • Fixed Price Project
  • $1500-$3000
  • Job Expired

Caspio Development - Linking Joomla And Caspio

I have a joomla website for employees only, i need to be able to pass the user_ID parameter through to caspio so i can link forms to the logged in user

Skills Required: JavaScript , Joomla
  • Fixed Price Project
  • $30-$50
  • Job Expired

Additional Functionality For Pre-Order Component.

PROJECT DESCRIPTION We have a Joomla restaurant pre-order component that requires some additional functionality. Currently Admin creates a party, and the system automatically emails the Party Leader a username and password to create and amend the guest's orders...

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

Looking For Joomla! Pro (need Help Every Time)

Hi there. I have a few websites which are installed with Joomla! 2.5/3.3 and I need every time help for CSS edition, installation of components and modules. Also improvement of these. Best Regards, Hakan

Skills Required: CSS , HTML5 , Joomla , jQuery/ Prototype
  • Fixed Price Project
  • €6-€12
  • Job Expired

Make Joomla 1.5 Component Work On 2.5 And 3.0

hello all i have a component that is free to use but it was built for joomla 1.5 and i want to use it on joomla 2.5 & 3.0 i will pay after you make it work and i test it

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

Job Details

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