Transfering Social Groups Database Error

[itsIAN]

Hi,

When we try to transfer social groups, we're getting a database error. Not sure why, the database details are fine- and the files seem to be fine too.

Any suggestions on how to fix this?

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[Caddyman]

I'm getting the same problem...


Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

SELECT user.userid, COUNT(groupid) AS targetgroups
FROM talkdel_user AS user
LEFT JOIN talkdel_socialgroup AS socialgroup ON socialgroup.creatoruserid = user.userid
WHERE username = "19720";

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Sunday, October 12th 2008 @ 11:57:34 PM
Error Date : Sunday, October 12th 2008 @ 11:57:35 PM
Script : http://www.talkdelaware.com/group.php?do=dotransfer&groupid=21
Referrer : http://www.talkdelaware.com/group.php?do=transfer&groupid=21
IP Address : 68.39.202.14
Username : Chase
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Steve Machol]

Please start your own thread with all the relevant details. Thank you.

[itsIAN]

Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

SELECT user.userid, COUNT(groupid) AS targetgroups
FROM user AS user
LEFT JOIN socialgroup AS socialgroup ON socialgroup.creatoruserid = user.userid
WHERE username = "smarfingos";

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Monday, October 13th 2008 @ 12:15:49 AM
Error Date : Monday, October 13th 2008 @ 12:15:49 AM
Script : http://www.midnightneoforums.com/group.php?do=dotransfer&groupid=1
Referrer : http://www.midnightneoforums.com/group.php?do=transfer&groupid=1
IP Address : 69.72.123.124
Username : Trevor
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Steve Machol]

Please report this in the Bug Tracker here:

http://www.vbulletin.com/forum/project.php?projectid=6

[itsIAN]

Please report this in the Bug Tracker here:

http://www.vbulletin.com/forum/project.php?projectid=6

Done. :)