Database problem - please help!

[Vralteladden]

I got this message from their support: "We apologise for the inconveniences. We ahve tried to access www.nybarbert.no and did not find ant link Zen Cart ,therefore could not repliacte the problem at our end. Please provide the exact URL from where we can access the Zen Cart, so that we can investigate into the issue and get it fixed."

What URL should I provide them so that they can try to fix the problem?

Thanks!

[DrByte]

As a result of the failed database connection, it's automatically redirecting you to this:
http://www.nybarbert.no/nddbc.html

That's probably confusing them.

[Vralteladden]

Yes, I told them this, but I dont think the guy in the support chat understood it. When I now try to access the site I get this error:

1054 Unknown column 'host_address' in 'field list'
in:
[insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, host_address, user_agent) values ('0', '¥Guest', '51333d3b99c2bbb45558d24c20377c8d', '129.240.156.81', '1169460562', '1169460562', '/', 'OFFICE_IP_TO_HOST_ADDRESS', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1)')]

What does this mean? I havent changed anything, so it must be someone at Ix webhosting who has changed things? The store has not been working for over 24 hours, and they still havent fixed it

Thanks so much for your help!

[Vralteladden]

I checked the MySQL server and it says it has been running for 17 hours... I created it in november, so how can this be? Have the people at IX actually deleted my entire database???

[Website Rob]

The problem was created by your Hoster and they are the ones' to fix it.

It does look like db corruption has occured. Hopefully, you or your Hoster has a recent backup because that is probably the only way you are going to (easily) fix the problem.

[kuroi]

You must have a database there, otherwise you wouldn't be getting the 1054 Unknown column error. The server info suggests instead that their MySQL server was rebooted 17 hours previously to when you checked. Re-booting the server is obviously a service interruption and to be avoided if possible and further evidence that they have been having some problems.

But there's something else here that we need to get to the bottom of. What you appear to have on your site at the moment is a default installation of osCOmmerce put there yesterday. Is this you or your host?

[Vralteladden]

Yes, I just noticed that. OsCommerce was put "on" in the panel, but I did not do this. I have no idea why they did this... Im just hoping their support can finally send me a reply and solve the problem ASAP.

I dont have a back-up of the database, only the site itself... Really hope Ix has a backup. Dont think they would update their servers without backing up everything?

Thanks for the replies!

[kuroi]

I'm looking forward to seeing your site. You're site down screen was one of the nicest I've seen and if that's representative of your site as a whole, it must be pretty good.

Yes. Hopefully IX can get you back up. Though if their solution is to try to restore your site to a default osCommerce, their problems may be even greater than we had thought.

Once your site is re-established and you can backup your database, there's a piece of advice that we sometimes give in these situations. Grab your backup and RUN.