Anspress 4.a1 – My Findings

Question

Anspress 4.a1 – My Findings

8.69K viewsOctober 15, 2016Issues

0

Cagliostro 4.19K Posted October 15, 2016

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 !

7 Answers

Rahul Aryan · Answer 1 · 2016-10-15T18:31:51+00:00

0

Cagliostro 4.19K Posted October 15, 2016 1 Comment

FLAG doesn’t seem to work. I see no flagged in Anspress admin.

Rahul Aryan commented on answer October 15, 2016

Rahul Aryan commented October 15, 2016

I know, will be back in 4.0.0-alpha2

Rahul Aryan · Answer 2 · 2016-10-15T18:22:59+00:00

0

Cagliostro 4.19K Posted October 15, 2016 3 Comments

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

Rahul Aryan commented on answer October 15, 2016

Rahul Aryan commented October 15, 2016

I invited you to slack channel

Cagliostro commented October 15, 2016

I have no idea what slack channel is !!!

Rahul Aryan commented October 15, 2016

http://anspress.slack.com

Cagliostro · Answer 3 · 2016-10-15T16:37:55+00:00

0

Cagliostro 4.19K Posted October 15, 2016 2 Comments

Also please see this:

Cagliostro commented on answer October 15, 2016

Rahul Aryan commented October 15, 2016

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.

Cagliostro commented October 15, 2016

New Questions also show that.

score 0 · Answer 4 · 2016-10-15T11:04:00+00:00

0

Cagliostro 4.19K Posted October 15, 2016 0 Comments

And this:

PHP Notice: Trying to get property of non-object in /home/valuema/wp-content/plugins/anspress-question-answer/includes/qameta.php on line 337

Cagliostro · Answer 5 · 2016-10-15T16:36:44+00:00

0

Cagliostro 4.19K Posted October 15, 2016 2 Comments

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

Cagliostro commented on answer October 15, 2016

Rahul Aryan commented October 15, 2016

Fixed.

Cagliostro commented October 15, 2016

Yes, it is fixed now, thanks !