Dibatalkan

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 [url removed, login to view] and Virtuemart 1.1.8.

On live site, in [url removed, login to view] 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 [url removed, login to view], 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:\xampp\htdocs\ciux\administrator\components\com_b2bimport\scripts\[url removed, login to view] 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:\xampp\htdocs\ciux\libraries\joomla\database\database\[url removed, login to view] on line 239

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\ciux\libraries\joomla\session\storage\[url removed, login to view] on line 82

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\ciux\libraries\joomla\session\storage\[url removed, login to view] on line 51

**************************************************************

then I make this changes in [url removed, login to view], 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:\xampp\htdocs\ciux\libraries\joomla\database\database\[url removed, login to view] 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.

Kemahiran: Joomla, MySQL, PHP, Kejuruteraan Perisian, Virtuemart

Lihat lagi: virtuemart fatal error memory, fatal error memory joomla, import mysql fatal error memory, memory xampp joomla, fatal error memory virtuemart, fatal error memory xampp, memory mysql xampp, php fatal error memory allocated mysql, memory virtuemart, xampp mysql import, web programer job, this error, programmer on line, programer need a job, php programmer laptop, php programer joomla, on line supplier, mysql database buy, maximum problem, i want help from programer

Tentang Majikan:
( 0 ulasan ) Novi Vinodolski, Croatia

ID Projek: #1512820

11 pekerja bebas membida secara purata $63 untuk pekerjaan ini

toinnisfree

quick pro help. ftp and escrow required.

$100 USD dalam 2 hari
(554 Ulasan)
7.9
sureshdevi

I can fix these two bugs in your import script for importing supplier. I can complete this work in 2 days. Thanks, Suresh

$54 USD dalam 2 hari
(507 Ulasan)
7.3
samitXI

Kindly check your inbox. Thanks

$100 USD dalam sehari
(56 Ulasan)
5.9
webmagics

Can fix it right now. Thanks

$80 USD dalam sehari
(42 Ulasan)
5.9
inspire007

hi...please check PM..thank you

$30 USD dalam 0 hari
(67 Ulasan)
5.9
dracco

let me help you in this project. I've completed similar projects in similar enviroments (check my reviews to see my work). I'm ready to start right away and complete your project in a short time. Dracco.

$100 USD dalam sehari
(135 Ulasan)
5.9
virusvi2

please check PM

$79 USD dalam 0 hari
(67 Ulasan)
5.5
ViliusSutkus

Hi. Details in PM.

$45 USD dalam sehari
(14 Ulasan)
4.7
mcam1551

Hello. I have reviewed the errors on your site. Please check your messages for details.

$100 USD dalam 0 hari
(3 Ulasan)
2.3
jimmyst

There are only two ways to solve this :) Ready to help

$30 USD dalam sehari
(1 Ulasan)
1.2
Dreamworker01

Sir Ready to start now

$30 USD dalam sehari
(0 Ulasan)
0.0
amanan

MySQL administration error I can solve easily.

$50 USD dalam sehari
(0 Ulasan)
0.0