ERROR 1170 (42000) : BLOB/TEXT

Next topic

Author	Message
rupam jaiswal	Saturday 30 September 2006 6:05:19 am hello friends, i am using mysql along with php. i am using xml for creating dbase. I hv create a table with some fileds among them 1 is <field> <name>memo_data</name> <type>text</type> <comment>data for ext property data_type = memo.</comment> <add>1.1</add> </field> <index> <name>index_memo_field</name> <fieldName>memo_data</fieldName> <fieldName>custom_field_id</fieldName> <add>1.6</add> </index> the problem is when i run this,then the error appears "ERROR 1170 (42000) at line 2717: BLOB/TEXT column 'memo_data' used in key specification without a key length". this problem is solved when i replace text with varchar and limit the length to 255 but i want it to remain text...... can any1 help me????? the meaning that i interpret from this errror msg is that limit of text should be defined but this is not possible in mysql for type text. Regards abcd
Kristof Coomans	Saturday 30 September 2006 6:30:09 am Hi abcd You need to specify the prefix length of your index, not for the database column. See http://dev.mysql.com/doc/refman/5.0/en/indexes.html independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org

Author

Message

Saturday 30 September 2006 6:05:19 am

hello friends,
i am using mysql along with php. i am using xml for creating dbase. I hv create a table with some fileds among them 1 is
<field>
<name>memo_data</name>
<type>text</type>
<comment>data for ext property data_type = memo.</comment>
<add>1.1</add>
</field>
<index>
<name>index_memo_field</name>
<fieldName>memo_data</fieldName>
<fieldName>custom_field_id</fieldName>
<add>1.6</add>
</index>
the problem is when i run this,then the error appears "ERROR 1170 (42000) at line 2717: BLOB/TEXT column 'memo_data' used in key specification without a key length".
this problem is solved when i replace text with varchar and limit the length to 255 but i want it to remain text......
can any1 help me????? the meaning that i interpret from this errror msg is that limit of text should be defined but this is not possible in mysql for type text.
Regards
abcd

Kristof Coomans

Saturday 30 September 2006 6:30:09 am

Hi abcd

You need to specify the prefix length of your index, not for the database column. See http://dev.mysql.com/doc/refman/5.0/en/indexes.html

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

eZ debug

Timing:	Jan 20 2025 04:13:26
Script start
Timing:	Jan 20 2025 04:13:26
Module start 'layout'
Timing:	Jan 20 2025 04:13:26
Module start 'content'
Timing:	Jan 20 2025 04:13:26
Module end 'content'
Timing:	Jan 20 2025 04:13:26
Script end

Main resources:

Total runtime	0.0179 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.0055	589.2734	152.6406
Module start 'layout'	0.0055	0.0031	741.9141	39.4609
Module start 'content'	0.0086	0.0072	781.3750	89.3359
Module end 'content'	0.0158	0.0020	870.7109	30.3047
Script end	0.0178		901.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	14.2205	14	0.0002
Check MTime	0.0012	6.4898	14	0.0001
Mysql Total
Database connection	0.0010	5.5011	1	0.0010
Mysqli_queries	0.0026	14.7302	3	0.0009
Looping result	0.0000	0.0841	1	0.0000
Template Total	0.0016	9.2	1	0.0016
Template load	0.0008	4.7073	1	0.0008
Template processing	0.0008	4.4271	1	0.0008
Override
Cache load	0.0006	3.2956	1	0.0006
General
dbfile	0.0030	16.5888	8	0.0004
String conversion	0.0000	0.0440	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