Joomla Module Install SQL Error

Status
Not open for further replies.
3

348webmaster44

New Member
Messages
2
Reaction score
0
Points
0
Hello, ive been trying to install modules and content into my joomla site but keep getting an error about not being able to connect to the sql server. Also some modules will install but do not display prooperley. I've been onto the C-pannel and checked for error and repair the databases but no luck.
 
xav0989

xav0989

Community Public Relation
Community Support
Messages
4,467
Reaction score
95
Points
0
What is the exact error shown?
 
3

348webmaster44

New Member
Messages
2
Reaction score
0
Points
0
JInstaller::install: SQL Error. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_joomgallery` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `alias` varchar(255) NOT NULL default '', `imgauthor` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` datetime NOT NULL, `hits` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `access` tinyint(3) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `imgfilename` varchar(100) NOT NULL default '', `imgthumbname` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `owner` int(11) UNSIGNED NOT NULL default '0', `approved` tinyint(1) NOT NULL default '0', `useruploaded` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, PRIMARY KEY (`id`), INDEX idx_catid (`catid`), INDEX idx_owner (`owner`) ) ENGINE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_joomgallery` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`alias` varchar(255) NOT NULL default '',
`imgauthor` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` datetime NOT NULL,
`hits` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`imgfilename` varchar(100) NOT NULL default '',
`imgthumbname` varchar(100) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`owner` int(11) UNSIGNED NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '0',
`useruploaded` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
PRIMARY KEY (`id`),
INDEX idx_catid (`catid`),
INDEX idx_owner (`owner`)
) ENGINE=MyISAM;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_joomgallery` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `alias` varchar(255) NOT NULL default '', `imgauthor` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` datetime NOT NULL, `hits` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `access` tinyint(3) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `imgfilename` varchar(100) NOT NULL default '', `imgthumbname` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `owner` int(11) UNSIGNED NOT NULL default '0', `approved` tinyint(1) NOT NULL default '0', `useruploaded` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, PRIMARY KEY (`id`), INDEX idx_catid (`catid`), INDEX idx_owner (`owner`) ) ENGINE=MyISAM;
SQL = CREATE TABLE IF NOT EXISTS `jos_joomgallery` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`alias` varchar(255) NOT NULL default '',
`imgauthor` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` datetime NOT NULL,
`hits` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`imgfilename` varchar(100) NOT NULL default '',
`imgthumbname` varchar(100) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`owner` int(11) UNSIGNED NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '0',
`useruploaded` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
PRIMARY KEY (`id`),
INDEX idx_catid (`catid`),
INDEX idx_owner (`owner`)
) ENGINE=MyISAM;
Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering
 
Status
Not open for further replies.
Top