Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / 1146 Table ... doesn't exist when accessing Admin

1146 Table ... doesn't exist when accessing Admin

Locked

Views: 970

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
18 Jan 2009, 10:25 PM
#1
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

1146 Table ... doesn't exist when accessing Admin

Wow, do I have a headache!
I've moved my stores under a new domain so everything has been a mess.
I'm finally able to see them from the front view (one being a Osc site) but having a problem with one when trying to access the Admin (back view).
I get the following error :
1146 Table 'jnothing_lilleypadtestdb.zen_project_version' doesn't exist
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

While I'm sure it has something to do with where things are pointing to compared to where they SHOULD be pointing to NOW, I can't seem to wrap my head around this one to figure out what needs to be done to correct it.
Anybody? :unsure:

18 Jan 2009, 11:17 PM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: 1146 Table ... doesn't exist when accessing Admin

Do you have a zen_project_version table in your database, or any other table ending project_version?

18 Jan 2009, 11:21 PM
#3
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: 1146 Table ... doesn't exist when accessing Admin

Ok, I figured it out. I had compared this file with one from a different shop of mine and had added a zen_ to the code because I was trying ANYTIHNG to get this one to work and it was the only difference between this none working site and a working site... removed that and its working now :smile:.
Now I just need to "FIX" my osCommerce site... way harder then these!

Thanks!