Database error: Unknown column ‘subs_item_id’ in ‘where clause’
Hi Rahul,
Updating from 2.3.8 to the latest 2.4 beta I have this data base error on almost every page:
Unknown column ‘subs_item_id’ in ‘where clause’
I disabled and enabled the plugin, and I clicked on “AnsPress update is not complete yet! Click here to continue.”
The tests are made on a local server, but I can upload the site to a public server if you need it.
In my case, this error is causing the activity feed is empty and that the “follow” buttons do not work.
The problem appears in several querys, such as:
SELECT COUNT (*)
FROM xxxxx_ap_subscribers
WHERE subs_item_id = 410
AND subs_activity = ‘q_all’
AND subs_user_id = 2
or
SELECT *
FROM xxxxx_ap_subscribers where subs_item_id=410
AND subs_activity=’q_all’
LIMIT 0 , 10
Idem with “Unknown column ‘subscriber.subs_activity’ in ‘on clause'”
You just need to deactivate and re-activate AnsPress to fix this.
Yes, I already tried, but the activation does not modify database tables, in my case. I performed manually the “ALTER TABLE `xxxxx_ap_subscribers` CHANGE id subs_id bigint(20),….” and working properly.
I will check then.
In my table “xxxxx_ap_subscribers” there are these columns:
id, user_id, question_id, item_id, activity