Error SQL syntax when exporting CREATE TABLE (Myphpadmin)

Question

I’m new here and haven’t started my studies in SQL and PHP, but I would like to ask for help.

When trying to download a theme content from my site in WP, error msg appears:

Cannot export CREATE TABLE sql for rconvert-subscriptions. You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near '-subscriptions' at line 1

In the syntax is:

SELECT * FROM `wphk_rconvert-subscriptions` WHERE 1

I would like to know what I should fix in the syntax. Should I update my Mysql server?

Answer 1

Hello

The Table wphk_rconvert-subscriptions not created. Try creating the table and try again.

CREATE TABLE wphk_rconvert-subscriptions

and pass the corresponding fields. should work

Answer 2

Your problem, as the error itself says, is in the syntax. The condition is missing for the WHERE. You must specify the column where the WHERE = 1

Example:

SELECT * FROM 'wphk_rconvert-subscriptions' WHERE id = 1