sql errors

[kabflash]

I have been trying to install components on my new Joomla installation and keep getting the following error...

• JInstaller::install: SQL Error. DB function failed with error number 2013
  Lost connection to MySQL server during query SQL=CREATE TABLE `jos_lgsl` ( `id` INT (11) NOT NULL auto_increment, `type` VARCHAR (50) NOT NULL DEFAULT '', `ip` VARCHAR (255) NOT NULL DEFAULT '', `c_port` VARCHAR (5) NOT NULL DEFAULT '0', `q_port` VARCHAR (5) NOT NULL DEFAULT '0', `s_port` VARCHAR (5) NOT NULL DEFAULT '0', `zone` VARCHAR (255) NOT NULL DEFAULT '0', `disabled` TINYINT (1) NOT NULL DEFAULT '0', `comment` VARCHAR (255) NOT NULL DEFAULT '', `status` TINYINT (1) NOT NULL DEFAULT '0', `cache` TEXT NOT NULL, `cache_time` TEXT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
  SQL = CREATE TABLE `jos_lgsl` (
  
  `id` INT (11) NOT NULL auto_increment,
  `type` VARCHAR (50) NOT NULL DEFAULT '',
  `ip` VARCHAR (255) NOT NULL DEFAULT '',
  `c_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `q_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `s_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `zone` VARCHAR (255) NOT NULL DEFAULT '0',
  `disabled` TINYINT (1) NOT NULL DEFAULT '0',
  `comment` VARCHAR (255) NOT NULL DEFAULT '',
  `status` TINYINT (1) NOT NULL DEFAULT '0',
  `cache` TEXT NOT NULL,
  `cache_time` TEXT NOT NULL,
  
  PRIMARY KEY (`id`)
  
  ) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
• 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 `jos_lgsl` ( `id` INT (11) NOT NULL auto_increment, `type` VARCHAR (50) NOT NULL DEFAULT '', `ip` VARCHAR (255) NOT NULL DEFAULT '', `c_port` VARCHAR (5) NOT NULL DEFAULT '0', `q_port` VARCHAR (5) NOT NULL DEFAULT '0', `s_port` VARCHAR (5) NOT NULL DEFAULT '0', `zone` VARCHAR (255) NOT NULL DEFAULT '0', `disabled` TINYINT (1) NOT NULL DEFAULT '0', `comment` VARCHAR (255) NOT NULL DEFAULT '', `status` TINYINT (1) NOT NULL DEFAULT '0', `cache` TEXT NOT NULL, `cache_time` TEXT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
  SQL = CREATE TABLE `jos_lgsl` (
  
  `id` INT (11) NOT NULL auto_increment,
  `type` VARCHAR (50) NOT NULL DEFAULT '',
  `ip` VARCHAR (255) NOT NULL DEFAULT '',
  `c_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `q_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `s_port` VARCHAR (5) NOT NULL DEFAULT '0',
  `zone` VARCHAR (255) NOT NULL DEFAULT '0',
  `disabled` TINYINT (1) NOT NULL DEFAULT '0',
  `comment` VARCHAR (255) NOT NULL DEFAULT '',
  `status` TINYINT (1) NOT NULL DEFAULT '0',
  `cache` TEXT NOT NULL,
  `cache_time` TEXT NOT NULL,
  
  PRIMARY KEY (`id`)
  
  ) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
• 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

After about 5-10 tries on each one I got most of my components to go through, but on this last one I've tried at least 20 times and it just keeps erroring... I see numerous threads about this with no answer and if I search I see hundreds of them also not answered....

Please help me?? My site is kinda pointless without these extensions...

---------- Post added at 01:54 PM ---------- Previous post was at 12:14 PM ----------

Update to problem. I managed to get the component installed by doing it manually. Now my next problem is it won't work because I think the port I'm trying to query is blocked.

Is it possible to get port 28970 unblocked for my site? This is for a game server status module. Just displays whether my game server is online, who's playing, the map etc..

Right now I'm hosting the feed for it locally(so its temporarily working), but this cannot be a permanent solution for me.


FORGOT to mention I only need it opened for UDP.

 

[stpvoice]

Hello,

I highly doubt that a port can be unblocked for you. If it is blocked, it is likely because of abuse, or to prevent it. Also, that port is around several used commonly by games, and unfortunately the demands of gaming sites often cannot be provided on free hosting. If you need more personalised options, I'd look into premium or a VPS.
http://x10premium.com/
http://x10vps.com/

 

[kabflash]

Hello,

I highly doubt that a port can be unblocked for you. If it is blocked, it is likely because of abuse, or to prevent it. Also, that port is around several used commonly by games, and unfortunately the demands of gaming sites often cannot be provided on free hosting. If you need more personalised options, I'd look into premium or a VPS.
http://x10premium.com/
http://x10vps.com/

I only need UDP opened, I don't see how that could contribute to abuse, although I don't know a lot about that nature of it. My gaming site does NOT have high demands it's a small COD server and my site will have less then 50 unique visitors. My gameserver IS hosted on a paid VPS I just got this hosting to keep my website (mainly forum) separate from it. At any rate, if it could be blocked, awesome.. If not well I'll figure something else out..

If it won't be unblocked on free hosting, would it be if I got premium?

 

[stpvoice]

I'll speak to an admin about this and get back to you.

 

[stpvoice]

Hello again,

I've been speaking to one of our admins. Ports cannot be opened on free, however it can be considered if you move to premium.