Bug #3964

Example 4: DB Error: no such field

Details

Submitted	2005-03-26 02:46 UTC
From	bg at bgmccollum dot com
Assigned	lsmith
Status	Closed
Package	LiveUser
PHP Version	4.3.10
OS	Fedora Core 3
Roadmaps	(Not assigned)

Comments

[2005-03-26 02:46 UTC] bg at bgmccollum dot com

Description:
------------
Example 4:

Post login, then selecting:

Change / delete news
View news

Produce:

error

/var/www/html/examples/example4/conf.php (32)
DB Error: no such field
SELECT DATE_FORMAT(news.created_at,"%d.%m.%Y - %H:%i")
AS date, news.news, liveuser_users.handle FROM news
INNER JOIN liveuser_perm_users ON news.owner_user_id
= liveuser_perm_users.perm_user_id INNER JOIN
liveuser_users ON liveuser_perm_users.auth_user_id =
liveuser_users.auth_user_id ORDER BY news.created_at
DESC [nativecode=1054 ** Unknown column
'liveuser_users.auth_user_id' in 'on clause']

[2005-03-26 15:55 UTC] bg at bgmccollum dot com

liveuser_users exists
there is no auth_user_id but there is a authUserId (no
underscores)

[2005-03-26 16:00 UTC] smith at backendmedia dot com

This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pear.php.net.

In case this was a pear.php.net website problem, the change will show
up on the website in short time.

Thank you for the report, and for helping us make PEAR better.