Question Rough Installation

I have upgraded from 1.5 to 1.6 and had a few problems. I think I still have some database table problems but want to know if I should do an uninstall/reinstall to fix. After upgrading I renamed quite a few of my old tables to match the new ones. This was because none of my messages, categories and users were showing up. I have them showing up now but get pink error codes. Here is my report info and after is the general joomla debug info. I have spent 7 hours trying to figure things out. Thanks in advance for your help.

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 64M | Max file upload: 20M

Joomla default template details : coolness | author: jh! design | version: 1.0 | creationdate: August 28 2009

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.4 | creationdate: 2011-05-07

Kunena version detailled: Installed version: 1.6.4 | Build: 4832 | Version name: Kerkrade | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	International 2.4 Metre
board_offline	1
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> <div>Check back soon!</div>
enablerss	0
enablepdf	0
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	default
showannouncement	0
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	1
useredit	1
useredittime	500
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	0
allowavatargallery	0
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	4000
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
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	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	0
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	109
help_infb	1
help_cid	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	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
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	5
sef	0
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	0
poppollscount	5
showpoppollstats	0
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	auto
integration_login	none
integration_avatar	communitybuilder
integration_profile	communitybuilder
integration_private	uddeim
integration_activity	communitybuilder
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	0
onlineusers	1
debug	1
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
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

Third-party components: CommunityBuilder 1.4 | UddeIm: The file doesn't exist uddeim.j15.xml !

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Enabled | System - Mootools12: Disabled

Modules: None

500 - JDatabaseMySQL::query: 1054 - Unknown column 'id' in 'order clause' SQL=SELECT * FROM 24mr_kunena_attachments WHERE mesid IN (82,81) ORDER BY id

JDatabaseMySQL::query: 1054 - Unknown column 'id' in 'order clause' SQL=SELECT * FROM 24mr_kunena_attachments WHERE mesid IN (82,81) ORDER BY id

Call stack
# Function Location
1 JSite->dispatch() /home/metre24/public_html/index.php:68
2 JComponentHelper->renderComponent() /home/metre24/public_html/includes/application.php:124
3 require_once() /home/metre24/public_html/libraries/joomla/application/component/helper.php:162
4 KunenaApp->__construct() /home/metre24/public_html/components/com_kunena/kunena.php:881
5 CKunenaView->display() /home/metre24/public_html/components/com_kunena/kunena.php:504
6 CKunenaView->getView() /home/metre24/public_html/components/com_kunena/funcs/view.php:820
7 CKunenaAttachments->get() /home/metre24/public_html/components/com_kunena/funcs/view.php:568
8 JDatabaseMySQL->loadObjectList() /home/metre24/public_html/components/com_kunena/lib/kunena.attachments.class.php:121
9 JDatabaseMySQL->query() /home/metre24/public_html/libraries/joomla/database/database/mysql.php:458
10 JError->raiseError() /home/metre24/public_html/libraries/joomla/database/database/mysql.php:231
11 JError->raise() /home/metre24/public_html/libraries/joomla/error/error.php:171
12 JException->__construct() /home/metre24/public_html/libraries/joomla/error/error.php:136

rclew4u wrote: After upgrading I renamed quite a few of my old tables to match the new ones.

I don't like the sound of this. Which tables did you rename? What were they named before and what are they named as now?

I named the new files with the addition of _old, so they are still intact. I just renamed most of the folders from the 1.5 installation to match the name of the new folders before I added _old to them. Example: new table was kunena_messages_text, now it is kunena_messages_text_old. then I changed my old file, fb_messages_text to kunena_messages_text

No wonder things won't work. The structure of the database tables between K 1.5 and K 1.6 has completely changed!

In K 1.5 the tables were named XXX_fb_*

In K 1.6 the tables are named XXX_kunena_*

Renaming "fb" tables as "kunena" tables simply will not work and it's no surprise that you have HTTP 500 server errors.

Is there a doc which explains how to migrate the data from the old tables to the new? I assumed the upgrade would do this but the new tables were empty.

The installation process takes care of these things. There is no need for people to tinker around with MySQL databases. The upgrade process is described in K 1.6 Upgrade Guide .

My suggestion to you is

(1) Restore your site from the backup that you made before you upgraded to K 1.6.4.
(2) Read the tutorial K 1.6 Upgrade Guide
(3) Check that the installation completed successfully
(4) Check that your site works.

It is possible that, in some rare cases, some messages may have lost their attachments in K 1.5 before you do the upgrade. It's also possible that, in some rare cases, the occasional attachment from a K 1.5 message may get lost or misplaced during the upgrade. Anything's possible.

What is most uncommon - in fact, I think you are the first person to describe the symptom - is the disappearance of messages, categories and users as a result of upgrading Kunena. So, can we try the exercise again (go back to the backup that you took immediately before upgrading K 1.5 -> K 1.6), do the upgrade again and this time look for any error messages that occur during the upgrade. I hope this helps.