Hello,

I have drupal 5.3 and I have installed userpoints 5.x-3.4 and userpoints contrib module 5.x-2.0. I realised that the two versions weren't compatible, so I delete the two modules and installed userpoints 5.x.2.16 and userpoints contrib module 5.x.2.0.

Now, when I go to administration of points (user/userpoints) the below error appears:

user warning: Unknown column 't.event' in 'field list' query: SELECT t.txn_id, t.uid, t.time_stamp, t.points, t.event, t.status FROM userpoints_txn t WHERE t.status = 1 ORDER BY uid DESC LIMIT 0, 30 in /var/www/drupal2/includes/database.mysql.inc on line 172.

In an essay to resolve the problem, I deleted the two modules again, delete the tables userpoints and userpoints:tnx in database, run the update.php script and then installed the modules again, but the same error appears.

Can anybody help? I somewhat urgent :-S

Thanks in advance,

Troiana

Comments

jredding’s picture

jredding commented
Assigned: Unassigned » jredding
Priority: Critical » Normal

yes, yes everything is urgent. Please don't mark things critical unless they are critical to the entire userbase and not simply you.

User points Version 3 and userpoints Version 2 use completely different tables thus they are not compatible. There are warnings on both the frontpages of both projects. If you simply deleted the modules and did not uninstall them via the administrative menus then the tables, variables and system tables were not cleaned up. I understand that you delete the tables but this is not enough (hence why Uninstalls are provided).

To fix the errors you should use the uninstall methods provided via the modules OR
(1) delete the modules
(2) Clean up all variables in the variables tables
(3) ensure that the system table doesn't contain references to userpoints
(4) delete the userpoints tables

then download and install as if nothing happened.

You could also manually follow the uninstall procedures in the .install files.

jredding’s picture

jredding commented
Status: Active » Closed (fixed)
Helenag’s picture

Helenag commented

sorry about the "critical" thing, I didn't know...

And thank you for your help I did what you pointed out, step by step, and it solved the problem! :-)

Thanks,

Troiana