×
Blue Eagle 1.5.2 Released (Yesterday)

The Kunena team has announce the arrival of Kunena Blue Eagle 1.5.2 which is now available for download as a native Joomla extension for Kunena 5.1. This version addresses most of the issues that were discovered in K 1.5.1 and issues discovered during the development stages of K 1.5.2.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Solved Problems after migration from J! 1.5

More
4 years 11 months ago #1 by d4rkcloud
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:

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

  • sozzled
  • Visitor
4 years 11 months ago - 4 years 11 months ago #2 by sozzled
Replied by sozzled on topic Problems after migration from J! 1.5
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:
Last edit: 4 years 11 months ago by sozzled.

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

More
4 years 11 months ago #3 by d4rkcloud
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:

This message contains confidential information

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! [ Click to expand ]

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! [ Click to expand ]
| Kunena integration settings:
Warning: Spoiler! [ Click to expand ]
| Joomla! detailed language files installed:
Warning: Spoiler! [ Click to expand ]

Third-party components: CommunityBuilder 1.2.1

Third-party SEF components: None

Plugins: None

Modules: None


I hope there's everything here....

Thanks!!!

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

  • sozzled
  • Visitor
4 years 11 months ago - 4 years 11 months ago #4 by sozzled
Replied by sozzled on topic Problems after migration from J! 1.5
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.
Last edit: 4 years 11 months ago by sozzled.

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

More
4 years 11 months ago #5 by d4rkcloud
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:
This message contains confidential information

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! [ Click to expand ]

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! [ Click to expand ]
| Kunena integration settings:
Warning: Spoiler! [ Click to expand ]
| Joomla! detailed language files installed:
Warning: Spoiler! [ Click to expand ]

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!

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

  • sozzled
  • Visitor
4 years 11 months ago - 4 years 11 months ago #6 by sozzled
Replied by sozzled on topic Problems after migration from J! 1.5
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.
Last edit: 4 years 11 months ago by sozzled.

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

More
4 years 11 months ago #7 by d4rkcloud
Ok, i tried to create a new category to use as top level, but...
in the panel where i define the new category i see this error:
Unknown column 'parent_id' in 'where clause' SQL=SELECT a.id, a.name FROM j25_kunena_categories AS a WHERE parent_id='0' AND id!='0' ORDER BY ordering

And when i try to save, i get this error:
Saving category 0 failed: TableKunenaCategories::store() failed - Unknown column 'parent_id' in 'field list' SQL=INSERT INTO `j25_kunena_categories` (`id`,`parent_id`,`name`,`alias`,`locked`,`accesstype`,`access`,`pub_access`,`pub_recurse`,`admin_access`,`admin_recurse`,`ordering`,`published`,`review`,`allow_anonymous`,`post_anonymous`,`description`,`headerdesc`,`class_sfx`,`allow_polls`,`params`) VALUES ('0','0','Provincia','provincia','0','joomla.level','1','1','1','8','1','99999','0','0','0','0','','','','0','{}')

It doesn't let me save anything.
What's wrong...? :dry:

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

  • sozzled
  • Visitor
4 years 11 months ago - 4 years 11 months ago #8 by sozzled
Replied by sozzled on topic Problems after migration from J! 1.5

d4rkcloud wrote: What's wrong? :dry:

I do not know what's wrong. I have not encountered a situation like yours before. It sounds like your SQL tables have something wrong. It sounds like you may need to undertake some detailed analysis of your database tables. There are diagnostic tools available in Kunena that may assist you. (Please note that I have not used these tools and I do not know how to interpret the results.) See Diagnostic tool and Database schema tool .
Last edit: 4 years 11 months ago by sozzled.

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

More
4 years 11 months ago #9 by d4rkcloud
Ok, in the diagnostic tools i see these problems:
topicMissingCategory TEST FAILED 1 issues
topicMissingMessages TEST FAILED 1 issues DELETE BROKEN ITEMS
messageOrphaned TEST FAILED 25608 issues DELETE BROKEN ITEMS


All the other items are ok!
In the layout scheme i don't see any error.
Should i copy it here?

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

  • sozzled
  • Visitor
4 years 11 months ago #10 by sozzled
Replied by sozzled on topic Problems after migration from J! 1.5
I don't think we want to see a few thousand lines of text posted here on the forum, no, thank you. :lol:

In short, your response confirms my suspicion that you have problems within the database.

To fix this problem means we need to roll up our sleeves and get involved in some creative database repair work. From the looks of things, you have a missing record in the table _kunena_categories. Because you have a missing record, other records in the database contain references to something that doesn't exist. It's my guess that, using a tool like phpMyAdmin, you could patch the database by re-creating the missing information so that the database integrity is restored. As I am sure you would appreciate, doing this kind of work is outside the "standard" support service we offer here in a "question-and-answer forum". This kind of work is specialised, it's one-on-one and it's time-consuming.

I cannot make any guarantees that I could fix this particular problem for you and I cannot give you a reliable estimate of how much time would be involved, either. I think that we're talking a couple of hours.

What do you have to say to this? Would this be worth paying someone else to look at your current situation to see if it's feasible to rectify the problem you now have? As you know, this time of the year is the holiday season and there may be a shortage of skilled specialists available to assist you. I'm only guessing (I can't say for sure) but I think we're talking less than $100.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.123 seconds