vb.org Archive
Page 37 of 74 « First 273536 37 383947 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


All times are GMT. The time now is 07:26 AM.
Page 37 of 74 « First 273536 37 383947 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.02326 seconds
  • Memory Usage 1,745KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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