Need Help ~ Admin Settings

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

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.

[SocalPotHead]

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.