vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced CMPS > vBa CMPS v2.0 Support > Troubleshooting & Problems

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-19-2006, 06:05 PM
Bailx Bailx is offline
Junior Member
 
Join Date: Mar 2004
Posts: 19
Default MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous

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
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT -4. The time now is 10:11 AM.

Forums Powered by vBulletin, Copyright ©2000-2009, Jelsoft Enterprises Ltd.
Please note that vBadvanced is in no way affiliated with Jelsoft Enterprises Ltd, nor will Jelsoft be able to provide any support for our products.