[SOLVED] Backup & Restore

[ontljoshi]

Hi,

i have restored the backup of prestashop into PHP MySQL and it was successful. I also copied a whole folder from my previous work and pasted back into www folder. Now when i try to go to administrator or index.php of front end side it doesn't work just gives blank page.

anyone please tell me what to do ? its urgent.

thanks for your kind attention.

regards,
om

[rocky]

Edit config/config.inc.php and temporarily change 'display_errors' from 'off' to 'on'. You should then get an error message instead of a blank page. Post the error message here.

[ontljoshi]

hi, comes with following error

Fatal error: Call to undefined function get_magic_quotes_gpc() in C:\AppServ\www\eisol\prestashop\config\config.inc.php on line 42

any suggestions?

thanks
om

[rocky]

It must be a PHP configuration issue, since get_magic_quotes_gpc() is a PHP function, not a PrestaShop function. For some reason, your PHP is missing that function. What version are you using?

[ontljoshi]

Hi,

i have installed following things

Appserve 2.6.0 in that php6 and phpMyAdmin - 2.10.3

i forgot what i have used earlier i.e. before formatting computer, what to do?

looking forward to hearing from you.

thanks.
om.

[rocky]

PrestaShop isn't compatible with PHP6, since it uses functions in PHP5 that were removed in PHP6.

[ontljoshi]

hi,

thanks for your reply. considering that before your reply comes i uninstalled aapservr2.6.0 and moved back to appserver2.5.9. although it gives me following error message

Invalid loadConfiguration() SQL query!

what should i do?

thanks for you feedback in advance.

regards, om.

[rocky]

That must mean the following query is failing:

SELECT c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS value
FROM `ps_configuration_lang` cl
LEFT JOIN `ps_configuration` c ON c.id_configuration = cl.id_configuration');

Make sure that the ps_configuration and ps_configuration_lang tables exist in your database.

[ontljoshi]

hi,

ps_configuration in use
ps_configuration_lang in use

the above mentioned tables are there in my database.

[rocky]

I'm not sure why the above query is failing then. Can you try running the query using phpMyAdmin and posting any error message that appears?

[ontljoshi]

Hi

i got following error message

Server: localhost - Database: eisol - Table: ps_configuration_lang "Unknown collation '#45' in table 'ps_configuration_lang.frm' definition"
Error

SQL query: Documentation

SELECT c.`name` , cl.`id_lang` , IFNULL( cl.`value` , c.`value` ) AS value
FROM `ps_configuration_lang` cl
LEFT JOIN `ps_configuration` c ON c.id_configuration = cl.id_configuration
)
LIMIT 0 , 30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
LIMIT 0, 30' at line 1

[ontljoshi]

i have solved the problem.... it was with whole database... i re-imported the backup into Mysql and it worked for me....
thanks for all you help buddy...

[olegirl2000]

Goodness!!! I've been up all night messing with my site.

I had it working great, then i stupidly decided to update to the new version of PS.
Then it all went down hill. Don't have a clue what happened. It's 6am and i'm braindead.

Long story short, I uninstalled everything (did a DB and images backup thank GOODNESS)
Then, I installed an older version of PS. 1.2.3, which is what I thought I originally had, and had generated the DB backup.

I did the install process no problem. Verified my "temp" DB (cuz i was gonna switch to orig. DB after all setup)

I get to my Back Office (PHEW), go to the settings where I choose the orig. DB, and screen kicks out and says
error message is Invalid loadConfiguration() SQL query!

And no, I do not have the Configuiration_Lang listed in my SQL.

I would like to get them there, but not sure how.

Don't even know if i'm running the right version of PS compared to my orig. DB.
Freaking out. [spam-filter] is freaking out. Store was just getting important to people. SAD PEOPLE:(

HELP PLEASE. DESPERATE.