Anspress 4.a1 – My Findings

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

Also please see this:

commented on answer

I know about it. Also display meta are not working because old meta table data were not migrated. I am working on migration. Try to edit or post new questions.

New Questions also show that.

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