[freeside-users] Install 1.9 on CentOS 5.3 DBD::mysql::db do failed

Ivan Kohler ivan at freeside.biz
Wed Oct 21 05:37:57 PDT 2009


On Wed, Oct 21, 2009 at 01:10:54PM +0300, Odhiambo Washington wrote:

> BLOB/TEXT column 'statustext' used in key
> specification without a key length [for Statement "CREATE  INDEX
> h_cust_bill_event4 ON h_cust_bill_event ( statustext )"]

To get things created under MySQL, I'd suggest editing Schema.pm and 
removing the statustext index from the cust_event and cust_bill_event 
tables.

Not sure what to do for a proper fix in tree.  The statustext index is 
used in cust_main.pm's retry_realtime method.  Perhaps we need to teach 
DBIx::DBSchema to specify a default length for MySQL indices on text 
columns, or just to support an index length at all so we can pass 
something in.

We could certainly use help keeping the MySQL support current if folks 
are interested in using it.  We had work sponsored not too long ago to 
bring it basically up-to-date but could use assistance with ongoinging 
testing and maintenence.

-- 
_ivan


More information about the freeside-users mailing list