error databse when use userCP

[GTTG]

hello all

i have been upgrade vbb forum 3.5.4 to 3.6.1 but when i use userCP it error database
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT points, infraction.*, thread.title, thread.forumid, thread.postuserid, user.username,
thread.visible AS thread_visible, post.visible, thread.postuserid, IF(ISNULL(post.postid) AND infraction.postid != 0, 1, 0) AS postdeleted
FROM giaitrit_UiTrOiinfraction AS infraction
LEFT JOIN xxxxxxxxxit changexxx AS post ON (infraction.postid = post.postid)
LEFT JOIN xxxxxxxxxit changexxx AS thread ON (post.threadid = thread.threadid)
LEFT JOIN xxxxxxxxx user xxxxxxx AS user ON (infraction.whoadded = user.userid)
WHERE infraction.userid = 1
ORDER BY infraction.dateline DESC
LIMIT 5;
MySQL Error : Column: 'points' in field list is ambiguous
Error Number : 1052
Date : Saturday, September 23rd 2006 @ 05:03:51 AM
Script : http://www.mydomain.com/forum/usercp.php
Referrer : http://www.mydomain.com/forum/memberlist.php
IP Address : 222.253.237.65
Username : admin
Classname : vB_Database


help me fix problem
thank

[Marco van Herwaarden]

Assuming you didn't get any error messages during upgrade, or skipped upgrade steps, then the only table of the 4 in that query that has a 'points' column should be 'infraction'.

If there is a point column in any of the user, thread or post table, then this is probably added by a modification you have installed.

Please uninstall the modificaiton that is causing you problems.

[GTTG]

didn't get any error during upgrade or skip ugrade .
i have install mod PET & UCASH 3 month ago . i was uninstall it but didn't fix error when used userCP .
who can help me ?????

[HAYTHAM]

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 some where else,, just go to usercp.php and then search for "SELECT points" and replace it with "SELECT user.points" and that will solve the problem ,,


replay if that solve ur problem ,.

good luck ;)

HAYTHAM
haytham.us/vb