[freeside] fs-setup error in pre10

[ivan]

Looks like `option' is a reserved word in MySQL, unlike the SQL92 or SQL3
standards.  Bummer.

I guess this can be added to the list of things the MySQL-using community
needs to submit patches for, if they would like to see MySQL support in
1.4.0.  No one from the MySQL-using community has come forward with a
patch for the browse functions yet either, but (untested) queries have
been written.

On Sat, Feb 16, 2002 at 02:57:03PM +0800, Shane Chrisp wrote:
> Hi,
> 
> Trying to do a fresh install of 1.4.0-pre10 on mysql and each time I run
> fs-setup it stops with the following error. I checked the cvs to see if
> there was a newer fs-setup first. Have I made a typo?
> 
> 
> DBD::mysql::db do failed: You have an error in your SQL syntax near
> 'option varchar(80) NOT NULL  ,
>   optionvalue text NULL  ,
>   PRIMARY KEY (optionn' at line 4 at ./fs-setup line 178.
> CREATE error: You have an error in your SQL syntax near 'option
> varchar(80) NOT NULL  ,
>   optionvalue text NULL  ,
>   PRIMARY KEY (optionn' at line 4
> doing statement: CREATE TABLE part_export_option (
>   optionnum int NOT NULL  ,
>   exportnum int NOT NULL  ,
>   option varchar(80) NOT NULL  ,
>   optionvalue text NULL  ,
>   PRIMARY KEY (optionnum)
> )
> 
> 
> cheers
> Shane
> 

-- 
_ivan