MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous

[Bailx]

Any idea whats causing this / how to fix it?

Database error in vBulletin 3.6.0:

Invalid SQL:

					SELECT threadid, firstpostid FROM thread AS thread
					LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
					WHERE visible = 1 AND open != 10 AND thread.forumid IN(2) AND deletionlog.primaryid IS NULL
					ORDER BY sticky DESC,dateline DESC
					LIMIT 5;

MySQL Error  : Column 'dateline' in order clause is ambiguous
Error Number : 1052
Date         : Saturday, August 19th 2006 @ 05:57:38 PM
Script       : http://www.mysite.com/cmps_index.php
Referrer     : 
IP Address   : 
Username     : 
Classname    : vb_database

[Bailx]

i guess maybe more info would be helpful....

upgrading from 3.5.3, ran the upgrade script, forum works fine and everything, just the portal main page gets that error...

[Zachery]

Try disabling the quick moderation menu.

[Bailx]

get this when i try to get to the default settings page.

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT varname, text FROM phrase WHERE phrasetypeid = 5000 ORDER BY languageid ASC;

MySQL Error  : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
Date         : Saturday, August 19th 2006 @ 11:25:00 PM
Script       : http://mysite.com/admincp/vba_cmps_admin.php?do=modifysettings
Referrer     : http://mysite.com/admincp/index.php?do=nav
IP Address   : 
Username     : 
Classname    : vb_database

[Bailx]

i' seem to remember something with the phrases in the past...

this was back when vbulletin wasn't working properly with mysql 4.1x and my database got all corrupted... there was something about the fact that even though i was using english, i had to translate my forum "into" english....

i don't know much else, but perhaps it's related...

[Zachery]

If you are getting phrasetypeid errors you are not running the vBa 2.2 files.

[Bailx]

heh i don't see how thats possible, i uploaded vb 3.6, upgraded the forum, then downloaded a fresh copy from here, uploaded those...ran the upgrade...

guess i'll... repeat the upload/upgrade and see if it affects anything....

[Bailx]

installing it a 2nd time fixed it... thx for the help.
b.

[Zachery]

Glad you got it fixed.