Forums / Upgrading to 1.5.x / 1146 Table '[my server name]_zc1.project_version' doesn't exist

1146 Table '[my server name]_zc1.project_version' doesn't exist

Started by lessismore on 25 Feb 2012, 4:51 AM · Views: 861

Results 1 to 2 of 2
25 Feb 2012, 4:51 AM
#1
lessismore avatar

lessismore

New Zenner

Join Date:
Feb 2012
Posts:
2
Plugin Contributions:
0

1146 Table '[my server name]_zc1.project_version' doesn't exist

What version of Zen Cart?
##################################################___
1.39 - > 1.50 upgrade

Is it a new install or an upgrade?
######################################################################
Upgrade

What the addons/contributions you have installed?
##########################################################################################____
none

What customizations have you made?
######################################################################
css, and switched sidebards on/off via admin

What type of server are you using?
######################################################################
unix (cpanel)

Are you installing locally?
##################################################___
no

What operating system?
########################################_
unix?

What version of PHP is installed on the server?
##########################################################################################____
sorry, I don't know how to find this out, but its whatever comes standard with cpanel(accelerated2) that came with my website.

What version of MYSQL is installed on the server?
##########################################################################################____
sorry, don't know how to find this out, but its whatever comes standard with cpanel(accelerated2) that came with my website.

What you were doing when your problem occurred?
##########################################################################################____
Upgraded from 1.39 - 1.50 (and my backup won't load - getting message that it doesnt terminate correctly).

What are the steps to reproduce the problem?
##########################################################################################____
when attempt to log into shop, it is there, with corect css but says 'down for maintenance'.

When attempt to log into admin area, I get the following error message:

1146 Table '[my server's name]_zc1.project_version' doesn't exist
in:
[select * from 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.

Have you attempted to fix the problem? What steps have you taken?
####################################################################################################____
Yes, I did a file by file line by line comparison with another (working) v 1.5 shop, and nothing at the file level is wrong.
I am guessing something went wrong with upgrading the database, but unsure what or how to fix it.

I've not got many products in the database so it is not utterly the end of the world if I need to blow the database away and re-create it, but it would be really helpful if it is a simple matter just to fix the database problem.

I can see the database (using phpmyadmin tool) so it clearly isn't totally toasted.

Any and all advice would be gratefully recieved.

Thanks
SKC

25 Feb 2012, 4:56 AM
#2
lessismore avatar

lessismore

New Zenner

Join Date:
Feb 2012
Posts:
2
Plugin Contributions:
0

Re: 1146 Table '[my server name]_zc1.project_version' doesn't exist

I'm sorry, I forgot to mention that when I check the database, that table DOES exist.