Zen Cart Logo
Forums / All Other Contributions/Addons / 1146 Table 'gra10000_zencart.admin_comments' does not exist

1146 Table 'gra10000_zencart.admin_comments' does not exist

Locked

Views: 810

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
19 Jan 2009, 8:12 AM
#1
grandpolar avatar

grandpolar

New Zenner

Join Date:
May 2008
Posts:
4
Plugin Contributions:
0

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

19 Jan 2009, 9:41 AM
#2
kuroi avatar

kuroi

Totally Zenned

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

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.

19 Jan 2009, 9:44 AM
#3
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,694
Plugin Contributions:
56

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.