Anspress 4.a1 – My Findings

9.58K 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

And this also:

[15-Oct-2016 11:00:16 UTC] WordPress database error Unknown column ‘attach’ in ‘field list’ for query UPDATE `wp_ap_qameta` SET `ptype` = ‘question’, `attach` = NULL WHERE `post_id` = 15 made by do_action(‘wp_ajax_ap_ajax’), AnsPress_Process_Form->ap_ajax, AnsPress_Process_Form->process_form, AnsPress_Process_Form->process_ask_form, ap_save_question, ap_attach_post_uploads, ap_update_post_attach_ids, ap_insert_qameta

commented on answer

Yes, it is fixed now, thanks !

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