Replace "/*!32302 TEMPORARY */" with "TEMPORARY" if your db supports
temporary tables, remove it if not. It looks like a mysql error message,
temporary tables are supported in 3.23 but not in 3.22
Alain
----- Message d'origine -----
De : Gayapolis Webmaster <[EMAIL PROTECTED]>
À : <[EMAIL PROTECTED]>
Envoyé : dimanche 6 août 2000 18:12
Objet : UdmSearch: Query Error using crc-multi mode
I just switched to using crc-multi mode. indexer runs fine, but when i try
to do a search (php front end 3.0.4.4) I get this error:
Query error: CREATE /*!32302 TEMPORARY */ TABLE t9655787694144967 ( url_id
INT DEFAULT '0' NOT NULL, word_id INT DEFAULT '0' NOT NULL, intag TINYINT
DEFAULT '0' NOT NULL, KEY i1t9655787694144967(url_id), KEY
i2t9655787694144967(word_id))
You have an error in your SQL syntax near '32302 TEMPORARY */ TABLE
t9655787694144967 ( url_id INT DEFAULT ' at line 1
followed by this:
Query error: DROP TABLE t9655787694144967
Unknown table 't9655787694144967'
Any ideas on the cause of this? Search worked fine before switching to
crc-multi.
Thanks in advance
mark
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]
