Hello,

I am using your amazing cms! and it is Awesome

But All of a sudden I found this error !!
No idea why ? and how !

Could not successfully run query: 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 '-users WHERE name='admin'' at line 1

Kindly Help me or tell me what it might be ??

[KK]

Hello Halakoukeh

Haven't come across this issue before.

I'll need to take a look at it first-hand to know the cause.
If possible, please PM me the FTP + Couch + phpMyAdmin creds of your site.

Thanks.

I have already send them to you.
Could you check your inbox please ?
and update me ?
Much Appreciated.

[KK]

Thanks for entrusting me with the creds.

I had a look and, from what I could see, the core Couch files have been substantially modified (e.g. the core tables have been renamed).

As such, I regret but I won't be able to help with this issue.

Thanks.

Is there anything in your mind ? that may cause this trouble ??
Should I delete the pages I just added ?
Should I delete the fields I just entered, the template ?

Any thing that might cause the trouble ??

[KK]

I'd say the immediate problem is that the users table has been renamed to 'couch-users' (i.e. now has a hyphen instead of the original underscore). This is causing the SQL query error as hyphenated values need to be in quotes.

But then, the problem could be just about anywhere. I cannot comment on it as the codebase has been changed so I have no baseline to compare against.

Perhaps you should ask your developer (the email is in the source files) for help?

Oh ya, You are right !!
Tabels in db.php file has been renamed !
is there a possibility they've changed without even though I haven't touched them ??

What I meant is : I just added two new templates with their fields, could it in anyway cause this issue ???

[KK]

is there a possibility they've changed without even though I haven't touched them ??

No. As I mentioned before, the names have been changed from within the source PHP files.

This couldn't have happened without someone manually modifying the files. If you take a look at the files, you'll find other tell-tale signs of such manual tweaking.