Error with SQL syntax

D

Danny

Guest
I have no problem with installation. However, I fear there is something wrong with my data. I'm new to MySQL, so I'm not exactly sure how to tackle this problem. I set up the database with phpMyAdmin.

Here is the debugged error report from dadabik:

[08] Error: during query execution.
SELECT `events`.`Event ID`, `events`.`Start Date`, `events`.`Start Time`, `events`.`End Date`, `events`.`End Time`, `events`.`Title`, `events`.`Description`, `events`.`All Day`, `events`.`Event Type`, `events`.`Day`, `events`.`Week`, `events`.`Recurance` FROM `events` ORDER BY events.Event ID ASC LIMIT 0 , 10
MySQL server said: You have an error in your SQL syntax near 'ID ASC LIMIT 0 , 10' at line 1

Please Advise!
Thank you
Danny

 
D

Debbie S

Guest
Danny

You have a space in some of your fields. The "Known bugs and limitations" section of the documentation for DaDaBIK clearly states:

Insert/search/update fail if one or more field names contain blank spaces or dots (e.g. "my field" or "my.field" are not allowed, use "my_field" instead).

You can specify "prettier" field labels from within DaDaBIK's admin interface.

Debbie
(Latest version of DaDaBIK when this message was posted: 3.1 Beta)
 
Top