i have finally gotten my fckeditor input to feed into MySQL database. But if I try to add "bold", "color", "image", etc. I get the following error:
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 'color: rgb(255, 0, 255);"xxxxxxx"'at line 2
I see this is common but have not found a solution...
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 'color: rgb(255, 0, 255);"xxxxxxx"'at line 2
I see this is common but have not found a solution...
Re: You have an error in your SQL syntax...
It sounds like your problem is the quotes. I have not used MySQL in a VERY long time and cannot remember what quotes it can use...Check the configuration for FCK and find the setting that will encode the posted back data in such a way that it can be saved, or replace ' with two instances, ie. '', that is how it works in Firebird and MSSQL.
If you cannot get it sorted, let me know and I will look into it in a bit more detail.