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]

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

[SocalPotHead]

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

That was all removed. I created a blog on a sub domain.

[DrByte]

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

That was all removed. I created a blog on a sub domain.

So if there's nothing on your site that needs preserving, what's wrong with starting afresh with a brand new install that you can be confident is clean?

[LTaylorBrown]

Forgive me for such a long post. I currently use v1.3.9h and I paid a company to install the following add-ons to my store and now "admin settings" is showing the same error as the first post. Could any of these add-ons cause that problem? :

Categories Dressing
Better Together
Define Pages Generator
Group Pricing (per Item)
MCEditor
Admin Category / Product Images
Maximum Amount Allowed In Shopping Cart
Ultimate SEO URLs
Quick Updates
Search Log
Quickbooks Import QBI
AutoFacebook
AutoTweet
Social Bookmarking
Contest System
Google Analytics
Google Base (Froogle) Feeder
SitemapXML
Snap Affiliates
Google Checkout
Add Customers via Admin

[DrByte]

Did you do an upgrade to 1.5.0 at all?
I say that because only the v1.5.0 upgrade would ever delete the admin_level field. Unless you're mucking around with addons which compromise the functionality of your store.

[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.