Closed (fixed)
Project:
Bible
Version:
6.x-1.2-rc6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
22 Jan 2009 at 04:27 UTC
Updated:
28 Mar 2011 at 02:51 UTC
Hello,
I just installed the module and when I go to my /admin/settings/bible and click on the "List" link it gives me this message:
user warning: Unknown column 'bible_list.bid' in 'where clause' query: SELECT drupal_bible_list.* FROM drupal_bible_list, drupal_bible_context WHERE book = 'GEN' AND chapter = 1 AND verse = 1 and linemark = '' AND context like '%<H0430>%' and bible_list.bid = bible_context.bid in /public_html/sites/default/modules/bible-6.x-1.2-rc6/bible/bible.module on line 396.
I set Drupal to show all errors, however if I turn off all errors showing than this message won't show. I was able to import Bible successfully so I don't know what this error message means.
Comments
Comment #1
MikeLee_Birdy commentedDear stormking:
I guess you can ignore this error if this won't bother you too much. This should be an error cause from the earlier operation. But, if this message happen again, please report again.
MikeLee
Comment #2
stieglitz commentedDear MikeLee,
Thank you for this module. I have a special place in my heart for Taiwan after spending a summer in Taichung, WuChi, and Chingshui. NeeHow. I just noticed a couple of minor typos and it may just be a language translation thing. I have only been a Drupalite (drupal user) for about a year and so I am not sure how the translation module affects stuff like this however I noticed the following:
Keyword to search in bible context. Multi-keywords are available. Use "-" as a nagative(NOT) search. should read Keyword to search in Bible context. Multi-keywords are available. Use "-" as a negative(NOT) search.
Comment #3
MikeLee_Birdy commentedDear stieglitz:
It's so great that you like Taiwan. If you have chance to visit Taiwan again, south part will be a better choice.
And, yes, there's some mis-typing there. I'll fix them in next version. Thanks.
MikeLee
Comment #4
jonathanbloom commentedI got this error too. I don't know how to fix it.
Comment #5
MikeLee_Birdy commentedDear Jonathan:
I've find this bug and fix it. This cause from when you install drupal, if you define some "prefix" for db, then this bug will appear. But this is coming from my careless.
Please find this line in function bible_admin_list, and find this line, add { } before and after bible_list, bible_context like this:
$sqlcmd .= " AND context like '%%' AND {bible_list}.bid = {bible_context}.bid";
MikeLee
Comment #6
brianbrown commentedHi, Mike!
Its me, "Brian the Pest" again! I have this issue also! I also have table prefixes. Please don't apologize for your being "careless," being a module maintainer isn't easy and you are to be commended and thanked for your efforts!
By the way, your English is excellent. You have a spelling error in the module description. "Privide" should be "provide." If you need any help with translation--- EVER--- please reach me at brian(at)brianbrown.net and I will be glad to look it over. English is very complicated.
Regards,
Brian Brown, Ph.D.
Comment #7
MikeLee_Birdy commentedDear Brian:
Hoho...Thanks for the correction. Please correct me whereever I should be.
I develop this module for my own need at first. But I think that this might be helpful for some who also need this. To make this module perfect is one thing, to let people to read more in bible is more important. Of course, I do need more users to help me, especially in where should I do more function or change so that people can read bible easier.
So, yes, I need your help. Any corrections are welcome. Please feel free to tell me where/how should I do. Thanks in advance.
MikeLee
Comment #8
landike commentedNot sure here it can be, but.... maybe this issue is pending to be fixed
After installing Bible module on Drupal 6.12 I have error messages :
1) on page where we have list of all modules:
* warning: Invalid argument supplied for foreach() in /virt/homes/*/htdocs/sites/all/modules/bible/bible.module on line 1808. (3 times)
2) on Bibble Setings page:
user warning: Unknown column 'bible_list.bid' in 'where clause' query: SELECT d612bible_list.* FROM d612bible_list, d612bible_context WHERE book = 'GEN' AND chapter = 1 AND verse = 1 AND linemark = '' AND context like '%%' AND bible_list.bid = bible_context.bid in /virt/homes/empirius/htdocs/sites/all/modules/bible/bible.module on line 446.
Please notify person who is responsible for fixing it.
And I'm interested in using this module, so inform me please too (landike@gmail.com)
Comment #9
Kriss-dupe commentedBeen here too long, changing status for efficiency.