mikelt4
Posts: 9
|
| Posted: 03/05/2012, 7:20 PM |
|
Windows, CCS 4.3, PHP 5.2, MySQL 5.0, IIS 7.0.
Many years with static HTML websites, just a few days with CCS. Just trying to learn and get the feel for CCS. Tried the Grid Builder and got the following error -----
-------------------------------------------------------------
Builders Common error window
Loading fields list: HY000:[MySQL][ODBC 3.51 Driver][mysqld-5.0.92-log]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 �themotorcity�,�carlist� LIMIT 0� at line 1.
----------------------------------------------------------
No problem connecting to my database, seemed to list all of the tables as well. However, when i selected one of the tables, 1 of 2 events would occur.
Event 1 - i could select a table, however, it would only list some of the fields, but not all of the fields. It would show a field, skip 1 or 2, show the next field, and so on. No error message would occur.
Event 2 - i could select another table, the above error would popup, and not show any of the fields in the table.
i used a program called PHPMagic Plus to create the tables and fields in my database. Only CCS seems to be having a problem with my database. I have opened my database in "MySQL Workbench 5.2 CE" and in phpMyAdmin, no problems, no errors. I have written a quick and dirty php program that saved data and viewed the data, no problems, no errors.
i then deleted one of the tables and in phpMyAdmin i manually recreated the table and fields and CCS still popped up the above error when i tried to select it.
I'm betting there is some simple "switch" or setting that i need to modify somewhere, but i'm at a loss as to where to look next.
any help?
thx
|
 |
 |
DataDoIT
|
| Posted: 03/06/2012, 5:42 AM |
|
Try using the latest MySQL ODBC Driver v5.1. Make sure you choose the
x86/x64 matches your MySQL server and OS.
Secondly, are you still on a trial or registered version of CCS?
|
|
|
|
mikelt4
Posts: 9
|
| Posted: 03/06/2012, 3:53 PM |
|
I was using ODBC 3.51.17. I loaded ODBC 5.01.10 and do not get the errors now.
thx for the help.
My CCS is registered. I bought it.
thx all
|
|
|
|
|
