Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.16.14

Bug #13154 Example 4:schema validation error
Submitted: 2008-02-20 01:51 UTC
From: anocomputing Assigned: dufuz
Status: Closed Package: LiveUser (version 0.16.13)
PHP Version: 5.2.5 OS: Windows Vista
Roadmaps: (Not assigned)    
Subscription  


 [2008-02-20 01:51 UTC] anocomputing (Arnold Chang)
Description: ------------ When I try to create the database using demodata.php for example 4, I received the following error: I could not populate the database, see error below MDB2_Schema Error: schema validation error Parser error: length has to be an integer greater 0 - No error - Byte: 24710; Line: 1651; Col: 9 Apparently, near line 1650 in example4/demodata.xml, the length tag is empty. It should define a value in it. I set it to 100 and the database is created again. <field> <name>news</name> <type>clob</type> <length></length> </field>

Comments

 [2008-02-20 02:22 UTC] anocomputing (Arnold Chang)
Similar issue in example 5. I could not populate the database, see error below MDB2_Schema Error: schema validation error Parser error: length has to be an integer greater 0 - No error - Byte: 14475; Line: 932; Col: 9
 [2008-03-22 01:05 UTC] dufuz (Helgi Þormar Þorbjörnsson)
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.
 [2009-01-18 13:39 UTC] jesperkp (Jesper Pedersen)
As per LiveUser 0.16.13 I still get this error with the Running this command : example4]# php ../demodata.php -d "pgsql://localtest:testpwd@rhea.solnet/wos" -f ./demodata.xml I could not populate the database, see error below MDB2_Schema Error: schema validation error Parser error: length has to be an integer greater 0 - No error - Byte: 24710; Line: 1651; Col: 12 --- Editing line 1651 to include a length as suggested gives me this error : I could not populate the database, see error below MDB2 Error: already exists _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE liveuser_areas ADD CONSTRAINT define_name_i_idx UNIQUE (application_id, area_define_name)] [Native message: ERROR: relation "define_name_i_idx" already exists] -- pear list Installed packages, channel pear.php.net: ========================================= Package Version State Archive_Tar 1.3.2 stable Auth 1.6.1 stable Auth_SASL 1.0.2 stable Console_Getopt 1.2.3 stable DB 1.7.14RC1 beta DB_Table 1.5.6 stable Event_Dispatcher 1.0.0 stable HTML_Common 1.2.4 stable HTML_Common2 2.0.0beta1 beta HTML_QuickForm 3.2.10 stable HTML_QuickForm2 0.2.0 alpha HTML_Template_IT 1.3.0a1 alpha LiveUser 0.16.13 beta LiveUser_Admin 0.3.9 beta MDB2 2.5.0b2 beta MDB2_Driver_pgsql 1.5.0b2 beta MDB2_Schema 0.8.4 beta PEAR 1.7.2 stable Structures_Graph 1.0.2 stable XML_DTD 0.5.0 alpha XML_Parser 1.3.1 stable XML_RPC 1.5.1 stable XML_Serializer 0.19.1 beta XML_Tree 2.0.0RC2 beta XML_Util 1.2.1 stable