Full SQL not being received / processed by mySQL

am 12.07.2004 17:51:29 von Envex Developments

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

Re: Full SQL not being received / processed by mySQL

am 12.07.2004 18:07:00 von Rudy Lippan

On Mon, 12 Jul 2004, Envex Developments wrote:

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

To help you, I need some more information:

1. What is different between the servers that this happens on compaired to the
ones where this does not happen?

2. A self-contained example of code the exhibits the problem.

3. A DBI->trace(9) when you get there error.

4. Versions of everything and

5 the output of perl -V.

Rudy

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

Re: Full SQL not being received / processed by mySQL

am 12.07.2004 18:07:00 von Rudy Lippan

Re: Full SQL not being received / processed by mySQL

am 16.07.2004 15:37:31 von lshen

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

Brian
----- Original Message -----
From: "Envex Developments"
To:
Cc:
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=gcdmp-msql-mysql-modules@m .gmane.org

Re: Full SQL not being received / processed by mySQL

am 16.07.2004 15:37:31 von lshen