
11-20-2011, 05:01 PM
|
|
|
Join Date: Oct 2011
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I'm installing for the first time. It starts off fine then I'm getting an error message here:
Quote:
Updating
Version Number To: 1.0.2
Altered Table: vb_user
Database Error Database error
The Vinylmation Kingdom Forums database has encountered a problem.
|
Then it tells me this:
Quote:
Invalid SQL:
UPDATE vb_user AS user
SET dbtech_vbactivity_pointscache = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321725343
),
dbtech_vbactivity_pointscache_day = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_week = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_month = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1320105600
);
MySQL Error : Column 'dbtech_vbactivity_pointscache' cannot be null
Error Number : 1048
Request Date : Sunday, November 20th 2011 @ 05:55:43 PM
Error Date : Sunday, November 20th 2011 @ 05:55:53 PM
Script : http://www.vinylmationkingdom.com/fo...=productimport
Referrer : ...
IP Address : ...
Username : ...
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30-log
|
Any advice?
|