AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

AI Assistant

Notifications

Clear all

[Solved] Limit comment likes/dislikes

✦ Summarize Topic

Plugin Update Issues

Last Post by ChrisR 6 years ago

13 Posts

3 Users

2 Reactions

2,861 Views

RSS

Posts: 6

niccomisul

Topic starter

Translate ▼

May 26, 2020 7:28 pm

(@niccomisul)

Active Member

Joined: 6 years ago

[#145]

Hi,

since the last update it seems that users are allowed to like or dislike as many times as they want each comment, while it was limited to one like/dislike before. Is there a way to go back to this previous setting?

Best regards

Topic Tags

comment likes limit votes

12 Replies

Posts: 512

Tom

Support

Translate ▼

May 26, 2020 10:14 pm

(@tomson)

Honorable Member

Joined: 10 years ago

Hi @niccomisul,

You can test the Like/Dislike in our demo page: https://wpdiscuz.com/demo/

As you can see, there is no such an issue. This is a site/server specific issue. Please leave your website URL to allow us test it.

2 Replies

niccomisul

(@niccomisul)

Joined: 6 years ago

Active Member

Posts: 6

May 27, 2020 1:35 am

Reply to

Tom

Translate ▼

@tomson Thanks for getting back to me.

My website is https://www.fiorentina.it/

niccomisul

(@niccomisul)

Joined: 6 years ago

Active Member

Posts: 6

May 27, 2020 10:27 pm

Reply to

Tom

Translate ▼

@tomson Hi. Any update on this matter? I've seen other users pointing out this issue in the forum

Posts: 31

ChrisR

Translate ▼

May 28, 2020 2:38 am

(@chrisr)

Eminent Member

Joined: 6 years ago

Yeah, this is definitely the same issue I'm having. It started after the v7 update.

Posts: 31

ChrisR

Translate ▼

May 29, 2020 11:55 pm

(@chrisr)

Eminent Member

Joined: 6 years ago

I want to bump your thread because you're experiencing the same exact issues that I am.

-Chris

2 Replies

Tom

Support

(@tomson)

Joined: 10 years ago

Honorable Member

Posts: 512

May 30, 2020 12:02 am

Reply to

ChrisR

Translate ▼

@chrisr,

This was table structure issue. Some ALTER TABLE SQL queries were not executed on update. Please disable and enable back the latest wpDiscuz 7.0.2 and check this issue again.

ChrisR

(@chrisr)

Joined: 6 years ago

Eminent Member

Posts: 31

May 30, 2020 1:25 am

Reply to

Tom

Translate ▼

@tomson

Did as instructed. Still happening.

Did you guys check out the staging environment that I sent you?

Posts: 512

Tom

Support

Translate ▼

May 30, 2020 9:46 am

(@tomson)

Honorable Member

Joined: 10 years ago

@niccomisul and @chrisr,

This is a database table structure issue. The wp_wc_users_voted table structure is not updated on your website. You should execute this SQL in Hosting Service cPanel > phpMyAdmin Database Manager > Your website Database > SQL Tab:

ALTER TABLE `wp_wc_users_voted` ADD COLUMN `post_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN `date` INT(11) UNSIGNED NOT NULL DEFAULT 0, ADD INDEX `post_id` (`post_id`);

Please check the red marked wp_ prefix. If your database table prefix is different, you should change it to yours.

wpDiscuz problem with unlimited like vote

After, executing the SQL, click on the database name and find wp_wc_users_voted table in table list, then click on the Structure button of this table and make sure all columns/fields exist in this table:

Also, I recommend find the wp_wc_users_rated table, clicks the Structure button of this table too and check the structure. It should look like this:

Posts: 31

ChrisR

Translate ▼

May 30, 2020 8:11 pm

(@chrisr)

Eminent Member

Joined: 6 years ago

This can't be fixed with an update? We need to go through all of this?

3 Replies

Tom

Support

(@tomson)

Joined: 10 years ago

Honorable Member

Posts: 512

May 30, 2020 11:06 pm

Reply to

ChrisR

Translate ▼

@chrisr,

Posted by: @chrisr

We need to go through all of this?

You just need to execute one SQL in the phpMyAdmin. This takes just one minute. This is one-step fix. The other part is just extra information.

Somehow this was not executed on update process in your website, this is not a new SQL, this SQL was added in 7.0.0, so you've updated three times but the table is not updated yet. This is not a general issue, at the moment we only got 4-5 report. So this is your server issue, it doesn't execute the update SQLs so it is maybe impossible to be fixed with update. But we'll continue to investigate your cases and try to find update based solutions.

ChrisR

(@chrisr)

Joined: 6 years ago

Eminent Member

Posts: 31

Jun 01, 2020 6:49 pm

Reply to

Tom

Translate ▼

@tomson

Hey Tom,

Thank you for looking into this for us. I'll try to do as you suggested sometime this week and I'll let you guys know what happens.

-Chris

ChrisR

(@chrisr)

Joined: 6 years ago

Eminent Member

Posts: 31

Jun 01, 2020 7:33 pm

Reply to

Tom

Translate ▼

@tomson

Hey Tom,

I ended up just doing it right now. The tutorial you provided was great. I can confirm that this did fix these two issues. Everything seems to be working as intended as of now.

Thank you very much for looking into and taking care of this for us. I really appreciate it.

-Chris