I am unable to create polls. Please see screenshots with all the info. Topic gets created but polls creation fails.
Thank you
Notifications
Clear all
wpForo Polls
5
Posts
2
Users
0
Reactions
987
Views
Aug 19, 2022 9:53 pm
4 Replies
Aug 20, 2022 9:23 am
Hi @lynne-benedict,
I've just reset the #42180 order license keys, please find the keys in your account or in the order email and activate them again.
Also, please use phpMyAdmin plugin or the tool in your hosting cPanel to check the wp_wpforo_polls table. It seems something wrong with the structure of this table. It should have the following fields:
Aug 20, 2022 5:54 pm
Good morning.
I activated the keys again. It seemed to take it (unlike yesterday) so your reset did shift something.
But the error did not go away.
I looked at the for table and see I have 1 column less than your screenshot.
thank you
Aug 21, 2022 12:52 am
Please execute this SQL to add a new "stat" field and do some changes in other fields:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; ALTER TABLE `wp_wpforo_polls` MODIFY COLUMN `options` LONGTEXT, CHANGE COLUMN `votes` `stat` LONGTEXT, ADD COLUMN `votes` LONGTEXT AFTER `stat`;
Copy all and execute the whole SQL at once.
Aug 22, 2022 10:52 pm
It worked. Thank you