Notifications

Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed. We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

[Solved] Unable to create polls

wpForo Polls

Last Post by Lynne Benedict 3 years ago

5 Posts

2 Users

0 Reactions

1,101 Views

RSS

Posts: 33

Lynne Benedict

Customer

Topic starter

Aug 19, 2022 9:53 pm

(@lynne-benedict)

Member

Joined: 3 years ago

I am unable to create polls. Please see screenshots with all the info. Topic gets created but polls creation fails.

Thank you

4 Replies

Posts: 4233

Tom

Admin

Aug 20, 2022 9:23 am

(@tomson)

Famed Member

Joined: 10 years ago

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:

Posts: 33

Lynne Benedict

Customer

Topic starter

Aug 20, 2022 5:54 pm

(@lynne-benedict)

Member

Joined: 3 years ago

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

1 Reply

Tom

Admin

(@tomson)

Joined: 10 years ago

Famed Member

Posts: 4233

Aug 21, 2022 12:52 am

Reply to

Lynne Benedict

@lynne-benedict,

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.