Kryptronic Software Support Forum

daviat · 08-14-2009 22:21:45

Hi . . .

I am trying to backup my product database in the CCP6 admin but I am timing out. Please see below.

Warning: All Raw Database Admin functions are unguided. Deletion of and changes to system data, tables and table columns can result in making this software inoperable. Be careful.

Fatal error: Maximum execution time of 120 seconds exceeded in /home/vg001web00/52/28/2002852/web/khxc-private/core/KHXC_BackEnd/ext/rawdb.php on line 3875

It is a large file, perhaps 4mb. How can I increase the execution time and will that help?

thanks,
Daniel

cyberws · 08-15-2009 09:09:48

The PHP execution time is set by the php.ini file with the following variable "max_execution_time". If you have a VPS or dedicated server you can change this however if you are on a shared hosting plan you will have to speak to your host. If you have access to SSH you can perform a database dump from there which won't be limited to PHP execution time since you won't be using PHP.

daviat · 08-30-2009 13:03:16

I talked to hostway and they set it to 1200 but I am still getting the error bwlow. It is still reading 120 seconds.

Fatal error: Maximum execution time of 120 seconds exceeded in /home/vg001web00/52/28/2002852/web/khxc-private/core/KHXC_BackEnd/ext/rawdb.php on line 3875

Now . . . do I need to go into home/vg001web00/52/28/2002852/web/khxc-private/core/KHXC_BackEnd/ext/rawdb.php and make that change also?

thanks,
Daniel

daviat · 08-30-2009 13:11:58

Hostway increased the max execution to 3000 and the max upload and download to 10mbs. but I am still getting the same error stating 120 seconds. Is it a thing with the rawdb.php file? Something that needs to be changed?

Can I download the prod file another way if the admin is having trouble with it? The file is 5mb. 10,000 products.

thanks,
Daniel

Last edited by daviat (08-30-2009 13:16:11)

Dave · 08-30-2009 13:18:51

That timeout is coming from the SQL connection and it's again something only Hostway can change for you. If you have access to phpMyAdmin you might try getting it that way instead though, under the covers, it's going to be doing pretty much the same thing as CCP does.

daviat · 08-30-2009 13:28:24

How do I change the SQL connection time since I need to translate that to Hostway. One of your guys told me it was the PHP.ini that was causing the trouble.

Daniel

Dave · 08-30-2009 13:59:36

I honestly don't know. I went on a hunt for it myself not long ago after running into the same error you are seeing but could never find it There are about 14.2 bazillion options that may be configured in MySQL but I couldn't put my finger on the right one apparently.

daviat · 08-30-2009 14:04:35

Can hostway do it for me? I tried exporting the prod file as a csv in Hostway's phpmyadmin and it is a total mess. I like the formating that your admin produces. Can I export sections at a time?

Daniel

Last edited by daviat (08-30-2009 14:07:17)

Dave · 08-30-2009 15:28:59

Exporting as a CSV using phpMyAdmin shouldn't be any different than exporting from CCP as a CSV Daniel. The export allows you to specify selection criteria so yes, you could do it sections at a time.

daviat · 08-30-2009 15:50:42

Can I send you what I got so you can take a look?

Dave · 08-30-2009 16:22:23

Errr, to what end sir? How it gets produced depends on what CSV option you choose in phpMyAdmin when exporting. The plain CSV option gives you all of the choices necessary to produce the same CSV that CCP would produce.

daviat · 08-30-2009 16:51:54

I set it for "CSV Excel" and it fixed it in the esport. For some reason just setting it for a basic CSV export didn't work for me.

thanks for the help,
Daniel
DDG

Last edited by daviat (08-30-2009 16:56:04)

JayCR48 · 12-17-2010 15:48:30

core-private/core/CORE/core.php line 971 might to have something to do with this. Definately check with Dave, Jon, Nick or one of the other smart guys.

Last edited by JayCR48 (01-28-2011 17:17:18)

Kryptronic Software Support Forum

#1 08-14-2009 22:21:45

Can't export my product db

#2 08-15-2009 09:09:48

Re: Can't export my product db

#3 08-30-2009 13:03:16

Re: Can't export my product db

#4 08-30-2009 13:11:58

Re: Can't export my product db

#5 08-30-2009 13:18:51

Re: Can't export my product db

#6 08-30-2009 13:28:24

Re: Can't export my product db

#7 08-30-2009 13:59:36

Re: Can't export my product db

#8 08-30-2009 14:04:35

Re: Can't export my product db

#9 08-30-2009 15:28:59

Re: Can't export my product db

#10 08-30-2009 15:50:42

Re: Can't export my product db

#11 08-30-2009 16:22:23

Re: Can't export my product db

#12 08-30-2009 16:51:54

Re: Can't export my product db

#13 12-17-2010 15:48:30

Re: Can't export my product db

Board footer