PDA

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

Bailx
08-19-2006, 06:05 PM
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
08-19-2006, 07:42 PM
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...
Our Sponsors
 
Zachery
08-19-2006, 08:28 PM
Try disabling the quick moderation menu.
Bailx
08-19-2006, 11:26 PM
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
Our Sponsors
 
Bailx
08-20-2006, 04:11 PM
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
08-20-2006, 06:24 PM
If you are getting phrasetypeid errors you are not running the vBa 2.2 files.
Bailx
08-20-2006, 09:34 PM
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
08-23-2006, 04:27 PM
installing it a 2nd time fixed it... thx for the help.
b.
Zachery
08-23-2006, 04:55 PM
Glad you got it fixed.