Anspress 4.a1 – My Findings

9.73K viewsIssues
0

Going from 3.0.7 to 4.a1, i got this:

[15-Oct-2016 10:36:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘NOT NULL,
`selected_id` bigint(20) DEFAULT NULL,
‘ at line 2 for query CREATE TABLE IF NOT EXISTS `wp_ap_qameta` (
`post_id` bigint(20) DEFAULT NOT NULL,
`selected_id` bigint(20) DEFAULT NULL,
`comments` bigint(20) DEFAULT 0,
`answers` bigint(20) DEFAULT 0,
`ptype` varchar(256) DEFAULT NULL,
`featured` tinyint(1) DEFAULT 0,
`selected` tinyint(1) DEFAULT 0,
`votes_up` bigint(20) DEFAULT 0,
`votes_down` bigint(20) DEFAULT 0,
`subscribers` bigint(20) DEFAULT 0,
`views` tinyint(4) DEFAULT 0,
`closed` tinyint(1) DEFAULT 0,
`flags` tinyint(2) DEFAULT 0,
`terms` LONGTEXT DEFAULT NULL,
`activities` LONGTEXT DEFAULT NULL,
`roles` varchar(256) DEFAULT NULL,
`last_updated` timestamp NULL DEFAULT NULL,
UNIQUE KEY `post_id` (`post_id`)
)DEFAULT CHARACTER SET utf8mb4 made by activate_plugin, do_action(‘activate_anspress-question-answer/anspress-question-answer.php’), AP_Activate::get_instance, AP_Activate->__construct, AP_Activate->activate, AP_Activate->insert_tables, dbDelta

 

Thanks !

0

Database error:

[15-Oct-2016 12:34:24 UTC] WordPress database error Unknown column ‘pm.post_id’ in ‘field list’ for query SELECT count(DISTINCT pm.post_id) FROM wp_ap_qameta qameta JOIN wp_posts p ON (p.ID = qameta.post_id) WHERE qameta.selected = 1 AND p.post_type = ‘answer’ AND p.post_author = 1 made by do_action(‘wp_ajax_ap_ajax’), AnsPress_Process_Form->ap_ajax, do_action(‘ap_ajax_select_best_answer’), AnsPress_Ajax->select_best_answer, ap_update_user_best_answers_count_meta, ap_user_best_answer_count

Thanks

commented on answer

I invited you to slack channel

I have no idea what slack channel is !!!

You are viewing 1 out of 7 answers, click here to view all answers.