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

[Ivan Kohler]

On Wed, Oct 14, 2009 at 08:43:10AM -0700, Jamuel P. Starkey wrote:
>
> $ freeside-setup -d hcvoip.com
>
> DBD::mysql::db do failed: BLOB/TEXT column 'job' used in key
> specification without a key length [for Statement "CREATE  INDEX
> h_queue3 ON h_queue ( job )"] at /usr/bin/freeside-setup line 110.
> CREATE error: BLOB/TEXT column 'job' used in key specification without a
> key length
> doing statement: CREATE  INDEX h_queue3 ON h_queue ( job ) at
> /usr/bin/freeside-setup line 110.
>
> I believe the offending SQL is:
>
> CREATE  INDEX h_queue3 ON h_queue ( job )

Looks like the index on a text field (queue.job) is tickling MySQL the 
wrong way

You could try Postgres, or this patch:

Index: Schema.pm
===================================================================
RCS file: /home/cvs/cvsroot/freeside/FS/FS/Schema.pm,v
retrieving revision 1.169
diff -u -r1.169 Schema.pm
--- Schema.pm	12 Oct 2009 01:45:12 -0000	1.169
+++ Schema.pm	21 Oct 2009 07:05:35 -0000
@@ -1643,7 +1643,7 @@
     'queue' => {
       'columns' => [
         'jobnum',      'serial',     '',      '', '', '', 
-        'job',           'text',     '',      '', '', '', 
+        'job',        'varchar',     '',     512, '', '', 
         '_date',          'int',     '',      '', '', '', 
         'status',     'varchar',     '', $char_d, '', '', 
         'statustext',    'text', 'NULL',      '', '', '', 


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