Bug #1278

Example 3 not working

Details

Submitted	2004-04-25 13:41 UTC
From	schnirkel at gmx dot at
Status	Bogus
Package	LiveUser
PHP Version	4.3.5
OS	linux
Roadmaps	(Not assigned)

Comments

[2004-04-25 13:41 UTC] schnirkel at gmx dot at

Description:
------------
o) using cvs version (sunday 25-04-2004 15:40)

I was following the instructions on index.html, and import the demodata.sql script into an empty myql database -> not working, because of missing table liveuser_areas
Well, ok, create an empty database with perm_db.sql and Auth_DB.sql from sql dir first... try again, nope, this time we do have a problem with an already existing liveuser_users.

ok, i know that is not that hard to work around this, but its a bit too difficult to get that example working.

Reproduce code:
---------------
1.try
[schnirkel@florenz example3]# _mysql pear_test < demodata.sql
ERROR 1146 at line 42: Table 'pear_test.liveuser_areas' doesn't exist

2.try (after drop and create database pear_test)
[schnirkel@florenz sql]# _mysql pear_test < Auth_DB.sql
[schnirkel@florenz sql]# _mysql pear_test < perm_db.sql
[schnirkel@florenz example3]# _mysql pear_test < demodata.sql
ERROR 1050 at line 3: Table 'liveuser_users' already exists

Expected result:
----------------
a working combination of create and insert scripts... or a working (complete) dump in demodata.sql