Re: please test pearweb package
| From: | Brett Bieber | Date: | Fri, 01 Dec 2006 02:12:35 +0000 |
| Subject: | Re: please test pearweb package | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-45057@lists.php.net to get a copy of this message | ||
> > Please report back, and also whether the final installation works (you
> > need to add a user to the database, otherwise you can't log in and so on)
> >
> > Greg
On 11/30/06, David Coallier <davidc@php.net> wrote:
> There is a problem in the field:
> comment
### Eclipse Workspace Patch 1.0 #P pearweb Index: sql/pearweb_mdb2schema.xml =================================================================== RCS file: /repository/pearweb/sql/pearweb_mdb2schema.xml,v retrieving revision 1.13 diff -u -r1.13 pearweb_mdb2schema.xml --- sql/pearweb_mdb2schema.xml 29 Nov 2006 04:34:05 -0000 1.13 +++ sql/pearweb_mdb2schema.xml 1 Dec 2006 02:11:14 -0000 @@ -2222,7 +2222,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field> @@ -2278,7 +2278,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field> @@ -2379,7 +2379,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field>
VARCHAR(65532) of the table
> "package_proposal_changelog`"
> please change this to text only so it doens't break on mysql :-)
>
As David notes, the problem is with the comment fields - causes
problems on certain versions of mysql evidently. Changing all the
comment fields from text to clob gets the pearweb post install script
to successfully complete for me.
Attached patch for the pearweb_mdb2schema.xml
Other than that... appears to work fine!
--
-Brett
http:saltybeagle.com aim:ianswerq
### Eclipse Workspace Patch 1.0 #P pearweb Index: sql/pearweb_mdb2schema.xml =================================================================== RCS file: /repository/pearweb/sql/pearweb_mdb2schema.xml,v retrieving revision 1.13 diff -u -r1.13 pearweb_mdb2schema.xml --- sql/pearweb_mdb2schema.xml 29 Nov 2006 04:34:05 -0000 1.13 +++ sql/pearweb_mdb2schema.xml 1 Dec 2006 02:11:14 -0000 @@ -2222,7 +2222,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field> @@ -2278,7 +2278,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field> @@ -2379,7 +2379,7 @@ <field> <name>comment</name> - <type>text</type> + <type>clob</type> <notnull>false</notnull> </field>