| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.16.14 |
| Bug #3964 | Example 4: DB Error: no such field | ||
|---|---|---|---|
| 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) | ||
[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']
Comments
[2005-03-26 05:19 UTC] dufuz
Does liveuser_users exist at all ? if so is there user_id or auth_user_id in there ?
Maybe you forgot to read the readme file and create the table ?
[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.