It is probably something I am doing wrong, but when I downloaded the bible-kjv-eng.bc and attempted to import it I got this error. The file itself uncompressed properly and opened in notepad but did not import. I tried placing it in various locations but that did not help either.

I work as a .NET developer so all this is new to me.

Thanks

CommentFileSizeAuthor
#3 php.zip15.15 KBstrayhand

Comments

MikeLee_Birdy’s picture

MikeLee_Birdy commented

Can you show me the error message so that I can keep tracking the problem? Or.... the title "The bible import failed, because the file %filename could not be read." is the Error message?

If "could not be read" is the error message, and your environment is windows, I guess that might be file locked problem. Be sure to close all editor that read .bc file then to import it.

I'm also a .NET developer using C#/ASP.NET. I've done a ASP.NET bible study web-site before. But I found Drupal got better environment to develop Bible study functions. So I switch to drupal. I hope you can help in developing bible study so that we can offer more bible to everyone.

geomarketing’s picture

geomarketing commented

Yes that was the error message. I tried to import on the server and also from a local workstation to make sure file locking was not the issue. So it is still a mystery.

Also I was wondering if you knew about the work being done in Germany by the group called Zefania. They have their own "standard" XML Bible document format and have converted a large amount of biblical references into it. I have a C# conversion tool to import their format into MS SQL (if I can locate it) and also some C# code to render the hyperlink stuff. Maybe converting it would be a good way to learn a little more about PHP! The document base they provide can be located on sourceforge.

http://sourceforge.net/project/shownotes.php?release_id=312698&group_id=... .

Also have you built out any blocks that access your functions (it looks like the one in the existing version pulls a verse from your site instead)?

Thanks

strayhand’s picture

strayhand commented
StatusFileSize
new php.zip15.15 KB

I too got this error. I believe that it's actually a PHP "upload_max_filesize" error. PHP has specific configuration variables that dictate how large of a file you can upload. The bible .bc translation files are pretty big 4+ MB. So you'll need to edit your PHP variables to account for larger file uploads. By default most systems are configured to allow 2MB. Insert these two variables in your .htaccess file or modify them in a new php.ini file that you place in the root directory of drupal.

  • php_value post_max_size 67108864
  • php_value upload_max_filesize 67108864

(The numbers above are in bytes).

.htaccess example:


# PHP 4, Apache 1.
<IfModule mod_php4.c>
  php_value post_max_size 67108864
  php_value upload_max_filesize 67108864
  php_value magic_quotes_gpc                0
  php_value register_globals                0
  php_value session.auto_start              0
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_value mbstring.encoding_translation   0
</IfModule>

# PHP 4, Apache 2.
<IfModule sapi_apache2.c>
  php_value post_max_size 67108864
  php_value upload_max_filesize 67108864
  php_value magic_quotes_gpc                0
  php_value register_globals                0
  php_value session.auto_start              0
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_value mbstring.encoding_translation   0
</IfModule>

# PHP 5, Apache 1 and 2.
<IfModule mod_php5.c>
  php_value post_max_size 67108864
  php_value upload_max_filesize 67108864
  php_value magic_quotes_gpc                0
  php_value register_globals                0
  php_value session.auto_start              0
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_value mbstring.encoding_translation   0
</IfModule>

php.ini example:

See attached.

MTecknology’s picture

MTecknology commented

After all this talk about MySQL being the issue....

Thanks very much for pointing this out. I just changed the 2MB and 8MB limits to 50MB. Seems insane enough. :P

Watchkeeper’s picture

Watchkeeper commented

Good point. Not "is it insane?" but "is it insane enough?" ;-)

dbt102’s picture

dbt102 commented

I'm trying to install upload and have the same problem. I got this far, editted the .htaccess file in as per example but still have the same problem.

I'm not sure if I understand the php.ini example so haven't tried it.

I'm wondering is this can be done on a hosted site? If so, what should i do next?

dbt102’s picture

dbt102 commented
Version: 5.x-2.0-dev » 6.x-1.0-rc3
Component: Miscellaneous » Documentation
Status: Active » Postponed (maintainer needs more info)

The change to .htaccess file did not wotk for me.

What do you do with the php.ini file? just load the detard zip file up? to where?

rajaubud’s picture

rajaubud commented

It works, just upload patch php.ini to /public_html using ftp , backup your current php.in first for safety. Thanks.

dbt102’s picture

dbt102 commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

I uploaded patch php.ini to /public_html and it works! Thank you for your help!

I'm one month new to Drupal, and learning more every week. The Bible module is really quite easy to implement and use.