Mailing List Archive


Back to the month index Back to the list index
Pablo Molinero Fernandez (molinero@stanford.edu)
Wed, 7 Apr 1999 23:18:35 -0700 (PDT) 

Date: Wed, 7 Apr 1999 23:18:35 -0700 (PDT)
From: Pablo Molinero Fernandez <molinero@stanford.edu>
Subject: mSQL 2.0.8 and perl
Message-ID: <Pine.HPP.3.96.990407230309.7498F-100000@yuba.stanford.edu>

Hi,

I do not know if this is the correct list to ask this question, if not
could you tell me where I could try to get an answer?

I upgraded my mSQL server from 2.0.4.1 to 2.0.8 and everything works fine
except that when I query the DB using DBD/DBI::mSQL sometimes I get an
error. The tables are as follows:

Table = people
 +-------------------+-------+--------+----------+-----+
 | Field | Type | Length | Not Null | Key |
 +-------------------+-------+--------+----------+-----+
 | PERSON_ID | int | 4 | N | N |
 | NAME | text | 80 | N | N |
 | SUNET_LOGIN | text | 20 | N | N |
 | UPDATE_FREQ | char | 80 | N | N |
 | EMAIL | text | 40 | N | N |
 | PHONE | text | 12 | N | N |
 | ADDRESS | text | 40 | N | N |
 | ix_PERSON_ID | index | N/A | N/A | N |
 +-------------------+-------+--------+----------+-----+

Table = people_interest
 +-----------+-------+--------+----------+-----+
 | Field | Type | Length | Not Null | Key |
 +-----------+-------+--------+----------+-----+
 | PERSON_ID | int | 4 | Y | N |
 | CAL_ID | int | 4 | N | N |
 +-----------+-------+--------+----------+-----+

And the commands:

$sql = "select distinct people_interest.PERSON_ID,people.NAME,people.EMAIL
from people,people_interest where
people_interest.PERSON_ID=people.PERSON_ID and people_interest.CAL_ID=58
order by people.NAME";

$datasource = "dbi:mSQL:calendus";
$dbh = DBI->connect($datasource);
$sth = $dbh->prepare($sql);

This is what I get:

Software error:

DBD::mSQL::st execute failed: Invalid field type 'TEXT' (type 6) in sort
at SQL_DB.pm line 623 [this is the line of the prepare], &lt;MFH&gt; chunk
1.

It seems to me that the prepare is doing some translation, and then it
fails due to an unexpected field type/value.

I had some problems before when the types and the numbers that they
correspond to did change from 2.0.3 to 2.0.4.1. Is this the same
situation?

I would appreciate any help.

        Pablo

-------------------------------------------------
Pablo Molinero Fernández
(650) 497-7490 (home)
(650) 723-1414 (office)
http://www.stanford.edu/~molinero
Snail-mail: Gates Building 3A, Room 342
             Stanford, CA 94305-9030