Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    4
    Plugin Contributions
    0

    Default 1146 Table 'gra10000_zencart.admin_comments' does not exist

    Hi
    I am suddenly receiving this error message when viewing orders.
    Otherwise the system is working fine.
    Any ideas on how to correct this?

    We have not done any upgrades etc and customisation has been kept to the absolute minimum - just colors.

    Admin Name Date Added Comments
    1146 Table 'gra10000_zencart.admin_comments' doesn't exist
    in:
    [select orders_id, admin_name, date_added, comments from admin_comments where orders_id = '1146' order by date_added]
    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

    See attachment as well.

    Thanks
    Attached Images Attached Images

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: 1146 Table 'gra10000_zencart.admin_comments' does not exist

    Well somebody is customizing your site.

    That error message suggests that code has added from the admin_comments add-in, but the associated SQL has not been installed.

    If not a botched installation, it could also happen if code were borrowed from another site that already had it installed.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,511
    Plugin Contributions
    126

    Default Re: 1146 Table 'gra10000_zencart.admin_comments' does not exist

    There's no admin_comments table in the default distribution. Perhaps you have installed a mod incorrectly. This kind of thing happens when there's a .sql file in the mod and your database uses a prefix, and you run the .sql file through phpMyAdmin without adding your prefix. If you can track down this file, run it through the admin panel under Tools->Install SQL patches; this adds in your prefix automatically.
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. Not receiving orders: 1146 Table 'maya_zc1.zen_gv_exclusion_list' doesn't exist
    By bellaphile in forum Managing Customers and Orders
    Replies: 2
    Last Post: 19 Apr 2011, 04:13 AM
  2. 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
  3. 1146 Table DB.configuration does not exist
    By pippa_oz in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 1 Nov 2010, 07:50 AM
  4. Replies: 6
    Last Post: 29 May 2008, 06:39 PM

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