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

Bug #13233 Example1 error when importing data in DB
Submitted: 2008-02-27 15:32 UTC
From: banquette Assigned: dufuz
Status: Closed Package: LiveUser_Admin (version 0.3.9)
PHP Version: 5.2.5 OS: win
Roadmaps: (Not assigned)    
Subscription  


 [2008-02-27 15:32 UTC] banquette (Alex Desktop)
Description: ------------ When I do php demodata.php -d mysql://root:@localhost/liveuser_admin_test_example1 -f demodata.xml I got the following error : I could not populate the database, see error below MDB2_Schema Error: schema validation error Parser error: sequence "liveuser_applications" on a table was not properly defined - No error - Byte: 10320; Line: 610; Col: 12 Line from XML file is : <sequence> <name>liveuser_applications</name> </sequence> <sequence> <name>liveuser_areas</name> </sequence> Test script: --------------- php demodata.php -d mysql://root:@localhost/liveuser_admin_test_example1 -f demodata.xml Expected result: ---------------- Good import Actual result: -------------- I could not populate the database, see error below MDB2_Schema Error: schema validation error Parser error: sequence "liveuser_applications" on a table was not properly defined - No error - Byte: 10320; Line: 610; Col: 12

Comments

 [2008-04-23 13:38 UTC] cherry (Patrick Pfeiffer)
I am getting the same error. You can use the sql-dump form http://wiki.pooteeweet.org/LiveUser/MySQLDumpOfDemodataForExample1 instead of generating the sql-tables with the demodata-script. This works for me.
 [2009-03-13 01:44 UTC] dufuz (Helgi Þormar Þorbjörnsson)
-Status: Open +Status: Closed -Type: Documentation Problem +Type: Bug -Assigned To: +Assigned To: dufuz
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.