![]() |
|
#1
|
|||
|
|||
|
Any idea whats causing this / how to fix it?
Code:
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 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Column 'iconid' in from clause is ambiguous | stitch | Troubleshooting & Problems | 2 | 11-16-2005 05:44 PM |
| Fill dateline manually in MySQL? | blikos | "How Do I..." Questions | 2 | 10-22-2005 08:30 PM |
| Upgrade to 3.5 error. MySQL duplicate column name | DougM | Troubleshooting & Problems | 1 | 10-08-2005 06:30 PM |