vb.org Archive - Upgrade From 3.6 gives SQL error

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

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

- - Upgrade From 3.6 gives SQL error (https://vborg.vbsupport.ru/showthread.php?t=123630)

Ntfu2

08-11-2006 02:08 AM

Upgrade From 3.6 gives SQL error

Anyone know which hack may cause this, i've disabled them via the config.php edit

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT COUNT(postid) AS count
FROM vb3_post AS post
LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE visible = 0 AND dateline > 1155260805
AND deletionlog.primaryid IS NULL;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, August 10th 2006 @ 11:04:07 PM
Script : http://www.xxxx.com/forums/
Referrer :
IP Address : xx
Username : xx
Classname : vB_Database

Kirk Y

08-11-2006 02:10 AM

<a href="https://vborg.vbsupport.ru/showpost.php?p=1019223" target="_blank">https://vborg.vbsupport.ru/showpost.php?p=1019223</a>

Ntfu2

08-11-2006 02:15 AM

Should i have done that before the upgrade?

doing it after the upgrade seems not to work?

Thanks for the help btw

Kirk Y

08-11-2006 02:32 AM

Do you have the Staff Can Post Hidden Posts mod installed?

If so, try changing the global_start hook for this mod from:

Code:

$posts = $db->query_first("

                SELECT COUNT(postid) AS count

                FROM " . TABLE_PREFIX . "post AS post

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

                WHERE visible = 0 AND dateline > " . $vbulletin->userinfo[lastvisit] . "

                        AND deletionlog.primaryid IS NULL

        ");

To...

Code:

$posts = $db->query_first("

                SELECT COUNT(postid) AS count

                FROM " . TABLE_PREFIX . "post AS post

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

                WHERE visible = 0 AND post.dateline > " . $vbulletin->userinfo[lastvisit] . "

                        AND deletionlog.primaryid IS NULL

        ");

Ntfu2

08-11-2006 02:43 AM

That was it, I appreciate your quick help ;)

Kirk Y

08-11-2006 03:06 AM

No problem.

wolfyman

08-12-2006 05:24 PM

Hmm, same error here. I have the double post merge hack installed, but I changed the hook as shown in that post above. I'm still getting the error.

Any other hacks that might cause this error?

Paul M

08-12-2006 06:29 PM

The fix above is not for the double post hack, so it's not likely to work.

Read the doublepost thread for the fix.

All times are GMT. The time now is 07:11 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01423 seconds Memory Usage 1,724KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: