![]() |
|
|
#1 (permalink) |
|
Registered User
Join Date: Feb 2003
Posts: 97
|
MySQL DB Error
Hello,
I'm having problems with the mySQL DB on my website, it hasn't found the DB/erroed since last night. I can't add a support ticket beacuse it times out ![]() Website: uklans.com (forums use mySQL) cat601. Many thanks, Adrian |
|
|
|
|
|
#2 (permalink) |
|
Resident NetOp/*nix Geek
Join Date: Dec 2003
Posts: 223
|
Adrian,
When you're submitting a ticket, what times out? If you're having problems with the web interface, you can always just mail us at support@catalyst2.com. Anyway, onto the more important bit. You were using the old database server IP (213.230.202.14) rather than the proper host (mysql.active-ns.com), so I updated it for you in config.php and it's all working again. http://www.uklans.com/forums/index.php Rob
__________________
Rob Shakir - rob@catalyst2.com |
|
|
|
|
|
#3 (permalink) |
|
Registered User
Join Date: Feb 2003
Posts: 97
|
Thanks rob, I actually run 2 forums on my webspace, another found here:
http://ice.uklans.com it's coming up with an error finding the assositated tables since I coulnd't get to the DB, any ideas? Khan |
|
|
|
|
|
#5 (permalink) |
|
Registered User
Join Date: Feb 2003
Posts: 97
|
Thanks Rob but i've sorted it. I have to change the table prefix in the config file to lower case, strange it just stopped working, was there a mySQL server upgrade? maybe the default setting changed so you need case sensitive table names?
Khan |
|
|
|
|
|
#6 (permalink) |
|
Administrator
Join Date: May 2003
Posts: 1,299
|
Yes, the server is now case sensitive. Rob mentioned this in the following post:
[MAINT] Windows MySQL Downtime Regards, Jacob
__________________
Jacob Colton jacob@catalyst2.com Open a ticket | Knowledgebase | Rate catalyst2 | Review catalyst2 |
|
|
|
![]() |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|