500 error after database restore (1.4.9.0)

[lowlight]

So I tried upgrading to 1.5, but several errors caused me to move back manually to 1.4.9.0

 

However, using a copy of the database, the site is now broken. It gives a 500 error, and when I try to log into the back office I get the following error

 

Fatal error (Employee -> id_lang is empty)

[lowlight]

Here are the errors from the php log

 

 

[Fri Sep 14 09:37:42 2012] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Cannot access empty property in /home/x/public_html/prestashop4/classes/FrontController.php on line 242

[Fri Sep 14 09:37:42 2012] [error] [client xxx.xxx.xxx.xxx] PHP Warning: Invalid argument supplied for foreach() in /home/x/public_html/prestashop4/classes/Link.php on line 248

[lowlight]

It looks like for some reason my database is missing some tables... but all I did was a mysql dump and restore... wtf?

 

BTW where is everyone? I expected the forum to be pretty busy after 1.5 launched :\

[lowlight]

Anyone?

 

I feel like I should be able to restore this database from yesterday, since all the data SHOULD be there. But when I try to use it, it is missing some tables.

 

Line 242 is

 

if ($tmp = (int)$cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')})

 

and the other file line 248 is

 

 

WHERE id_lang = '.(int)$cookie->id_lang);

foreach ($result as $row)

 

EDIT: I checked the database in phpmyadmin, and the PS_TAX_ADDRESS_TYPE is there! It exists!

 

So the data is there, but for some reason it can't find it! Please I need help with this

Edited September 15, 2012 by lowlight (see edit history)

[lowlight]

It looks like I am having 100% the same problems as this guy

 

http://www.prestasho...x-address-type/

 

Exact same problems with the same parts of the database missing.

 

I am now at the point where I am in the admin, but it gives a non specific error "tabs not found"

 

People told him to "see what files are missing" and then it stopped from there. For some reason the thread was marked "solved" even though it was never solved.

 

By the way, ONLY THE FRONT PAGE OF THE ADMIN has this error. All the rest of the tabs work fine.

 

So can someone tell me what 'tab' file the /admin/index.php front page is looking for?

 

This is a fresh upload of 1.4.9.0

 

Edit: Found these errors, investigating now

 

 

[15-Sep-2012 01:54:23] PHP Warning: Invalid argument supplied for foreach() in home/x/public_html/prestashop4/administrator/tabs/AdminPreferences.php on line 43

[15-Sep-2012 01:54:23] PHP Warning: Invalid argument supplied for foreach() in /home/x/public_html/prestashop4/administrator/tabs/AdminPreferences.php on line 78

 

Line 43:

 

 

foreach (Tax::getTaxes((int)($cookie->id_lang)) as $tax)

$taxes[] = array('id' => $tax['id_tax'], 'name' => $tax['name']);

 

Line 78:

 

 

oreach (CMS::listCms($cookie->id_lang) as $cms_file)

$cms_tab[] = array('id' => $cms_file['id_cms'], 'name' => $cms_file['meta_title']);

 

So the id_lang problem again... Can someone tell me what table it's looking in?

Edited September 15, 2012 by lowlight (see edit history)

[lowlight]

I checked my other PS shop (1.4.9.0) and there is no id_lang column in the employee table either.

 

But at least PS_TAX_ADDRESS_TYPE is there...

 

I have a feeling that it is just a single error causing this.. any ideas?

[lowlight]

Anyone?

[lowlight]

Bump - my store has been down for 3 days now. I would really appreciate some help in figuring this out!