vb.org Archive
Page 10 of 19 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - SocialForums 1.4 (https://vborg.vbsupport.ru/showthread.php?t=174878)

djilou 05-27-2008 12:02 PM
I have a problem with the 1.4.1 version
Quote:
Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT
t.postusername, t.threadid, t.title, t.lastpost, t.lastpostid, t.replycount, t.views, p.pagetext, p.dateline, p.userid, u.username,
IF(displaygroupid=0, u.usergroupid, displaygroupid) AS displaygroupid
, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb
FROM thread AS t
INNER JOIN post AS p ON t.lastpostid=p.postid
INNER JOIN user AS u ON p.userid=u.userid
LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid)
WHERE t.forumid=86 AND t.visible=1
ORDER BY t.lastpost
LIMIT 10;

MySQL Error : Unknown column 'user.avatarrevision' in 'field list'
Error Number : 1054

almera 05-27-2008 12:04 PM
When trying to import 1.4.1 I get this error:

Importing Product, Please Wait...

[:]

vBulletin Message
Invalid File Specified

I have uploaded bitfield_vbblog.xml to ./includes/xml and checked that the path is correct.

ecihanuysal 05-27-2008 12:05 PM
After just i have updated it

i got a db error..

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT
                                t.postusername, t.threadid, t.title, t.lastpost, t.lastpostid, t.replycount, t.views, p.pagetext, p.dateline, p.userid, u.username,
                                IF(displaygroupid=0, u.usergroupid, displaygroupid) AS displaygroupid
                                , user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb
                                FROM db_thread AS t
                                INNER JOIN db_post AS p ON t.lastpostid=p.postid
                                INNER JOIN db_user AS u ON p.userid=u.userid
                                LEFT JOIN db_avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN db_customavatar AS customavatar ON (customavatar.userid = u.userid)
                                WHERE t.forumid=187 AND t.visible=1
                                ORDER BY t.lastpost
                                LIMIT 10;

MySQL Error  : Unknown column 'user.avatarrevision' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, May 27th 2008 @ 04:02:23 PM
Error Date    : Tuesday, May 27th 2008 @ 04:02:23 PM
Script        : http://faz.la/group.php?groupid=7
Referrer      : http://faz.la/group.php?do=createforum&groupid=7

Phalynx 05-27-2008 12:14 PM
It must be the heat today in germany - fixed and reuploaded. Sorry!

VargTimmen 05-27-2008 12:16 PM
I think, I have found another Bug:
The overview from the Forum is ascending in Date. The oldest Posts are the first, which are shown, seen, as here:
http://forum.gcult.de/group.php?groupid=5

Kind regards,
Benny

almera 05-27-2008 12:25 PM
Quote:
Originally Posted by Phalynx (Post 1532851)
It must be the heat today in germany - fixed and reuploaded. Sorry!
N/p. You do an awesome job man! I think you should go commercial and extend the community features.

I'll try the new version now, thanks!

Phalynx 05-27-2008 12:31 PM
Which file are your trying to upload?

almera 05-27-2008 12:32 PM
Quote:
Originally Posted by Phalynx (Post 1532866)
Which file are your trying to upload?
Sorry, my bad!

Phalynx 05-27-2008 12:35 PM
Ok... the fix was for the avatarrevision :)

djilou 05-27-2008 12:35 PM
Quote:
Originally Posted by VargTimmen (Post 1532854)
I think, I have found another Bug:
The overview from the Forum is ascending in Date. The oldest Posts are the first, which are shown, seen, as here:
http://forum.gcult.de/group.php?groupid=5

Kind regards,
Benny
yep same here,
and the "Last Post" column show never for old forum's group

djilou 05-27-2008 12:42 PM
another thing, I have some word in french like : m'active
after update I see : m\'active
how can I remove the \ ?

almera 05-27-2008 12:42 PM
I have another issue. The "Add new thread" button on a group page is a non-clickable image. The link, saying "Add new thread", is side by side with the pic.

Varsh 05-27-2008 01:45 PM
Quote:
Originally Posted by djilou (Post 1532879)
another thing, I have some word in french like : m'active
after update I see : m\'active
how can I remove the \ ?
That's an issue with PHP, check whether magicquotes is turned on or off on your server.

Phalynx 05-27-2008 01:47 PM
Quote:
Originally Posted by djilou (Post 1532871)
yep same here,
and the "Last Post" column show never for old forum's group
What do you mean exactly with "old forum's group"?

Quote:
Originally Posted by djilou (Post 1532879)
another thing, I have some word in french like : m'active
after update I see : m\'active
how can I remove the \ ?
Quote:
Originally Posted by almera (Post 1532880)
I have another issue. The "Add new thread" button on a group page is a non-clickable image. The link, saying "Add new thread", is side by side with the pic.
Fixed in 1.4.2

djilou 05-27-2008 01:49 PM
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off

Phalynx 05-27-2008 01:51 PM
This is a bug in 1.4.x prior to 1.4.2, not a behaviour of PHP.

djilou 05-27-2008 01:53 PM
Quote:
Originally Posted by Phalynx (Post 1532949)
What do you mean exactly with "old forum's group"?
I have a forum A with threads, I create a new group A
I assign the old forum A as a forum for the group A from Phpmyadmin, instead create a new forum for this group :D

Phalynx 05-27-2008 01:55 PM
If you linked it via table "socialgroup" in the column "forumid" than this hack should accept it without problems.

djilou 05-27-2008 02:02 PM
Yes this is what I did

Phalynx 05-27-2008 02:04 PM
And what exactly does not work?

Phalynx 05-27-2008 02:11 PM
Update to 1.4.2 has been released. It fixes the slashes, last post info and it has a changed layout regarding new thread button.

djilou 05-27-2008 03:58 PM
Quote:
Originally Posted by Phalynx (Post 1532970)
And what exactly does not work?
On groups home page, "Last Post" column show never for old forum's group

MaxiMal 05-27-2008 04:01 PM
in 142:
Code:
Группу создал [ARG:3 UNDEFINED]
http://infofree.ru/forum/group.php?groupid=44

pkallberg21 05-27-2008 04:55 PM
Great idea for a mod! Thanks a lot!

I have a few remarks though:
Why are group starters with forums appearing in my showgroups.php page as moderators? This feels pretty weird, having normal users there.

Also, since I use vBSEO to rewrite all my URL's, when one "url" is the same as another "url", it redirects to the first page available with that name. For example, if a user were to start a group called "Cats" with a forum, its URL would become http://www.x.com/forum/cats. If I someday would like to start a forum regarding cats on my board, it would receive the same URL from the rewrite. Is there any way of distinguishing group forum URL's, so that they do not interfere with ones of the "normal" forums?

Thanks again! Good job.

Mark.B 05-27-2008 06:19 PM
Quote:
Originally Posted by djilou (Post 1533068)
On groups home page, "Last Post" column show never for old forum's group
I *think* I'm getting the same thing.

The last post column is showing "never" on group.php for the bottom group in the list, even though its forum has had posts.

Also, is it possible to query the last poster details as well, so that the display is consistent with groups that DON'T have fourms, and still use the default messaging system?

Mark.B 05-27-2008 06:22 PM
Quote:
Originally Posted by pkallberg21 (Post 1533126)
Why are group starters with forums appearing in my showgroups.php page as moderators? This feels pretty weird, having normal users there.
That isn't happening for me....have you got the setting enabled that makes group owners into moderators for the forums they create? I have that set to no, and I don't get the problem you're describing.

DieselTruck 05-27-2008 06:50 PM
Quote:
Originally Posted by pkallberg21 (Post 1533126)
Great idea for a mod! Thanks a lot!

I have a few remarks though:
Why are group starters with forums appearing in my showgroups.php page as moderators? This feels pretty weird, having normal users there.


Thanks again! Good job.
X2..

I'm having that problem also, Can't figure out how to remove them..

Mark.B 05-27-2008 06:53 PM
Quote:
Originally Posted by DieselTruck (Post 1533233)
X2..

I'm having that problem also, Can't figure out how to remove them..
Check in your forum manager and see if they are actually set as moderators. If so, remove them. And change the setting in the social forums options so that group owners do not become moderators of forums they create.

DieselTruck 05-27-2008 06:56 PM
Quote:
Originally Posted by Mark.B (Post 1533239)
Check in your forum manager and see if they are actually set as moderators. If so, remove them. And change the setting in the social forums options so that group owners do not become moderators of forums they create.
Ok, That fixes that problem. But, how do I add moderators to each social forum?

Mark.B 05-27-2008 07:04 PM
Well, by default you can only add either the group owner or nobody automatically.

However, if you assign your desired moderators to the "parent" forum, these will cascade down and give the same moderators permissions in any social group forums that are created.

mikeylikesitz 05-27-2008 09:27 PM
you can take care of this by changing the settings in General Settings > Enable Forum Leaders to "Yes, but disable moderators", that will leave them as moderators of the group forums and not show them on the Forum Leaders page.

DieselTruck 05-27-2008 09:29 PM
Quote:
Originally Posted by mikeylikesitz (Post 1533412)
you can take care of this by changing the settings in General Settings > Enable Forum Leaders to "Yes, but disable moderators", that will leave them as moderators of the group forums and not show them on the Forum Leaders page.
Yes, But, Personally I like the idea of a moderator's list on the showgroup.php page. Helps members locate staff if needing help, etc.

mikeylikesitz 05-27-2008 09:46 PM
it wont disable the moderators group listing on the forums, just the individual moderators per forum listed

Phalynx 05-28-2008 09:33 AM
Quote:
Originally Posted by pkallberg21 (Post 1533126)
Why are group starters with forums appearing in my showgroups.php page as moderators? This feels pretty weird, having normal users there.
There is no other way giving the leader moderation abilities. Disable this behaviour via settings, remove existing moderators from the forums.

Quote:
Originally Posted by pkallberg21 (Post 1533126)
Also, since I use vBSEO to rewrite all my URL's, when one "url" is the same as another "url", it redirects to the first page available with that name. For example, if a user were to start a group called "Cats" with a forum, its URL would become http://www.x.com/forum/cats. If I someday would like to start a forum regarding cats on my board, it would receive the same URL from the rewrite. Is there any way of distinguishing group forum URL's, so that they do not interfere with ones of the "normal" forums?
That's not a problem with this hack. Same thing would be if you would have multiple troubleshooting forums for different topics, e.g. mobiles.

edenx 05-28-2008 11:13 AM
Quote:
Originally Posted by Phalynx (Post 1533886)
There is no other way giving the leader moderation abilities. Disable this behaviour via settings, remove existing moderators from the forums.


That's not a problem with this hack. Same thing would be if you would have multiple troubleshooting forums for different topics, e.g. mobiles.
Phalynx, maybe this hack should check group name v/s forum existing names, as an admin configurable option. (allow or not allow group names with same name as forum OR add created forum a prefix: Group-CAT)

I also use vBSEO, like many big-boards and this could be a potential problem.
Thanks

MrEyes 05-28-2008 11:46 AM
Another vote the the vbSeo compatibility, not an issue right now but it could become one in the future.

Also a quick question relating to Restriction mode...

If I set this to "no" does it remove the additional 2 SQL calls? And if set to "no" what permissions are assumed?

Phalynx 05-28-2008 11:55 AM
No means there is no check for permissions. The forums permissions are untouched. You can pre-define the permission on the parent forum, all subforums inherite that permissions.

pkallberg21 05-28-2008 02:36 PM
Quote:
Originally Posted by Mark.B (Post 1533239)
Check in your forum manager and see if they are actually set as moderators. If so, remove them. And change the setting in the social forums options so that group owners do not become moderators of forums they create.
I disabled it despite the fact that I would like group owners to become moderators of their forums. This is however the best solution as I do not want my showgroups.php filled with random users.

Regarding the vBSEO problem though, is there any solution to this? The quicker we can find a solution to this the better, imho.

Thanks.

VargTimmen 05-28-2008 07:33 PM
Hi,

I upgraded to the new Version (1.4.2) and it works well.
But, and this is, in my opinion, an important function:
Could you build in, that Admins and Supermods always can see the groupforumlink (and the forum of course) and keep their rights.

Kind regards
Benny

abrecher 05-28-2008 08:36 PM
The "Visit the forum of this group." should be MUCH more noticeable.


All times are GMT. The time now is 12:47 AM.
Page 10 of 19 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

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.01958 seconds
  • Memory Usage 1,840KB
  • 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
  • (2)bbcode_code_printable
  • (20)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
  • (40)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