bitweaver
Wiki
wiki Home
List Pages
wiki Books
Orphan Pages
wiki Rankings
Photos
List Galleries
Forums
Browse forums
Files
List Galleries
Categories
List Categories
Sign In
Message Boards
»
10. Development - Bugs
Newest
Oldest
Threaded
5
10
20
50
100
All
Messages
undefined index errors when using sqlite
Post Reply
Paul
Joined: 02 Aug 2006
undefined index errors when using sqlite
Posted:02 Aug 2006 (18:58 UTC)
Post Reply
Page 1 of 1
1
Post
Title
Login
If you are already registered, please enter your login credentials.
Your Name
Anonymous Post
Content Format
Tiki Wiki Syntax
Allow HTML
{quote format_guid="bbcode" comment_id="8166" user="Brannan"}After installing bitweaver using sqlite, I get numerous errors like this: [Wed Aug 2 14:45:11 2006] [error] PHP Notice: Undefined index: content_id in /usr/local/sites/withoutpenandink.com/html/bitweaver/users/BitUser.php on line 137 Seems sqlite doesn't behave the way bitweaver is expecting. I don't know SQL well, but a simple modification to the query eliminates the errors: $query = "select uu.*, uu.`login` AS `user`, tf_ava.`storage_path` AS `avatar_storage_path`, tf_por.`storage_path` AS `portrait_storage_path`, tf_logo.`storage_path` AS `logo_storage_path` $fullSelect, uu.`user_id` AS `uu_user_id, uu.`content_id` as content_id, uu.`login` as login, uu.`real_name` as real_name, uu.`email` as email` ... But this problem seems to be prevalent throughout the code. If the problem is with the version of sqlite that I'm using (I have both 2.8 and 3.2 installed, but I'm not sure how to tell which one I'm using), then bitweaver should warn about this at install time. If the problem is endemic to all versions of sqlite, then sqlite should be removed as an option from future versions of bitweaver until the problem is resolved. If you think the problem is elsewhere, let me know and I'll be happy to dig deeper.{/quote}
Recent Page Changes
welcome to bitweaver.org
Bitweaver Overview
ReleaseTwo Schema Changelog 2006
PressReleaseOne
Spider's Web
Press Release Two
BitcommercePackage
InfiniBand vs Ethernet Performance
InfiniBand for Dummies
Show More…