Install process

[cristianounix]

RuntimeException Object ( [message:protected] => SQL=SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1 [string:Exception:private] => [code:protected] => 0 [file:protected] => /www/cobaltcrm.com.br/libraries/joomla/database/driver/mysql.php [line:protected] => 309 [trace:Exception:private] => Array ( [0] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/database/driver.php [line] => 975 [function] => execute [class] => JDatabaseDriverMysql [type] => -> [args] => Array ( ) ) [1] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/access/access.php [line] => 334 [function] => loadColumn [class] => JDatabaseDriver [type] => -> [args] => Array ( ) ) [2] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/access/access.php [line] => 403 [function] => getGroupsByUser [class] => JAccess [type] => :: [args] => Array ( [0] => 0 ) ) [3] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/user/user.php [line] => 411 [function] => getAuthorisedViewLevels [class] => JAccess [type] => :: [args] => Array ( [0] => 0 ) ) [4] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/plugin/helper.php [line] => 263 [function] => getAuthorisedViewLevels [class] => JUser [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /www/cobaltcrm.com.br/libraries/joomla/plugin/helper.php [line] => 163 [function] => _load [class] => JPluginHelper [type] => :: [args] => Array ( ) ) [6] => Array ( [file] => /www/cobaltcrm.com.br/includes/application.php [line] => 75 [function] => importPlugin [class] => JPluginHelper [type] => :: [args] => Array ( [0] => system ) ) [7] => Array ( [file] => /www/cobaltcrm.com.br/index.php [line] => 49 [function] => route [class] => Cobalt [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => [xdebug_message] => ( ! ) RuntimeException: SQL=SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1 in /www/cobaltcrm.com.br/libraries/joomla/database/driver/mysql.php on line 309 Call Stack #TimeMemoryFunctionLocation 10.0006375456{main}( )../index.php:0 20.05562925536Cobalt->route( )../index.php:49 30.08313245664JPluginHelper::importPlugin( )../application.php:75 40.08323245824JPluginHelper::_load( )../helper.php:163 50.08613497608JUser->getAuthorisedViewLevels( )../helper.php:263 60.08733622024JAccess::getAuthorisedViewLevels( )../user.php:411 70.08733622024JAccess::getGroupsByUser( )../access.php:403 80.09784444760JDatabaseDriver->loadColumn( )../access.php:334 90.10884450848JDatabaseDriverMysql->execute( )../driver.php:975 )

[scriptonomy]

I am getting the same error...

[cristianounix]

@scriptonomy you are using mac, linux or windows ? I'm using mac.

[scriptonomy]

Linux CentOS 6

[cristianounix]

You can solve this problem? I can't !

[raviufor]

I found a solution. After installation find configuration.php file (this file will appear only after instalation) Opend with any editor and change

public $error_reporting = 'maximum';

to

 public $error_reporting = 'minimum';

This will solve it for sure.

I tried it.

The developer needs to change it.

[cristianounix]

I will test it !
But all the errors exist, but do not show ok?

[mayckxavier]

It still with errors.
What database are you trying? I've tried with MySql and could not mate it works.

[cristianounix]

Not Work...
I am using mysql !

[davidhurley]

Hi all!

I think the problem exists here:

SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft 
AND b.rgt >= a.rgt WHERE a.id = 1

Can you check your database directly and see what tables have been installed and what data exists in the #__usergroups table?

[cristianounix]

Query return:
Table 'jos_usergroups' doesn't exist.

[mayckxavier]

I could install defining a prefix in installation, but I found some errors while I was testing it. =/

[scriptonomy]

The application defaults to a table prefix of jos_ That's where the db access error is coming from. However, upon adding a prefix of jos_ to all the tables in the database the application runs but object instantiation errors abound. So back to square one, but at least one problem is out of the way.