libdb-develop

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

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

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

On 24 April 2005, William Denton wrote:

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

Since that's the only place that the condition table is mentioned, there
was nothing in the way of renaming it to condition1.  That went through
without trouble.

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

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

[Morbus I. <mo...@di...>]

> Since that's the only place that the condition table is mentioned, there
> was nothing in the way of renaming it to condition1.  That went through

Yeah, MySQL 4 has been the only version I've tested that code on, so it 
probably is some sort of new reserved word in MySQL 5. I'll throw it on 
the TODO list to change. I keep itching to come back to the code, but 
I've recently now picked up a new ('nother) writing gig for O'Reilly, 
and am working on a game engine for Drupal too.

-- 
Morbus Iff ( a blivet is 11 pounds of manure in a 10 pound sack )
Technical: http://www.oreillynet.com/pub/au/779
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

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

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

On 3 May 2005, Morbus Iff wrote:

: Yeah, MySQL 4 has been the only version I've tested that code on, so it
: probably is some sort of new reserved word in MySQL 5. I'll throw it on
: the TODO list to change. I keep itching to come back to the code, but
: I've recently now picked up a new ('nother) writing gig for O'Reilly,
: and am working on a game engine for Drupal too.

You may get some more interest in it over the next little while.  At the
FRBR workshop at OCLC in Dublin OH earlier this week, I mentioned it and
some people were interested.  I said it was a beginning, very early,
implementation of FRBR built right from the spec, by a non-librarian, for
people to catalogue their personal libraries, and I had it running on my
laptop.  That provided a contrast to OCLC, who've been FRBRizing their
enormous WorldCat catalogue by using a twenty-four-node Beowulf cluster of
dual CPU Linux boxes.  I showed it to a couple of people and a couple of
others made a note of the name.

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