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-25 21:46 UTC Modified: 2006-12-24 16:12 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)    
Subscription  


 [2005-03-25 21: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 00: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 10: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 11: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.