newreply DB error 3.7.0 - Column 'dateline' in where clause is ambiguous

[ldma]

Here's the full text...no problems with quick reply so no riot on my hands yet...but needs addressing urgently.

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 30564
AND dateline > 1209452213
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 940480
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Request Date : Wednesday, April 30th 2008 @ 01:56:53 AM
Error Date : Wednesday, April 30th 2008 @ 01:56:53 AM
Script : http://www.ajarnforum.net/vb/newreply.php?do=postreply&t=30564
Referrer : http://www.ajarnforum.net/vb/newreply.php?do=newreply&noquote=1&p=940476
IP Address : 92.40.49.24
Username : LDMA
Classname : vB_Database
MySQL Version : 5.0.45-community

[Jose Amaral Rego]

Try uploading original vBulletin version 3.7.0 non-image files in ASCII(Auto) mode (except install.php) to overwrite those on server

You can just try this to see if you have any files that do not belong or have not been overwritten from an upgrade.
Admin Control Panel > Maintenance > Diagnostics > Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]


To disable the plugin/hook system completely without accessing the Admin CP options, you need to edit includes/config.php and add the following code after <?php in the next empty line:
define('DISABLE_HOOKS', true);



I would disable all modification first and see if that fixes the problem temporarily, then if not do the instructions above.

[ldma]

Yup...it was a moody hack...automerge doublepost...thanks!

[Jose Amaral Rego]

Double post maybe this
http://www.vbulletin.org/forum/showpost.php?p=1054999&postcount=568