Log in

View Full Version : vb upgrade Error

almac
10-20-2006, 12:27 AM
Forum page looked perfect till i logged in then got error page with box inside containing bellow error. what do I do?

Database error in vBulletin 3.6.2:

Invalid SQL:


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

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, October 19th 2006 @ 08:15:14 PM
Script : http://www.postforprizes.com/login.php?do=login
Referrer : http://www.postforprizes.com/admincp/index.php
IP Address : 84.43.111.230
Username : posttrauma
Classname : vb_database
G0F0RBR0KE
10-20-2006, 01:57 AM
Disable all plugin and than upgrade it ;)
Paul M
10-20-2006, 02:56 AM
That's the Staff can post hidden posts mod - you need to update it for vb 3.6
almac
10-20-2006, 11:45 AM
noticed elswere that no mod is needed to to post hidden posts as can be done through permissions is there a folder that i can just delete that contains the hidden post mod?
i am not able to log in as previous user but can as new user or non mod ok So no access to admin
Paul M
10-20-2006, 04:17 PM
Nope, it's a product (plugins), you can only remove it in the ACP.
almac
10-20-2006, 05:54 PM
that mean reinstate older ver then remove plugin before upgrading to 3.6 2?