Topic: Wp-ratings messes up database in MySQL 3.x

[Frans]

Hi, great plugin! but,
when i rate my post bad things happen in the database 

For every rating i make it makes three new entries in the wp-postmeta table.
I rated 4 posts and this is what was added to the wp-postmeta:



And the wp-ratings table looked ok i think:



How can i fix this because the wp-postmeta table becomes HUGE and i cannot remove the entries from within your plugin, the plugin only empties the wp-ratings table.

Thanks!

p.s. there is a bug in your postratings.php on line 100:

Code: [Select]

echo "\t".'var ratings_ajax_url = \''.$ratings_ajax_url.'/wp-content/plugins/postratings/postratings/postratings.php\';'."\n";
Notice the double /postratings/postratings/ 

[GaMerZ]

Yea I fixed the bug. THANK YOU SO MUCH. But for some weird reasons, it still work. LOL

Actually the wp-postmeta is not a bug, it is meant to be like that. there will be 3 added rows to the postmeta table. Actually it is not that much even if you got 100,000 post, there are only 300,000 rows, still less than what a database can handles.

[Ttech]

Can it easily get over 100 MB?

[GaMerZ]

nope not easy. forums DB anytime will use up more space than blogs DB.

[Frans]

Test if forum works again, yesterday i got a "Internal Server Error" every time i tried to reply.

Just testing...

[Frans]

Ok, works again 

Yea I fixed the bug. THANK YOU SO MUCH. But for some weird reasons, it still work. LOL

Strange, i got a "Page Not Found" when i voted.
I also had to change the "$ratings_ajax_url" because it created yhe wrong url.

The postmeta table is supposed to be like that? Ah ok, so it works fine in MySQL 3.x?
For me its a reason to not use the plugin but that is just personal.. too much work to remove all the data from the database 

Thanks for your reply and for the great plugins!

[GaMerZ]

Really? as in now on my http://www.lesterchan.net/wordpress ?

By right it should work with 3.x because I change the sql query, but not 100% sure because I did not test it.

The new version (1.05) you can remove the postmeta information easily. It is under PostRatings Data/Log

[Frans]

The new version (1.05) you can remove the postmeta information easily. It is under PostRatings Data/Log

Yes, i use 1.05 and tried to remove logs and data but i doesnt remove the entries in wp-postmeta. I get the following error:



Maybe thats because i use MySQL 3.x?

[GaMerZ]

do u have any postmeta/log there? Because if there is no log or ratings data, there will be an error. Deleting should work even if it is 3.x