Need Help ~ Admin Settings

[SocalPotHead]

Hello, I have a questions,

I'm trying to change my password in zen cart and I'm getting this error, I see no fields or anything


1054 Unknown column 'admin_level' in 'field list'
in:
[select admin_id, admin_name, admin_email, admin_pass, admin_level from zen_admin order by admin_name limit 0, 20]
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.

[DrByte]

Please click Reply below and answer all the questions in the Posting Tips section of that screen.

[SocalPotHead]

What version of Zen Cart are you using? 1.3.9h
Has your site been upgraded? When? From what version(s)? No
What addons have you installed? When? None
In what ways is your site customized or different from a brand new uncustomized install? Its not


I changed my password about a month ago. I go to change it again and I can't

[DrByte]

Somehow your database has been changed and a required column/field is missing from the admin table.

You need to find out why that is.

A fresh clean install of Zen Cart v1.3.9h does indeed contain the admin_level column. So, either you've done something yourself which has deleted that column, or you've installed an addon that's deleted it, or you've been hacked by someone who's deleted it.

If indeed you've done NOTHING to change the initial install of Zen Cart on your site, then perhaps a fresh new install after wiping all the files and deleting and recreating the database would be your smartest first step. And while you're at it you may as well use the latest version of Zen Cart. No point starting a new site on old code.

[SocalPotHead]

Somehow your database has been changed and a required column/field is missing from the admin table.

You need to find out why that is.

A fresh clean install of Zen Cart v1.3.9h does indeed contain the admin_level column. So, either you've done something yourself which has deleted that column, or you've installed an addon that's deleted it, or you've been hacked by someone who's deleted it.

If indeed you've done NOTHING to change the initial install of Zen Cart on your site, then perhaps a fresh new install after wiping all the files and deleting and recreating the database would be your smartest first step. And while you're at it you may as well use the latest version of Zen Cart. No point starting a new site on old code.

This would be in the admin.php file correct? So if I just replace the admin.php file with a orig one would that work? I'm new to ZC so Im not sure how to update it without messing my shop up.

[DrByte]

No, it's not the admin.php file. It's the admin table in your database.
What have you done to damage your database?

[RescoCCC]

Since this is the admin login being effected, I'd be looking at that table in the database poste-haste to see if any changes, (like new admins), have been added.

[SocalPotHead]

No, it's not the admin.php file. It's the admin table in your database.
What have you done to damage your database?

I haven't done anything. My host ( JustHost ) was the last person to do anything to my site. Only because my sub domain wasnt on the same server as my main so they moved it. I'm not sure what to do.

[SocalPotHead]

I'm looking at my DB and i see "admin_level" is missing. How do i add it to the table? I don't remember how to

[DrByte]

What addons have you installed? When? None
In what ways is your site customized or different from a brand new uncustomized install? Its not

Um ... so what should I make of your prior posts which talk about addons you HAVE installed?
http://www.zen-cart.com/forum/showth...87#post1081687
http://www.zen-cart.com/forum/showthread.php?t=188936
and another about adding a blog