Can anyone help please

This is the General Board for JoomLeague Questions!
Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Can anyone help please

Postby Mundo24 » Mon Jul 11, 2011 12:30 am

I cannot upload the new joomleague so i stick to 93.b but when i try to upload it, i get this message


JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 36 SQL=CREATE TABLE IF NOT EXISTS `jos_joomleague` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `league_id` int(11) NOT NULL default '0', `season_id` int(11) NOT NULL default '0', `joomleague_admin` int(11) NOT NULL default '0', `joomleague_editor` int(11) NOT NULL default '0', `master_template` int(11) NOT NULL default '0', `current_round` varchar(32) NOT NULL default '0', `current_round_auto` tinyint(4) NOT NULL default '0', `auto_time` INT(11) NULL default NULL, `project_type` ENUM( 'SIMPLE_LEAGUE', 'DIVISIONS_LEAGUE', 'SIMPLE_KO', 'TOURNAMENT_MODE' ) NOT NULL default 'SIMPLE_LEAGUE', `teams_as_referees` TINYINT(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `use_legs` tinyint(1) NULL default NULL, `fav_team` varchar(64) NOT NULL default '', `fav_team_color` varchar(7) NOT NULL default '', `game_regular_time` smallint(6) NOT NULL default '90', `game_parts` smallint(6) NOT NULL default '2', `halftime` smallint(6) NOT NULL default '15', `allow_add_time` tinyint(1) NOT NULL default '0', `add_time` smallint(6) NOT NULL default '30', `points_after_regular_time` varchar(10) NOT NULL default '3,1,0', `points_after_add_time` varchar(10) NOT NULL default '3,1,0', `points_after_penalty` varchar(10) NOT NULL default '2,1,1', `joomleague_tip` tinyint(4) NOT NULL default '0', `checked_out` int(11) default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `template` varchar(32) NOT NULL default 'default', `allmatch_order` tinyint(4) NOT NULL default '0', `serveroffset` varchar(6) NOT NULL default '0:00', `enable_sb` tinyint(4) NOT NULL default '0', `sb_catid` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `name, league, season` (`name` , `league_id` , `season_id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_joomleague` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`league_id` int(11) NOT NULL default '0',
`season_id` int(11) NOT NULL default '0',
`joomleague_admin` int(11) NOT NULL default '0',
`joomleague_editor` int(11) NOT NULL default '0',
`master_template` int(11) NOT NULL default '0',
`current_round` varchar(32) NOT NULL default '0',
`current_round_auto` tinyint(4) NOT NULL default '0',
`auto_time` INT(11) NULL default NULL,
`project_type` ENUM( 'SIMPLE_LEAGUE', 'DIVISIONS_LEAGUE', 'SIMPLE_KO', 'TOURNAMENT_MODE' ) NOT NULL default 'SIMPLE_LEAGUE',
`teams_as_referees` TINYINT(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`use_legs` tinyint(1) NULL default NULL,
`fav_team` varchar(64) NOT NULL default '',
`fav_team_color` varchar(7) NOT NULL default '',
`game_regular_time` smallint(6) NOT NULL default '90',
`game_parts` smallint(6) NOT NULL default '2',
`halftime` smallint(6) NOT NULL default '15',
`allow_add_time` tinyint(1) NOT NULL default '0',
`add_time` smallint(6) NOT NULL default '30',
`points_after_regular_time` varchar(10) NOT NULL default '3,1,0',
`points_after_add_time` varchar(10) NOT NULL default '3,1,0',
`points_after_penalty` varchar(10) NOT NULL default '2,1,1',
`joomleague_tip` tinyint(4) NOT NULL default '0',
`checked_out` int(11) default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`template` varchar(32) NOT NULL default 'default',
`allmatch_order` tinyint(4) NOT NULL default '0',
`serveroffset` varchar(6) NOT NULL default '0:00',
`enable_sb` tinyint(4) NOT NULL default '0',
`sb_catid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name, league, season` (`name` , `league_id` , `season_id`)
) TYPE=MyISAM;

Component Install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 36 SQL=CREATE TABLE IF NOT EXISTS `jos_joomleague` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `league_id` int(11) NOT NULL default '0', `season_id` int(11) NOT NULL default '0', `joomleague_admin` int(11) NOT NULL default '0', `joomleague_editor` int(11) NOT NULL default '0', `master_template` int(11) NOT NULL default '0', `current_round` varchar(32) NOT NULL default '0', `current_round_auto` tinyint(4) NOT NULL default '0', `auto_time` INT(11) NULL default NULL, `project_type` ENUM( 'SIMPLE_LEAGUE', 'DIVISIONS_LEAGUE', 'SIMPLE_KO', 'TOURNAMENT_MODE' ) NOT NULL default 'SIMPLE_LEAGUE', `teams_as_referees` TINYINT(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `use_legs` tinyint(1) NULL default NULL, `fav_team` varchar(64) NOT NULL default '', `fav_team_color` varchar(7) NOT NULL default '', `game_regular_time` smallint(6) NOT NULL default '90', `game_parts` smallint(6) NOT NULL default '2', `halftime` smallint(6) NOT NULL default '15', `allow_add_time` tinyint(1) NOT NULL default '0', `add_time` smallint(6) NOT NULL default '30', `points_after_regular_time` varchar(10) NOT NULL default '3,1,0', `points_after_add_time` varchar(10) NOT NULL default '3,1,0', `points_after_penalty` varchar(10) NOT NULL default '2,1,1', `joomleague_tip` tinyint(4) NOT NULL default '0', `checked_out` int(11) default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `template` varchar(32) NOT NULL default 'default', `allmatch_order` tinyint(4) NOT NULL default '0', `serveroffset` varchar(6) NOT NULL default '0:00', `enable_sb` tinyint(4) NOT NULL default '0', `sb_catid` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `name, league, season` (`name` , `league_id` , `season_id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_joomleague` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`league_id` int(11) NOT NULL default '0',
`season_id` int(11) NOT NULL default '0',
`joomleague_admin` int(11) NOT NULL default '0',
`joomleague_editor` int(11) NOT NULL default '0',
`master_template` int(11) NOT NULL default '0',
`current_round` varchar(32) NOT NULL default '0',
`current_round_auto` tinyint(4) NOT NULL default '0',
`auto_time` INT(11) NULL default NULL,
`project_type` ENUM( 'SIMPLE_LEAGUE', 'DIVISIONS_LEAGUE', 'SIMPLE_KO', 'TOURNAMENT_MODE' ) NOT NULL default 'SIMPLE_LEAGUE',
`teams_as_referees` TINYINT(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`use_legs` tinyint(1) NULL default NULL,
`fav_team` varchar(64) NOT NULL default '',
`fav_team_color` varchar(7) NOT NULL default '',
`game_regular_time` smallint(6) NOT NULL default '90',
`game_parts` smallint(6) NOT NULL default '2',
`halftime` smallint(6) NOT NULL default '15',
`allow_add_time` tinyint(1) NOT NULL default '0',
`add_time` smallint(6) NOT NULL default '30',
`points_after_regular_time` varchar(10) NOT NULL default '3,1,0',
`points_after_add_time` varchar(10) NOT NULL default '3,1,0',
`points_after_penalty` varchar(10) NOT NULL default '2,1,1',
`joomleague_tip` tinyint(4) NOT NULL default '0',
`checked_out` int(11) default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`template` varchar(32) NOT NULL default 'default',
`allmatch_order` tinyint(4) NOT NULL default '0',
`serveroffset` varchar(6) NOT NULL default '0:00',
`enable_sb` tinyint(4) NOT NULL default '0',
`sb_catid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name, league, season` (`name` , `league_id` , `season_id`)
) TYPE=MyISAM;


Can anyone help please
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Can anyone help please

Postby timoline » Mon Jul 11, 2011 9:50 am

do not install joomleague 1.5.2 over 0.93...just create a NEW install
Joomla 1.5.x
Joomleague 1.5.....latest git version

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Mon Jul 11, 2011 4:22 pm

Hi

I'm trying to install 0.93 again but it comes up with all that again.

Anymore help you could give.
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Can anyone help please

Postby timoline » Mon Jul 11, 2011 8:43 pm

restore your backup
Joomla 1.5.x
Joomleague 1.5.....latest git version

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Mon Jul 11, 2011 9:15 pm

another question (sorry for them) how do i do that.
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Can anyone help please

Postby timoline » Mon Jul 11, 2011 9:36 pm

sorry dont know how to help you futher....(no time) :confused:
you dont know how to backup or restore....you are the web(master), arent you?
Maybe you didnt tell the whole story, please describe all steps how did you try to upgrade from jl0.93 to jl1.5
Joomla 1.5.x
Joomleague 1.5.....latest git version

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Mon Jul 11, 2011 9:44 pm

HI

I have try to set up joomleague 0.93b on a different website which is new and got the same message.

It was a new database.

Could there be a problem with the version of joomleague which you have on your download bit of the website.
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Can anyone help please

Postby timoline » Mon Jul 11, 2011 9:50 pm

and if you try to install jl1.5 with a new db its the same?
Joomla 1.5.x
Joomleague 1.5.....latest git version

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Mon Jul 11, 2011 9:52 pm

i dont even know where to start to upload 1.5 that is why i like 0.93 but i get that big message everytime.

Why cant u make 1.5 as easy (well use to be easy lol) to upload as 0.93
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Can anyone help please

Postby timoline » Tue Jul 12, 2011 5:37 am

dont blame us ...;)
I installed 1.5 about 1000 of times, and +10000 of users installed 1.5 succesfully....
Joomla 1.5.x
Joomleague 1.5.....latest git version

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Tue Jul 12, 2011 4:24 pm

Im not blaming you lol :gelb:

It would of been nice for it to be in a zip file so not so tech people like myself could install it.
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

Mundo24
Newbie
Posts: 7
Joined: Sat Apr 02, 2011 8:17 pm

Re: Can anyone help please

Postby Mundo24 » Tue Jul 12, 2011 4:59 pm

I have tried to install 1.5 through Extension Manager on joomla and all it says is Unable to find install package.
www.fifalife.ulmb.com
Joomla 1.50
Joomleague 93.b

User avatar
kubik
.
Posts: 618
Joined: Tue Nov 03, 2009 7:20 pm
Joomleague version: 2.0.x
Location: Oberschlesien
Contact:

Re: Can anyone help please

Postby kubik » Wed Jul 13, 2011 4:53 pm

Mundo24 wrote:I have tried to install 1.5 through Extension Manager on joomla and all it says is Unable to find install package.

Cause you have shite zip pack, maybe its not joomleague? :confused:
Joomla 2.5.x & 3.x
JoomLeague - Latest Git Version
GG Network No : 5739578
www.RegioLiga.pl


Return to “JoomLeague Component, Version <= 0.93b”

Who is online

Users browsing this forum: No registered users and 2 guests

cron