Re: [Phpwebsite-developers] SQL error on boost

[Greg M. <drk...@co...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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 )
- -------------------^
Look here.

 [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
);
- --^
- ----------------^

Try taking all the mysql junk out of the create statement at the very
end of the create statement.  The translation from PEARDB to mysql my be
bad.  Moreover, if you are planning for a fallout module, then this code
would not be portable to postgresql anyhow as I recall.

HTH,
Greg


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFEe48Cxyxe5L6mr7IRAkpmAJ9msbZu96uS8eKSFY89u5GF+88TCgCfY4dA
i+YYSGSlLmelWxEjBEJhBjc=
=725Y
-----END PGP SIGNATURE-----