Database problem - please help!

Im sorry for bringing this up again, since there are so many posts about this already, but by following the instruction in those posts, my site still doesnt work.

Im running 1.3.6 on Ix Webhosting. Its been working for over a month now, but today I get: 0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
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.

I havent changed any settings either in Zen Cart or in MySQL. I have checked the configure.php files, and the username and passwords match those in MySQL. I even made a new user and tried that, but it still didnt work. I had the same error sometime last week, but then it was fixed pretty quickly. Today I chatted with someone there, and they said it would be fixed within a short time. Two hours later I again contacted them, and they said the MySQL database was working fine. Well.. I still cant connect, so I guess they must have messed up something? I think they have been updating stuff on their site, so maybe that has messed things up for me?? Ive contacted them, but still not reply..

The address is https://www.nybarbert.no

Thanks for your help!

You're not the only ix webhosting company customer posting here today about problems with their service. Here's another example.

This rather suggests that it's their problem and not something that you have done or can fix.

Thanks for the reply!

I hope they fix it soon.. 5 hours and still no reply and their live chat claim that things are working fine, and then tell me to write a ticket, which I already have done... Its been offline all day, so if this isnt fixed by tomorrow Im switching hosts!

I got this message from their support: "We apologise for the inconveniences. We ahve tried to access https://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!

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.

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 :no:

Thanks so much for your help!

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???

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.

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?

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!

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. :cry:

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.

Thanks, I guess its not too shabby :)

I will keep you updated on how things go, even though it doesnt look too good at the moment..

Thank you for all the advice so far!

Well.. ist been over 3 days and they still havent managed to fix it. I think they have actually just made things a lot worse. Doesnt seem like there is any way to fix it.. So Im now giving up.. I need the site back online, so I have chosen to go with a Norwegian company who will sort things out.. Its gonna cost me over a 1000$ to get a new store, which I am pissed off about... Its not like I have a lot of money, and its especially aggravating since this was 100% IX Webhostings fault.. But I doubt they will pay a cent...

So... thanks to everyone who tried to help, its been a good time with Zen Cart, but unfortunately way too short..

I think it's safe to say your problems were caused by your Hoster, not ZenCart. Moving to another Hoster is definitely a good plan but why does it costs so much to get the site back up, if you are still using ZenCart?

kuroi:

You're not the only ix webhosting company customer posting here today about problems with their service. Here's another example.

This rather suggests that it's their problem and not something that you have done or can fix.

Hello Kuroi,
your avatar is chinese character! nice to meet u here , I am from china.

I encountered the same problems days ago. and I spend much time to deal with that . I could not solve the problem. and I found this thread here .
I get despairing when i see your post which says it is IX's problem.
You know i just rent their service.

Then i enquiried them . They fixed problem for me after i short chat.
It is because there is another configure.php file locates youdomain/admin/includes/local/ , you need change this configure.php's information to match your db as well as the other two.

There are three configure.php total you need to re_configure!!!

Thanks.

Website Rob:

I think it's safe to say your problems were caused by your Hoster, not ZenCart. Moving to another Hoster is definitely a good plan but why does it costs so much to get the site back up, if you are still using ZenCart?

No , it is not IX fault. really.

Please check back all of your configure.php files in zencart folder.

they are not two , actually three.

adam9110:

Please check back all of your configure.php files in zencart folder.

they are not two , actually three.

Three ? Where ?

I dont know why there are three configure.php.

But it must be exsits when somebody get the problems as desribled above.

Go and check if there is a folder called " local" exsit under:

yourzencart/admin/includes/

and there is the another configure.php.

i know there is no such file in the default zencart files!

It may automatically come out during the copy process.

I mean i copy the all the zencart files from another exsited store.

The /includes/local/configure.php file is intended for use only on a development PC and typically should never be uploaded to a live webserver.

THanks , But that why i get confused.

I hardly find any /local / folder in my other zen cart website ! Even in my local PC.
I just made a copy from my other live zencart site .

Does it come up automatically?

Any way i just solve the problem.