Updating from 3 to 4 data error

4.33K viewsUpdates
0

I started updating anspress 3 and got this (and tried the button again).  Is there some error log or output associated with this?  I have a relatively large data set.

“Aaiyaa! Something went wrong. Please click above button again or report issue to us.”

Also, is there any instructions on what needs to be deactivated before you do the anspress 4 upgrade?  Just anspress-question-answer plugin? Or the category, email, tags plugins for 3 as well?

Hello Frank, Do you installed latest commit? No, tags, categories and email plugins are not required anymore. Its merged to AnsPress

0

I wrote my own the data conversion since this wouldn’t handle our load.  It seems fine but 1 think I noticed when I watched a small sample set is that wp_ap_qameta only had rows for questions during the conversion.  But when I was entering data it looks like there should be a row for every answer in there too.  Should I make sure to add that?

commented on answer

Yes, qameta table store data for both question and answer

0

I’m pretty sure the issue maybe that this isn’t optimized for large data sets.  It looks like its just executing these 1 off commands and probably hitting some timeout.

SELECT meta_id FROM wp_postmeta WHERE meta_key = ‘_ap_updated’ AND post_id = 10177719

UPDATE `wp_ap_qameta` SET `last_updated` = ‘2017-01-24 04:01:06’ WHERE `post_id` = 10177719

UPDATE `wp_ap_qameta` SET `activities` = ” WHERE `post_id` = 10177719

SELECT meta_id FROM wp_postmeta WHERE meta_key = ‘__ap_activity’ AND post_id = 10177719

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (10177719) ORDER BY meta_id ASC

SELECT * FROM wp_ap_meta WHERE apmeta_type IN (‘vote_up’, ‘vote_down’) AND apmeta_actionid = 10177719

SELECT meta_id FROM wp_postmeta WHERE meta_key = ‘_ap_flag’ AND post_id = 10177719

SELECT * FROM wp_posts WHERE ID = 10177719 LIMIT 1

INSERT INTO `wp_ap_qameta` (`ptype`, `flags`, `post_id`, `roles`) VALUES (‘answer’, 0, ‘10177719’, ‘1211’)

SELECT qm.*, p.post_type as ptype FROM wp_posts p LEFT JOIN wp_ap_qameta qm ON qm.post_id = p.ID WHERE p.ID = 10177719

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (10177719) ORDER BY meta_id ASC

DELETE FROM wp_postmeta WHERE meta_id IN( 2755501 )

commented on answer

How many questions do your site have?

AnsPress migrates 1k questions in each run, so if you have more then that you have to keep pressing that button.