Announcement

Collapse
No announcement yet.

Column 'points' in field list is ambiguous

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Column 'points' in field list is ambiguous

    Need a little help. I believe the column points carried over from this store product from a while ago. Anyways, here is the error.

    PHP Code:
    Database error in vBulletin 3.6.0 Beta 2:
    Invalid SQL:
     
    SELECT pointsinfraction.*, thread.titlethread.forumidthread.postuseriduser.username,
     
    thread.visible AS thread_visiblepost.visiblethread.postuserid, IF(ISNULL(post.postid) AND infraction.postid != 010) AS postdeleted
     FROM infraction 
    AS infraction
     LEFT JOIN post 
    AS post ON (infraction.postid post.postid)
     
    LEFT JOIN thread AS thread ON (post.threadid thread.threadid)
     
    LEFT JOIN user AS user ON (infraction.whoadded user.userid)
     
    WHERE infraction.userid 17690
     ORDER BY infraction
    .dateline DESC
     LIMIT 5
    ;
    MySQL Error  Column 'points' in field list is ambiguous
    Error Number 
    1052 
    I'm guessing I'm going to have to manually troubleshoot this error so could some advise me towards fixing it? Thank you

  • #2
    Before I forget, this is for the usercp.php main page.

    AND http://images.vbulletin.com/images_v...iquote_off.gif
    That icon does not load on this thread at the time I'm posting this message. You just get a little red error image box.

    Comment


    • #3
      i have the same problem and i post it and i didnt found any solution for that here in vbulletin ,,

      but i found the solution for this problem ,, just go to usercp.php and then search for "SELECT points" and replace it with "SELECT user.points" and that will solve the problem ,,



      good luck

      haytham.us/vb

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X