Changed domain - getting error message

[djd5059]

My company owns the domains suppliesondemand.biz and suppliesondemand.net. We want the .biz address to be the primary, but because our server administrators didn't set things up right, the .net domain has always been the default. So if you typed a .biz address into the browser, it would always redirect to the .net equivalent unless it was the main page. This was really screwing with our PageRank as Google was treating our index page as a different site than our item pages.

I finally explained this to the administrators that made sense, and they switched the defaults over last night. Unfortunately, this caused some kind of fatal error within Zen Cart, and now no matter what page you try to go to within the store, you get the following error message:

145 Table '.\suppliesondemand\whos_online' is marked as crashed and should be repaired
in:
[delete from whos_online where time_last_click < '1281620206']

Does anyone know if there is an easy fix for this? I assume files were written with self referential links by the program, and now it is confused because part of the address changes. The IP address is the same, and the file structure has not change. Does anyone know how to fix this? Thanks.

[afo]

It's doubtful the change caused that issue. You should be able to recover the table using phpMyAdmin from your webmaster panel (outside Zen Cart).

When the switch was made to the .biz address, did you edit the configure.php files in Zen Cart to match?

[mprough]

First check admin/includes/configure.php and includes/configure.php are set up correctly.... Verify the database prefix as well.

Then run this http://www.zen-cart.com/index.php?ma...products_id=82

If that doesn't work we will need some details as to what the webhost did... new account? dns trick? etc.

~Melanie

[djd5059]

Thanks for the tips - I updated both of the configure files, and I tried to run the fix_cache_key.php file, but I get the same error message. That probably means I need to address the database issue first. I am not familiar with database administration. I can find the whos_online database in the phpmyadmin on my server, but I have no idea what I should be doing with it. Tips?

[djd5059]

Ha. So turns out there is just a 'repair' button. Clicked that and now everything is back up and running (as far as I can tell, more testing will ensue). Thank you guys so much. I thought I broke my store.

[afo]

Glad it was an easy fix!