Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
BibleStudy
BibleStudy 6.0.x and older
Help Forum

Installation Problem
(1 viewing) (1) Guest
Reply Topic
New Topic

TOPIC: Installation Problem

Installation Problem 27 Nov 2007 12:42 #2

  • Rich.Simpson
Hi, This looks like an interesting new component especially as 1.5 components are rare at the moment and I'd like to try it. However I cannot get it to install. Im using Joomla 1.5RC3 recent nightly build.

It looks as though it is having trouble creating the databas entries:

error messages below - Thanks
Richard

___
JInstaller::install: SQL Error. DB function failed with error number 1067
Invalid default value for 'chapter_begin' SQL=CREATE TABLE IF NOT EXISTS `jos_bsms_studies`( `id` INT(11) NOT NULL AUTO_INCREMENT, `studydate` datetime default NULL, `teacher_id` INT(11) NULL default '1', `studynumber` VARCHAR(100) NULL default '', `booknumber` INT(3) NULL default '101', `chapter_begin` INT(3) NULL default '', `verse_begin` INT(3) NULL default '', `chapter_end` INT(3) NULL default '', `verse_end` INT(3) NULL default '', `studytitle` text NULL default '', `studyintro` text NULL default '', `messagetype` VARCHAR(100) NULL default '1', `series_id` INT(3) NULL default '', `topics_id` INT(3) NULL default '', `studytext` TEXT NULL default '', `media1_id` INT(11) NULL default '', `media1_server` VARCHAR(250) NULL default '', `media1_path` VARCHAR(250) NULL default '', `media1_special` VARCHAR(250) NULL default '_self', `media1_filename` TEXT NULL default '', `media1_show` TINYINT(1) NULL default '0', `media2_id` INT(11) NULL default '0', `media2_server` VARCHAR(250) NULL default '', `media2_path` VARCHAR(250) NULL default '', `media2_special` VARCHAR(250) NULL default '_self', `media2_filename` TEXT NULL default '', `media2_show` TINYINT(1) NULL default '0', `media3_id` INT(11) NULL default '0', `media3_server` VARCHAR(250) NULL default '', `media3_path` VARCHAR(250) NULL default '', `media3_special` VARCHAR(250) NULL default '_self', `media3_filename` TEXT NULL default '', `media3_show` TINYINT(1) NULL default '0', `media4_id` INT(11) NULL default '0', `media4_server` VARCHAR(250) NULL default '', `media4_path` VARCHAR(250) NULL default '', `media4_special` VARCHAR(250) NULL default '_self', `media4_filename` TEXT NULL default '', `media4_show` TINYINT(1) NULL default '0', `media5_id` INT(11) NULL default '0', `media5_server` VARCHAR(250) NULL default '', `media5_path` VARCHAR(250) NULL default '', `media5_special` VARCHAR(250) NULL default '_self', `media5_filename` TEXT NULL default '', `media5_show` TINYINT(1) NULL default '0', `media6_id` INT(11) NULL default '0', `media6_server` VARCHAR(250) NULL default '', `media6_path` VARCHAR(250) NULL default '', `media6_special` VARCHAR(250) NULL default '_self', `media6_filename` TEXT NULL default '', `media6_show` TINYINT(1) NULL default '0', `published` TINYINT(1) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`
SQL =
CREATE TABLE IF NOT EXISTS `jos_bsms_studies`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`studydate` datetime default NULL,
`teacher_id` INT(11) NULL default '1',
`studynumber` VARCHAR(100) NULL default '',
`booknumber` INT(3) NULL default '101',
`chapter_begin` INT(3) NULL default '',
`verse_begin` INT(3) NULL default '',
`chapter_end` INT(3) NULL default '',
`verse_end` INT(3) NULL default '',
`studytitle` text NULL default '',
`studyintro` text NULL default '',
`messagetype` VARCHAR(100) NULL default '1',
`series_id` INT(3) NULL default '',
`topics_id` INT(3) NULL default '',
`studytext` TEXT NULL default '',
`media1_id` INT(11) NULL default '',
`media1_server` VARCHAR(250) NULL default '',
`media1_path` VARCHAR(250) NULL default '',
`media1_special` VARCHAR(250) NULL default '_self',
`media1_filename` TEXT NULL default '',
`media1_show` TINYINT(1) NULL default '0',
`media2_id` INT(11) NULL default '0',
`media2_server` VARCHAR(250) NULL default '',
`media2_path` VARCHAR(250) NULL default '',
`media2_special` VARCHAR(250) NULL default '_self',
`media2_filename` TEXT NULL default '',
`media2_show` TINYINT(1) NULL default '0',
`media3_id` INT(11) NULL default '0',
`media3_server` VARCHAR(250) NULL default '',
`media3_path` VARCHAR(250) NULL default '',
`media3_special` VARCHAR(250) NULL default '_self',
`media3_filename` TEXT NULL default '',
`media3_show` TINYINT(1) NULL default '0',
`media4_id` INT(11) NULL default '0',
`media4_server` VARCHAR(250) NULL default '',
`media4_path` VARCHAR(250) NULL default '',
`media4_special` VARCHAR(250) NULL default '_self',
`media4_filename` TEXT NULL default '',
`media4_show` TINYINT(1) NULL default '0',
`media5_id` INT(11) NULL default '0',
`media5_server` VARCHAR(250) NULL default '',
`media5_path` VARCHAR(250) NULL default '',
`media5_special` VARCHAR(250) NULL default '_self',
`media5_filename` TEXT NULL default '',
`media5_show` TINYINT(1) NULL default '0',
`media6_id` INT(11) NULL default '0',
`media6_server` VARCHAR(250) NULL default '',
`media6_path` VARCHAR(250) NULL default '',
`media6_special` VARCHAR(250) NULL default '_self',
`media6_filename` TEXT NULL default '',
`media6_show` TINYINT(1) NULL default '0',
`published` TINYINT(1) NOT NULL default '1',
PRIMARY KEY (`id`) )
TYPE=MyISAM CHARACTER SET `utf8`Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1067
Invalid default value for 'chapter_begin' SQL=CREATE TABLE IF NOT EXISTS `jos_bsms_studies`( `id` INT(11) NOT NULL AUTO_INCREMENT, `studydate` datetime default NULL, `teacher_id` INT(11) NULL default '1', `studynumber` VARCHAR(100) NULL default '', `booknumber` INT(3) NULL default '101', `chapter_begin` INT(3) NULL default '', `verse_begin` INT(3) NULL default '', `chapter_end` INT(3) NULL default '', `verse_end` INT(3) NULL default '', `studytitle` text NULL default '', `studyintro` text NULL default '', `messagetype` VARCHAR(100) NULL default '1', `series_id` INT(3) NULL default '', `topics_id` INT(3) NULL default '', `studytext` TEXT NULL default '', `media1_id` INT(11) NULL default '', `media1_server` VARCHAR(250) NULL default '', `media1_path` VARCHAR(250) NULL default '', `media1_special` VARCHAR(250) NULL default '_self', `media1_filename` TEXT NULL default '', `media1_show` TINYINT(1) NULL default '0', `media2_id` INT(11) NULL default '0', `media2_server` VARCHAR(250) NULL default '', `media2_path` VARCHAR(250) NULL default '', `media2_special` VARCHAR(250) NULL default '_self', `media2_filename` TEXT NULL default '', `media2_show` TINYINT(1) NULL default '0', `media3_id` INT(11) NULL default '0', `media3_server` VARCHAR(250) NULL default '', `media3_path` VARCHAR(250) NULL default '', `media3_special` VARCHAR(250) NULL default '_self', `media3_filename` TEXT NULL default '', `media3_show` TINYINT(1) NULL default '0', `media4_id` INT(11) NULL default '0', `media4_server` VARCHAR(250) NULL default '', `media4_path` VARCHAR(250) NULL default '', `media4_special` VARCHAR(250) NULL default '_self', `media4_filename` TEXT NULL default '', `media4_show` TINYINT(1) NULL default '0', `media5_id` INT(11) NULL default '0', `media5_server` VARCHAR(250) NULL default '', `media5_path` VARCHAR(250) NULL default '', `media5_special` VARCHAR(250) NULL default '_self', `media5_filename` TEXT NULL default '', `media5_show` TINYINT(1) NULL default '0', `media6_id` INT(11) NULL default '0', `media6_server` VARCHAR(250) NULL default '', `media6_path` VARCHAR(250) NULL default '', `media6_special` VARCHAR(250) NULL default '_self', `media6_filename` TEXT NULL default '', `media6_show` TINYINT(1) NULL default '0', `published` TINYINT(1) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`
SQL =
CREATE TABLE IF NOT EXISTS `jos_bsms_studies`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`studydate` datetime default NULL,
`teacher_id` INT(11) NULL default '1',
`studynumber` VARCHAR(100) NULL default '',
`booknumber` INT(3) NULL default '101',
`chapter_begin` INT(3) NULL default '',
`verse_begin` INT(3) NULL default '',
`chapter_end` INT(3) NULL default '',
`verse_end` INT(3) NULL default '',
`studytitle` text NULL default '',
`studyintro` text NULL default '',
`messagetype` VARCHAR(100) NULL default '1',
`series_id` INT(3) NULL default '',
`topics_id` INT(3) NULL default '',
`studytext` TEXT NULL default '',
`media1_id` INT(11) NULL default '',
`media1_server` VARCHAR(250) NULL default '',
`media1_path` VARCHAR(250) NULL default '',
`media1_special` VARCHAR(250) NULL default '_self',
`media1_filename` TEXT NULL default '',
`media1_show` TINYINT(1) NULL default '0',
`media2_id` INT(11) NULL default '0',
`media2_server` VARCHAR(250) NULL default '',
`media2_path` VARCHAR(250) NULL default '',
`media2_special` VARCHAR(250) NULL default '_self',
`media2_filename` TEXT NULL default '',
`media2_show` TINYINT(1) NULL default '0',
`media3_id` INT(11) NULL default '0',
`media3_server` VARCHAR(250) NULL default '',
`media3_path` VARCHAR(250) NULL default '',
`media3_special` VARCHAR(250) NULL default '_self',
`media3_filename` TEXT NULL default '',
`media3_show` TINYINT(1) NULL default '0',
`media4_id` INT(11) NULL default '0',
`media4_server` VARCHAR(250) NULL default '',
`media4_path` VARCHAR(250) NULL default '',
`media4_special` VARCHAR(250) NULL default '_self',
`media4_filename` TEXT NULL default '',
`media4_show` TINYINT(1) NULL default '0',
`media5_id` INT(11) NULL default '0',
`media5_server` VARCHAR(250) NULL default '',
`media5_path` VARCHAR(250) NULL default '',
`media5_special` VARCHAR(250) NULL default '_self',
`media5_filename` TEXT NULL default '',
`media5_show` TINYINT(1) NULL default '0',
`media6_id` INT(11) NULL default '0',
`media6_server` VARCHAR(250) NULL default '',
`media6_path` VARCHAR(250) NULL default '',
`media6_special` VARCHAR(250) NULL default '_self',
`media6_filename` TEXT NULL default '',
`media6_show` TINYINT(1) NULL default '0',
`published` TINYINT(1) NOT NULL default '1',
PRIMARY KEY (`id`) )
TYPE=MyISAM CHARACTER SET `utf8`
Reply Quote

Re:Installation Problem 27 Nov 2007 19:07 #3

  • Tom
  • OFFLINE
  • Administrator
  • Posts: 860
Rich: Thanks for the heads up. I'll look into this later today. Sometimes the nightly builds change some things that make other things break.

Tom
"You shall know the truth and the truth shall set you free." JC
Reply Quote

Re:Installation Problem 27 Nov 2007 22:33 #4

  • Tom
  • OFFLINE
  • Administrator
  • Posts: 860
Rich: Try the attached file. It contains the complete RC2 of the Bible Study component with an altered install.sql file.

It appears as if some versions of MySQL are more stringent than others. Let me know if this works. There were 7 instances where I used a default value of '' for an integer value where your version of MySQL may be looking for a number value like '0'.

I removed the default value hoping this resolves the problem.

Tom

Attachment biblestudy_RC2_SQLTest.zip not found

Attachments:
"You shall know the truth and the truth shall set you free." JC
Last Edit: 27 Nov 2007 22:38 by Tom.
Reply Quote

Re:Installation Problem 28 Nov 2007 08:56 #5

  • Rich.Simpson
Tom, That now works perfectly, thank you

Rich
Reply Quote

Re:Installation Problem 28 Nov 2007 10:20 #6

  • Rich.Simpson
Having got the component installed successfully - looks great by the way - loads of confguration options and modifications right from the back-end (my favourite feature has to be the ability to add more books to the bible )

I then moved on the module and search plug-in - however both generate nearly the same error again on installation:
for the plugin:
Fatal error: Call to undefined method JInstallerPlugin::_remove() in /htdocs/libraries/joomla/filter/filterinput.php on line 150

and for the module:
Fatal error: Call to undefined method JInstallerModule::_remove() in /htdocs/libraries/joomla/filter/filterinput.php on line 150

Hope you can help again.
Thanks
Rich
Reply Quote

Re:Installation Problem 28 Nov 2007 15:00 #7

  • Tom
  • OFFLINE
  • Administrator
  • Posts: 860
Rich: What build of Joomla! are you using?

I noticed the same problem cropping up in this forum post:
forum.joomla.org/index.php/topic,236233.0.html

They say that using build 9441 fixes the problem.

I'll try to install that version - or the latest on this test site and see if I can replicate the problem.

part of the difficulty is programming for a beta is that they keep changing it!

I'll incorporate the changes to the sql file into an RC3 release. I'm also going to make it so there are alternating background colors for each row of the studies list. Not all templates use the css style that already has color changes.

tom
"You shall know the truth and the truth shall set you free." JC
Reply Quote
Reply Topic
New Topic
BibleStudy
BibleStudy 6.0.x and older
Help Forum
Moderators: Darren Vandermyde, Kyle
Powered by Kunena  Protected by Spam Fighter
Time to create page: 0.72 seconds