fulltext is now a reserved word - either change the name of the field,
or use quotes when refering to it.
regards,
P
On Tue, 6 Mar 2001
[EMAIL PROTECTED] wrote:
> Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
> that has a table that has a column with the name: FullText. Unfortunately,
> now with 3.23.33, any queries that explicitly refer to this column/field
> return an SQL error. So far this has been tested with SELECT and UPDATE.
> Is this expected behavior? Or is this an actual bug?
>
> Eric A. Stewart - Network Administrator - [EMAIL PROTECTED]
> University of South Florida, Tampa Campus Library - Technology
> Work: http://www.lib.usf.edu/ | MS/MIS | ICQ#
> Play: http://cerebus.lib.usf.edu/ | Graduate Student | 31285736
> SSI MD#100762 Mail not in plain text is annoying.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php