Re: [Phpwebsite-developers] SQL error on boost

[Verdon V. <ve...@gm...>]

That did the job... thanks Matt :)

verdon


On 29-May-06, at 1:44 PM, Matthew McNaney wrote:

> 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
>
>
>
> -------------------------------------------------------
> 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
>