superecignumber1 Posted January 19, 2014 Share Posted January 19, 2014 Hey - so I just recently switched hosts. (Apache host) And my site was up and running just fine for a day or so...then as I was changing a few colors on my shopping cart/checkout....the page just went white! I tried reverting to the original files. Still white.I tried uninstalling everything, and re-uploadinging everyhthing.....still the same! Any ideas what this could be? NWebsite is www.ciggiez.com I've been trying to fix issues for a couple days now & could really use some help. Thank you very much in advance. Any ideas or suggestions greatly appreciated - as I have exhausted myself this week trying to fix it. Thanks Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 UPDATE: The homepage now loads!!!!! First time in 2 days. I now have access to the back office as well. However...no pictures...no descriptions....and all links lead to 404 !! This better than 404 I've had the past day.(All products & descriptions are in the back office still!! Which is really great. Homepage however is not functional. Ideas? Link to comment Share on other sites More sharing options...
limon994 Posted January 19, 2014 Share Posted January 19, 2014 Hello, What hosting service is serving you? Is it 1&1. I have faced similar problem but found that there are some modules which include files and have ?> "ENDING PHP TAG" and that caused the problem. Thanks, Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 Yes, it is 1&1. I'll have to check on that.....I do have several php files.....? Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 I'm so lucky all my stuff is still on the back office. All pics, descriptions, tags, etc.However...the front page is another story. lol It's late, and I HAVE to get some sleep - but any and all suggestions appreciated.& please feel free to elaborate on the possible PHP issues......What are my next steps in transferring things from the back to front office? Maybe in the back office, I can try to "reset" a module module or two that I was working on? Who knows......open to all tips! Thanks a million guys, I really appreciate it Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 So I really have to go to sleep for work in the AM. I'm leaving the site up for you guys to take a look at - and will investigate a possible php issue. It would be really nice to come home from work tomorrow to see a few different possible solutions. Hoping somebody can help me get the front page running again.... Free ecigs ...? LOL Link to comment Share on other sites More sharing options...
El Patron Posted January 19, 2014 Share Posted January 19, 2014 to save 'loads' of time...when your site goes blank follow this: http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/ Link to comment Share on other sites More sharing options...
vekia Posted January 19, 2014 Share Posted January 19, 2014 hello can you temporarily turn off "friendly urls" ? what's goin on then? images are visible? Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 to save 'loads' of time...when your site goes blank follow this: http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/ Hi there, thank you. I switched it to debugging on....but what do you mean by "reproduce the error" ? Where should I be looking for said error message(s)? P.S - when I switched it, my pictures no longer show. The main issue I'm having is my front office. All back office products/images/descriptions are still in tact. The front page however....it appears that not 1 single link works? They all go to 404. lol Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 hello can you temporarily turn off "friendly urls" ? what's goin on then? images are visible? Wow. This apparently substantially helps.............LOL! It would appear that stuff shows up on the homepage after turning off friendly urls. wth? Hmmmmmmmmmmmmmmm..... it's getting closer.......... Got error -1 from storage engineSELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`id_product_attribute`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 5 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND (pa.id_product_attribute IS NULL OR product_attribute_shop.id_shop=1) AND (i.id_image IS NULL OR image_shop.id_shop=1) AND cp.`id_category` = 4 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY `orderprice` asc LIMIT 0,10 at line 605 in file classes/db/Db.php 599. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);600. }601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))602. {603. if ($sql)604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');605. throw new PrestaShopDatabaseException($this->getMsgError());606. }607. }608. 609. /** DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 655 - classes/Category.php] - [1 Arguments] CategoryCore->getProducts - [line 193 - controllers/front/CategoryController.php] - [5 Arguments] CategoryControllerCore->assignProductList - [line 113 - controllers/front/CategoryController.php] - [0 Argument] CategoryControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument] Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 Here's somethin crazy too....the site looks functioning for the most part on firefox..... Chrome however,,, not so much. lol Link to comment Share on other sites More sharing options...
superecignumber1 Posted January 19, 2014 Author Share Posted January 19, 2014 Thank you!!!!!!!!!!!!!! Apparently, after turning off url friendly, then disabling apache mulitviews, then turning friendly urls back on....it seems to be working. CRAZY! All of this happened b/c I've been trying to fix the shopping cart color scheme. I don't know code too well, so I was freaking out. lol I'll make a new post for the shopping cart/checkout issue - - - but I really appreciate the advice!!!! THANK YOU!!!!!!!!!! Link to comment Share on other sites More sharing options...
vekia Posted January 20, 2014 Share Posted January 20, 2014 thank you for detailed informations what you did now i can mark this topic as [solved]. Link to comment Share on other sites More sharing options...
Recommended Posts