Full SQL not being received / processed by mySQL

Hey guys,

I have a Perl based CGI script, and sometimes receive a weird error upon
installation for a customer. The inllstallation script processes several
SQL commands to create all needed tables in the database, but for some
reason, mySQL doesn't always seem to get the full SQL command. This doesn't
happen on the majority of servers, but only some of them.

For example, say if the SQL command being processed is:

-----
CREATE TABLE internal_systems (id INT NOT NULL, engine INT NOT NULL,
table_name VARCHAR(100) NOT NULL, name VARCHAR(100) NOT NULL, recipients
VARCHAR(50) NOT NULL, multiple_recipient INT NOT NULL);
-----

I'll get an error message saying mySQL can't process the SQL command:

-----
CREATE TABLE internal_systems (id INT NOT NULL, engine INT NOT NULL,
table_name VARCHAR(100) NOT NULL, name VARCHAR(100) NOT NULL, recipients
VARCHAR(50) NOT
-----

Or something to that effect. I've tried getting people to re-install the
DBI and DBD::mysql Perl modules, but still won't work. Any advice would be
greatly appreciated.

Thanks alot,
Matt



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org