SQL Error

[Trekkan]

Just upgraded to the latest version, getting this error now:

Invalid SQL:

					UPDATE dhv_user
					SET dbtech_vbactivity_rewardscache = 'a:1:{s:0:\"\";a:4:{s:6:\"userid\";s:2:\"47\";s:7:\"feature\";s:11:\"achievement\";s:9:\"featureid\";s:2:\"34\";s:8:\"dateline\";s:10:\"1267913477\";}}'
					WHERE userid = 47;

MySQL Error   : Unknown column 'dbtech_vbactivity_rewardscache' in 'field list'

 

[Fillip H.]

Are you sure you imported the XML file? It didn't seem to run the install code...

Check if the dbtech_vbactivity_rewardscache exists in your user table.

If not, then run these:

ALTER TABLE `dbtech_vbactivity_rewards` DROP PRIMARY KEY

ALTER TABLE `dbtech_vbactivity_rewards` ADD `rewardid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

ALTER TABLE `user` ADD `dbtech_vbactivity_rewardscache` MEDIUMTEXT NULL DEFAULT NULL AFTER `dbtech_vbactivity_pointscache_month`

 

[Trekkan]

I imported both scripts for sure (and overwrite).

I took a look at the DB tables and such and compared their settings to what the SQL queries you had above would do, they look ok.

So far, the error has appeared only once, so my guess is, that post came in right as I was doing the upgrade. Right now, I'll call it good and let you know if it happens again.

 

[Fillip H.]

Yeah, that's my guess too. It's a chicken and egg situation when it comes to this type of upgrade:
* Import first, files complain
* Import last, database complains.