Question Missing messages in database

Hello, I am trying to move from joomla 2.5 (server 1) to 3.x (server 2). The problem is that after the import of the kunena tables, I am missing the last 40 messages. However... the strange thing is.. they are also missing on server 1! When I check the forum on the frontside, the last message had ID 1654, while when I check in PHPmyAdmin the last ID is 1614, where is the rest? I really have no clue, does Kunena save the last 50 messages or so in a textile?

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

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: 25M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
397	Index	jomsocial	view=category&catid=0&layout=list	forum-profile/index
392	Recente Berichten	jomsocial	view=topics&layout=default&mode=replies	forum-profile/recent
393	Geen Reacties	jomsocial	view=topics&layout=default&mode=noreplies	forum-profile/noreplies
394	Mijn Berichten	jomsocial	view=topics&layout=user&mode=default	forum-profile/mylatest
395	Profiel	jomsocial	view=user	forum-profile/profile
396	Zoek...	jomsocial	view=search	forum-profile/search
295	Forum	kunenamenu	view=home&defaultmenu=296	forum
296	Index | Forum	kunenamenu	view=category&catid=0&layout=list	forum/index
297	Recente Berichten	kunenamenu	view=topics&mode=replies	forum/recent
298	Nieuw Bericht	kunenamenu	view=topic&layout=create&catid=	forum/newtopic
299	Geen Reacties	kunenamenu	view=topics&layout=default&mode=noreplies	forum/noreplies
300	Mijn Berichten	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
301	Profiel	kunenamenu	view=user	forum/profile
302	Rules	kunenamenu	view=misc	forum/rules
303	Help	kunenamenu	view=misc	forum/help
304	Zoek...	kunenamenu	view=search	forum/search
233	Profile	jomsocial	view=user	profile
353	Forum	mainmenu-gb	view=home&defaultmenu=232	2012-11-08-15-18-32/forum-index
358	Forum	mainmenu-es	view=home&defaultmenu=232	i-am-magnetic-es/forum-index
461	Forum	mainmenu-it	view=home&defaultmenu=232	i-am-magnetic-it/forum-index
623	Forum	main-menu-ru	view=home&defaultmenu=232	2012-11-08-15-18-33/forum-index
634	Forum	mainmenu-de	view=home&defaultmenu=192	2013-06-10-12-11-54/forum-index
644	Forum	menu-fr	view=home&defaultmenu=232	2012-11-08-15-18-35/forum-index

Joomla default template details : yoo_cloud | author: YOOtheme | version: 1.0.7 | creationdate: Unknown

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

Kunena version detailed: Kunena 3.0.6 | 2014-07-28 [ Tala ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	15
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
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	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	300
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	800
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	15
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	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
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	10
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:10: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	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	2
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
show_list_time	720
show_session_type	1
show_session_starttime	60
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	10
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	0
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	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
userlist_usertype	0
sefutf8	0
changename	0
enablepdf	1
jmambot	0
annmodid	62
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Enabled: activity=1 avatar=1 profile=1 activity_points_limit=0
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1
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 Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
de-DE	German (DE-CH-AT)
en-GB	English (United Kingdom)
es-ES	Español
fr-FR	Français (FR)
it-IT	Italian (IT)
nl-NL	Dutch (NL)
pt-BR	Português (BR)
ru-RU	Russian

Third-party components: Jomsocial 2.4.1

Third-party SEF components: sh404sef 3.6.4.1481 | AceSEF 2.5.4

Plugins: Content - Kunena Discuss 1.7.2 | JomSocial - My Kunena Forum Menu 2.0.1 | JomSocial - My Kunena Forum Posts 2.0.1

Modules: None

Hello,

When you look directly on the forum, do-you see that messages are missing ?

No, the messages are perfectly visible. I just can't find them in PhpMyAdmin. Even if I search for strings or single words, nothing.... The last 40 messages are nowhere to be found in the Kunena message tables

I see on your phpMyAdmin-image that the numbering is messed up. Choose the sorting by ID. But it seems you have the field "parent" marked on this image.

Oops wrong column marked indeed, but the order of the ID column is ok, as you see. After I export and import into Joomla 3 on a different server I still miss those messages.

when you copy from the other server, it should be the same. So i can only say, please try again.

Tyjeco wrote: Oops wrong column marked indeed, but the order of the ID column is ok, as you see. After I export and import into Joomla 3 on a different server I still miss those messages.

I think I understand what you are trying to say even if the moderators do not understand.

If we look at your your earlier image and we look at the correct column, we see that the last record in the database has the ID 1614:



The topic subject of message ID 1614 is "lostaten van de nagel door psoriasis".

If you look at the second image that you posted in msg #3 above, the topic subject is "Examens".

According to the information you have given, you should look in the topic lostaten van de nagel door psoriasis to find message #1614.

Tyjeco wrote: Does Kunena save the last 50 messages or so in a text file?

No, Kunena does not "store the last x messages in a text file"; the forum posts are stored in the database table _kunena_messages.

For your information, AceSEF 2.5.4 and sh404SEF 3.6.4.1481 should not be used together and they do not work with K 3.0.

I hope some of this information helps.

Look at the index page, and check the total messages, then check other server, if the total is the same, then you have all messages.

Go to *_kunena_messages_text
if you order the table by message id, then you will find the last message id.