Bug #2231

Example 3 fails due to missing table

Details

Submitted	2004-08-27 00:28 UTC
From	ryan at numeriex dot com
Assigned	dufuz
Status	Closed
Package	LiveUser
PHP Version	4.3.7
OS	Any
Roadmaps	(Not assigned)

Comments

[2004-08-27 00:28 UTC] ryan at numeriex dot com

Description:
------------
Version: LiveUser 0.12.0

I followed the database setup instructions exactly:
"Set up a test database by importing demodata.sql and perm_db.sql (from /misc/schema)" but the example failed.
After some digging around it turned out that the table
liveuser_users was missing. The answer was to source
Auth_db.sql, and then source demodata.sql again.

Just a bug in the documentation, but a showstopper for anyone
who doesn't know what to look for.

Please don't tell me this is not a bug. If a developer omits
something and it prevents the software from working, it's a
bug. It doesn't matter whether the omission is in the code
or the docs.

Reproduce code:
---------------
No coding needed. Just drop the example in a directory,
follow instructions, and attempt to log in.

Expected result:
----------------
Testarea

Wow, you've the right to read the latest posting in this list!
OK, let's search the database for the last entry ...

Actual result:
--------------
DB Error: no such table:
SELECT auth_user_id AS auth_user_id,handle AS handle,passwd AS passwd,lastlogin AS lastlogin,is_active AS is_active FROM liveuser_users WHERE handle='boss' AND passwd='test' [nativecode=1146 ** Table 'pear_test.liveuser_users' doesn't exist]