IRS error on upgrade to 3.11.01

[AndyW]

Upgraded to 3.11.01 and IRS gives error

Invalid SQL: SELECT kbarticlelinks.kbarticleid, MATCH(kbarticledata.contents) AGAINST ('asd') AS relevance FROM `kbarticledata` AS kbarticledata LEFT JOIN `kbarticlelinks` AS kbarticlelinks ON (kbarticledata.kbarticleid = kbarticlelinks.kbarticleid) LEFT JOIN `tgroupassigns` AS tgroupassigns ON (kbarticlelinks.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '5') LEFT JOIN `swkbcategories` AS kbcategories ON (kbarticlelinks.kbcategoryid = kbcategories.kbcategoryid) WHERE (tgroupassigns.tgroupid = '1' OR kbarticlelinks.kbcategoryid = '0') AND MATCH(kbarticledata.contents) AGAINST('asd') LIMIT 5; (Table 'kayako.swkbcategories' doesn't exist)

Setup completed and gave message 'Your version is now up to date'

What can this be?

[supportskins]

Seems like the issue is with your database. The error suggest the table 'kayako.swkbcategories' no longer exist. Seems like your DB got corrupted. Restore your back up database and re-run the upgrade script. That should fix the issue.

[AndyW]

supportskins,

Yes I though so too, but apparently it was a table naming issue. The script wanted 'swkbcategories' while the table was available as 'kbcategories'.

Apparently tabes have been prefixed with 'sw' since version 3. But our install was working perfectly without any 'sw' prefix.

Kunal from Kayako, was kind enough to put in a fix and get it working.

[supportskins]

Thanks for sharing that information and I am glad the issue has been fixed.

[Eric]

I have just upgraded and i get this error too.

I fixed the problem myself.
This is a coding error by kayako.

You hardcoded the table prefix as "sw" in functions_irs.php

LEFT JOIN `swkbcategories` AS kbcategories

should be

LEFT JOIN `". TABLE_PREFIX ."kbcategories` AS kbcategories

[Jamie Edwards]

Hi Eric,

I am sorry for this; we will fix it on Monday.

[Jamie Edwards]

Fixed and pushed to the CVS.

[ganesh.rao]

Hello,

I too have this problem. But mine is a fresh new install of the latest stable build.

Do I need to open a new ticket to get this thing fixed?

Best Regards,
Ganesh Rao

[Jamie Edwards]

Hi Ganesh,

Are you running the latest STABLE release or the latest CVS release under Builds tab)?

[ganesh.rao]

Hello Jamie,

The latest STABLE release. The one that is found on https://members.kayako.net/index.php?_m=home

I am using the Zend Encoded release.

Best Regards,
Ganesh Rao

[Jamie Edwards]

Hi Ganesh,

The fix is only available in the latest CVS build. You can either install this (backup before you do) or wait for the next stable build (coming soon).

[ganesh.rao]

Hello Jamie,

Is there any changelog or something I can use to know which is the file which contains the fix and only update that file instead of moving to the CVS?

I'm a kind of person who doesn't like problems at all. Stable, I will stay at all times.

You can't move me outta that.

I have a seen a help desk which fixes this problem without using the CVS. Right in the stable version, now how did they do this?

Best Regards,
Ganesh Rao

[Jamie Edwards]

You can try and replace this file: swift/modules/knowledgebase/functions_irs.php - it is unlikely, but there may be dependancies in other files I have not found.

You can view the build logs here:

http://builds.kayako.net

[ganesh.rao]

Hello Jamie,

According to "Files Affected: 1" (11 Nov 2007 05:20 PM - mslaria), I guess there is no compatibility or dependencies. I'll just rename the current file (STABLE) and then upload this and check, if it works. Good, else delete the file and revert the rename.

Best Regards,
Ganesh Rao

[ganesh.rao]

Hello,

Any update to what I said in my above post? Is it true, that there is no dependencies?

Id like it if a developer could make a reply here.

Best Regards,
Ganesh Rao