Admin tools

[tony_sar]

if you really dropped the admin table , then the only way to rebuilt it is to restore it from your database backup ( latest ) if you have any done ..

if you never done any back up before , contact your hosting company. most host do backup of database on daily basis .. so they might be able to restore your database or just admin table for you .

[Lasa]

Thanks for the reply,
I know I droped the zc_admin for a fact.
Is there anyway of renaming the admin (no zc_) file that is there or is it a totally different beast.

Lasa

[tony_sar]

default zencart installer , will create two table for admin .. called admin and admin activity log tables . it sounds like , your designer has installed zen cart once without zc_ prefix for table names , and second time with zc_ prefix ..
your site currently using tables with zc_ added to table name ..

how many tables do you have in your database ? default install is 98 tables.

although that can be renamed , but honestly , i do not know the side effect of such changes to rest of your site.

[Lasa]

I was able to restore...
so I have the zc_admin

I ran the restore scripts in sql tab... and it should have reset...
but i can not log in?

[tony_sar]

did you change the admin name in this sql statement to reflect your admin table ?


DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);


for you should be

DELETE FROM zc_admin WHERE admin_name = 'Admin';
INSERT INTO zc_admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

[Lasa]

Its not letting me in...
In the SQL tab I place the restore:

DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

The localhost would be my site domain name correct?
ie: [email protected] right?

Any Ideas?

Lasa

[Lasa]

Thanks for being here Tony..
I know nothing of this...so you really need to take baby steps here.

I've been simply going into mysql and clicking the sql tab..
entering the info.
should I be entering a specific item on the left side drop down?
you indicated zc_admin?

Should I run the code with zc_admin instead of only the admin.
and local hosting is my site correct.

Thanks,

Lasa

[Lasa]

All right!! I'm in thanks!!!... zc_admin rest did the trick
I wanted to change some meta tags
but when I click on Catagories and products I get :

Parse error:syntaz error, unexpected $end, expecting']' in /home/content/x/x/x/xxxcompany/html/admin/catagories.php on line 833

The X's are to hide the company name.

Could this be related to having run the rest password on the admin instead of the zc_admin?
Or is this another beast all together.

Lasa