Re: [Phpwebsite-developers] SQL error on boost

[Matthew M. <ma...@tu...>]

Have you tried dropping the TYPE=MyISAM;?



On Mon, 2006-05-29 at 12:42 -0400, Verdon Vaillancourt wrote:
> Hi,
> 
> I'm encountering a strange thing while trying to write an install.sql 
> file for a module I am working on. I'm hoping fresh eyes might help.
> 
> Thanks for any advice. Regards,
> verdon
> 
> 
> If I run the sql statement below, in phpmyadmin, it works fine. If I 
> try to boost instead, I get this generic error
> 
> DB Error: syntax error
> CREATE TABLE mod_cstconference_applications ( id int NOT NULL default 
> '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL 
> default '0', regprov varchar(20) default '', regonline tinyint NOT NULL 
> default '0', applicants text, firstname varchar(60) default '', 
> lastname varchar(60) default '', organization varchar(255) default '', 
> address1 varchar(255) default '', address2 varchar(255) default '', 
> city varchar(120) default '', province varchar(60) default '', postal 
> varchar(20) default '', phone varchar(60) default '', email 
> varchar(120) default '', total ) [nativecode=1064 ** 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 ')' at line 1]
> 
> This is the sql...
> 
> CREATE TABLE mod_cstconference_applications (
>    id            int NOT NULL default '0',
>    regnum        int NOT NULL default '0',
>    regstudent    tinyint NOT NULL default '0',
>    regprov       varchar(20) default '',
>    regonline     tinyint NOT NULL default '0',
>    applicants    text,
>    firstname     varchar(60) default '',
>    lastname      varchar(60) default '',
>    organization  varchar(255) default '',
>    address1      varchar(255) default '',
>    address2      varchar(255) default '',
>    city          varchar(120) default '',
>    province      varchar(60) default '',
>    postal        varchar(20) default '',
>    phone         varchar(60) default '',
>    email         varchar(120) default '',
>    total         text,
>    PRIMARY KEY   (id)
> ) TYPE=MyISAM;
> 
> 
> 
> -------------------------------------------------------
> All the advantages of Linux Managed Hosting--Without the Cost and Risk!
> Fully trained technicians. The highest number of Red Hat certifications in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
-- 
Matthew McNaney
Electronic Student Services
Appalachian State University
http://phpwebsite.appstate.edu