Question Kunena Latest - broken after wrong install of version 3

Hi,

By mistake I installed the newest version of the Kunena Latest module on my site, but I'm using the 2.04 version yet.

After that, I removed the module and reinstalled the 2.04 version of the module, but it's not working. It's appearing but is not bringing any posts/topics.

I didn't change any configuration but maybe something wrong was kept on the database or some hidden configuration.

My site is www.brejas.com.br/forum/
configuration is [strike]attached[/strike].

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 256M | Max file upload: 80M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
358	Fórum	kunenamenu	view=home&defaultmenu=359	forum
359	Categorias	kunenamenu	view=category&layout=list&catid=0	forum/categorias
360	Últimas Discussões	kunenamenu	view=topics&mode=replies	forum/ultimas
361	Novo Tópico	kunenamenu	view=topic&layout=create	forum/novotopico
362	Sem Respostas	kunenamenu	view=topics&mode=noreplies	forum/sem-respostas
363	Minhas Discussões	kunenamenu	view=topics&layout=user&mode=default	forum/minhas-discussoes
364	Perfil	kunenamenu	view=user	forum/perfil
365	Ajuda	kunenamenu	view=misc	forum/ajuda
366	Pesquisa	kunenamenu	view=search	forum/pesquisa-forum

Joomla default template details : brejastableless | author: Ricardo Sangion | version: 1.0.0 | creationdate: 07/21/08

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.4 | creationdate: 2013-01-18

Kunena version detailed: Kunena 2.0.4 | 2013-01-18 [ Pharmacopoeia ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	0
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	0
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	0
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	0
allowavatarupload	0
allowavatargallery	0
avatarquality	85
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	999
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	500
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	0
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
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
defaultpage	recent
default_sort	asc
sef	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
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	85
thumbheight	50
thumbwidth	50
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	15
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	180
iptracking	1
rss_feedburner_url
changename	0
enablepdf	0
jmambot	1
annmodid	62
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1 activity_points_limit=0 activity_stream_limit=0
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)
pt-BR	Português (BR)

Third-party components: Jomsocial 2.8.4

Third-party SEF components: None

Plugins: JomSocial - My Kunena Forum Menu 2.0.4 | JomSocial - My Kunena Forum Posts 2.0.3

Modules: Kunena Latest 2.0.4

Edited by moderator. Please read the FAQs page to learn how to insert your configuraton report in the body of the message

thanks!

Hello,

Do you have tried to save a new once the settings of kunena lastest module ?

thanks for the advice

I've just tried and the new one is having the same problem.
I saved as a new module, but it is still not showing anything.

Any other idea?

rsangion wrote: Any other idea?

(1) Talk to JomSocial about whether their JomSocial - My Kunena Forum Menu and JomSocial - My Kunena Forum Posts plugins are suitable for K 3.0; and then
(2) Upgrade from K 2.0.4 to K 3.0.1 and then upgrade Kunena Latest module

... and see if these things resolve your problems.

Not even the My Forum Posts from JomSocial is working now

Anyone would have an idea of what is going on or how to debug it?

thanks!

My advice is to use the backup you took before you did the "wrong" install in the first place and restore your site to its earlier [working] state.

I have too many changes already on the database, this would be a pain.

Do you guys know a way to debug, try to race what is happening wrong?

Have you looked at the diagnostic functions of Kunena?

• Diagnostic tool
• Database schema tool

To recap the situation:

(1) Your forum works properly
(2) The integration of Kunena and JomSocial seems to work properly, that is, users' profiles and avatar images are obtained from JomSocial.
(3) There is some problem with JomSocial - My Kunena Forum Menu and JomSocial - My Kunena Forum Posts plugins (but that's not the problem we are discussing here)
(4) There is a problem with the Kunena Latest module: you say that you do not see any new topics listed.

So let's concentrate on the problem - the Kunena Latest module problem.

I don't think there's anything "broken" as such with this module. I think that the module settings may be been changed. You say that you re-installed the K 2.0.4 Kunena Latest module after you mistakenly installed the K 3.0.1 version (and I believe that's what you did) but maybe, in the process of re-installing the K 3.0.1 version, something corrupted the XML file or changed the module parameter settings.

My advice is to delete the instance of the module that you are using somewhere on your site, and create a new instance of the Kunena Latest module, publish the new module, setup the module settings as you want them, and tell us if things are back to the way that you want them. This should take you about 2 minutes (or less).

I deleted the module many times, reinstalling it and reconfiguring it. It didn't work.

Running Diagnostic Tool I saw 2 lines with errors. Deleted the items and the problem was still there.

Running the Schema Tool, I can see this:

Kunena Database Schema
Schema Difference

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema type="diff">
<table name="kunena_users" action="alter">
<field name="view" type="varchar(" null="0" default="" action="alter" after="userid"/>
</table>
</schema>

Is there anything I should do about it?

thanks!

Just in case, posting the other results showing:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema>
<table name="kunena_aliases">
<field primary_key="yes" name="alias" type="varchar(255)" null="0"/>
<field name="type" type="varchar(10)" null="0"/>
<field name="item" type="varchar(32)" null="0"/>
<field name="state" type="tinyint(4)" null="0" default="0"/>
<key name="alias" unique="1" columns="alias"/>
<key name="state" columns="state"/>
<key name="item" columns="item"/>
<key name="type" columns="type"/>
</table>
<table name="kunena_announcement">
<field primary_key="yes" name="id" type="int(3)" null="0" extra="auto_increment"/>
<field name="title" type="tinytext" null="0"/>
<field name="created_by" type="int(11)" null="0" default="0"/>
<field name="sdescription" type="text" null="0"/>
<field name="description" type="text" null="0"/>
<field name="created" type="datetime" null="0" default="0000-00-00 00:00:00"/>
<field name="published" type="tinyint(1)" null="0" default="0"/>
<field name="ordering" type="tinyint(4)" null="0" default="0"/>
<field name="showdate" type="tinyint(1)" null="0" default="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_attachments">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="mesid" type="int(11)" null="0" default="0"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="hash" type="char(32)" null="1"/>
<field name="size" type="int(11)" null="1"/>
<field name="folder" type="varchar(255)" null="0"/>
<field name="filetype" type="varchar(20)" null="0"/>
<field name="filename" type="varchar(255)" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="mesid" columns="mesid"/>
<key name="userid" columns="userid"/>
<key name="hash" columns="hash"/>
<key name="filename" columns="filename"/>
</table>
<table name="kunena_categories">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="parent_id" type="int(11)" null="1" default="0"/>
<field name="name" type="tinytext" null="1"/>
<field name="alias" type="varchar(255)" null="0"/>
<field name="icon_id" type="tinyint(4)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="accesstype" type="varchar(20)" null="0" default="joomla.level"/>
<field name="access" type="int(11)" null="0" default="0"/>
<field name="pub_access" type="int(11)" null="0" default="1"/>
<field name="pub_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="admin_access" type="int(11)" null="0" default="0"/>
<field name="admin_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="ordering" type="smallint(6)" null="0" default="0"/>
<field name="published" type="tinyint(4)" null="0" default="0"/>
<field name="channels" type="text" null="1"/>
<field name="checked_out" type="tinyint(4)" null="0" default="0"/>
<field name="checked_out_time" type="datetime" null="0" default="0000-00-00 00:00:00"/>
<field name="review" type="tinyint(4)" null="0" default="0"/>
<field name="allow_anonymous" type="tinyint(4)" null="0" default="0"/>
<field name="post_anonymous" type="tinyint(4)" null="0" default="0"/>
<field name="hits" type="int(11)" null="0" default="0"/>
<field name="description" type="text" null="0"/>
<field name="headerdesc" type="text" null="0"/>
<field name="class_sfx" type="varchar(20)" null="0"/>
<field name="allow_polls" type="tinyint(4)" null="0" default="0"/>
<field name="topic_ordering" type="varchar(16)" null="0" default="lastpost"/>
<field name="numTopics" type="mediumint(" null="0" default="0"/>
<field name="numPosts" type="mediumint(" null="0" default="0"/>
<field name="last_topic_id" type="int(11)" null="0" default="0"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="last_post_time" type="int(11)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="published_pubaccess_id" columns="published,pub_access,id"/>
<key name="category_access" columns="accesstype,access"/>
<key name="parent_id" columns="parent_id"/>
</table>
<table name="kunena_configuration">
<field primary_key="yes" name="id" type="int(11)" null="0" default="0"/>
<field name="params" type="text" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_keywords">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="name" type="varchar(40)" null="0"/>
<field name="public_count" type="int(11)" null="0"/>
<field name="total_count" type="int(11)" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="name" unique="1" columns="name"/>
<key name="public_count" columns="public_count"/>
<key name="total_count" columns="total_count"/>
</table>
<table name="kunena_keywords_map">
<field primary_key="yes" name="keyword_id" type="int(11)" null="0"/>
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0"/>
<key name="keyword_user_topic" unique="1" columns="keyword_id,user_id,topic_id"/>
<key name="user_id" columns="user_id"/>
<key name="topic_user" columns="topic_id,user_id"/>
</table>
<table name="kunena_messages">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="parent" type="int(11)" null="1" default="0"/>
<field name="thread" type="int(11)" null="1" default="0"/>
<field name="catid" type="int(11)" null="0" default="0"/>
<field name="name" type="tinytext" null="1"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="email" type="tinytext" null="1"/>
<field name="subject" type="tinytext" null="1"/>
<field name="time" type="int(11)" null="0" default="0"/>
<field name="ip" type="varchar(128)" null="1"/>
<field name="topic_emoticon" type="int(11)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="hold" type="tinyint(4)" null="0" default="0"/>
<field name="ordering" type="int(11)" null="1" default="0"/>
<field name="hits" type="int(11)" null="1" default="0"/>
<field name="moved" type="tinyint(4)" null="1" default="0"/>
<field name="modified_by" type="int(7)" null="1"/>
<field name="modified_time" type="int(11)" null="1"/>
<field name="modified_reason" type="tinytext" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="thread" columns="thread"/>
<key name="ip" columns="ip"/>
<key name="userid" columns="userid"/>
<key name="time" columns="time"/>
<key name="locked" columns="locked"/>
<key name="hold_time" columns="hold,time"/>
<key name="parent_hits" columns="parent,hits"/>
<key name="catid_parent" columns="catid,parent"/>
</table>
<table name="kunena_messages_text">
<field primary_key="yes" name="mesid" type="int(11)" null="0" default="0"/>
<field name="message" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="mesid"/>
</table>
<table name="kunena_polls">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="title" type="varchar(100)" null="0"/>
<field name="threadid" type="int(11)" null="0"/>
<field name="polltimetolive" type="datetime" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="threadid" columns="threadid"/>
</table>
<table name="kunena_polls_options">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="pollid" type="int(11)" null="1"/>
<field name="text" type="varchar(100)" null="1"/>
<field name="votes" type="int(11)" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="pollid" columns="pollid"/>
</table>
<table name="kunena_polls_users">
<field name="pollid" type="int(11)" null="1"/>
<field name="userid" type="int(11)" null="1"/>
<field name="votes" type="int(11)" null="1"/>
<field name="lasttime" type="timestamp" null="0" default="0000-00-00 00:00:00"/>
<field name="lastvote" type="int(11)" null="1"/>
<key name="pollid" unique="1" columns="pollid,userid"/>
</table>
<table name="kunena_ranks">
<field primary_key="yes" name="rank_id" type="mediumint( unsigned" null="0" extra="auto_increment"/>
<field name="rank_title" type="varchar(255)" null="0" default=""/>
<field name="rank_min" type="mediumint( unsigned" null="0" default="0"/>
<field name="rank_special" type="tinyint(1) unsigned" null="0" default="0"/>
<field name="rank_image" type="varchar(255)" null="0" default=""/>
<key name="PRIMARY" unique="1" columns="rank_id"/>
</table>
<table name="kunena_sessions">
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<field name="allowed" type="text" null="1"/>
<field name="lasttime" type="int(11)" null="0" default="0"/>
<field name="readtopics" type="text" null="1"/>
<field name="currvisit" type="int(11)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="userid"/>
<key name="currvisit" columns="currvisit"/>
</table>
<table name="kunena_smileys">
<field primary_key="yes" name="id" type="int(4)" null="0" extra="auto_increment"/>
<field name="code" type="varchar(12)" null="0" default=""/>
<field name="location" type="varchar(50)" null="0" default=""/>
<field name="greylocation" type="varchar(60)" null="0" default=""/>
<field name="emoticonbar" type="tinyint(4)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_thankyou">
<field primary_key="yes" name="postid" type="int(11)" null="0"/>
<field primary_key="yes" name="userid" type="int(11)" null="0"/>
<field name="targetuserid" type="int(11)" null="0"/>
<field name="time" type="datetime" null="0"/>
<key name="postid" unique="1" columns="postid,userid"/>
<key name="userid" columns="userid"/>
<key name="targetuserid" columns="targetuserid"/>
</table>
<table name="kunena_topics">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="category_id" type="int(11)" null="0" default="0"/>
<field name="subject" type="tinytext" null="1"/>
<field name="icon_id" type="int(11)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="hold" type="tinyint(4)" null="0" default="0"/>
<field name="ordering" type="int(11)" null="0" default="0"/>
<field name="posts" type="int(11)" null="0" default="0"/>
<field name="hits" type="int(11)" null="0" default="0"/>
<field name="attachments" type="int(11)" null="0" default="0"/>
<field name="poll_id" type="int(11)" null="0" default="0"/>
<field name="moved_id" type="int(11)" null="0" default="0"/>
<field name="first_post_id" type="int(11)" null="0" default="0"/>
<field name="first_post_time" type="int(11)" null="0" default="0"/>
<field name="first_post_userid" type="int(11)" null="0" default="0"/>
<field name="first_post_message" type="text" null="1"/>
<field name="first_post_guest_name" type="tinytext" null="1"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="last_post_time" type="int(11)" null="0" default="0"/>
<field name="last_post_userid" type="int(11)" null="0" default="0"/>
<field name="last_post_message" type="text" null="1"/>
<field name="last_post_guest_name" type="tinytext" null="1"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="category_id" columns="category_id"/>
<key name="locked" columns="locked"/>
<key name="hold" columns="hold"/>
<key name="posts" columns="posts"/>
<key name="hits" columns="hits"/>
<key name="first_post_userid" columns="first_post_userid"/>
<key name="last_post_userid" columns="last_post_userid"/>
<key name="first_post_time" columns="first_post_time"/>
<key name="last_post_time" columns="last_post_time"/>
</table>
<table name="kunena_user_categories">
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="category_id" type="int(11)" null="0"/>
<field name="role" type="tinyint(4)" null="0" default="0"/>
<field name="allreadtime" type="datetime" null="1"/>
<field name="subscribed" type="tinyint(4)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="user_id,category_id"/>
<key name="category_subscribed" columns="category_id,subscribed"/>
<key name="role" columns="role"/>
</table>
<table name="kunena_user_read">
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0"/>
<field name="category_id" type="int(11)" null="0"/>
<field name="message_id" type="int(11)" null="0"/>
<field name="time" type="int(11)" null="0"/>
<key name="user_topic_id" unique="1" columns="user_id,topic_id"/>
<key name="category_user_id" columns="category_id,user_id"/>
<key name="time" columns="time"/>
</table>
<table name="kunena_user_topics">
<field primary_key="yes" name="user_id" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0" default="0"/>
<field name="category_id" type="int(11)" null="0"/>
<field name="posts" type="mediumint(" null="0" default="0"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="owner" type="tinyint(4)" null="0" default="0"/>
<field name="favorite" type="tinyint(4)" null="0" default="0"/>
<field name="subscribed" type="tinyint(4)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="user_topic_id" unique="1" columns="user_id,topic_id"/>
<key name="topic_id" columns="topic_id"/>
<key name="posts" columns="posts"/>
<key name="owner" columns="owner"/>
<key name="favorite" columns="favorite"/>
<key name="subscribed" columns="subscribed"/>
</table>
<table name="kunena_users">
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<field name="view" type="varchar(" null="0" default="flat"/>
<field name="signature" type="text" null="1"/>
<field name="moderator" type="int(11)" null="1" default="0"/>
<field name="banned" type="datetime" null="1"/>
<field name="ordering" type="int(11)" null="1" default="0"/>
<field name="posts" type="int(11)" null="1" default="0"/>
<field name="avatar" type="varchar(255)" null="1"/>
<field name="karma" type="int(11)" null="1" default="0"/>
<field name="karma_time" type="int(11)" null="1" default="0"/>
<field name="group_id" type="int(4)" null="1" default="1"/>
<field name="uhits" type="int(11)" null="1" default="0"/>
<field name="personalText" type="tinytext" null="1"/>
<field name="gender" type="tinyint(4)" null="0" default="0"/>
<field name="birthdate" type="date" null="0" default="0001-01-01"/>
<field name="location" type="varchar(50)" null="1"/>
<field name="icq" type="varchar(50)" null="1"/>
<field name="aim" type="varchar(50)" null="1"/>
<field name="yim" type="varchar(50)" null="1"/>
<field name="msn" type="varchar(50)" null="1"/>
<field name="skype" type="varchar(50)" null="1"/>
<field name="twitter" type="varchar(50)" null="1"/>
<field name="facebook" type="varchar(50)" null="1"/>
<field name="gtalk" type="varchar(50)" null="1"/>
<field name="myspace" type="varchar(50)" null="1"/>
<field name="linkedin" type="varchar(50)" null="1"/>
<field name="delicious" type="varchar(50)" null="1"/>
<field name="friendfeed" type="varchar(50)" null="1"/>
<field name="digg" type="varchar(50)" null="1"/>
<field name="blogspot" type="varchar(50)" null="1"/>
<field name="flickr" type="varchar(50)" null="1"/>
<field name="bebo" type="varchar(50)" null="1"/>
<field name="websitename" type="varchar(50)" null="1"/>
<field name="websiteurl" type="varchar(50)" null="1"/>
<field name="rank" type="tinyint(4)" null="0" default="0"/>
<field name="hideEmail" type="tinyint(1)" null="0" default="1"/>
<field name="showOnline" type="tinyint(1)" null="0" default="1"/>
<field name="thankyou" type="int(11)" null="1" default="0"/>
<key name="PRIMARY" unique="1" columns="userid"/>
<key name="group_id" columns="group_id"/>
<key name="posts" columns="posts"/>
<key name="uhits" columns="uhits"/>
<key name="banned" columns="banned"/>
<key name="moderator" columns="moderator"/>
</table>
<table name="kunena_users_banned">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="userid" type="int(11)" null="1"/>
<field name="ip" type="varchar(128)" null="1"/>
<field name="blocked" type="tinyint(4)" null="0" default="0"/>
<field name="expiration" type="datetime" null="1"/>
<field name="created_by" type="int(11)" null="0"/>
<field name="created_time" type="datetime" null="0"/>
<field name="reason_private" type="text" null="1"/>
<field name="reason_public" type="text" null="1"/>
<field name="modified_by" type="int(11)" null="1"/>
<field name="modified_time" type="datetime" null="1"/>
<field name="comments" type="text" null="1"/>
<field name="params" type="text" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="userid" columns="userid"/>
<key name="ip" columns="ip"/>
<key name="expiration" columns="expiration"/>
<key name="created_time" columns="created_time"/>
</table>
<table name="kunena_version">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="version" type="varchar(20)" null="0"/>
<field name="versiondate" type="date" null="0"/>
<field name="installdate" type="date" null="0"/>
<field name="build" type="varchar(20)" null="0"/>
<field name="versionname" type="varchar(40)" null="1"/>
<field name="state" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
</schema>