I have this exact same issue. http://fcsportsbar.com/chat I installed using godaddy installatron v1.94-RC5. I also tried importing the tables manually in MyPHPAdmin.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
^ Yep, exactly the same. I tried installatron as well (among the other things listed in the first post), same thing. Wonder if there's something wrong in the latest package?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
somehow it's a database misconfiguration, yet admin works fine and users can register, they appear in the database. It's writing to the db correctly but not reading it. It could be a form error, like a mismatch in table names or something.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
yeah still does not work, same error. I've tried multiple things on multiple domains, manual install, auto install and have spent far too many hours on this. I'm going to have to find another solution.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm installing on/with Go Daddy CPanel and I'm having this seemingly exact same issue where it says the links for the needed updated files and instructions are grayed out on this site. Can you send me a link at lfsternn81@gmail.com or leave it on here as to what I need to do to get it installed correctly?
Here is my exact error... Database error: Invalid SQL: SELECT password,perms,rooms,allowpopup,last_login,login_counter,join_room,use_sounds FROM mc_reg_users WHERE username='ddd' LIMIT 1
MySQL error: 1054 (Unknown column 'use_sounds' in 'field list')
Session halted.
Last edit: Lincoln F Sternn 2016-05-03
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello and sorry about that. Some webhosts like GoDaddy got the Rc zip very quick, before I published a fixed version the day after initial realease.
Anyway, now that you have it installed, the fix is easy.
Go to phpmyadmin, select the c_reg_users table, go to SQL tab in the top right menu and paste the line below, then click Go. That should add the missing field.
ALTER TABLE c_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'
I'm sorry but sourceforge is the only source for this software, GoDaddy and other hosting websites have their own agenda which I can't influence.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Awesome it worked. In my phpadmin for godaddy the db structure had only an mc_reg_users specifically so I changed your line accordingly to; ALTER TABLE mc_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'; and viola it works. Thanks so much for the quick response and fix... cheers!!!
Last edit: Lincoln F Sternn 2016-05-04
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Indeed, I forgot to mention that the default table names might be different (carring a prefix), based on the installation process.
I'm glad you figured it out and it worked.
Ciprian
Last edit: Ciprian Murariu 2016-05-04
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tryed to add the ALTER TABLE c_reg_users ADD use_sounds enum('0','1') NOT NULL default '1' to my SQL file. But all I got was error messages. I really didn't know exactly where to add the line. I added it in front of the c_reg_users. I added it on the boottom. and I replaced the c_reg_users with the new line and got an error messase every time.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I installed the chat and the admin side of things seems to work fine but when I try to log on the chat I get the following error:
Database error: Invalid SQL: SELECT password,perms,rooms,allowpopup,last_login,login_counter,join_room,use_sounds FROM swre_reg_users WHERE username='frobishounen' LIMIT 1
MySQL error: 1054 (Unknown column 'use_sounds' in 'field list')
Session halted.
I've tried manual installation already, got the same error. How can I fix this?
Which packet did you install? Was it a new install or upgrade? Can I have a link?
It was the latest one available here, and it was a new install.
I have this exact same issue. http://fcsportsbar.com/chat I installed using godaddy installatron v1.94-RC5. I also tried importing the tables manually in MyPHPAdmin.
here is the error I get:
Database error: Invalid SQL: SELECT password,perms,rooms,allowpopup,last_login,login_counter,join_room,use_sounds FROM mc_reg_users WHERE username='John' LIMIT 1
MySQL error: 1054 (Unknown column 'use_sounds' in 'field list')
Session halted.
^ Yep, exactly the same. I tried installatron as well (among the other things listed in the first post), same thing. Wonder if there's something wrong in the latest package?
somehow it's a database misconfiguration, yet admin works fine and users can register, they appear in the database. It's writing to the db correctly but not reading it. It could be a form error, like a mismatch in table names or something.
Hi and thank you for catching this small bug. It is fixed now. Please re-download, and re-run mysql_new_install.txt.
Thank you and sorry for the inconvenience...
yeah still does not work, same error. I've tried multiple things on multiple domains, manual install, auto install and have spent far too many hours on this. I'm going to have to find another solution.
Can you please contact me at ciprianmp @ yahoo.com?
I emailed you, thanks!
I'm installing on/with Go Daddy CPanel and I'm having this seemingly exact same issue where it says the links for the needed updated files and instructions are grayed out on this site. Can you send me a link at lfsternn81@gmail.com or leave it on here as to what I need to do to get it installed correctly?
Here is my exact error... Database error: Invalid SQL: SELECT password,perms,rooms,allowpopup,last_login,login_counter,join_room,use_sounds FROM mc_reg_users WHERE username='ddd' LIMIT 1
MySQL error: 1054 (Unknown column 'use_sounds' in 'field list')
Session halted.
Last edit: Lincoln F Sternn 2016-05-03
Hello and sorry about that. Some webhosts like GoDaddy got the Rc zip very quick, before I published a fixed version the day after initial realease.
Anyway, now that you have it installed, the fix is easy.
Go to phpmyadmin, select the c_reg_users table, go to SQL tab in the top right menu and paste the line below, then click Go. That should add the missing field.
ALTER TABLE c_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'
I'm sorry but sourceforge is the only source for this software, GoDaddy and other hosting websites have their own agenda which I can't influence.
Awesome it worked. In my phpadmin for godaddy the db structure had only an mc_reg_users specifically so I changed your line accordingly to; ALTER TABLE mc_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'; and viola it works. Thanks so much for the quick response and fix... cheers!!!
Last edit: Lincoln F Sternn 2016-05-04
Indeed, I forgot to mention that the default table names might be different (carring a prefix), based on the installation process.
I'm glad you figured it out and it worked.
Ciprian
Last edit: Ciprian Murariu 2016-05-04
Hello, Just found this forum, and I also have got same issues,
Database error: Invalid SQL: SELECT password,perms,rooms,allowpopup,last_login,login_counter,join_room,use_sounds FROM mc_reg_users WHERE username='Lillita' LIMIT 1
MySQL error: 1054 (Unknown column 'use_sounds' in 'field list')
Session halted.
Tried to see if I could sort it, but then I got an error, and I am not good at this at all, so what am I doing wrong?
Last edit: Lill Eriksson 2016-07-20
I don't see any issue in that line.
Try to add that field manually at the end of that table.
I tryed to add the ALTER TABLE c_reg_users ADD use_sounds enum('0','1') NOT NULL default '1' to my SQL file. But all I got was error messages. I really didn't know exactly where to add the line. I added it in front of the c_reg_users. I added it on the boottom. and I replaced the c_reg_users with the new line and got an error messase every time.
It might be that your table has a different prefix, therefore a different name
Can you paste the error pls?
if anyone is still haveing an issue while using cpanel, the command line
ALTER TABLE c_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'
may need to be changed to
ALTER TABLE mc_reg_users ADD use_sounds enum('0','1') NOT NULL default '1'
took like 3 hours to notice this, just replace the contents of the sql box and hit go.