Default Charset errror

Archived from the Xataface Users forum.

jstalin — Thu Dec 13, 2007 7:25 am

When I’m trying to edit an existing record, I get the following when I try to submit it:

Fatal 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 ‘DEFAULT CHARSET= COLLATE’ at line 29 in /home/xxxxx/dataface/Dataface/HistoryTool.php on line 319

Any ideas? When I look at that line of the code, it looks like it’s getting a blank .$charset value.

---

shannah — Thu Dec 13, 2007 12:08 pm

What version of mysql are you using?

---

jstalin — Thu Dec 13, 2007 5:01 pm

5.0.24a

---

jstalin — Thu Dec 13, 2007 5:02 pm

This only seems to happen after I’ve created a new record and subsequently want to go back and edit it. It doesn’t happen when I try to edit a record that was previously imported.

---

shannah — Sat Dec 15, 2007 12:17 am

I have filed a bug at

http://bugs.weblite.ca/view.php?id=54

Hopefully I can get around to fixing this soon.

-Steve