Support Suite integration with WHMCS [MERGED]

[bear]

WHMCS has announced the integration with Kayako has been completed and is included with the new 3.5 release. It apparently requires some files that are only available from Kayako in the CVS "beta" builds. I won't install these, as I don't have time to be able to troubleshoot, etc.

Will this be usable with a slightly older version of the suite (3.04.10)?
Will it work with the full normal release of the suite if not (3.11.01)?
I wont' be the only one asking about this, I'd imagine, based on forum posts over there discussing it.

[craigbrass]

I don't think you'll be able to "patch" 3.04.10. You will need to upgrade.

It is committed to CVS so I imagine it will be released with 3.12.00.

[Jamie Edwards]

Hi there,

This will be released officially with 3.11.02. However, the current CVS build is currently being tested and primed for our next stable release, 3.11.02 - so should be find to run. As always though, please take a backup.

The current CVS build is available to all customers with an active support package, and can be found under the Builds tab.

Will this be usable with a slightly older version of the suite (3.04.10)?

I am afraid not, as setting changes (involving file and database changes) are required for WHMCS integration, just like with the ModernBill integration option.

[Jamie Edwards]

Originally Posted by Jamie Edwards

Hi there,

This will be released officially with 3.11.02. However, the current CVS build is currently being tested and primed for our next stable release, 3.11.02 - so should be find to run. As always though, please take a backup.

3.11.02 should not be more than one or two weeks away.

The current CVS build is available to all customers with an active support package, and can be found under the Builds tab.

I am afraid not, as setting changes (involving file and database changes) are required for WHMCS integration, just like with the ModernBill integration option.

[bear]

Originally Posted by craigbrass

I don't think you'll be able to "patch" 3.04.10. You will need to upgrade.

Yup, I was afraid of that. Been avoiding it as we've customized quite a bit, but its unavoidable. Dang progress.

[hbidad]

Does this require a separate license? I went ahead and took the plunge.

So far it appears to work, but as a client from WHMCS and viewing the tickets I get a big red error:

ERROR (2): Domain does not match license key file domain (client.domain.com), please change the product path to match the domain under Admin CP > Settings > General Settings
This Product will not work properly unless untill that value is changed.

We have WHMCS installed under client.domain.com and kayako under support.domain.com

[hbidad]

Also, I'm not sure if this is related, but when viewing the frontpage of kayako without being logged in, we see the following:

Invalid SQL: SELECT kbarticles.*, kbarticlelinks.*, kbcategories.categorytype FROM `swkbarticles` AS kbarticles LEFT JOIN `swkbarticlelinks` AS kbarticlelinks ON (kbarticles.kbarticleid = kbarticlelinks.kbarticleid) LEFT JOIN `swkbcategories` AS kbcategories ON (kbarticlelinks.kbcategoryid = kbcategories.kbcategoryid) LEFT JOIN `swtgroupassigns` AS tgroupassigns ON (kbarticlelinks.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '5') WHERE ((tgroupassigns.tgroupid = '1') OR (kbarticlelinks.kbcategoryid = 0)) AND (kbcategories.categorytype != 'public') AND (kbarticles != 'published') ORDER BY kbarticles.views DESC LIMIT 4; (Unknown column 'kbarticles' in 'where clause')

This is with the latest CVS as of right now. Just food for the thought if you are eager like I was

[craigbrass]

We have WHMCS installed under client.domain.com and kayako under support.domain.com

Contact support and ask them to licence the second domain. Hopefully they will do it free of charge as it is the same helpdesk.

[Neil-UKWSD]

Originally Posted by hbidad

Also, I'm not sure if this is related, but when viewing the frontpage of kayako without being logged in, we see the following:

Invalid SQL: SELECT kbarticles.*, kbarticlelinks.*, kbcategories.categorytype FROM `swkbarticles` AS kbarticles LEFT JOIN `swkbarticlelinks` AS kbarticlelinks ON (kbarticles.kbarticleid = kbarticlelinks.kbarticleid) LEFT JOIN `swkbcategories` AS kbcategories ON (kbarticlelinks.kbcategoryid = kbcategories.kbcategoryid) LEFT JOIN `swtgroupassigns` AS tgroupassigns ON (kbarticlelinks.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '5') WHERE ((tgroupassigns.tgroupid = '1') OR (kbarticlelinks.kbcategoryid = 0)) AND (kbcategories.categorytype != 'public') AND (kbarticles != 'published') ORDER BY kbarticles.views DESC LIMIT 4; (Unknown column 'kbarticles' in 'where clause')

This is with the latest CVS as of right now. Just food for the thought if you are eager like I was

I've just done a fresh install of the CVS to play around with the WHMCS integration and start to skin things to match and seeing this same error on the SupportSuite index page.

[Jamie Edwards]

This has been fixed - please upgrade to the CVS build on December 13th -or- simply update the file /modules/core/client_index.php

[Neil-UKWSD]

Thanks Jamie,

Will grab the update when available, for now I have disabled the popular KB articles on the index page which stops the error.

[Jamie Edwards]

Please note that integration is only possible if your Kayako SupportSuite license is valid for the domain under which WHMCS is installed.

If it is not (i.e. you have SupportSuite installed at support.domain.com and WHMCS at billing.domain.com), you must purchase an additional domain license or move the installations of either.

[hbidad]

You've got to be kidding. At WHMCS another member said that this would be corrected in tonights CVS. At least thats what they quoted from Kayako support.

[Jamie Edwards]

Hi hbidad,

The notice regarding the license file does not relate to the error talked about above, which has been fixed in the CVS build for 13th December 2007.

[chrisduk]

hello

why is the kayako integration so ugly? it just seems to load supportsuite in a frame.

i know when i used kayako with modernbill v4 it was a nice integration. also i found if you click my tickets. and click a ticket to open it. it just refreshes the frame rather than load the actual ticket.