Install under Joomla 3 failed

[creactiv]

It says: 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 'SET =1 WHERE ='otrsgateway' AND ='plugin'' at line 1 SQL=UPDATE SET =1 WHERE ='otrsgateway' AND ='plugin'

Any idea how to fix that? I am looking into the combination of OTRS and Joomla; and i am really excited about this combination, since other tools also can be connected to Joomla. So this really would make sense for me. Nevertheless, will you be able to update the connectors to more recent otrs and joomla versions?

Thanks for your work :-)

PS: MySQL Version is 5.1.73, PHP is 5.3.2

[lbourne43]

Hi creactiv

Thanks for your interest. Sorry, we don't have support for Joomla 3 yet but this is something that we plan to add in the future.

Regards
Lewis

[creactiv]

Well, do you have a time Frame? And could you perhaps assist how to fix that MySQL Problem?
Thank you for your quick reply.
Best

[lbourne43]

We don't have a time frame yet but we are happy to assist you with any problems that you come across. The issue that you are seeing is the result of a change in Joomla 3 to the object returned by JFactory::getDBO(). It's method: 'nameQuote()' has been removed and replaced with another called 'quoteName()'. The usage is the same so you can just open up joomla_1.6/com_otrsgateway/install.otrsgateway.php and change the '$db' method from 'nameQuote()' to quote name where it is used on lines 37-40. eg:

$tableExtensions = $db->nameQuote("#__extensions"); 

becomes:

$tableExtensions = $db->quoteName("#__extensions");

After this change the installer should run without error but Joomla versions are radically different from one another so you are likely to come across more problems.

[ChuckNorrison]

Solution in #39