Kayako DB import into blank DB error

[christinasc]

I am trying to import a kayako database (exported from the admin panel) into a brand new blank database. I have done this before with the same database, so i know it works but now

I keep getting this error.


CREATE TABLE `swkbarticledata` (
`kbarticledataid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`kbarticleid` int( 10 ) unsigned DEFAULT '0' NOT NULL ,
`contents` mediumtext NOT NULL ,
PRIMARY KEY ( `kbarticledataid` ) ,
KEY `kbarticledata1` ( `kbarticleid` ) ,
KEY `contents` ( `contents` )
)

MySQL said: Documentation
#1170 - BLOB column 'contents' used in key specification without a key length

Can anyone help me get past this? Many thanks.

[Mahesh Slaria]

Hi,

This issue is fixed in our latest CVS build. Please try to change "'contents' mediumtext NOT NULL," to "'contents' mediumtext". This will fix the issue.

Thanks.

Regards,

[christinasc]

Actually what i did instead to fix this is i just did a phpmyadmin dump of the whole database and then uploaded it into my new blank db.

It appears to work very smoothly when it is done through phpmyadmin as an export and import.

[mramos]

Hi which CVS build does this problem fix?

Thanks,

Marc

Originally Posted by Mahesh Slaria

Hi,

This issue is fixed in our latest CVS build. Please try to change "'contents' mediumtext NOT NULL," to "'contents' mediumtext". This will fix the issue.

Thanks.

Regards,

[mchandarana]

Hi,

I am getting the same error even though contents is mediumtext. It doesn't have NOT NULL.

CREATE TABLE `swkbarticledata` (
`kbarticledataid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`kbarticleid` int( 10 ) unsigned DEFAULT '0' NOT NULL ,
`contents` mediumtext ,
PRIMARY KEY ( `kbarticledataid` ) ,
KEY `kbarticledata1` ( `kbarticleid` ) ,
KEY `contents` ( `contents` )
)

[John Haugeland]

Please open a support ticket. The repairs described above are incorrect.