Announcement

Collapse
No announcement yet.

mysql error number: 1052

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

  • mysql error number: 1052

    hi

    i found this databae erorr


    PHP Code:
    Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT
    user
    .useridreputationusernameusergroupidbirthday_searchemail,
    parentemail,(options 8) AS coppauserhomepageicqaimyahoomsn,
    signature,
    usertitlejoindatelastvisitlastpostpostsipaddressuserfield.*
    FROM user AS user
    LEFT JOIN userfield 
    AS userfield ON(userfield.userid user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid =
    user.userid)
    WHERE 1=AND username = \'\'
    ORDER BY username
    LIMIT 0, 25

    mysql error: Column: \'signature\' in field list is ambiguous

    mysql error number: 1052

    Date: Thursday 26th of August 2004 03:09:49 AM
    Script: http://www.xxx.com/vb/admincp/user.php
    Referer: http://www.xxx.com/vb/admincp/index.php?do=home
    Username: xxx
    IP Address: 212.138.64.174 

  • #2
    That error means two or more of the joined tables have a field named signature.

    There should only be a signature field in the usertextfield table. You probably added an extra field to one of the other tables at one point. You need to remove the extra field(s).

    Comment

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