Solved Problems after migration from J! 1.5

Hi guys,

i'm trying to upgrade a 1.5 site with kunena, i imported all the old tables as writtem here:
webilicious.com.au/kunena-migration

But when i log in, i get these errors:


Table 'namedb.j25_kunena_configuration' doesn't exist SQL=SELECT * FROM j25_kunena_configuration WHERE id=1
Table 'namedb.j25_kunena_user_categories' doesn't exist SQL=SELECT user_id, category_id, role FROM j25_kunena_user_categories WHERE role IN (1,2)


Do you know why...?

Thnks guys and merry Xmas to everyone! :laugh:

G'day, d4rkcloud, and welcome to Kunena.

What tool did you use to migrate from J! 1.5? What version of Kunena are you using now and what version of Joomla are you using now. Have you watched the video vimeo.com/69818669 ?

The short answer to your question is, based on the information you've given us, no, Idon't know why you're getting this error. Sounds like it was a Joomla migration gone wrong to me. :dry:

Hi Sozzled,

thanks for answering so quickly!
I installed kunena 3.0.3 in joomla 2.5.17, the old version was the 1.5.6 in joomla 1.5.26.
I used jupgrade and this is the configuration report:

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

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

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 48M | Max file upload: 32M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
158	Forum	kunenamenu	view=home&defaultmenu=160	kunena
159	Indice delle categorie	kunenamenu	view=category&layout=list	kunena/home
160	Discussioni recenti	kunenamenu	view=topics&mode=replies	kunena/recente
161	Nuova discussione	kunenamenu	view=topic&layout=create	kunena/nuovadiscussione
162	Senza risposta	kunenamenu	view=topics&mode=noreplies	kunena/senzarisposte
163	Mie discussioni	kunenamenu	view=topics&layout=user&mode=default	kunena/mierecenti
164	Profilo	kunenamenu	view=user	kunena/profilo
165	Aiuto	kunenamenu	view=misc	kunena/aiuto
166	Ricerca	kunenamenu	view=search	kunena/cerca
167	Forum	mainmenu	Itemid=158	kunena-2013-12-24
66	Forum CTL	mainmenu	option=com_kunena	forum-ctl

Joomla default template details : gantry | author: RocketTheme, LLC | version: 4.1.10 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.3 | creationdate: 2013-10-20

Kunena version detailed: Kunena 3.0.3 | 2013-10-20 [ Bifrost ]
| 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	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
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	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
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	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
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	50
thumbheight	32
thumbwidth	32
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	0
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	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	1
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	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
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)
it-IT	Italian (IT)

Third-party components: CommunityBuilder 1.2.1

Third-party SEF components: None

Plugins: None

Modules: None

I hope there's everything here....

Thanks!!!

You can't use Community Builder 1.2.1 with J! 2.5.17 and you definitely cannot use CB 1.2.1 with K 3.0.4. Before you do anything else, make a decision to upgrade CB or uninstall it.

Next step is to upgrade to K 3.0.4.

Last of all, get rid of the conflicting Kunena menu item. The FAQs page will show you how to restore the standard Kunena menu.

After you've done those things, you need to go though, category by category, each of you forum categories and fix the permissions; these things should take a couple of hours.

Ok Sozzled, installed CB 1.9.1 and installed Kunena 3.0.4.
The item menu seems to be ok and the previus error vanished.
In the admin panel i don't see any category. Now you say i should fix the permissions, category by category.
You mean in the ftp? where do i find these categories to fix?

My report:

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

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

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 48M | Max file upload: 32M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
158	Forum	kunenamenu	view=home&defaultmenu=160	kunena
159	Indice delle categorie	kunenamenu	view=category&layout=list	kunena/home
160	Discussioni recenti	kunenamenu	view=topics&mode=replies	kunena/recente
161	Nuova discussione	kunenamenu	view=topic&layout=create	kunena/nuovadiscussione
162	Senza risposta	kunenamenu	view=topics&mode=noreplies	kunena/senzarisposte
163	Mie discussioni	kunenamenu	view=topics&layout=user&mode=default	kunena/mierecenti
164	Profilo	kunenamenu	view=user	kunena/profilo
165	Aiuto	kunenamenu	view=misc	kunena/aiuto
166	Ricerca	kunenamenu	view=search	kunena/cerca
167	Forum	mainmenu	Itemid=158	kunena-2013-12-24
66	Forum CTL	mainmenu	view=home&defaultmenu=158	forum-ctl

Joomla default template details : gantry | author: RocketTheme, LLC | version: 4.1.10 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.4 | creationdate: 2013-12-22

Kunena version detailed: Kunena 3.0.4 | 2013-12-22 [ Ukko ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	18
messages_per_page_search	20
showhistory	1
historylimit	10
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	0
reportmsg	0
username	1
askemail	0
showemail	1
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	1
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	70
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	zip,txt,doc,gz,tgz
filesize	120
showranking	1
rankimages	1
userlist_rows	50
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	0
showgenstats	1
showpopuserstats	1
popusercount	10
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
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	50
thumbheight	32
thumbwidth	32
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	0
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	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	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
board_ofset	0
default_view	flat
enablepdf	1
newchar	NEW!
jmambot	0
templateimagepath	default_ex
joomlastyle	0
numchildcolumn	0
annmodid
enablerulespage	0
poststats	1
statscolor	1
wrap	80
changename	0
allowavatar	1
imageprocessor	gd2
avatarsmallheight	60
avatarsmallwidth	60
avatarheight	100
avatarwidth	100
avatarlargeheight	250
avatarlargewidth	250
allowimageupload	0
allowimageregupload	1
allowfileupload	0
allowfileregupload	1
cb_profile	0
discussbot	0
userlist_username	1
userlist_group	0
userlist_usertype	0
showlatest	1
latestcount	10
latestcountperpage	5
latestsinglesubject	1
latestreplysubject	1
latestsubjectlength	100
latestshowdate	1
latestshowhits	1
latestshowauthor	1
rules_infb	0
rules_cid	0
rules_link	no
enablehelppage	0
help_infb	0
help_cid	0
help_link	NO
fbsessiontimeout	1800
rsstype	post
rsshistory	month
fbdefaultpage	categories
integration_avatar	kunena
integration_access	joomla
integration_login	joomla
integration_profile	kunena
integration_activity	none
integration_private	uddeim

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
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)
it-IT	Italian (IT)

Third-party components: CommunityBuilder 1.9.1

Third-party SEF components: None

Plugins: None

Modules: None

Hope you can help me to handle this!

Thnak you very much!

The biggest problem that people have, after migrating from J! 1.5, is caused by the fact that J! 1.5 did not have ACLs. After migrating from J! 1.5 to any later version of Joomla, you need to use the Kunena Category Manager to reset all the forum section and category permissions again.

This problem is discussed in the topic K 3.0: "There are no published categories in ." message . The answers you are looking for are all there.