Solved error create table agora_posts

I want to reinstall a backup made with Ackeeba backup, but I get the following error when I try to import the database


Fout in regel 21: CREATE TABLE `#__agora_posts` ( `id` int(10) unsigned NOT NULL auto_increment, `poster` varchar(200) default NULL, `poster_id` int(10) unsigned default '1', `poster_ip` varchar(15) default NUL ... MySQL: MySQL query failed with error 1214 (The used table type doesn't support FULLTEXT indexes). The query was:CREATE TABLE `jos_agora_posts` ( `id` int(10) unsigned NOT NULL auto_increment, `poster` varchar(200) default NULL, `poster_id` int(10) unsigned default '1', `poster_ip` varchar(15) default NULL, `poster_email` varchar(50) default NULL, `message` text, `hide_smilies` tinyint(1) default '0', `posted` int(10) unsigned default '0', `edited` int(10) unsigned default NULL, `edited_by` varchar(200) default NULL, `topic_id` int(10) unsigned default '0', `userimage` varchar(144) NOT NULL, PRIMARY KEY (`id`), KEY `jos_agora_posts_topic_id_idx` (`topic_id`), KEY `jos_agora_posts_multi_idx` (`poster_id`,`topic_id`), FULLTEXT KEY `message_fulltext_search` (`message`) ) AUTO_INCREMENT=3 DEFAULT CHARSET=utf8

Does anyone know what this means and how it can be solved ?
Thanks
Isabel



Configuration settings copied from Kunena in back-end of thes site:

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Enabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 2M

Joomla default template details : isabeldesmet_reetzweters | author: Isabel De Smet | version: 1.0.0 | creationdate: 22/02/2010

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.3 | creationdate: 2011-01-31

Kunena version detailled: Installed version: 1.6.3 | Build: 4344 | Version name: Parlare | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	:: FORUM REETZWETERS ::
board_offline	0
board_ofset	0
offline_message	<h2>Het forum is momenteel offline wegens onderhoud</h2> Kom gauw terug!
enablerss	0
enablepdf	0
threads_per_page	20
messages_per_page	20
messages_per_page_search	15
showhistory	1
historylimit	20
shownew	1
jmambot	0
disemoticons	0
template	default
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	0
annmodid	62,87
rtewidth	600
rteheight	20
enableforumjump	1
reportmsg	1
username	1
askemail	1
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	3600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	0
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	1
mailfull	0
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	100
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	800
allowfileupload	0
allowfileregupload	1
filetypes	zip,txt,doc,gz,tgz,jpg,xls,pdf,asf,bmp,png
filesize	800
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	100
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_usertype	1
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	9
help_infb	1
help_cid	10
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	3600
highlightcode	1
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	categories
default_sort	desc
alphauserpointsnumchars	0
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	joomla
integration_login	joomla
integration_avatar	kunena
integration_profile	kunena
integration_private	none
integration_activity	auto
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	0
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	image
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Disabled or not installed | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Third-party SEF components: sh404sef: Installed (Version : 2.2.2.941) | ARTIO JoomSEF: Disabled or not installed | AceSEF: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Enabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Disabled or not installed | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

This was not Kunena related issue, but I think I know the solution: you need to remove existing tables before restoring backup.

I had created a new empty database, so this cannot be the problem

Sorry, I missed this:

MySQL: MySQL query failed with error 1214 (The used table type doesn't support FULLTEXT indexes)

Looks like Agora only works with MyISAM engine, which isn't supported in MySQL 5.5 anymore. If you have older version of MySQL, you can fix this issue by changing default engine from InnoDB into MyISAM (in my.cfg). There should be docs on how to do that all over the internet.

Ok, i'll check that. But I am wondering, AGORA isn't that the older version of Kunena ? Can't these tables be deleted ? Are the still used by Kunena ?

Agora is a totally different product to Kunena. Agora was developed by a different team to Kunena. There are no xxx_agora_* tables used by Kunena, just like there are no xxx_kunena_* tables used by Agora. You can, if you want, install Agora as the same time as Kunena but they operate independently of one another.

If you have a problem with Agora, I would advise you to ask the people who wrote it; got to www.jvitals.com/support/support-forum/de...oard.html?view=board

Further, K 1.6.3 was retired a long time ago and we don't support it any more. I advise you to upgrade to K 1.7.2 as soon as possible. You should also update you version of Joomla, too.

I have updated this site beginning 2011, I transferred the forum from AGora to Kunena...
At the moment I do not use Agora anymore, only Kunena.

If you say that Kunena uses nothing from the Agora, then I can delete these tables ! Thanks for the info!

You have a point concerning the update, however the budget here is not that high... I'm afraid an update every 2 years has to do. Also from joomla 1.5 to 1.7 is a migration... more time... more budget

(1) Yes, you can drop the Agora tables if you do not need them.

(2) Upgrading from K 1.6.3 to K 1.7.2 will probably take you about 2 minutes. It's free, it's easy to do. The point is, if you do not upgrade to K 1.7.2 we may not be able to help you in future. In the time since K 1.6.3 was released (nearly 1½ years ago) about 300 problems have been fixed and K 1.7.2 is more reliable and better to use.

(3) Updating from J! 1.5.22 to J! 1.5.26 is free and it is not the same as migrating from J! 1.5 to J! 2.5.

(4) The version of sh404SEF is also old, outdated and questionable in terms of its value. Chances are you don't need it anyway. Running websites with sh404sef can actually slow down the site's performance.

Thank you for the advices! Indeed SH404SEF causes me a lot of troubles...
I'll follow you adives!