Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2007
    Posts
    95
    Plugin Contributions
    0

    Default site down following error 1146 Table 'project_version' doesn't exist

    Hi a customer of mines site has totally and suddenly just stopped working, when you go to the home page it says the following

    1146 Table 'wwwglitz_glit.project_version' doesn't exist
    in:
    [SELECT project_version_major, project_version_minor FROM project_version WHERE project_version_key = 'Zen-Cart Database']

    the customer has told me they have not made any changes to the site, its just done this by its self.

    can anyone let me know why its done this?? and if there is a fix???

    Please get back to me thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: site down following error [SELECT project_version_major, project_version_minor FR

    The DB_XXXXXXX settings in your configure.php files are obviously not pointing to a database which contains Zen Cart tables.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2007
    Posts
    95
    Plugin Contributions
    0

    Default Re: site down following error [SELECT project_version_major, project_version_minor FR

    Quote Originally Posted by DrByte View Post
    The DB_XXXXXXX settings in your configure.php files are obviously not pointing to a database which contains Zen Cart tables.
    this is not the case, the config files point to the correct database, has all the correct info in them, the site was working fine it just suddenly stopped and shown this error. it also shows the following when you go the the admin page.

    1146 Table 'wwwglitz_glit.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.

    can anyone please help???

  4. #4
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: site down following error 1146 Table 'project_version' doesn't exist

    Do you actually have a table by that name in your database?

  5. #5
    Join Date
    Aug 2007
    Posts
    95
    Plugin Contributions
    0

    Default Re: site down following error 1146 Table 'project_version' doesn't exist

    Quote Originally Posted by RescoCCC View Post
    Do you actually have a table by that name in your database?
    yes, like i said the sites been working fine for over a year.... nothing has been changed in the database it just shown that error the other day.

  6. #6
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: site down following error 1146 Table 'project_version' doesn't exist

    What is wwwglitz_glit?

  7. #7
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: site down following error [SELECT project_version_major, project_version_minor FR

    Quote Originally Posted by paddy_uk2007 View Post
    the site was working fine it just suddenly stopped and shown this error.
    Well, if our advice isn't enough, then I suggest you talk to the people who have access to your site, to figure out what *they* have to say.
    That would include: *you*, your staff, your hosting company, and any outside contractors you've given your login information to.

    I can tell you that the REASON that Zen Cart shows that message is exactly as I described earlier. So, since this problem just "suddenly" happened, you'll need to now consult with the people who have control over the "suddenly" part.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v139h SQL Error 1146 Table TABLE_CUSTOMERS_ADMIN_NOTES doesn't exist
    By utefan in forum General Questions
    Replies: 4
    Last Post: 3 Mar 2016, 07:45 PM
  2. v151 upgrading error 1146 table doesn't exist
    By scottrdj in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 31 Dec 2012, 03:05 PM
  3. v150 1146 Table '[my server name]_zc1.project_version' doesn't exist
    By lessismore in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 25 Feb 2012, 05:56 AM
  4. MYSQL error #1146 table doesn't exist - help!
    By TheKenster in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 20 Jan 2012, 01:48 PM
  5. 1146 Table error zenconfiguration doesn't exist
    By gayelston in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 1 Dec 2007, 10:26 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