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

[Odhiambo Washington]

On Wed, Oct 21, 2009 at 10:21 AM, Ivan Kohler <ivan at freeside.biz> wrote:

> 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.



On FreeBSD 7.2, with perl v5.8.9 and MySQL v5.1.38 while installing
freeside-1.9.1, I get this error despite applying this patch, although mine
seems to fail at a different stage..


[freeside at FreeBSD-7 ~]$ freeside-setup -d testdomain.name
NO CONFIGURATION TABLE FOUND at
/usr/local/lib/perl5/site_perl/5.8.9/FS/UID.pm line 131.
DBD::mysql::db do failed: 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 )"] at
/usr/local/bin/freeside-setup line 109.
CREATE error: BLOB/TEXT column 'statustext' used in key specification
without a key length
doing statement: CREATE  INDEX h_cust_bill_event4 ON h_cust_bill_event (
statustext ) at /usr/local/bin/freeside-setup line 109.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
"If you have nothing good to say about someone, just shut up!."
              -- Lucky Dube
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://420.am/pipermail/freeside-users/attachments/20091021/7a76725f/attachment.htm>