[GrimR7529]

Hi,

I just purchased the pro version for my site: www.cgmatter.com and have the following error come up when I try to use it. I installed the 'Advanced Post Thank...' first and now I am trying to install the vbActivity ...

I upload the files fine without a hickup, but then when I run the script the following happens:

Importing Product, Please Wait...

[:]

Created Table: cgm_dbtech_vbactivity_achievement
Created Table: cgm_dbtech_vbactivity_activitylevel
Created Table: cgm_dbtech_vbactivity_category
Created Table: cgm_dbtech_vbactivity_condition
Created Table: cgm_dbtech_vbactivity_conditionbridge
Created Table: cgm_dbtech_vbactivity_pointslog
Created Table: cgm_dbtech_vbactivity_rewards
Created Table: cgm_dbtech_vbactivity_type
Altered Table: cgm_administrator
Altered Table: cgm_user
Altered Table: cgm_usergroup
Populated Table: cgm_dbtech_vbactivity_activitylevel
Populated Table: cgm_dbtech_vbactivity_type
Updating Version Number To: 1.0.0

Altered Table: cgm_dbtech_vbactivity_achievement
Updating Version Number To: 1.0.2

Altered Table: cgm_dbtech_vbactivity_pointslog
Altered Table: cgm_user

When it gets to the above line it stops and I get the following error:

Database error
The cgmatter database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.cgmatter.com home page, then try to open another page.
Click the Back button to try another link.
The www.cgmatter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT SUM(points) AS numpoints
FROM cgm_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321763533;

MySQL Error : Unknown column 'user.userid' in 'where clause'
Error Number : 1054
Request Date : Sunday, November 20th 2011 @ 10:32:13 PM
Error Date : Sunday, November 20th 2011 @ 10:32:23 PM
Script : http://www.cgmatter.com/admincp/plug...=productimport
Referrer : http://www.cgmatter.com/admincp/plug...?do=productadd
IP Address : XXX.XXX.XXX.XXX <- I changed this...
Username : cgmatteradmin
Classname : vB_Database
MySQL Version : 5.0.92-community

Any help would be greatly appreciated.