Installation Error

All Installation / Update / Upgrade Issues here.
Posts: 28
Joined: Thu Aug 30, 2012 5:26 pm

Installation Error

Postby Private6 » Thu Aug 29, 2013 10:41 pm


I tried installing it on Joomla 3.1.5 2 times and on 2 different websites and always get this

 0 SQL=ALTER TABLE ls_joomleague_version ADD `major` INT NOT NULL , ADD `minor` INT NOT NULL , ADD `build` INT NOT NULL , ADD `count` INT NOT NULL , ADD `revision` VARCHAR(128) NOT NULL , ADD `file` VARCHAR(255) NOT NULL

Can you please help me because I loved the 1.6 version but need the new one now.



User avatar
Atletic Rodenc
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter

Re: Installation Error

Postby Atletic Rodenc » Fri Aug 30, 2013 10:15 am

Hi !

JoomLeague it's not compatible with Joomla 3.x .. In that moment it's only for Joomla 2.5.x

User avatar
Posts: 312
Joined: Tue Aug 27, 2013 11:26 am
Joomleague version: 2.0.x
Location: Friesland, Netherlands

Re: Installation Error

Postby Bluefox » Mon Sep 02, 2013 9:51 am


This post seems a double post..

did respond to the other one and this was the text:


i'm no that familiair with JL so just guessing.

as you probably read: Joomleague is not compatible with J3+ at this moment.
Mainly due to a different template (isis), deprecated code, bootstrap.
But another thing is the strict query's and the minimal error reporting

- do you know the line + file the error is poiting to?
it seems to be the file admin\assets\updates\jl_install.php
- did you succeed with the install?
- was it with an update?

It seems that the function is checking the table "joomleague_version" and if it can't find the field major
it's running a query to add some columns/fields. So to circumvent that issue you can add the fields manually.

This is the code in that file. As you can see it's adding the columns: major, minor, build,count,revision,file

Code: Select all

function _checkVersionTable()
   $db = JFactory::getDbo();

   $res = $db->getTableFields('#__joomleague_version');
   $cols = array_keys(reset($res));

   if (!in_array('major', $cols))
      $query = ' ALTER TABLE #__joomleague_version ADD `major` INT NOT NULL ,
            ADD `minor` INT NOT NULL ,
            ADD `build` INT NOT NULL ,
            ADD `count` INT NOT NULL ,
            ADD `revision` VARCHAR(128) NOT NULL ,
            ADD `file` VARCHAR(255) NOT NULL';
      if (!$db->query()) {
         echo JText::_('Failed updating version table');

think it would be nice that people who made it running with J3 will share their experience.
Help can be asked in the forum

Return to “Installation / Update”

Who is online

Users browsing this forum: No registered users and 2 guests