Results 1 to 9 of 9

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

  1. #1
    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

  2. #2
    Junior Member
    Join Date
    Mar 2004
    Posts
    19

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

    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...

  3. #3
    Super Moderator Zachery's Avatar
    Join Date
    Jan 2004
    Posts
    3,186

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

    Try disabling the quick moderation menu.
    Zachery
    I may or may not do things.

  4. #4
    Junior Member
    Join Date
    Mar 2004
    Posts
    19

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

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

    Code:
    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

  5. #5
    Junior Member
    Join Date
    Mar 2004
    Posts
    19

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

    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...
    Last edited by Bailx; 08-20-2006 at 05:45 PM.

  6. #6
    Super Moderator Zachery's Avatar
    Join Date
    Jan 2004
    Posts
    3,186

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

    If you are getting phrasetypeid errors you are not running the vBa 2.2 files.
    Zachery
    I may or may not do things.

  7. #7
    Junior Member
    Join Date
    Mar 2004
    Posts
    19

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

    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....

  8. #8
    Junior Member
    Join Date
    Mar 2004
    Posts
    19

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

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

  9. #9
    Super Moderator Zachery's Avatar
    Join Date
    Jan 2004
    Posts
    3,186

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

    Glad you got it fixed.
    Zachery
    I may or may not do things.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Column 'iconid' in from clause is ambiguous
    By stitch in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 11-16-2005, 06:44 PM
  2. Fill dateline manually in MySQL?
    By blikos in forum "How Do I..." Questions
    Replies: 2
    Last Post: 10-22-2005, 08:30 PM
  3. Upgrade to 3.5 error. MySQL duplicate column name
    By DougM in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-08-2005, 06:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •