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 errors
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: installation errors

installation errors 20 Apr 2008 22:37 #84

  • frazier500
I keep getting this error on install:

Notice: Only variable references should be returned by reference in /home/tedfrazi/public_html/libraries/joomla/application/module/helper.php on line 281

Notice: Trying to get property of non-object in /home/tedfrazi/public_html/libraries/joomla/application/module/helper.php on line 86

then it says:



* JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away 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, `verse_begin` INT(3) NULL, `chapter_end` INT(3) NULL, `verse_end` INT(3) NULL, `studytitle` text NULL default '', `studyintro` text NULL default '', `messagetype` VARCHAR(100) NULL default '1', `series_id` INT(3) NULL, `topics_id` INT(3) NULL, `studytext` TEXT NULL default '', `media1_id` INT(11) NULL, `media1_server` VARCHAR(250) NULL, `media1_path` VARCHAR(250) NULL, `media1_special` VARCHAR(250) NULL, `media1_filename` TEXT NULL, `media1_size` TEXT NULL, `media1_show` TINYINT(1) NULL default '0', `media2_id` INT(11) NULL default '0', `media2_server` VARCHAR(250) NULL, `media2_path` VARCHAR(250) NULL, `media2_special` VARCHAR(250) NULL, `media2_filename` TEXT NULL, `media2_size` TEXT NULL, `media2_show` TINYINT(1) NULL default '0', `media3_id` INT(11) NULL, `media3_server` VARCHAR(250) NULL, `media3_path` VARCHAR(250) NULL, `media3_special` VARCHAR(250) NULL, `media3_filename` TEXT NULL, `media3_size` TEXT NULL, `media3_show` TINYINT(1) NULL default '0', `media4_id` INT(11) NULL, `media4_server` VARCHAR(250) NULL, `media4_path` VARCHAR(250) NULL, `media4_special` VARCHAR(250) NULL, `media4_filename` TEXT NULL, `media4_size` TEXT NULL, `media4_show` TINYINT(1) NULL default '0', `media5_id` INT(11) NULL, `media5_server` VARCHAR(250) NULL, `media5_path` VARCHAR(250) NULL, `media5_special` VARCHAR(250) NULL, `media5_filename` TEXT NULL, `media5_size` TEXT NULL, `media5_show` TINYINT(1) NULL default '0', `media6_id` INT(11) NULL, `media6_server` VARCHAR(250) NULL, `media6_path` VARCHAR(250) NULL, `media6_special` VARCHAR(250) NULL, `media6_filename` TEXT NULL, `media6_size` TEXT NULL, `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,
`verse_begin` INT(3) NULL,
`chapter_end` INT(3) NULL,
`verse_end` INT(3) NULL,
`studytitle` text NULL default '',
`studyintro` text NULL default '',
`messagetype` VARCHAR(100) NULL default '1',
`series_id` INT(3) NULL,
`topics_id` INT(3) NULL,
`studytext` TEXT NULL default '',
`media1_id` INT(11) NULL,
`media1_server` VARCHAR(250) NULL,
`media1_path` VARCHAR(250) NULL,
`media1_special` VARCHAR(250) NULL,
`media1_filename` TEXT NULL,
`media1_size` TEXT NULL,
`media1_show` TINYINT(1) NULL default '0',
`media2_id` INT(11) NULL default '0',
`media2_server` VARCHAR(250) NULL,
`media2_path` VARCHAR(250) NULL,
`media2_special` VARCHAR(250) NULL,
`media2_filename` TEXT NULL,
`media2_size` TEXT NULL,
`media2_show` TINYINT(1) NULL default '0',
`media3_id` INT(11) NULL,
`media3_server` VARCHAR(250) NULL,
`media3_path` VARCHAR(250) NULL,
`media3_special` VARCHAR(250) NULL,
`media3_filename` TEXT NULL,
`media3_size` TEXT NULL,
`media3_show` TINYINT(1) NULL default '0',
`media4_id` INT(11) NULL,
`media4_server` VARCHAR(250) NULL,
`media4_path` VARCHAR(250) NULL,
`media4_special` VARCHAR(250) NULL,
`media4_filename` TEXT NULL,
`media4_size` TEXT NULL,
`media4_show` TINYINT(1) NULL default '0',
`media5_id` INT(11) NULL,
`media5_server` VARCHAR(250) NULL,
`media5_path` VARCHAR(250) NULL,
`media5_special` VARCHAR(250) NULL,
`media5_filename` TEXT NULL,
`media5_size` TEXT NULL,
`media5_show` TINYINT(1) NULL default '0',
`media6_id` INT(11) NULL,
`media6_server` VARCHAR(250) NULL,
`media6_path` VARCHAR(250) NULL,
`media6_special` VARCHAR(250) NULL,
`media6_filename` TEXT NULL,
`media6_size` TEXT NULL,
`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 2006
MySQL server has gone away 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, `verse_begin` INT(3) NULL, `chapter_end` INT(3) NULL, `verse_end` INT(3) NULL, `studytitle` text NULL default '', `studyintro` text NULL default '', `messagetype` VARCHAR(100) NULL default '1', `series_id` INT(3) NULL, `topics_id` INT(3) NULL, `studytext` TEXT NULL default '', `media1_id` INT(11) NULL, `media1_server` VARCHAR(250) NULL, `media1_path` VARCHAR(250) NULL, `media1_special` VARCHAR(250) NULL, `media1_filename` TEXT NULL, `media1_size` TEXT NULL, `media1_show` TINYINT(1) NULL default '0', `media2_id` INT(11) NULL default '0', `media2_server` VARCHAR(250) NULL, `media2_path` VARCHAR(250) NULL, `media2_special` VARCHAR(250) NULL, `media2_filename` TEXT NULL, `media2_size` TEXT NULL, `media2_show` TINYINT(1) NULL default '0', `media3_id` INT(11) NULL, `media3_server` VARCHAR(250) NULL, `media3_path` VARCHAR(250) NULL, `media3_special` VARCHAR(250) NULL, `media3_filename` TEXT NULL, `media3_size` TEXT NULL, `media3_show` TINYINT(1) NULL default '0', `media4_id` INT(11) NULL, `media4_server` VARCHAR(250) NULL, `media4_path` VARCHAR(250) NULL, `media4_special` VARCHAR(250) NULL, `media4_filename` TEXT NULL, `media4_size` TEXT NULL, `media4_show` TINYINT(1) NULL default '0', `media5_id` INT(11) NULL, `media5_server` VARCHAR(250) NULL, `media5_path` VARCHAR(250) NULL, `media5_special` VARCHAR(250) NULL, `media5_filename` TEXT NULL, `media5_size` TEXT NULL, `media5_show` TINYINT(1) NULL default '0', `media6_id` INT(11) NULL, `media6_server` VARCHAR(250) NULL, `media6_path` VARCHAR(250) NULL, `media6_special` VARCHAR(250) NULL, `media6_filename` TEXT NULL, `media6_size` TEXT NULL, `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,
`verse_begin` INT(3) NULL,
`chapter_end` INT(3) NULL,
`verse_end` INT(3) NULL,
`studytitle` text NULL default '',
`studyintro` text NULL default '',
`messagetype` VARCHAR(100) NULL default '1',
`series_id` INT(3) NULL,
`topics_id` INT(3) NULL,
`studytext` TEXT NULL default '',
`media1_id` INT(11) NULL,
`media1_server` VARCHAR(250) NULL,
`media1_path` VARCHAR(250) NULL,
`media1_special` VARCHAR(250) NULL,
`media1_filename` TEXT NULL,
`media1_size` TEXT NULL,
`media1_show` TINYINT(1) NULL default '0',
`media2_id` INT(11) NULL default '0',
`media2_server` VARCHAR(250) NULL,
`media2_path` VARCHAR(250) NULL,
`media2_special` VARCHAR(250) NULL,
`media2_filename` TEXT NULL,
`media2_size` TEXT NULL,
`media2_show` TINYINT(1) NULL default '0',
`media3_id` INT(11) NULL,
`media3_server` VARCHAR(250) NULL,
`media3_path` VARCHAR(250) NULL,
`media3_special` VARCHAR(250) NULL,
`media3_filename` TEXT NULL,
`media3_size` TEXT NULL,
`media3_show` TINYINT(1) NULL default '0',
`media4_id` INT(11) NULL,
`media4_server` VARCHAR(250) NULL,
`media4_path` VARCHAR(250) NULL,
`media4_special` VARCHAR(250) NULL,
`media4_filename` TEXT NULL,
`media4_size` TEXT NULL,
`media4_show` TINYINT(1) NULL default '0',
`media5_id` INT(11) NULL,
`media5_server` VARCHAR(250) NULL,
`media5_path` VARCHAR(250) NULL,
`media5_special` VARCHAR(250) NULL,
`media5_filename` TEXT NULL,
`media5_size` TEXT NULL,
`media5_show` TINYINT(1) NULL default '0',
`media6_id` INT(11) NULL,
`media6_server` VARCHAR(250) NULL,
`media6_path` VARCHAR(250) NULL,
`media6_special` VARCHAR(250) NULL,
`media6_filename` TEXT NULL,
`media6_size` TEXT NULL,
`media6_show` TINYINT(1) NULL default '0',
`published` TINYINT(1) NOT NULL default '1',
PRIMARY KEY (`id`) )
TYPE=MyISAM CHARACTER SET `utf8`;

Message

My hosting company says that max_allowed_packet is set to 30MB and the query timeout is set to 40 seconds. Is that the problem or there another reason for this error. I am able to install other components, but this is the largest one I've tried.
Reply Quote

Re:installation errors 17 Jun 2008 11:52 #128

  • Tom
  • OFFLINE
  • Administrator
  • Posts: 860
have you had any success in re-installing?
"You shall know the truth and the truth shall set you free." JC
Reply Quote

Re:installation errors 17 Jun 2008 15:42 #131

  • Tom
  • OFFLINE
  • Administrator
  • Posts: 860
Just bumping this message.
"You shall know the truth and the truth shall set you free." JC
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
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.65 seconds