sql upgrade error

Previous topic

Install & configuration

Next topic

Author	Message
James Ward	Wednesday 27 September 2006 5:15:12 pm Hi All, I just wanted to check with some folks here before I reach for the bug report button. We are doing a large upgrade from a 3.0-1 site to a 3.8.4 site and are in the process of running all the sql upgrade scripts. There have been a few errors but most of them were easily corrected with a little editing. I am currently stumped running dbupdate-3.4.4-to-3.5.0.sql. It gives me the following error: ERROR 1170 (42000) at line 63: BLOB/TEXT column 'word' used in key specification without a key length The error is occuring while runing the following sql: ALTER TABLE ezsearch_word ADD INDEX ezsearch_word_word_i ( word ); I'm having no luck tracking this error down. I am runing mysql server 5.0.22 on a debian box. Thanks for any advice. working at www.wardnet.com blogging at www.jamesward.ca
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
Kristof Coomans	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 independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org

Author

Message

James Ward

Wednesday 27 September 2006 5:15:12 pm

Hi All,
I just wanted to check with some folks here before I reach for the bug report button.

We are doing a large upgrade from a 3.0-1 site to a 3.8.4 site and are in the process of running all the sql upgrade scripts. There have been a few errors but most of them were easily corrected with a little editing.

I am currently stumped running dbupdate-3.4.4-to-3.5.0.sql. It gives me the following error:

ERROR 1170 (42000) at line 63: BLOB/TEXT column 'word' used in key specification without a key length

The error is occuring while runing the following sql:

ALTER TABLE ezsearch_word ADD INDEX ezsearch_word_word_i ( word );

I'm having no luck tracking this error down. I am runing mysql server 5.0.22 on a debian box.

Thanks for any advice.

working at www.wardnet.com
blogging at www.jamesward.ca

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

Kristof Coomans

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

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

eZ debug

Timing:	Jan 18 2025 23:06:14
Script start
Timing:	Jan 18 2025 23:06:14
Module start 'layout'
Timing:	Jan 18 2025 23:06:14
Module start 'content'
Timing:	Jan 18 2025 23:06:14
Module end 'content'
Timing:	Jan 18 2025 23:06:14
Script end

Main resources:

Total runtime	0.0176 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	587.9141	152.6250
Module start 'layout'	0.0057	0.0027	740.5391	39.4453
Module start 'content'	0.0084	0.0072	779.9844	93.4609
Module end 'content'	0.0156	0.0019	873.4453	34.3047
Script end	0.0175		907.7500

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	15.5413	14	0.0002
Check MTime	0.0012	6.8795	14	0.0001
Mysql Total
Database connection	0.0007	3.8606	1	0.0007
Mysqli_queries	0.0027	15.2644	3	0.0009
Looping result	0.0000	0.0747	1	0.0000
Template Total	0.0015	8.4	1	0.0015
Template load	0.0009	4.8909	1	0.0009
Template processing	0.0006	3.4846	1	0.0006
Override
Cache load	0.0006	3.4723	1	0.0006
General
dbfile	0.0023	13.1563	8	0.0003
String conversion	0.0000	0.0434	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs