Kunena 7.0.8 Released
The Kunena team has announce the arrival of Kunena 7.0.8 [K 7.0.8] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.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
Question Database error
- Oscarfishlover
-
Topic Author
- Offline
- Premium Member
-
Less
More
17 years 2 months ago #19666
by Oscarfishlover
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Database error was created by Oscarfishlover
I made a copy of my database from my 1.015 jumble website. Made a fresh install of 1.5 and then reinstalled the database from 1.015 and then got this message
jtablesession::Store Failed
DB function failed with error number 1054
Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'nl6t4hs9vhf58pbai5u5j4c041','1245012096','','0','1','0' )
I did exactly the same on a website without the Kunena forum installed and it worked perfectly okay, installed all my old information very easily and quickly.
jtablesession::Store Failed
DB function failed with error number 1054
Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'nl6t4hs9vhf58pbai5u5j4c041','1245012096','','0','1','0' )
I did exactly the same on a website without the Kunena forum installed and it worked perfectly okay, installed all my old information very easily and quickly.
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Please Log in or Create an account to join the conversation.
17 years 2 months ago #19671
by Matias
Replied by Matias on topic Re: Database error
This has nothing to do with Kunena (it never uses jos_session). You should not use J!1.0 database with J!1.5 without migrating it to the new version.
Please Log in or Create an account to join the conversation.
- Oscarfishlover
-
Topic Author
- Offline
- Premium Member
-
17 years 2 months ago #19682
by Oscarfishlover
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Replied by Oscarfishlover on topic Re:Database error
thanks for the clarification on that. However, I have been using migrator to upgrade all my 1.0 websites However none of them have forum installed. Someone suggested I use MTWmigrate. I was thinking of may be setting up a 1.5 site on a temporary domain, and then using MTW migrate to import everything from the 1.0 site. And then move the new 1.5 onto its domain.But am I right in saying that MTW migrate does not move components across? But it will migrate the forum database tables?
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Please Log in or Create an account to join the conversation.
17 years 2 months ago #19735
by Matias
Replied by Matias on topic Re:Database error
I've never upgraded J1.0 to 1.5, so someone else has to give answer to this question.
Please Log in or Create an account to join the conversation.
- Oscarfishlover
-
Topic Author
- Offline
- Premium Member
-
17 years 2 months ago #19762
by Oscarfishlover
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Replied by Oscarfishlover on topic Re:Database error
What I've done for the moment is migrate (on a test site)the 1.0 site to the 1.5 sites. Even though Kunena was installed on the 1.0 site, the migration has not included Kunena tables in the database. I'm assuming this is because the migration is only effective on Joomla itself. Now since I cannot find any correspondence whatsoever, I'm working in the dark wearing a blindfold at the same time. So I was thinking that maybe I should install the latest version of kumnena on my new 1.5 site, and then import the Kunena tables from the old 1.0 site and drop them into the new 1.5 database overwriting the existing Kunena tables.
How does that sound?
How does that sound?
The #1 Oscar Fish website on the net
Joomla! 2.5.14
Kunena 3.0.2
Please Log in or Create an account to join the conversation.
17 years 2 months ago #19790
by Matias
Replied by Matias on topic Re:Database error
1) Import/copy all jos_fb_* tables to your new site.
2) Do this for each table (if they are not yet UTF8): ALTER TABLE jos_fb_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
3) Install latest Kunena
It's important that you install Kunena AFTER doing the first two steps.
2) Do this for each table (if they are not yet UTF8): ALTER TABLE jos_fb_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
3) Install latest Kunena
It's important that you install Kunena AFTER doing the first two steps.
Please Log in or Create an account to join the conversation.
Time to create page: 0.219 seconds