Wednesday 27 September 2006 5:15:12 pm - 2 replies
Modified on Wednesday 27 September 2006 5:17:11 pm by James Ward
Kristof Coomans
Thursday 28 September 2006 2:59:23 am
Hello James
Take a look at http://dev.mysql.com/doc/refman/5.0/en/indexes.html
I checked our db (eZ 3.7) and the word field is VARCHAR(150) instead of TEXT or BLOB. Did you alter this manually? Or maybe you accidentily skipped a mysql upgrade script.
independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org
Tuesday 06 May 2008 5:17:53 am
Apparently Cupdate/database/mysql/3.3/dbupdate-3.3-6-to-3.3-7.sql contains
ALTER TABLE ezsearch_word CHANGE word word blob;
This is AFAIK not intended. This eventually leads to the error James described when doing an upgrade to 3.5 later on.
You can simply use this SQL:
ALTER TABLE ezsearch_word CHANGE word word varchar(150);
to fix the problem, before running dbupdate-3.4.4-to-3.5.0.sql
You must be logged in to post messages in this topic!