Problem Front shop not loading after importing combinations

[bigyiin]

I have came accross a problem building my shop. I Prestashop installed on localhost and running via Xampp, and have successfully uploaded 1606 products however when i upload my combinations csv everything seems to be fine on the back office. there are no errors returned the csv upload is successful and i am able to visit the product links separately and see that the products now show the appropriate options. but there is a problem somewhere as I am no longer able to browse to the shop homepage. 

The back office is fine. 

 

I turned on error reporting and was returned the below error. 

 

Fatal error: Maximum execution time of 30 seconds exceeded in Z:\XAMPP\htdocs\prestashop\classes\db\DbPDO.php on line 91

 

I have already tried regenerating the htaccess file

 

Can anyone advise me how to fix this problem?

 

Bellow is the php.info pertaining to PDO

 

 

PDO PDO support enabled PDO drivers mysql, sqlite
pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.8.3.1

 

[NemoPS]

Well, as the error says you are reaching the max execution time. Do you have any third party module in the homepage? even if you increase the exec time I doubt you want customers to wait more than 30 secs to see your homepage!

[bigyiin]

Well, as the error says you are reaching the max execution time. Do you have any third party module in the homepage? even if you increase the exec time I doubt you want customers to wait more than 30 secs to see your homepage!

 

Hi Nemo, I managed to fix this. it was basically a resource issue on my machine. so i done some pc maintenance and cleared cache's etc. 

 

Also want to say thanks for posting this video. http://blog.arvixe.com/prestashop-migration-local-to-live/ it has really made things a millions times easyer and faster using this method to update my site. 

 

1. Uploading .csv to my shared hosting was impossible due to a fixed max connection timer. 

 

2. Uploading my combinations locally with presta/xampp installed on my HDD took over 24 hours before i stopped it. at 75%.

 

3. Uploading my combinations locally with presta/xampp installed on 4g Ramdisk is super fast in comparison. 1606 products in an hour including image regen and only 2 hours to upload the 6000 combinations.

 

Using method 3 is just so much faster and your video allowed me to perform my changes locally then just swap out the database and webspace. circumventing that annoying 30sec max connection timer at the same time.

 

One happy camper here 8)