[libdb-develop] Problem with "condition" in libdb.mysql

[William D. <bu...@po...>]

I tried to install LibDB today and ran into a problem. Drupal 4.5.2, PHP
4.3.11 and MySQL 5.0.3 are working fine on my FreeBSD 5.4 box, but when I
tried to work in the LibDB module from the current libdb-cvs.tar.gz, I got
this:

# mysql -u drupal -p drupal < libdb/libdb.mysql
Enter password:
ERROR 1064 (42000) at line 24: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'condition TEXT, treatment TEXT, scheduled_treatment
TEXT, access_restrictions TE' at line 1

The offending line is:

CREATE TABLE libdb_item (
 id CHAR(20) NOT NULL,
 manifestation_id CHAR(20) NOT NULL,
 provenance TEXT,
 marks TEXT,
 exhibition TEXT,
 condition TEXT,
 treatment TEXT,
 scheduled_treatment TEXT,
 access_restrictions TEXT,
 INDEX(id,manifestation_id) ) TYPE=MyISAM;

I broke it down to just create the id and manifestation_id columns, which
worked, then added columns one by one, and the problem is column named
condition.

In the manual, section 19.2.10 discusses conditions, and there's an
example:

 DECLARE condition_name CONDITION FOR condition_value

I looked through the description of changes from 4 to 5 but didn't see any
mention of a condition keyword, but I could have missed it.  I assume this
is something new from MySQL 4 to 5 and LibDB was built with 4?

I can easily drop 5 and go to 4, but I thought I'd check to see if this is
indeed the problem.


Thanks,

Bill
-- 
William Denton : Toronto, Canada : http://www.miskatonic.org/