[freeside-devel] Upgrade to 1.4.0 problem

[ivan]

On Fri, Jan 11, 2002 at 04:35:59PM +0100, Marcus R?nnquist wrote:
> Hi!
> In the document "Upgrading to 1.4.0 from 1.3.1 in the section "Apply the
> following changes to your database:" I SQL syntax error when trying to
> create the queue table because of the "arg varchar null" statement. If I
> define "arg varchar(80) null" for example it slips through. Should mysql
> accept undefined varchars or how big should they be?

Try the attached changes to upgrade8.html

Note that some of the browse/search functions in current 1.4.0 snapshots
are broken under MySQL regardless.

As per the recent discussion, unless someone steps forward to maintain the
MySQL support (work around MySQL's lack of standard SQL features), 1.4.0
will not support MySQL.

-- 
_ivan

Index: upgrade8.html
===================================================================
RCS file: /home/cvs/cvsroot/freeside/httemplate/docs/upgrade8.html,v
retrieving revision 1.27
diff -r1.27 upgrade8.html
105c105
<   job varchar not null,
---
>   job text not null,
113c113
<   arg varchar null
---
>   arg text null
153,154c153,154
< ALTER TABLE part_pkg ADD plan varchar NULL;
< ALTER TABLE part_pkg ADD plandata varchar NULL;
---
> ALTER TABLE part_pkg ADD plan varchar(80) NULL;
> ALTER TABLE part_pkg ADD plandata text NULL;
220c220
< ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
---
> ALTER TABLE cust_main ADD COLUMN comments text NULL;