[SOLVED] moscomprofiler::store failed - added column

All has been fine, but I added a new column to my jos_users called jackpot which i populate with a symbol if a user has paid to enter a jackpot contest. That way i can keep track of who has paid and who hasnt. But when i try to edit any users data in the CB USers list I get the following error.

moscomprofiler::store failed: Unknown column 'jackpot' in 'field list' SQL=UPDATE `jos_comprofiler` SET `user_id`=78.....

It still saves the data and it is changed so in some ways it isnt causing any problems except that it isnt ideal that it brings up errors, and I just dont want it to cause any errors somewhere else in the functionality of the CB database.

Any suggestions

I am making an assumption the symbol you enter is an ASCII symbol such as !@#$%^&*()_+ and not an image?

If so, then you might want to do it this way:

1. Delete the column you made in jos_users. This will bring you back to the default database before you added column.
2. Create a new tab in CB tab management and title it Jackpot. Set the Access level to Admin (SuperUser).
3. Next, create a new text field and label it Jackpot. Then add this field to the new Jackpot tab you created.

This new tab will not appear to the users when viewing their profile, but will appear to the Admin on the backend when viewing a user's profile when in edit user mode. Now you can open up a user, click on the Jackpot tab and make changes to this field from here. If you wish the tab and field to appear on user's profiles and allw them to view, change the tab from Admin(superUser) to Registered user and set the field to read only.

Hope this helps.

that soundspretty good, but ill describe ow it is used and see if that would still work.

The $ is what i would pt in and in the backend it is for my uses but when i do the points tally, an oscar pool contest, on the night i have a live standings page with user name and tally ppoints from a pools database. Thing is all people who enter its free, but i do a seperate jackpot for those that paid so on the standings i woould have a Username column, their points column and a column showing if they entered (ie the dollar sign woukld be behind those have paid) so ive got the pools view php gettig that info from the field ive created originally,so if i can do the same with the field from CB, then that would work, do you think it would? i Can show the code i have for the view php

Here is the rough way i want it to appear on the Live Standings page

Jim 155
Bob 145
Sam 142 $
Bill 140 $
Nancy 138

and here is what i did first for my original code, which was done by a freelancer

1. Add the field(jackpot eg) to the users table (I'm assuming you will manually add $ against the names)

2. components\com_pools\models\tally.php (change as follows)

$query =
"SELECT u.name as user, u.jackpot, SUM(tp2.points) AS user_points " .
"FROM #__tc_pools as tp, " .
" #__tc_categories as tc, " .
" #__tc_selections as ts, " .
" #__tc_points tp2, " .
" #__users u " .
"WHERE tp.id = tc.pool_id " .
"AND tc.id = tp2.category_id " .
"AND tc.id = ts.category_id " .
"AND tc.winner_nomination_id = ts.nomination_id " .
"AND ts.nomination_type = tp2.nomination_type " .
"AND ts.username = u.username " .
"GROUP BY u.name, u.jackpot " .
"ORDER BY SUM(tp2.points) DESC";

3. change components\com_pools\views\tally\tmpl\default.php

<tr><th>User</th><th>Points</th><th>Jackpot</th></tr>



<tr><td><?php echo $row->user ?></td><td><?php echo $row->user_points ?></td><td><?php echo $row->jackpot?></td></tr>

hope that gives enough info as to what im trying to achieve, if your solution can suit this would be great if not i can live with the error until after SUnday night

Why are you manually altering the database tables? Please don't tamper with the tables. To add a field simple add it through CB > Field Management and it'll safely add the table column to _comprofiler. Never alter _users, ever. In your query just do a join of _comprofiler and pull it from there.

ill put the user table back to the original status and hope my programemr can do this for me