Can't log in anymore, can't delete admin -- after server IP change

Strange things have been happening lately with my site. First, our host changed the site's IP. After we made all the nameserver corrections, site was acting weird, sometime it came up, sometime it didn't Host found out their DNS zone was still using the old IP for nameserver 2 (ns1 and ns2).

Now I can't login to my zencart admin, with neither one of my login IDs! Here's the error message I get "Fatal error: Call to a member function Execute() on a non-object in /home/starting/public_html/store/includes/functions/sessions.php on line 61"

I searched on these forums and tried to run this SQL query: DELETE FROM admin WHERE admin_name = 'Admin';DELETE FROM admin WHERE admin_name = 'Admin';DELETE FROM admin WHERE admin_name = 'Admin';

phpMyAdmin gives me this error:

Error
SQL query:

DELETE FROM admin WHERE admin_name = 'Admin';

MySQL said:

#1146 - Table 'starting_zc1.admin' doesn't exist

i'm confused, what should I do??

Probably you will have to wait a while, upto 48 hours for the propagation process to complete.

Question your host: why did they change your ips, did they make some other changes? I would be so pissed off if my host ever does that to me.

I don't think propagation has much to do with my inability to login as admin, or to make changes to phpMyAdmin - but then again, I could be wrong.

any ideas?

Do you see your database listed when you go into phpMyAdmin?

yes I do

Check that your settings in admin/includes/configure.php and includes/configure.php are pointing to the right places.

What would the right places be? I'm a little confused.

I looked into both those files and, strange enough, the pwd for the db seems strange, i never set this one to this: yz3Wx***jUM2

do u think i've been hacked??

update:

ok, i used zen as prefix and the sql command ran ok (followed instructions here: https://www.zen-cart.com/tutorials/index.php?article=2). I went and used Admin admin and still nothing! :( I still get this "Fatal error: Call to a member function Execute() on a non-object in /home/starting/public_html/store/includes/functions/sessions.php on line 61"

When I go to that file, line 61 says "$total = $db->Execute($qid);"

When I click on the link "resend password" it says "Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience."

What version of Zen Cart are you using?
What version of PHP is on your server?

Your reported symptoms suggest that you're using old code not compatible with PHP5 running on a PHP5 server.

PHP version: 5.2.5

zen version (according to fantastico, cause I don't know another way how to check it): 1.3.0.2

shqipo:

zen version (according to fantastico, cause I don't know another way how to check it)
https://www.zen-cart.com/tutorials/index.php?article=149 (when you can login to your admin)

shqipo:

PHP version: 5.2.5

zen version ...: 1.3.0.2

Zen Cart v1.3.0.2 wasn't designed for PHP 5

You could try copying the /includes/functions/sessions.php file from v1.3.8 onto your server and cross your fingers that it might provide some relief.
And then put a plan in place to do a full upgrade.

Or, you could follow this thread, which I found by searching for the Fatal Error message you posted initially: http://www.zen-cart.com/forum/showthread.php?t=49684
... which points to this specific fix: http://www.zen-cart.com/forum/showthread.php?p=287587#post287587

v1.3.0.2 had some serious security bugs, which if you haven't patched it or upgraded, can leave you open to hack attempts.

DrByte:

What version of Zen Cart are you using?
What version of PHP is on your server?

Your reported symptoms suggest that you're using old code not compatible with PHP5 running on a PHP5 server.

Looks like you are right again, DrByte! :smartalec:

DrByte:

https://www.zen-cart.com/tutorials/index.php?article=149

yes, that's another way - if I could log into my admin are though ;)

update: I followed doctor's advice (thanks doc!) here: http://www.zen-cart.com/forum/showthread.php?p=287587#post287587 and was able to login.

it's interesting how fantastico says it's Zen 1.3.0.2 but the version that zen shows is 1.3.5.

Do I still need to update?

You should still put a plan in place to do an upgrade. There are many fixes in 1.3.6, 1.3.7, and 1.3.8.
If the other fix for PHP5 worked for you, then the upgrade isn't as urgent. But if your host is upgrading MySQL as well, you may find problems if you're still running old software.

Will do. Thanks again doc! It turns out that my host screwed this one up with their unnotified updates of PHP as well as IPs (they didn't update my SSL).

maybe i should look for a different host. man, i so don't want to have to move all that site! :(