vb.org Archive - SQL error after upgrade.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - SQL error after upgrade. (https://vborg.vbsupport.ru/showthread.php?t=143216)

mightyb

03-26-2007 03:30 PM

SQL error after upgrade.

Hey guys!

I went from 3.5.4 to 3.6.5 and now every time i login as an admin i get the following error:

Database error in vBulletin 3.6.5:

Code:

Invalid SQL:



        SELECT COUNT(postid) AS count

        FROM vbpost AS post

        LEFT JOIN vbdeletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')

        WHERE visible = 0 AND dateline > 1174327637

            AND deletionlog.primaryid IS NULL;



MySQL Error  : Column 'dateline' in where clause is ambiguous

Error Number : 1052

Date         : Monday, March 19th 2007 @ 02:54:59 PM

Script       : http://www.thelocalforum.co.uk/forum/

Referrer     : 

IP Address   : my IP

Username     : My username

Classname    : vb_database

Everything else seem to work fine. I was told that this error is probably caused by a mod. Does anyone know what one that might be and how i could disable it via php admin because obviously i don't have access to CP.

Thanks a lot!

Lynne

03-26-2007 03:58 PM

Which table is dateline in? Change it from just "dateline" to "table.dateline" where table is the name of the table.

WetWired

03-26-2007 07:10 PM

That looks like a query to find the number of new posts needing moderation. I'd guess that you either have a mod relating to thread/post moderation (or just a general admincp front page enhancement) that needs updating, or that you didn't upload the new admincp files and it's still running on old code.

All times are GMT. The time now is 11:50 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00887 seconds Memory Usage 1,711KB 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 (3)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
Messages: