Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    2
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Feb 2012
    Posts
    2
    Plugin Contributions
    0

    Default 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.

 

 

Similar Threads

  1. Replies: 6
    Last Post: 13 Mar 2012, 05:05 AM
  2. 1146 Table '_zc1.zen_configuration' doesn't exist in: [select configuration
    By HelperSeventy in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 4 Oct 2011, 11:45 AM
  3. 1146 Table 'XXXX.zen_configuration' doesn't exist in: [db_cache table]
    By CheapStairParts in forum General Questions
    Replies: 1
    Last Post: 4 Jan 2011, 12:39 AM
  4. 1146 Table Doesn't Exist
    By pazdar in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 3 Jan 2008, 07:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR