Need Help ~ Admin Settings

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.

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

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

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.

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.

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.

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

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.

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?

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.

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

SocalPotHead:

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/showthread.php?p=1081687#post1081687
http://www.zen-cart.com/forum/showthread.php?t=188936
and another about adding a blog

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
If I give you the instructions to add that column back to the database, then I'm doing you a disservice, because it's HIGHLY UNUSUAL for that to go missing. It's ALARMING and indicative of much deeper problems which suggest you really need to do a much more aggressive cleanup of your site, both its files and its database.

Your database integrity is suspect. Applying bandages is NOT enough.

Hence my asking many questions to get the bigger picture.

If you wanna go your own way and put bandages on, fine. But don't come here crying for support when other things are broken too. Sorry, that may sound harsh, but it's that important.

DrByte:

Um ... so what should I make of your prior posts which talk about addons you HAVE installed?
http://www.zen-cart.com/forum/showthread.php?p=1081687#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.

SocalPotHead:

DrByte:

Um ... so what should I make of your prior posts which talk about addons you HAVE installed?
http://www.zen-cart.com/forum/showthread.php?p=1081687#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?

Im thinking it was removed by someone from my hosting company. When i first started with them i was moved to a faster server and they forgot half my site and wound up taking a few weeks for them to get everything on the same server. I'v paid someone to check out my site to make sure its malware and virus free.

It doesn't make sense that your hosting company, or anyone for that matter, would remove just one column from a database table. Extremely peculiar.

DrByte:

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?

Im new to ZC. Im afraid of losing my products and info on my site while updating.

DrByte:

It doesn't make sense that your hosting company, or anyone for that matter, would remove just one column from a database table. Extremely peculiar.

I might have done it whiten the last month. I don't always go to the admin settings

DrByte:

It doesn't make sense that your hosting company, or anyone for that matter, would remove just one column from a database table. Extremely peculiar.

They wouldn't. I'm with the same host as the OP, (with multiple sites), and generally speaking they know what they're doing.

RescoCCC:

They wouldn't. I'm with the same host as the OP, (with multiple sites), and generally speaking they know what they're doing.

I don;t think they removed it. It was most likely me I just dont remember doing it. But JustHost has some people that arnt smart. When i first started using JH as my hosting company i bought the faster server. 2 weeks later i find out im still on the "slow" server and i ask them to move my site over to the faster server. Witch they did but wound up messing alot of things up. Then 2 weeks ago i find out my sub domain was still on the "slow" server they moved it to the faster server then my sub domain no longer worked anyways every things fixed now. Im new to shopping carts but i know alot about other things :P I thank everyone for their help! :bigups:

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