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:

Champagne In Joomla -- 2

A New website for an existing High Profile GoGo Bar in Pattaya Thailand. Please ignore this project if you are morally offended by stunningly beautiful scantily clothed girls as this is the subject matter of their business here...

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

Help On Joomla Site(s)

Hello, I am looking at creating a relationship with a developer to assist with my clients needs on web building. I prefer to have clients update the content once the site if finished, so a CMS like Joomla or WP are my preference...

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • $8-$15
  • 7 hours left

Joomla Help Needed

Ive recently installed joomla, instalation went ok , ive acquired a template, installed it ok, it appears in template manager, but the site is blank (white, no code, nothing). I need help in setting it up, and as a separate job, guidance to modify the template.

  • Fixed Price Project
  • $10-$30
  • 21 hours, 55 minutes left

Build A Website Into Joomla Cms

Hi all, I am looking pro developer joomla to built new website asap. more details I will to discuss freelancer who i choose. My budget from 100 to 200 SGD. regards,

Skills Required: HTML , Joomla , PHP , Website Design
  • Fixed Price Project
  • $100-$200
  • 1 day, 22 hours left

Create A Joomla Template

We are a web design company looking for a skilled freelancer we can build an ongoing relationship with. We have a couple of projects in the pipeline and if things work out there will be plenty more in the future...

Skills Required: CSS , HTML , Joomla , PHP
  • Fixed Price Project
  • Min $50
  • 2 days, 1 hour left

SobiPro Templates, XML & CSS Skills Needed -- 2

I am looking to hire someone urgently to do some CSS and xml work on my Joomla site. Its an interesting site to say the least. :) I am using SobiPro, with SobiTemplates Biz, linked to a jomsocial community,I need you to have knowledge of all the these in some way...

Skills Required: CSS , Joomla , Website Design , XML
  • Fixed Price Project
  • $10-$30
  • 3 days, 13 hours left

Build The Same Website As Shown

Please read the whole content below carefully. Read through remarks from our previous freelancers who have worked with us. We need you to do the following: 1. Build the same website as shown http://www.aomevents.com/ANS2014 (but we dont want the codes to be copied) - No plagiarism please...

Skills Required: HTML , Joomla , PHP
  • Fixed Price Project
  • $30-$250
  • 3 days, 22 hours left

Joomla Template Coding - Long Term

looking for a long term freelancer to build joomla templates + some other work on joomla: content adding, sometimes development also template design (if possible)

Skills Required: Joomla
  • Fixed Price Project
  • €2-€6
  • 4 days, 7 hours left

Looking For A Joomla, Dj-classifieds, Virtuemart Expert - Building Website

I am looking for somebody for a longer term cooperation. I have some projects. First I need some repair on a virtuemart store. Second I have a half ready project with joomla and djclassified component to build a classifieds portal. And some other projects later. I want to look your references..

Skills Required: Joomla , PHP , Virtue Mart , Website Design
  • Fixed Price Project
  • $30-$250
  • 6 days, 16 hours left

Create A Website

need someone to create me a website using Joomla, and guide on how the website was created in a word document. please message for more information, thanks.

Skills Required: Graphic Design , Joomla , Website Design
  • Fixed Price Project
  • £10-£20
  • 6 days, 16 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