Re: Full SQL not being received / processed by mySQL

is that any way to connect mysql administrator to server with ssl
connection? thanks

Brian
----- Original Message -----
From: "Envex Developments" <[email protected]>
To: <[email protected]>
Cc: <[email protected]>
Sent: Monday, July 12, 2004 11:51 AM
Subject: 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/[email protected]
>


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]