2 Things Really

[Wolfe]

I updated my forums from 2.3.0 to 3.0.0 beta 3 and when i click on a forum i got this error


Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
### GET MOST RECENT ANNOUNCEMENT ###
SELECT
announcementid, startdate, title, views,
user.username, user.userid, user.usertitle, user.customtitle
FROM announcement AS announcement
LEFT JOIN user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1055631110
AND enddate >= 1055631110
AND forumid IN (7,6,-1)
ORDER BY startdate DESC
LIMIT 1

mysql error: Column: 'views' in field list is ambiguous


what does this mean :(

also in the admin cp when you add a promotion when you pick

Promotion Strategy as posts and reputation and date it does not show a Promotion Strategy on the modify page :(

but can you please help me fix the above error please

[Freddie Bingham]

What modify page?

The views error is because you have added a 'views' column to your user table. Remove it.

[Wolfe]

heres what i mean d00d

[Wolfe]

thanx fixed the problem with the forumdisplay how did you know there was a views in user table also what does ambigues mean

[Freddie Bingham]

Edit line 806 of admincp.usergroup.php

change

$vbphrase['promotion_strategy' . $promotion['strategy']],


to


$vbphrase['promotion_strategy' . ($promotion['strategy'] + 1)],

[Wolfe]

d00d working that how would i make the ranks system in to 2 of them for somthing like this

* (stars fo every 500 posts)
- (pips for every 50 posts)

how would i do this i made a second table and added the $vbphrase[user_rank2]

how would i make it show up in the postbit