MySQL Warning

Found a bug? Tell us!!
Post Reply
JWalker
Regular
Posts: 177
Joined: Mon Sep 12, 2005 4:14 pm
Location: Botevgrad, Bulgaria
Contact:

MySQL Warning

Post by JWalker »

Here is what I read in MySQL Error Log:

051129 9:11:38 InnoDB: Warning: using a partial-field key prefix in search.
InnoDB: index `date_idx` of table `serendipity/serendipity_entries`. Last data field length 5 bytes,
InnoDB: key ptr now exceeds key end by 4 bytes.
InnoDB: Key value in the MySQL format:
len 1; hex 01; asc ;


My Blog works perfectly, no any problems. I simply took a look at the error log. I do not understand what this message means, but may be this will be in help removing some real problem ?

MySQL 4.1.14 / PHP 5.0.2 / Apache 2.0.54 / Windows XP SP2
Ivan Cenov
OKTO-7 Co., Botevgrad
Bulgaria
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: MySQL Warning

Post by garvinhicking »

Hm, never heard of this. But usually Serendipity uses MyISAM tables; InnoDB AFAIK does not support fulltext search.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply