I'm trying to use SK2 on our school's WordPressMU site. After installing it this is the error we get when someone tries to comment.
WordPress database error: [Table 'saschina_blogs.wp_28_sk2_spams' doesn't exist]
SELECT
comment_table
.*,
posts_table
.*,
users_table
.*,
spam_table
.*,
spam_table
.
id
AS
spam_table_id
, NOW() AS
now_sql
FROM
wp_28_comments
AS
comment_table
LEFT JOIN
wp_28_posts
AS
posts_table
ON
posts_table
.
ID
=
comment_table
.
comment_post_ID
LEFT JOIN
wp_users
AS
users_table
ON
users_table
.
ID
=
comment_table
.
user_id
LEFT JOIN
wp_28_sk2_spams
AS
spam_table
ON
spam_table
.
comment_ID
=
comment_table
.
comment_ID
WHERE
comment_table
.
comment_ID
= 16
sk2_comment: Cannot fetch comment record from table.
SQL error: Table 'saschina_blogs.wp_28_sk2_spams' doesn't exist
Error: Submitted Post_ID variable (14) not matching ours (0).
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
comments
.
comment_approved
= '1' AND
comments
.
comment_date_gmt
< DATE' at line 1]
SELECT COUNT(*) AS
cmt_count
, AVG(
spams
.
karma
) AS
karma_avg
FROM
wp_28_comments
AS
comments
LEFT JOIN
wp_28_sk2_spams
AS
spams
ON
spams
.
comment_ID
=
comments
.
comment_ID
WHERE
comments
.
comment_ID
!= AND
comments
.
comment_approved
= '1' AND
comments
.
comment_date_gmt
< DATE_SUB('', INTERVAL 3 DAY) AND
comments
.
comment_author_IP
= ''
get_granularity: query failed.
Query: SELECT COUNT(*) AS
cmt_count
, AVG(
spams
.
karma
) AS
karma_avg
FROM
wp_28_comments
AS
comments
LEFT JOIN
wp_28_sk2_spams
AS
spams
ON
spams
.
comment_ID
=
comments
.
comment_ID
WHERE
comments
.
comment_ID
!= AND
comments
.
comment_approved
= '1' AND
comments
.
comment_date_gmt
< DATE_SUB('', INTERVAL 3 DAY) AND
comments
.
comment_author_IP
= ''
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
comments
.
comment_approved
= '1' AND
comments
.
comment_date_gmt
< DATE' at line 1
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
comment_post_ID
= AND
comment_approved
= '1' AND
comment_date_gmt
> D' at line 1]
SELECT COUNT(*) AS
cmt_count
FROM
wp_28_comments
AS
comments
WHERE
comments
.
comment_ID
!= AND
comment_post_ID
= AND
comment_approved
= '1' AND
comment_date_gmt
> DATE_SUB(NOW() , INTERVAL 15 DAY)
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
UPDATE
wp_28_comments
SET
comment_approved
= '0' WHERE
comment_ID
=
Error: cannot update comment entry ID: 0 to status: moderated.
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Cannot update sk2_kSpamTable info (no comment ID provided).
Warning: Cannot modify header information - headers already sent by (output started at /home/saschina/public_html/blogs/wp-includes/wp-db.php:111) in /home/saschina/public_html/blogs/wp-comments-post.php on line 55
Warning: Cannot modify header information - headers already sent by (output started at /home/saschina/public_html/blogs/wp-includes/wp-db.php:111) in /home/saschina/public_html/blogs/wp-comments-post.php on line 56
Warning: Cannot modify header information - headers already sent by (output started at /home/saschina/public_html/blogs/wp-includes/wp-db.php:111) in /home/saschina/public_html/blogs/wp-comments-post.php on line 57
Warning: Cannot modify header information - headers already sent by (output started at /home/saschina/public_html/blogs/wp-includes/wp-db.php:111) in /home/saschina/public_html/blogs/wp-includes/pluggable.php on line 281
From what I understand SK2 needs to make a table in the database for each blog? Is there a way to make it do this for blogs that already exist?