| Re: SQL syntax error when trying to enter forums [message #29405 is a reply to message #29404] |
Sun, 18 December 2005 16:17   |
sommer
Messages: 21
Registered: December 2005
Location: Denmark
Karma:
|
Junior Member |
|
|
| Ilia wrote on Sun, 18 December 2005 15:30 |
Try changing "reads" to another name, maybe on your system it is a reserved SQL keyword.
|
That is very likely. If I replace "reads" with the danish equivalent "laesninger", then the query return an error-free result in phpMyAdmin:
id name name id laesninger
1 TestForum Test Category 1 0
One step closer, but how can I make my copy of FUDforum in eGW avoid using "reads" in the SQL query and is this going to have an affect on other parts of the FUDforum?
By the way, replacing the presumably reserved keyword "reads" with another word makes the braces () enclosing the CASE ... END block (mentioned earlier in this thread) obsolete.
/Henrik
[Updated on: Mon, 19 December 2005 21:10] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]