[Solved] Front store and Admin panel crashed | Fatal error: require_once() [function.require]

[sashabz]

Hi,

 

My website got crashed and front store and admin panel is not opening:

I wanted to update prestashop from 1.4.9, but the result wasn't good. So I just clicked rollback, and now I have this error:

Warning: require_once(/home/anvelopp/public_html/tools/smarty/Smarty.class.php) [function.require-once]: failed to open stream: No such file or directory in /home/anvelopp/public_html/config/smarty.config.inc.php on line 30

Fatal error: require_once() [function.require]: Failed opening required '/home/anvelopp/public_html/tools/smarty/Smarty.class.php' (include_path='.:/opt/alt/php53/usr/share/pear:/opt/alt/php53/usr/share/php') in /home/anvelopp/public_html/config/smarty.config.inc.php on line 30

 

I haven't found "smarty" directory in /home/anvelopp/public_html/tools/, so I just uploaded it from my backup files via FTP. The error I have now is:  "Bad SubDomain SQL query."

 

Please help me. I just want to restore my website to 1.4.9. Should I detele my public_html directory and upload the backup of it? Thanks a lot.

Edited December 13, 2014 by sashabz (see edit history)

[FullCircles]

If you have a full backup of the site and database, sounds like it might be best just switching back to that, yes. Something's gone wrong there for sure

 

A quick search for that error did however suggest it might be an issue with bad cookie data, so might be worth just trying to clear both your cookies and any store cache or whatnot first, just to see if that helps the issue and saves you the time

[tuk66]

Make sure you still have all core PrestaShop files. It seems some are missing.

[sashabz]

Thanks FullCircles, thanks tuk66.

I uploaded my backup files and database to localhost on xampp. The error is the same:  "Bad SubDomain SQL query."

How can I verify if something is missing from my files?

Thank you again.

[FullCircles]

Hmm, I can see a fair few threads with a similar error, but not many that have managed to fix the issue (or that have posted how if so)

 

First off, I'd have a check on your database, see if there's a table called `ps_subdomain`, if so, try running the built in mysql repair function on that table, maybe it's crashed in an odd way

 

If you don't have a table or your prefix is something other than ps_, then it might be an issue someone else had, where their prefix was wrong, but it was still looking for ps_ on that particular table.. not sure how often the table gets used, but could be worth cloning it and just calling it ps_subdomain for the purposes of getting past the error (hopefully)

 

Could also be related to the .htaccess file apparently, so try backing that up and then deleting it, then if it lets you into the admin, should be able to regenerate it

 

Hmm, another person reports it's just an issue when trying to restore the database, it's timing out while doing the imports or some such, and some of the tables aren't fully loaded.. so have a compare of the database and see if it's missing anything, not much you can do there other than perhaps export it again, and do a comparison of the sql files.

 

If it is timing out trying to import your previous sql file, there are programs out there which will split it up into smaller ones, I use one called SQLDumpSplitter, pretty simple to use

 

Hopefully one of these helps, hard to track down what the issue is for this one

[sashabz]

Thank you for the help, FullCircles.

I didnt find a table ps_subdomain in database, so I create one, solving the "bad subdomain SQL querry" error, but another error occurred: "Current theme unavailable". I discovered that my theme was missing. I made again a backup. Comparing files and database, I saw that some files and tables were missing,  so I restored my backup files and database. Now everything works fine.

 

!!!You may loose essential data while updating, manual backup is the best practice.

FullCircles, you made my day!

(sorry for my english)