Error while installing JooBB 0.7.4
Hello,
When I install JooBB 0.7.4 I do see a error:
Quote by Unknown:
* JInstaller::install: SQL fout. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `ordering` (`ordering`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `ordering` (`ordering`)
) TYPE=MyISAM CHARACTER SET `utf8`;
* component Installeer: SQL fout of SQLbestand ontbreekt of is niet leesbaar. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `ordering` (`ordering`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `ordering` (`ordering`)
) TYPE=MyISAM CHARACTER SET `utf8`;
My database prefix is avmp_ , by the most of you it should be jos_.
I have first install the plug-in without problems.
Does anyone know how I should install Joobb 0.7.4.
Sorry for my bat English.
Greets,
PCIO
Re: Error while installing JooBB 0.7.4
Hi pcio,
it seems to be a problem of mysql. Which version do you use?
I guess, it could be a sql timeout response limit problem!
What you can try is to unzip com_joobb_0.7.4.zip and edit "install.joobb.sql". Than run the sql on your database. Do not forget to rename all "#__" to "avmp_"!!!
If this works, you can try to install again. The sql should be now faster because the DB is now set up.
Kind regards,
Robbie
Re: Error while installing JooBB 0.7.4
Hi Robbie,
I have manually install the sql script. Before i have edit all #__ to avmp_ . Install the sql finished succesfol.
But when i tried to install Joo!BB component i do have the same error as before.
I have my language set on English so you can read the error in English:
Quote by Unknown:
* JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `ordering` (`ordering`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `ordering` (`ordering`)
) 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 `avmp_joobb_categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `ordering` (`ordering`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `avmp_joobb_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`published` tinyint(1) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `ordering` (`ordering`)
) TYPE=MyISAM CHARACTER SET `utf8`;
My MYSQL version is: 5.0.51a
I'm looking forward to your next reaction,
greets,
PCIO
Re: Error while installing JooBB 0.7.4
Hi pcio
I had a similar problem with some components (ie joomfish, joomlapack etc). By accident I found the solution which is pretty easy.
Switch off the ftp-layer (I think thats the correct name) in you joomla configuration. Afterwards it should work and you can upload and install the extension.
Hope it helps.
Maultrommel
Re: Error while installing JooBB 0.7.4
Hi Maultrommel,
Thanks for your answer.
But I couldn't find the ftp-layer configuration file in Joomla. could you make a screen shot or something so i can see where I can find the ftp-layer.
I use joomla 1.5.7
Pcio
Re: Error while installing JooBB 0.7.4
Hey, pcio...
The FTP-Layer configuration stuff is located in your global configuration. In your dropdown menu, click Site > Global Configuration.
Once that loads, there are three links above the configuration options. The third is 'Server'. The FTP layer config is located there. Click the 'off' radio button and save.
Hope that helps!
Nomnom
Re: Error while installing JooBB 0.7.4
Thanks everyone,
I have Joo!BB Community successfully installed.
I know it's my hosting service but...
I'm having similar issues, but updating the sql file manually didn't help (and turning off the ftp layer didn't either). The install package still times out. I even tried uploading to my server and installing from there, but no go.
I know this is because I'm on shared hosting at GoDaddy, so it's not really an issue with Joo!BB, but is there a way to strip down the install package, so it doesn't even go through the motions of trying to create the sql tables?
I know the simple answer is switch hosts, but it's not really a practical solution at this point.
EDIT:Scratch that. I managed to get this to work by uploading the entire package to the server in a folder that didn't have a period in it. I think the transfer was corrupting files. Installed from there and everything worked.
Thanks,
Perry
