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

MikeLee_Birdy’s picture

Dear 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

stieglitz’s picture

Dear 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.

MikeLee_Birdy’s picture

Dear 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

jonathanbloom’s picture

I got this error too. I don't know how to fix it.

MikeLee_Birdy’s picture

Dear 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

brianbrown’s picture

Hi, 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.

MikeLee_Birdy’s picture

Dear 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

landike’s picture

Not 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)

Kriss-dupe’s picture

Status: Active » Fixed

Been here too long, changing status for efficiency.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.