I get error: #1146 - Table 'tel1222205460806.admin' doesn't exist
Printable View
I get error: #1146 - Table 'tel1222205460806.admin' doesn't exist
Then you probably installed Zen Cart using some sort of one-click-auto-installer from your hosting company, and they've added a "zen_" (or some other) prefix to all your table names.
So the DELETE FROM admin will need to be changed to DELETE FROM zen_admin
Same with the INSERT INTO statement.
logged in with the admin, and the menu is still not there
I beleive I got the SQL database. How can I add all the products and groups back from this SQL file?
I have a store made up and have added many products, I noticed after adding all the products, setting up the interface for the user, and install plugins, that the admin menu is missing. I created a new zencart [on the same domain] with a new database and the admin page returns. If I take the new database, and have replace the damage database the admin menu returns[but I loose the products]. Does anyone know either where this is located in the database, or how I can get the menu back[need this to setup permissions for other users].
Thanks in advance
CONTEXT:
a) You said you've installed a clean new instance of Zen Cart into a new database.
b) And you want to fix a corrupted admin menu in the old database, using the clean working (uncustomized) menu from the new one.
c) You were thinking that you wanted to copy the products from the old one into the new one, as your fix. But, since this is an admin problem, don't touch the products/categories/etc.
Instead, focus on restoring just the menu, as in (b).
RESTORING:
As long as the tables in both database have the same prefixes (ie: the "admin" table is actually named "admin" and not "zen_admin" ... in both databases), then the following steps will put the clean new admin-user settings into the old database.
First, on the NEW DATABASE, that is the clean properly-working new version:
1. Login to phpMyAdmin, find your NEW Zen Cart database. Click on it so the tables are all listed.
2. click on the Export tab
3. A box will appear listing all your tables, click on each of these tables (using CTRL-click to select more than one at a time):
- admin
- admin_menus
- admin_pages
- admin_pages_to_profiles
- admin_profiles
(Since you'll probably ask, NO, don't select the admin-activity-log table)
3. On the right-hand side, check the checkbox next to "Add DROP TABLE / VIEW / etc........"
4. On the bottom, check the "Save as file" checkbox
5. Click Go.
6. Now select the OLD BROKEN database from the pulldown on the far/top left.
7. Click the Import tab
8. Select the CHOOSE FILE browse button, and select the file you downloaded in #5 above.
9. Click Go.
Then delete the temporary "new" database and temporary store files, since it's not needed.
Did the above, message reads: Import has been successfully finished, 123 queries executed.
I logged into the admin page, and the problem is still there...
Okay, then the problem wasn't with the menu. Or else the tablenames have different prefixes and thus didn't actually restore anything.
no idea, not even sure where to look. I would have thought the menu names would have been in the database, considering that when the database is changed it shows up.
Load your database in phpmyadmin and inspect the table namesQuote:
no idea, not even sure where to look
Look for any prefix to the table name
If there is a prefix then insure that ALL tables have the same prefix