vb upgrade Error
 

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

Disable all plugin and than upgrade it ;)

That's the Staff can post hidden posts mod - you need to update it for vb 3.6

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

Nope, it's a product (plugins), you can only remove it in the ACP.

that mean reinstate older ver then remove plugin before upgrading to 3.6 2?