Loading demo database

View: New views
2 Messages — Rating Filter:   Alert me  

Loading demo database

by Glenn Lyons :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Hi all,

When loading the demo database I get this error.

Command:
"mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"

Results:
ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key
'factor_name'

I can see that I have half a demo database with only one for the three
company records that start on line 6326.

How do I fix this? Can I delete the other two duplicate records?

Thanks,

Glenn


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Loading demo database

by Phil Daintree-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

If you drop the database completely then rerun.

Phil

Glenn Lyons wrote:

> Hi all,
>
> When loading the demo database I get this error.
>
> Command:
> "mysql --user=root --password=xxxxx <webERP/sql/mysql/weberp-demo.sql"
>
> Results:
> ERROR 1062 (23000) at line 6326: Duplicate entry 'None' for key
> 'factor_name'
>
> I can see that I have half a demo database with only one for the three
> company records that start on line 6326.
>
> How do I fix this? Can I delete the other two duplicate records?
>
> Thanks,
>
> Glenn
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>  


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers