Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question User statistics broken in K1.6

thujahekk
Topic Author
Offline
Junior Member

15 years 6 months ago #64009 by thujahekk

User statistics broken in K1.6 was created by thujahekk

Hi,
After upgrading to Kunena 1.6, existing users either have no posts at all - or double what they should have. I have tried to recount stats, synchronize users and reset cache.

Any ideas what could be done to fix this?

Thanks!

This message contains confidential information

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: 60 seconds | Max execution memory: 32M | Max file upload: 64M

Kunena version detailled: Installed version: 1.6.0 | Build: 3620 | Version name: Spika | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]
board_title Barnevognguiden.no

board_offline 0

board_ofset 0

offline_message <h2>The Forum is currently offline for maintenance.</h2>
Check back soon!

enablerss 1

enablepdf 0

threads_per_page 20

messages_per_page 40

messages_per_page_search 20

showhistory 1

historylimit 6

shownew 1

jmambot 0

disemoticons 0

template default

showannouncement 1

avataroncat 1

catimagepath category_images/

showchildcaticon 1

annmodid 62

rtewidth 450

rteheight 300

enableforumjump 1

reportmsg 1

username 1

askemail 0

showemail 0

showuserstats 1

showkarma 0

useredit 1

useredittime 0

useredittimegrace 600

editmarkup 1

allowsubscriptions 1

subscriptionschecked 0

allowfavorites 1

maxsubject 100

maxsig 800

regonly 0

changename 1

pubwrite 0

floodprotection 0

mailmod 0

mailadmin 0

captcha 0

mailfull 1

allowavatar 1

allowavatarupload 1

allowavatargallery 1

imageprocessor gd2

avatarquality 80

avatarsize 4096

allowimageupload 0

allowimageregupload 1

imageheight 8000

imagewidth 8000

imagesize 8096

allowfileupload 0

allowfileregupload 1

filetypes zip,txt,doc,gz,tgz,pdf,docx

filesize 4096

showranking 1

rankimages 1

avatar_src

fb_profile

pm_component

userlist_rows 30

userlist_online 1

userlist_avatar 1

userlist_name 0

userlist_username 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 1

popusercount 10

showpopsubjectstats 1

popsubjectcount 10

usernamechange 1

rules_infb 0

rules_cid 0

rules_link www.bestofjoomla.com/

help_infb 0

help_cid 1

help_link www.bestofjoomla.com/

showspoilertag 1

showvideotag 1

showebaytag 1

trimlongurls 0

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 1

ebaylanguagecode en-no

fbsessiontimeout 3600

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

fbdefaultpage categories

default_sort asc

alphauserpointsnumchars 0

sef 1

sefcats 0

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 uddeim

integration_activity none

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

onlineusers 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

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Disabled or not installed | Jomsocial: Disabled or not installed | UddeIm: Installed (Version : 1.9)

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | 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

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

Please Log in or Create an account to join the conversation.

Matias
Offline
Administrator

15 years 6 months ago #64044 by Matias

Replied by Matias on topic Re: User statistics broken in K1.6

Your issues sound like you have migrated from Joomla 1.0 and your database was slightly broken because of it (migration script proved to be buggy). I may be wrong, though..

Can you copy output of this url (in your site administration):

/administrator/index.php?option=com_kunena&view=install&layout=schema

Please Log in or Create an account to join the conversation.

thujahekk
Topic Author
Offline
Junior Member

15 years 6 months ago - 15 years 6 months ago #64045 by thujahekk

Replied by thujahekk on topic Re: User statistics broken in K1.6

From the user menu in Kunena, it seems the users are duplicated. However, if I list the users in Joomla they are not duplicated. Could this be the underlying problem?

Last edit: 15 years 6 months ago by thujahekk.

Please Log in or Create an account to join the conversation.

thujahekk
Topic Author
Offline
Junior Member

15 years 6 months ago - 15 years 6 months ago #64046 by thujahekk

Replied by thujahekk on topic Re: User statistics broken in K1.6

Sure, here is the output:

Schema Difference

Warning: Spoiler!

!DOCTYPE schema>
<schema type="diff">
<table name="kunena_announcement" action="alter">
<field name="title" type="tinytext" null="0" action="alter" after="id"/>
</table>
<table name="kunena_categories" action="alter">
<field name="moderated" type="tinyint(4)" null="0" default="1" action="alter" after="alert_admin"/>
<field name="image" action="unknown"/>
</table>
<table name="kunena_config" action="alter">
<field name="alphauserpoints" type="int(11)" null="1" action="create" after="default_sort"/>
<field name="alphauserpointsrules" type="int(11)" null="1" action="create" after="alphauserpoints"/>
<field name="showpopthankysoustats" type="int(11)" null="1" action="create" after="showthankyou"/>
<field name="rss_author_in_title" action="unknown"/>
<field name="rss_cache" action="unknown"/>
<field name="showpopthankyoustats" action="unknown"/>
<field name="bbcode_img_secure" action="unknown"/>
<field name="listcat_show_moderators" action="unknown"/>
</table>
<table name="kunena_messages" action="alter">
<key name="ip" columns="ip" action="create"/>
<key name="userid" columns="userid" action="create"/>
</table>
<table name="kunena_moderation" action="alter">
<key name="PRIMARY" unique="1" columns="catid,userid" action="create"/>
</table>
<table name="kunena_polls_users" action="alter">
<field name="lasttime" type="timestamp" null="0" extra="on update CURRENT_TIMESTAMP" action="alter" after="votes"/>
</table>
<table name="kunena_ranks" action="alter">
<field name="rank_title" type="varchar(255)" null="0" default="" action="alter" after="rank_id"/>
<field name="rank_image" type="varchar(255)" null="0" default="" action="alter" after="rank_special"/>
</table>
<table name="kunena_sessions" action="alter">
<key name="PRIMARY" unique="1" columns="userid" action="create"/>
</table>
<table name="kunena_subscriptions" action="alter">
<key name="thread" unique="1" columns="thread,userid" action="create"/>
<key name="userid" columns="userid" action="create"/>
</table>
<table name="kunena_users" action="alter">
<field name="birthdate" type="date" null="0" default="0001-01-01" action="alter" after="gender"/>
<key name="PRIMARY" unique="1" columns="userid" action="create"/>
</table>
<table name="kunena_whoisonline" action="alter">
<key name="userid_2" action="unknown"/>
</table>
<table name="kunena_discussbot" action="unknown"/>
</schema>

Database Schema

Warning: Spoiler!

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema>
<table name="kunena_announcement">
<field primary_key="yes" name="id" type="int(3)" null="0" extra="auto_increment"/>
<field name="title" type="tinytext" null="1"/>
<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" type="int(11)" null="1" default="0"/>
<field name="name" type="tinytext" null="1"/>
<field name="cat_emoticon" type="tinyint(4)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="alert_admin" type="tinyint(4)" null="0" default="0"/>
<field name="moderated" type="tinyint(4)" null="0" default="0"/>
<field name="moderators" type="varchar(15)" null="1"/>
<field name="pub_access" type="tinyint(4)" null="1" default="1"/>
<field name="pub_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="admin_access" type="tinyint(4)" null="1" default="0"/>
<field name="admin_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="ordering" type="tinyint(4)" null="0" default="0"/>
<field name="future2" type="int(11)" null="1" default="0"/>
<field name="published" type="tinyint(4)" null="0" default="0"/>
<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="id_last_msg" type="int(10)" null="0" default="0"/>
<field name="numTopics" type="mediumint(

" null="0" default="0"/>
<field name="numPosts" type="mediumint(

" null="0" default="0"/>
<field name="time_last_msg" type="int(11)" null="1"/>
<field name="image" type="varchar(255)" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="parent" columns="parent"/>
<key name="published_pubaccess_id" columns="published,pub_access,id"/>
<key name="msg_id" columns="id_last_msg"/>
</table>
<table name="kunena_config">
<field primary_key="yes" name="id" type="int(11)" null="0" default="0"/>
<field name="board_title" type="text" null="1"/>
<field name="email" type="text" null="1"/>
<field name="board_offline" type="int(11)" null="1"/>
<field name="board_ofset" type="text" null="1"/>
<field name="offline_message" type="text" null="1"/>
<field name="enablerss" type="int(11)" null="1"/>
<field name="enablepdf" type="int(11)" null="1"/>
<field name="threads_per_page" type="int(11)" null="1"/>
<field name="messages_per_page" type="int(11)" null="1"/>
<field name="messages_per_page_search" type="int(11)" null="1"/>
<field name="showhistory" type="int(11)" null="1"/>
<field name="historylimit" type="int(11)" null="1"/>
<field name="shownew" type="int(11)" null="1"/>
<field name="jmambot" type="int(11)" null="1"/>
<field name="disemoticons" type="int(11)" null="1"/>
<field name="template" type="text" null="1"/>
<field name="showannouncement" type="int(11)" null="1"/>
<field name="avataroncat" type="int(11)" null="1"/>
<field name="catimagepath" type="text" null="1"/>
<field name="showchildcaticon" type="int(11)" null="1"/>
<field name="annmodid" type="text" null="1"/>
<field name="rtewidth" type="int(11)" null="1"/>
<field name="rteheight" type="int(11)" null="1"/>
<field name="enableforumjump" type="int(11)" null="1"/>
<field name="reportmsg" type="int(11)" null="1"/>
<field name="username" type="int(11)" null="1"/>
<field name="askemail" type="int(11)" null="1"/>
<field name="showemail" type="int(11)" null="1"/>
<field name="showuserstats" type="int(11)" null="1"/>
<field name="showkarma" type="int(11)" null="1"/>
<field name="useredit" type="int(11)" null="1"/>
<field name="useredittime" type="int(11)" null="1"/>
<field name="useredittimegrace" type="int(11)" null="1"/>
<field name="editmarkup" type="int(11)" null="1"/>
<field name="allowsubscriptions" type="int(11)" null="1"/>
<field name="subscriptionschecked" type="int(11)" null="1"/>
<field name="allowfavorites" type="int(11)" null="1"/>
<field name="maxsubject" type="int(11)" null="1"/>
<field name="maxsig" type="int(11)" null="1"/>
<field name="regonly" type="int(11)" null="1"/>
<field name="changename" type="int(11)" null="1"/>
<field name="pubwrite" type="int(11)" null="1"/>
<field name="floodprotection" type="int(11)" null="1"/>
<field name="mailmod" type="int(11)" null="1"/>
<field name="mailadmin" type="int(11)" null="1"/>
<field name="captcha" type="int(11)" null="1"/>
<field name="mailfull" type="int(11)" null="1"/>
<field name="allowavatar" type="int(11)" null="1"/>
<field name="allowavatarupload" type="int(11)" null="1"/>
<field name="allowavatargallery" type="int(11)" null="1"/>
<field name="imageprocessor" type="text" null="1"/>
<field name="avatarquality" type="int(11)" null="1"/>
<field name="avatarsize" type="int(11)" null="1"/>
<field name="allowimageupload" type="int(11)" null="1"/>
<field name="allowimageregupload" type="int(11)" null="1"/>
<field name="imageheight" type="int(11)" null="1"/>
<field name="imagewidth" type="int(11)" null="1"/>
<field name="imagesize" type="int(11)" null="1"/>
<field name="allowfileupload" type="int(11)" null="1"/>
<field name="allowfileregupload" type="int(11)" null="1"/>
<field name="filetypes" type="text" null="1"/>
<field name="filesize" type="int(11)" null="1"/>
<field name="showranking" type="int(11)" null="1"/>
<field name="rankimages" type="int(11)" null="1"/>
<field name="avatar_src" type="text" null="1"/>
<field name="fb_profile" type="text" null="1"/>
<field name="pm_component" type="text" null="1"/>
<field name="userlist_rows" type="int(11)" null="1"/>
<field name="userlist_online" type="int(11)" null="1"/>
<field name="userlist_avatar" type="int(11)" null="1"/>
<field name="userlist_name" type="int(11)" null="1"/>
<field name="userlist_username" type="int(11)" null="1"/>
<field name="userlist_posts" type="int(11)" null="1"/>
<field name="userlist_karma" type="int(11)" null="1"/>
<field name="userlist_email" type="int(11)" null="1"/>
<field name="userlist_usertype" type="int(11)" null="1"/>
<field name="userlist_joindate" type="int(11)" null="1"/>
<field name="userlist_lastvisitdate" type="int(11)" null="1"/>
<field name="userlist_userhits" type="int(11)" null="1"/>
<field name="latestcategory" type="text" null="1"/>
<field name="showstats" type="int(11)" null="1"/>
<field name="showwhoisonline" type="int(11)" null="1"/>
<field name="showgenstats" type="int(11)" null="1"/>
<field name="showpopuserstats" type="int(11)" null="1"/>
<field name="popusercount" type="int(11)" null="1"/>
<field name="showpopsubjectstats" type="int(11)" null="1"/>
<field name="popsubjectcount" type="int(11)" null="1"/>
<field name="usernamechange" type="int(11)" null="1"/>
<field name="rules_infb" type="int(11)" null="1"/>
<field name="rules_cid" type="int(11)" null="1"/>
<field name="rules_link" type="text" null="1"/>
<field name="help_infb" type="int(11)" null="1"/>
<field name="help_cid" type="int(11)" null="1"/>
<field name="help_link" type="text" null="1"/>
<field name="showspoilertag" type="int(11)" null="1"/>
<field name="showvideotag" type="int(11)" null="1"/>
<field name="showebaytag" type="int(11)" null="1"/>
<field name="trimlongurls" type="int(11)" null="1"/>
<field name="trimlongurlsfront" type="int(11)" null="1"/>
<field name="trimlongurlsback" type="int(11)" null="1"/>
<field name="autoembedyoutube" type="int(11)" null="1"/>
<field name="autoembedebay" type="int(11)" null="1"/>
<field name="ebaylanguagecode" type="text" null="1"/>
<field name="fbsessiontimeout" type="int(11)" null="1"/>
<field name="highlightcode" type="int(11)" null="1"/>
<field name="rss_type" type="text" null="1"/>
<field name="rss_timelimit" type="text" null="1"/>
<field name="rss_limit" type="int(11)" null="1"/>
<field name="rss_included_categories" type="text" null="1"/>
<field name="rss_excluded_categories" type="text" null="1"/>
<field name="rss_specification" type="text" null="1"/>
<field name="rss_allow_html" type="int(11)" null="1"/>
<field name="rss_author_format" type="text" null="1"/>
<field name="rss_author_in_title" type="int(11)" null="1"/>
<field name="rss_word_count" type="text" null="1"/>
<field name="rss_old_titles" type="int(11)" null="1"/>
<field name="rss_cache" type="int(11)" null="1"/>
<field name="fbdefaultpage" type="text" null="1"/>
<field name="default_sort" type="text" null="1"/>
<field name="alphauserpointsnumchars" type="int(11)" null="1"/>
<field name="sef" type="int(11)" null="1"/>
<field name="sefcats" type="int(11)" null="1"/>
<field name="sefutf8" type="int(11)" null="1"/>
<field name="showimgforguest" type="int(11)" null="1"/>
<field name="showfileforguest" type="int(11)" null="1"/>
<field name="pollnboptions" type="int(11)" null="1"/>
<field name="pollallowvoteone" type="int(11)" null="1"/>
<field name="pollenabled" type="int(11)" null="1"/>
<field name="poppollscount" type="int(11)" null="1"/>
<field name="showpoppollstats" type="int(11)" null="1"/>
<field name="polltimebtvotes" type="text" null="1"/>
<field name="pollnbvotesbyuser" type="int(11)" null="1"/>
<field name="pollresultsuserslist" type="int(11)" null="1"/>
<field name="maxpersotext" type="int(11)" null="1"/>
<field name="ordering_system" type="text" null="1"/>
<field name="post_dateformat" type="text" null="1"/>
<field name="post_dateformat_hover" type="text" null="1"/>
<field name="hide_ip" type="int(11)" null="1"/>
<field name="js_actstr_integration" type="int(11)" null="1"/>
<field name="imagetypes" type="text" null="1"/>
<field name="checkmimetypes" type="int(11)" null="1"/>
<field name="imagemimetypes" type="text" null="1"/>
<field name="imagequality" type="int(11)" null="1"/>
<field name="thumbheight" type="int(11)" null="1"/>
<field name="thumbwidth" type="int(11)" null="1"/>
<field name="hideuserprofileinfo" type="text" null="1"/>
<field name="integration_access" type="text" null="1"/>
<field name="integration_login" type="text" null="1"/>
<field name="integration_avatar" type="text" null="1"/>
<field name="integration_profile" type="text" null="1"/>
<field name="integration_private" type="text" null="1"/>
<field name="integration_activity" type="text" null="1"/>
<field name="boxghostmessage" type="int(11)" null="1"/>
<field name="userdeletetmessage" type="int(11)" null="1"/>
<field name="latestcategory_in" type="int(11)" null="1"/>
<field name="topicicons" type="int(11)" null="1"/>
<field name="onlineusers" type="int(11)" null="1"/>
<field name="debug" type="int(11)" null="1"/>
<field name="catsautosubscribed" type="int(11)" null="1"/>
<field name="showbannedreason" type="int(11)" null="1"/>
<field name="version_check" type="int(11)" null="1"/>
<field name="showthankyou" type="int(11)" null="1"/>
<field name="showpopthankyoustats" type="int(11)" null="1"/>
<field name="popthankscount" type="int(11)" null="1"/>
<field name="mod_see_deleted" type="int(11)" null="1"/>
<field name="bbcode_img_secure" type="text" null="1"/>
<field name="listcat_show_moderators" type="int(11)" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_discussbot">
<field primary_key="yes" name="content_id" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="section_id" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="catid" type="int(11)" null="0" default="0"/>
<field name="thread_id" type="int(11)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="content_id,section_id,catid"/>
</table>
<table name="kunena_favorites">
<field primary_key="yes" name="thread" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<key name="thread" unique="1" columns="thread,userid"/>
<key name="userid" columns="userid"/>
</table>
<table name="kunena_groups">
<field primary_key="yes" name="id" type="int(4)" null="0" extra="auto_increment"/>
<field name="title" type="varchar(255)" null="1"/>
<key name="PRIMARY" unique="1" columns="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(15)" 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="hold_time" columns="hold,time"/>
<key name="locked" columns="locked"/>
<key name="time" columns="time"/>
<key name="parent_hits" columns="parent,hits"/>
<key name="thread" columns="thread"/>
<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_moderation">
<field name="catid" type="int(11)" null="0" default="0"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="future1" type="tinyint(4)" null="1" default="0"/>
<field name="future2" type="int(11)" null="1" default="0"/>
</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" extra="on update CURRENT_TIMESTAMP"/>
<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"/>
<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"/>
<key name="PRIMARY" unique="1" columns="rank_id"/>
</table>
<table name="kunena_sessions">
<field 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="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_subscriptions">
<field name="thread" type="int(11)" null="0" default="0"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="future1" type="int(11)" null="1" default="0"/>
</table>
<table name="kunena_subscriptions_categories">
<field primary_key="yes" name="catid" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<field name="future1" type="int(11)" null="1" default="0"/>
<key name="thread" unique="1" columns="catid,userid"/>
<key name="userid" columns="userid"/>
</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="timestamp" null="0"/>
<key name="postid" unique="1" columns="postid,userid"/>
<key name="userid" columns="userid"/>
<key name="targetuserid" columns="targetuserid"/>
</table>
<table name="kunena_users">
<field 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(50)" 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="0000-00-00"/>
<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="hideEmail" type="tinyint(1)" null="0" default="1"/>
<field name="showOnline" type="tinyint(1)" null="0" default="1"/>
<field name="rank" type="tinyint(4)" null="0" default="0"/>
<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"/>
<key name="group_id" columns="group_id"/>
<key name="posts" columns="posts"/>
<key name="uhits" columns="uhits"/>
<key name="banned" columns="banned"/>
</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"/>
</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>
<table name="kunena_whoisonline">
<field primary_key="yes" name="id" type="int(6)" null="0" extra="auto_increment"/>
<field name="userid" type="int(7)" null="0" default="0"/>
<field name="time" type="varchar(14)" null="0" default="0"/>
<field name="item" type="int(6)" null="1" default="0"/>
<field name="what" type="varchar(255)" null="1" default="0"/>
<field name="func" type="varchar(50)" null="1"/>
<field name="do" type="varchar(50)" null="1"/>
<field name="task" type="varchar(50)" null="1"/>
<field name="link" type="text" null="1"/>
<field name="userip" type="varchar(20)" null="0" default=""/>
<field name="user" type="tinyint(2)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="userid" columns="userid"/>
<key name="userid_2" columns="userid"/>
</table>
</schema>

Last edit: 15 years 6 months ago by Matias.

Please Log in or Create an account to join the conversation.

thujahekk
Topic Author
Offline
Junior Member

15 years 6 months ago #64049 by thujahekk

Replied by thujahekk on topic Re: User statistics broken in K1.6

And yes.. you are right, the site was originally Joomla 1.0 some time back.

Please Log in or Create an account to join the conversation.

Matias
Offline
Administrator

15 years 6 months ago #64059 by Matias

Replied by Matias on topic Re: User statistics broken in K1.6

Put your site offline ASAP, as the issue is easier to fix if there are no changes in the forum.

Easiest and most robust way is to fix tables in Kunena 1.5 tables (jos_fb) and after that install Kunena 1.6 again.

The issue is that following tables have a broken/missing PRIMARY KEY (containing these fields):

kunena_moderation (catid,userid)
kunena_sessions (userid)
kunena_users (userid)

Please take backup before trying to fix them.. (will find out the queries, 10 mins)

Please Log in or Create an account to join the conversation.

Time to create page: 0.232 seconds