vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Portal Software - Ap - Groups (https://vborg.vbsupport.ru/showthread.php?t=182845)

transparent 07-03-2008 11:33 PM

Quote:

Originally Posted by sross (Post 1559042)
Warning, this can cause mass carnage on a large site it shows info from private groups in the latest post block, no fix yet, guess I'll uninstall it..

Quote:

Originally Posted by Zacarias (Post 1555726)
The latest posts show posts from boards that a user is not a member of, even when the group's messages and content are set to private.

Quote:

Originally Posted by sross (Post 1556570)
Yes, very dangerous! Can someone supply a fix for this asap? Thanks! -and great mod btw! :)

This is a great hack but I can't see how any w/ private groups can use it without this bug being fixed first. I have it disabled for now.

Is this being worked on????

desibw 07-04-2008 07:27 PM

installed ...thanks man ...its realy good

Baldilocks 07-05-2008 07:19 AM

I have the "Latest Posts and Most Active" blocks disabled anyway. Since I use the Social Group Forums, those two blocks don't pull the correct information anyway....

If you set them to 0, they won't display.

Animecraving 07-05-2008 04:29 PM

For the next version if you can make it have favorite group. where people can add a group as their favorite

Chadi 07-06-2008 06:09 PM

I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

jacki 07-06-2008 07:15 PM

very nice :) thanx kaptanblack

Ideal Web Tech 07-06-2008 09:16 PM

Quote:

Originally Posted by chadi (Post 1568333)
I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

Check and make sure that all your db's tables are set to the same collation type as from the error thats telling me that your tables for vbulletin are not all of the same collation type.

You can check this using phpmyadmin. (I dont remember how off the top of my head, If I get time later to look it up I will let you know the steps)

Chadi 07-08-2008 12:54 PM

I don't see why I should have to do that. I have never encountered this issue before and I have nearly 70 mods installed too.

Justin Murad 07-08-2008 04:19 PM

Thanks, nice plugin. ;)

zmmmzz 07-09-2008 04:10 AM

nice!


All times are GMT. The time now is 10:53 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01160 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete