Error in sql syntax when try to delete all ratings | ww.wp.xz.cn

Resolved benhartwich
(@yoursql719)

10 years ago

Hi,

there is an error at your sql syntax when I try to delete logs and data. When I hit delete only data nothing happens by the way.

WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1 f\xc3\xbcr Abfrage DELETE FROM wp_ratings WHERE rating_postid IN () von include(‘D:\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php’), referer: http://localhost/wordpress/wp-admin/admin.php?page=wp-postratings%2Fpostratings-manager.php

https://ww.wp.xz.cn/plugins/wp-postratings/

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author Lester Chan
(@gamerz)

10 years ago
Hmm I can’t reproduce this problem on my end. I am using MariaDB as well. Just tried it on my test site
```
All Rating Logs For Post ID(s) 1 Have Been Deleted.
Rating Data "ratings_users" For Post ID(s) 1 Has Been Deleted.
Rating Data "ratings_score" For Post ID(s) 1 Has Been Deleted.
Rating Data "ratings_average" For Post ID(s) 1 Has Been Deleted.
```
Thread Starter benhartwich
(@yoursql719)

10 years ago

Weird, I´ve got this error on two different systems. Is there any information, which do you need for further debug?

Plugin Author Lester Chan
(@gamerz)

10 years ago

Are u deleting a single rating or per post?

Possible to do a var_dump https://github.com/lesterchan/wp-postratings/blob/master/postratings-manager.php#L86 on this line?

Thread Starter benhartwich
(@yoursql719)

10 years ago

Oh sorry, I´ven´t read carefully. I missed to fill out the text field before the submit button – so it was empty. I had to fill in all. 😉

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Error in sql syntax when try to delete all ratings’ is closed to new replies.

4 replies
2 participants
Last reply from: benhartwich
Last activity: 10 years ago
Status: resolved