Re: is 'start' a keyword?

2004-10-18 Thread Jigal van Hemert
From: rik onckelinx [EMAIL PROTECTED] where FULLTEXT was causing the error. My workaround was renaming (in the sql create table scirpt) fulltext - ful_text option - optio_ The easiest solution to preventing these errors from popping up from time to time is to put backticks (`) around names

Re: is 'start' a keyword?

2004-10-15 Thread rik onckelinx
Hi, Had a similar error last night: My hosting provider offered my to upgrade to mambo 4.5.1 cms. While it ruined the whole site, I've tried to restore the backup. When using the backup.sql file (generated through phpmyadmin) using this syntax: CREATE TABLE mos_components ( ... option

is 'start' a keyword?

2004-10-14 Thread Brian Reichert
I tried to create a table with a column named 'start'. This word does not appear here: http://dev.mysql.com/doc/mysql/en/Reserved_words.html But, my effort to create such a column yeilded a syntax error, and I did subsequently learn of a 'start' directive, such as in: START TRANSACTION,

Re: is 'start' a keyword?

2004-10-14 Thread Brian Reichert
On Thu, Oct 14, 2004 at 10:33:45PM -0400, Brian Reichert wrote: I tried to create a table with a column named 'start'. This word does not appear here: http://dev.mysql.com/doc/mysql/en/Reserved_words.html Hmph; I had a typo in my 'create table' directive. Sorry about the noise... --