Import problem - FIXED! - Was a limit of the shared hosting package

5 posts by 3 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: July 19, 2010   (RSS)

Re: [8bit Gamer] Import problem (Is there maybe a total max limit of images that can be imported to the database?)

By Jason - July 12, 2010

Hi Paul,

That's a strange one. I can definitely look into this for you. If you could email me your CMS Builder Login Details and your FTP information to jason@interactivetools.com I can take a look.

Also, if you could tell me where I could find the original CSV and ZIP files that you were using for testing, I can see if I can replicate the problem on our internal sever.

Please only email this information, don't post it to the forum.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Import problem (Is there maybe a total max limit of images that can be imported to the database?)

Hi Jason,

Wall of text has been emailed! [crazy]

Thanks

Paul

FIXED! - Update

By gadefgaertgqe - July 19, 2010 - edited: July 19, 2010

First of all thanks goes to Jason @ Interactive tools for jumping on this so quick and helping me diagnose the problem. Quality service as always!

As for the problem.....

We were hitting the max execution time of the PHP script. This issue was a limitation of our shared hosting package on 1&1, which has a execution timeout of 30 seconds by default. This value could not be changed on the shared hosting package we were on. The reason for that was so that our scripts would not affect other websites hosted on the same server, by taking up processing time and slowing it down.

Over the weekend we upgraded to our own dedicated server, with that we were able to increase the execution time and everything worked great!

For those of you who maybe having a similar problem this piece of code may help if you are not getting any errors back from the server (which is what was happening to me). Error reporting is disabled by default on 1and1, and after some research I found that creating a file called php.ini and placing in the same folder as my import script, with the following code:

[MySQL]
mysql.trace_mode = on

This then gave me the errors which pointed to the problem. The error was this:

Fatal error: Maximum execution time of 30 seconds exceeded in [the last bit here will refer to the PHP file that you are executing and the line number in that file]

Hope this helps someone :)

Paul

Re: [8bit Gamer] FIXED! - Update

By Donna - July 19, 2010

Hi Paul,

That's great! Glad to hear you were able to track down what was going on there, thanks for sharing your solution!
Donna

--
support@interactivetools.com