Database error for hyphenated friendly url’s:
Running evolution 1.02, and fairly recent version of everything else (php, mysql, etc...). Using the most basic example you provided to create ratings pages.
When it occurs: If, for example, I have a page with a friendly URL alias of
bluewidget.htm, then everything seems to work fine. If instead, I simply add a hyphen, like
blue-widget.htm, then it breaks, throwing this error:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 '-family ( `id` int(11) NOT NULL auto_increment, `rating_id` ' at line 1 »
SQL: CREATE TABLE modx_atRating_blue-widget ( `id` int(11) NOT NULL auto_increment, `rating_id` VARCHAR(80) NOT NULL, `rating` int(11) NOT NULL, `lastIP` varchar(255) NOT NULL, `nbIP` int(11) NOT NULL, `voteDate` TIMESTAMP(12), PRIMARY KEY (`id`) ) ENGINE=MyISAM; 
☆ A M B ☆
