[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    Re: Full SQL not being received / processed by mySQL
From:       "lei shen" <lshen () pop900 ! gsfc ! nasa ! gov>
Date:       2004-07-16 13:37:31
Message-ID: 0a5b01c46b3a$0e253090$9621b780 () arizona
[Download RAW message or body]

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

Brian
----- Original Message -----
From: "Envex Developments" <partners@envex.com>
To: <perl@lists.mysql.com>
Cc: <admin@skymarx.com>
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/perl?unsub=lshen@pop900.gsfc.nasa.gov
>


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

[prev in list] [next in list] [prev in thread] [next in thread]