FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Mysql error!





completeforums
Hi,

I am recieving a MySQL error: 1054 on my site.
The URL is : http://www.completeforums.frihost.net/forums/chat.php


Here is a username and pass you can use to login and see the error first hand:

[removed pass + user]


Do you understand what it means? Also, what should I do?
sorcerer
repeat upload..
completeforums
I tried that.

I looked at mysql.com and I found out that error is cause by a bug in MySQL.

Here is a link that talks about the error and has a link to get a patch that fixes the bug:
http://bugs.mysql.com/bug.php?id=13597
Aelita
Quote:
Database error: Invalid SQL: UPDATE phpbb_c_users SET u_time = 1128812249 WHERE room = 'Default' AND name = 'chat'
MySQL error: 1054 (Unknown column 'name' in 'where clause')
Session halted.

thats what i saw when i logged into your site with the name and pass.

Go into your database and be absolutely sure that the spelling for name is not Name NAME or any other way other than name if it is thats your problem, I doubt its a bug in mysql...
completeforums
I checked that already. Did you go to the link I provided above?
It clearly says that it is a MySQL bug, unless it was patched already.
n0obie4life
Don't post your passwords and user names here!

Only when someone requests for it, then PRIVATE MESSAGE him the password and username Wink. Make sure you trust that guy too. We won't be responsible if he does anything at all to your account.

I'll try and help you with that problem.

[edit]Right.

FRIHost appears to be using 4.* version. Bondings would have to confirm that.

Uninstall that mod. And use another. That would be the best Wink.

If you really want to use another, I would recommend the one at http://smartor.is-root.com .
Bondings
Yeah, it is php 4.*, the most used version at the moment.
Aelita
Aelita wrote:
Quote:
Database error: Invalid SQL: UPDATE phpbb_c_users SET u_time = 1128812249 WHERE room = 'Default' AND name = 'chat'
MySQL error: 1054 (Unknown column 'name' in 'where clause')
Session halted.

thats what i saw when i logged into your site with the name and pass.

Go into your database and be absolutely sure that the spelling for name is not Name NAME or any other way other than name if it is thats your problem, I doubt its a bug in mysql...
Quote:
I checked that already. Did you go to the link I provided above?
It clearly says that it is a MySQL bug, unless it was patched already.


Can you give me a link to that chat. I'll install it fix whatever the problem is (if I am able to) and report back.
Related topics
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.