vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   error in get new posts (https://vborg.vbsupport.ru/showthread.php?t=178488)

cgway.net 05-08-2008 02:09 AM
error in get new posts
 
hello

i have more errors after upgrde to vb3.7.0

when any member press on http://www.cgway.net/search.php?do=getnew

will get this error


Code:
Database error in vBulletin 3.7.0:

Invalid SQL:

                        SELECT post.pagetext AS preview,
                                thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
                                thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
                                thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
                               
                                replycount, IF(views<=replycount, replycount+1, views) AS views,
                                thread.lastpost, thread.lastposter, thread.lastpostid
                        ,
                                deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
                                user.userid AS postuserid
                                , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                               
                                , attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , post.pagetext AS previewbbcode
                        FROM thread AS thread
                        LEFT JOIN user AS user ON(user.userid = thread.postuserid)

                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                       
                        LEFT JOIN subscribethread AS subscribethread
                                ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                       
                        LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
                        WHERE thread.threadid IN
                (11115, 11100, 9266, 11104, 11114, 11087, 11093, 10970, 11113, 6216, 11103, 11105, 10961, 7970, 10851);

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140
Request Date  : Wednesday, May 7th 2008 @ 02:25:45 AM
Error Date    : Wednesday, May 7th 2008 @ 02:25:45 AM
Script        : http://www.cgway.net/search.php?searchid=97720
Referrer      : http://www.cgway.net/private.php?do=showpm&pmid=135873
IP Address    : 212.43.19.1
Username      : gfhhj
Classname    : vB_Database
MySQL Version : 5.0.45-community-log
please help it's very important for my site

i wait the support

Kirk Y 05-08-2008 02:17 AM
Did you overwrite all your non-image files with the 3.7.0 files?

Lynne 05-08-2008 02:26 AM
You might want to look at this thread: http://www.vbulletin.com/forum/showt...=GROUP+columns

cgway.net 05-09-2008 02:38 AM
yes i have overwrite all files

please help me with the solution

Marco van Herwaarden 05-09-2008 08:53 AM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

If your problem still exists, please create a new Style with no Parent set. Now browse the forum using this new style, do you still have the same problems? If you are troubleshooting login or guest issues, you will need to set this style as board default in the vBulletin Options.


All times are GMT. The time now is 12:57 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.00928 seconds
  • Memory Usage 1,727KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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