0
Welcome Guest! Login
0 items Join Now

Is Rockettheme compatible with MSSQL?

  • Is Rockettheme compatible with MSSQL?

    Posted 12 years 3 months ago
    • I have been having all lkinds of issues trying to get Rockettheme templates and components to work with my Joomla installation using WIndows and MSSQL. From what I see from other forums it seems that Rockettheme templates may not work with MSSQL database. Is this true?

      For example: loading missioncontrol component to my Joomla (2.5. 8) site I get the following errors:



      500 - An error has occurred.
      JDatabaseDriverSQLAzure::query: 42000 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '`'.SQL=SELECT `id` FROM `nsq4u_modules` WHERE module = N'mod_rokquicklinks'

      Return to Control Panel

      Call stack
      # Function Location
      1 JAdministrator->dispatch() C:\inetpub\wwwroot\joomla2\administrator\index.php:46
      2 JComponentHelper::renderComponent() C:\inetpub\wwwroot\joomla2\administrator\includes\application.php:153
      3 JComponentHelper::executeComponent() C:\inetpub\wwwroot\joomla2\libraries\joomla\application\component\helper.php:351
      4 require_once() C:\inetpub\wwwroot\joomla2\libraries\joomla\application\component\helper.php:383
      5 JController->execute() C:\inetpub\wwwroot\joomla2\administrator\components\com_installer\installer.php:18
      6 InstallerControllerInstall->install() C:\inetpub\wwwroot\joomla2\libraries\joomla\application\component\controller.php:761
      7 InstallerModelInstall->install() C:\inetpub\wwwroot\joomla2\administrator\components\com_installer\controllers\install.php:29
      8 JInstaller->install() C:\inetpub\wwwroot\joomla2\administrator\components\com_installer\models\install.php:105
      9 JInstallerPlugin->install() C:\inetpub\wwwroot\joomla2\libraries\joomla\installer\installer.php:472
      10 PlgSystemInstallerInstallerScript->install() C:\inetpub\wwwroot\joomla2\libraries\joomla\installer\adapters\plugin.php:463
      11 RokInstaller->install() C:\inetpub\wwwroot\joomla2\tmp\install_50fd5fa8f2029\install.script.php:98
      12 RokInstallerModule->postInstall() C:\inetpub\wwwroot\joomla2\tmp\install_50fd5fa8f2029\installer\RokInstaller.php:148
      13 RokInstallerModule->removeInstances() C:\inetpub\wwwroot\joomla2\tmp\install_50fd5fa8f2029\installer\adapters\module.php:171
      14 JDatabase->loadResultArray() C:\inetpub\wwwroot\joomla2\tmp\install_50fd5fa8f2029\installer\adapters\module.php:200
      15 JDatabase->loadColumn() C:\inetpub\wwwroot\joomla2\libraries\joomla\database\database.php:1842
      16 JDatabaseSQLSrv->execute() C:\inetpub\wwwroot\joomla2\libraries\joomla\database\database.php:965
      17 JError::raiseError() C:\inetpub\wwwroot\joomla2\libraries\joomla\database\database\sqlsrv.php:695
      18 JError::raise() C:\inetpub\wwwroot\joomla2\libraries\joomla\error\error.php:251
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: Is Rockettheme compatible with MSSQL?

    Posted 12 years 3 months ago
    • We don't provide MS SQL Server support. Gantry will be looking at it in the future probably with the Gantry 5 rev planned for later this year. But right now we just don't support it.
    • Check my services at: Mihha-Vision

Time to create page: 0.062 seconds