17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 2247 Views |
-
Database tables lack prefixes...

31 March 2007 at 7:56pm
Ran into another problem with SilverStripe:
mysql> SELECT * FROM 'Group';
ERROR 1064 (42000): 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 ''Group'' at line 1
mysql> SELECT * FROM Group;
ERROR 1064 (42000): 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 'Group' at line 1This problem occurs because you guys have a table called "group" and that is a reserved word for SQL so...this could cause problems...
The server is running MySQL 4.19. Newer versions of MySQL don't seem to have this problem, however MySQL 4.19 is within your listed server requirements.
-
Re: Database tables lack prefixes...

1 April 2007 at 5:25am
The correct query should be like that: SELECT * FROM `Group` so you have to use ` instead of '.
| 2247 Views | ||
|
Page:
1
|
Go to Top |

