vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Issue on UCP: Social Group Messages (https://vborg.vbsupport.ru/showthread.php?t=168396)

KURTZ 01-21-2008 06:07 PM
Issue on UCP: Social Group Messages
 
when i select Social Group Messages in my UCP i've the following error ...

Code:
Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

                        SELECT SQL_CALC_FOUND_ROWS
                                groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
                               
                                ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                               
                       
                        FROM nWmoderation AS moderation
                        INNER JOIN nWgroupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND type = 'groupmessage')
               
                        LEFT JOIN nWuser AS user ON (groupmessage.postuserid = user.userid)
                        LEFt JOIN nWsocialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
                        LEFT JOIN nWavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN nWcustomavatar AS customavatar ON(customavatar.userid = user.userid)
                       
                       
                        WHERE 1=1
                                AND moderation.dateline >= 1198343179
                               
                        ORDER BY groupmessage.dateline DESC
                        LIMIT 0, 10;

MySQL Error  : Column: 'type' in on clause is ambiguous
Error Number  : 1052
Date          : Monday, January 21st 2008 @ 06:06:19 PM
Script        : http://www.nowhine.net/board/moderation.php?do=viewgms&type=moderated
Referrer      : http://www.nowhine.net/board/moderation.php?do=viewvms&type=moderated
IP Address    : XXX.XXX.XXX.XXX
Username      : ADMIN
Classname    : vb_database
MySQL Version : 4.0.27-standard-log
someone can help me? Thx

PS. i've just updated my board @ Beta 4

Opserty 01-21-2008 06:22 PM
Its a vB bug, I just read about it on the vB.com forums. Check their Bug tracker for 3.7, it should be near the top as it is fairly recent. I'm not sure if they have uploaded a patch or not for it.

KURTZ 01-21-2008 07:19 PM
Quote:
Originally Posted by Opserty (Post 1426047)
Its a vB bug, I just read about it on the vB.com forums. Check their Bug tracker for 3.7, it should be near the top as it is fairly recent. I'm not sure if they have uploaded a patch or not for it.
Thank you so much mate ... :)

Opserty 01-21-2008 08:58 PM
Your welcome, you were lucky I had just seen it moments before ;)


All times are GMT. The time now is 10:59 PM.

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.00993 seconds
  • Memory Usage 1,723KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete