[vbboarder]

Fixed the TABLE_PREFIX bug in v1.0.0. Reupload all files and reimport the 1.0.1 product xml file with allow overwrite.

[Huy Hoàng]

Import the file groupstats_vba.xml, you place?

[alehawk]

It doesnt work

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'adforop_000032.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 02:56:10 PM
Error Date : Sunday, February 8th 2009 @ 02:56:10 PM
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log

For some reason didnt add the table prefix to the query, it will query from table socialgroup instead of myprefix_socialgroup.

Can that be fixed?

[RvG2]

very very nice mod!

thanks for sharing

[kleinschwanz]

However... when I enable this hack it shows me following:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

It is not the edit, as I haver undone it with the editor... but the failure still showed up. I can only browse index.php when the mod is disabled... I guess this is not what you wanted...

[PakFuse]

I am getting a very similar error ... except that my MySQL version is 5.0.51a-log

I first installed noedit version and had to uninstall it due to this error.

I then, installed 2edit version and edited the group.php as advised; same error...

I have disabled the MOD but if this can be fixed or pointed out why such an error is occuring, that would be a great help.

Originally Posted by alehawk

It doesnt work

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'adforop_000032.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 02:56:10 PM
Error Date : Sunday, February 8th 2009 @ 02:56:10 PM
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log

For some reason didnt add the table prefix to the query, it will query from table socialgroup instead of myprefix_socialgroup.

Can that be fixed?

[kleinschwanz]

I guess it can... if oyu have a new install create at least one group and then enable the product again... it worked for me

[PakFuse]

^ tried that, got the following error:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'pakfuse_vbulletin_011409.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 09:38:12 PM
Error Date : Sunday, February 8th 2009 @ 09:38:12 PM
Script : [url of my forum]
Referrer : [URL of the group I created]
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-log

[vbboarder]

Sorry guys about the Sql error. There were 3 queries where I forgot to prefix the name of the table with TABLE_PREFIX. This error does not affect users who don't use table prefixes. I think I caught all the prefix problems now. The zip files were updated.

To Update: For both versions of this mod, reupload all files to your forum directory AND reimport the product xml file with allow overwrite.

[Huy Hoàng]

Has successfully installed. Very good

[vbboarder]

Originally Posted by Huy Hoàng

Has successfully installed. Very good

Glad to hear it works fine

[alehawk]

it worked. tnx!

[Huy Hoàng]

I then upgraded that version is still 1.0.0? (selected override mode)

[vbboarder]

The version number in the xml file was not updated - it will not affect the functionality of the mod or VB. If you want to update it, simply go to Manage Products > Categories' Group Statistics > and update the version # to 1.0.1