Error in Forums for Usergroups

Guest

Greetings,
I just upgraded from BETA5 to BETA6
and I ran update.sql but the fields were already renamed in the user database. So the update file never realy ran.
After I unpacked all files instead of the old files, I ran upgrade6-65.php eventhough I had 6.5beta 5 was installed. So I have no idea how did this go!

and started to get this error when a user logs in, then click on Forums, then Click on Usergroups, then finally click on "View Information"

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'ORDER BY u.uname' at line 7

SELECT u.uname, u.uid, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.url, u.email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = 6 AND u.uid = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.uname

Line : 811
File : /home/www/mydomain/html/modules/Forums/groupcp.php

Thank you again
Mark

Posted: Sun Jan 26, 2003 1:38 pm

You ran the upgrade file and the fields were already renamed, that is very odd, beta 5 still used the old field names, how could yours be renamed already, anyway, did you upload beta 6's files so that they replace the old files?

Guest

Well! I looked at the users database a day ago and it was with the new names. Somehow, now I see it with the old names. I am going to get your sql fix and run it again, hopefully it will fix this problem..
Thank you for your help.
Mark

Guest

Greetings again,
I ran the file update.sql using phpMyAdmin.
After it ran, it gave me the following:

Code:

Error
SQL-query:

ALTER TABLE nuke_users CHANGE uid uid int(11) NOT NULL auto_increment;

ALTER TABLE nuke_users CHANGE uname uname varchar(25) NOT NULL default \'\';

ALTER TABLE nuke_users CHANGE url url varchar(255) NOT NULL default \'\';

ALTER TABLE nuke_users CHANGE user_intrest user_intrest varchar(150) NOT NULL default \'\';

ALTER TABLE nuke_users CHANGE pass pass varchar(40) NOT NULL default \'\';

ALTER TABLE nuke_users CHANGE email email varchar(255) NOT NULL default \'\';
MySQL said: Unknown column 'uid' in 'nuke_users'

My question: did it run successfully or somehow the uid did not work all the way?

Thank you again for your help
Mark

Joined: Jan 31, 2004 Posts: -88

yeah, it would.

You can't run it twice, once the field names have been changed, the whole script is done and dusted.

ArtificialIntel

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Sure seems like it isn't uid. Can you list the fields for us from nuke_users?

Guest

uid only exists in the keys table as follow:

Code:

Keyname Unique Field Action
PRIMARY Yes uid Drop
uid No uid Drop
uname No uname Drop
user_session_time No user_session_time Drop
user_session_time_2 No user_session_time Drop
user_session_time_3 No user_session_time Drop

I am wondering if it realy needed!!
Thank you
Mark

Joined: Jan 31, 2004 Posts: -88

edit the nuke_users table and change all instances of uid to user_id and uname to username

ArtificialIntel

Guest

Now I have it as follow:

Code:

Keyname Unique Field Action
PRIMARY Yes uid Drop
user_session_time No user_session_time Drop
user_session_time_2 No user_session_time Drop
user_session_time_3 No user_session_time Drop
username No uname Drop
user_id No uid Drop

is this right?
Thank you
Mark

[/code]

Joined: Jan 31, 2004 Posts: -88

Close, but no cigar, Change it so it looks like this:

Code:

Keyname Unique Field Action
PRIMARY Yes user_id Drop
user_session_time No user_session_time Drop
user_session_time_2 No user_session_time Drop
user_session_time_3 No user_session_time Drop
username No username Drop
user_id No user_id Drop

Guest

Hummm! puzzelled! I thought I posted the changes!! I shouldv'e clicked preview first to make sure this what I wanted to post! sorry.

Ok... This is what I have now:

Code:

Keyname Unique Field Action
PRIMARY Yes uid Drop
user_session_time No user_session_time Drop
user_session_time_2 No user_session_time Drop
user_session_time_3 No user_session_time Drop
username No uname Drop
user_id No uid Drop

Thank you
Mark

Guest

Something wrong!! I put the text and Preview it and looks fine, but when I post it to switch the post to the good old one...!!! I will try to put it without the code tags:

Keyname Unique Field Action
PRIMARY Yes uid Drop
user_session_time No user_session_time Drop
user_session_time_2 No user_session_time Drop
user_session_time_3 No user_session_time Drop
username No uname Drop
user_id No uid Drop

lets see ... thank you
Mark

Guest

I can not belive it... I do not know what to tell you! but basically I had the table like you told me... and thank you for your help
Mark

Joined: Jan 31, 2004 Posts: -88

lol no worries, I know what u mean. Does it match what I posted?

ArtificialIntel

Guest

Yes! it matches whatever you have posted; however, I am still having the same problem when you click on View Information for the user group:

Code:

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'ORDER BY u.uname' at line 7

SELECT u.uname, u.uid, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.url, u.email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = 6 AND u.uid = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.uname

Line : 811
File : /home/www/mydomain/html/modules/Forums/groupcp.php

Regards..
Mark