[Solved] Import old voting data into wpDiscuz Article Rating database records

✦ Summarize Topic

How-to and Troubleshooting

Last Post by ITpro 2 years ago

3 Posts

2 Users

0 Reactions

1,007 Views

RSS

Posts: 19

ITpro

Topic starter

Translate ▼

Oct 16, 2023 9:47 pm

(@itpro)

Eminent Member

Joined: 3 years ago

[#7700]

In our old WordPress Theme we have a lot of article vote data for 14 years back in the database. I would like to import the old voting data into the data records that wpDiscuz uses for Article Rating and start using your Article Rating feature.

To be able to import the old data I need to know how you are storing each vote for each article in the database, so that I can create a custom INSERT INTO Sql statement with phpMyAdmin.

That way I can revive ratings on the old articles and start using your function. Any help is highly appreciated. Thanks.

This topic was modified 2 years ago by ITpro

2 Replies

Posts: 67

Zackar

Support

Translate ▼

Oct 17, 2023 12:39 pm

(@zackar)

Trusted Member

Joined: 10 years ago

Hi @itpro

wpDiscuz stores rating information in the wp_wc_users_rated table and in the wp_postmeta under the wpdiscuz_post_rating and wpdiscuz_post_rating_count metakeys.
The like/dislike information is stored in the wp_wc_users_voted and wp_commentmeta table under the wpdiscuz_votes and wpdiscuz_votes_seperate metakeys.