Zen Cart Logo
Forums / General Questions / 1146 Table 'xxx_xxxxxadmin_menu_headers' doesn't exist

1146 Table 'xxx_xxxxxadmin_menu_headers' doesn't exist

Locked

Views: 966

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
17 Mar 2008, 4:43 PM
#2
dfoxengr avatar

dfoxengr

New Zenner

Join Date:
Mar 2008
Posts:
36
Plugin Contributions:
0

Re: 1146 Table 'xxx_xxxxxadmin_menu_headers' doesn't exist

i didnt install the install_adminlevels.sql patch, but now when i goto php myadmin and try to run install_admin_profiles.sql I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'install_admin_profiles.sql' at line 1

20 Mar 2008, 11:54 AM
#3
kuroi avatar

kuroi

Totally Zenned

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

Re: 1146 Table 'xxx_xxxxxadmin_menu_headers' doesn't exist

dfoxengr:

i didnt install the install_adminlevels.sql patch, but now when i goto php myadmin and try to run install_admin_profiles.sql I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'install_admin_profiles.sql' at line 1It's important that the installation instructions are followed precisely, especially for this module, since the SQL script creates the user who has access to everything. If it's not run as part of the setup, Admin Profiles will still do its job of preventing access to anything to which a user is not entitled, there just won't be any users entitled to do anything.

You can correct this after the event, and it sounds as though you are heading in the tight direction. I haven't used phpMyAdmin for a long, long time, so I'm working from very distant memories. I believe that it allows you to either execute a file, or a series of instructions. It sounds as though you have gone to the right place, but are trying to execute the file name as an instruction, rather than the contents of the file.

Kuroi Web Design and Development | Twitter

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

22 Mar 2008, 9:40 PM
#4
dfoxengr avatar

dfoxengr

New Zenner

Join Date:
Mar 2008
Posts:
36
Plugin Contributions:
0

Re: 1146 Table 'xxx_xxxxxadmin_menu_headers' doesn't exist

thank you.
i just had to manually delete all the installed files and reinstall it the original way per the instructions. it works now.