Hello
I have this errore when search user in ACP:
*************************
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
user.userid, reputation, username, usergroupid, birthday_search, email,
parentemail,(options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, signature,
usertitle, joindate, lastvisit, lastpost, posts, ipaddress, userfield.*
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=1 AND username LIKE '%x\_5%'
ORDER BY username
LIMIT 0, 25
mysql error: Column: 'signature' in field list is ambiguous
mysql error number: 1052
Date: Thursday 02nd of September 2004 12:39:02 PM
Script: http://www.32uae.com/vb/admincp/user.php
Referer: http://www.32uae.com/vb/admincp/index.php?do=home
Username: x_5
IP Address: xxxxxxxx
*********************
Any idea?
Regards
alkahf
I have this errore when search user in ACP:
*************************
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
user.userid, reputation, username, usergroupid, birthday_search, email,
parentemail,(options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, signature,
usertitle, joindate, lastvisit, lastpost, posts, ipaddress, userfield.*
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=1 AND username LIKE '%x\_5%'
ORDER BY username
LIMIT 0, 25
mysql error: Column: 'signature' in field list is ambiguous
mysql error number: 1052
Date: Thursday 02nd of September 2004 12:39:02 PM
Script: http://www.32uae.com/vb/admincp/user.php
Referer: http://www.32uae.com/vb/admincp/index.php?do=home
Username: x_5
IP Address: xxxxxxxx
*********************
Any idea?
Regards
alkahf
Comment