Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.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

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question Unknown column 'moved'

More
15 years 3 months ago - 15 years 3 months ago #81894 by brady8
Hello,

Using Joomla 1.5, and installed Kunena 1.6.2, migrating from a previous Fireboard installation. Everything migrated fine, and forums and posts are all there. Problem shows up when logged out of the site and viewing the forums: A 500 error:

"500 - JDatabaseMySQL::query: 1054 - Unknown column 'm.moved' in 'where clause' SQL=Select COUNT(DISTINCT t.thread) FROM jos_kunena_messages AS t INNER JOIN jos_kunena_messages AS m ON m.id=t.thread WHERE m.moved='0' AND m.hold IN (0) AND m.catid IN (2,3,4,6,12,17,511,512,513,515,516,517,518,519,527,529) AND t.hold IN (0) AND t.moved=0 AND t.catid IN (2,3,4,6,12,17,511,512,513,515,516,517,518,519,527,529) AND t.time>'1292836595'"


Config report below... any help would be greatly appreciated!

This message contains confidential information

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

Legacy mode: Disabled | 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: 90M | Max file upload: 7M

This message contains confidential information

Joomla default template details : rhuk_milkyway | author: Andy Miller | version: 1.0.2 | creationdate: 11/20/06

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.2 | creationdate: 2010-12-29

Kunena version detailled: Installed version: 1.6.2 | Build: 3894 | Version name: Team | Kunena detailled configuration:

Warning: Spoiler!

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Disabled or not installed | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Third-party SEF components: sh404sef: Disabled or not installed | ARTIO JoomSEF: Disabled or not installed | AceSEF: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Disabled or not installed | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

Last edit: 15 years 3 months ago by brady8.

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

More
15 years 3 months ago #81933 by xillibit
Replied by xillibit on topic Re: Unknown column 'moved'
Hello,

Check in your table jos_kunena_messages that you have right a colunm nammed moved

I don't provide support by PM, because this can be useful for someone else.

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

Time to create page: 0.219 seconds