Kunena 6.2.6 released

The Kunena team has announce the arrival of Kunena 6.2.6 [K 6.2.6] which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

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.

Merged [Merged topic] An invalid post ID was requested

Requiem
Topic Author
Offline
Junior Member

13 years 9 months ago - 12 years 1 day ago #1 by Requiem

[Merged topic] An invalid post ID was requested was created by Requiem

After upgrade to 1.6

Attachments:

Last edit: 12 years 1 day ago by sozzled. Reason: Merge topics: change subject and topic icon

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

Matias
Offline
Administrator

13 years 9 months ago #2 by Matias

Replied by Matias on topic Re: An invalid post ID was requested

If you see this message, log in as administrator and Kunena will show you slightly different error message which asks you to enable debug mode (if admin gets the same error).

After you have enabled debug (either in Kunena or Joomla), you should see Joomla error page. Just copy its contents to this thread.

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

Requiem
Topic Author
Offline
Junior Member

13 years 9 months ago #3 by Requiem

Replied by Requiem on topic Re: An invalid post ID was requested

JDatabaseMySQL::query: 1054 - Unknown column 'p.id' in 'field list' SQL=SELECT a.*, b.*, p.id AS poll_id, modified.name AS modified_name, modified.username AS modified_username FROM jos_kunena_messages AS a LEFT JOIN jos_kunena_messages_text AS b ON a.id=b.mesid LEFT JOIN jos_users AS modified ON a.modified_by = modified.id LEFT JOIN jos_kunena_polls AS p ON a.id=p.threadid WHERE a.id='3417' AND a.hold IN (0,1,2)

Call stack
# Function Location
1 JSite->dispatch() Z:\home\myjob\www\index.php:68
2 JComponentHelper->renderComponent() Z:\home\myjob\www\includes\application.php:124
3 require_once() Z:\home\myjob\www\libraries\joomla\application\component\helper.php:162
4 KunenaApp->__construct() Z:\home\myjob\www\components\com_kunena\kunena.php:698
5 CKunenaView->display() Z:\home\myjob\www\components\com_kunena\kunena.php:418
6 CKunenaView->getView() Z:\home\myjob\www\components\com_kunena\funcs\view.php:683
7 JDatabaseMySQL->loadObject() Z:\home\myjob\www\components\com_kunena\funcs\view.php:340
8 JDatabaseMySQL->query() Z:\home\myjob\www\libraries\joomla\database\database\mysql.php:435
9 JError->raiseError() Z:\home\myjob\www\libraries\joomla\database\database\mysql.php:231
10 JError->raise() Z:\home\myjob\www\libraries\joomla\error\error.php:171
11 JException->__construct() Z:\home\myjob\www\libraries\joomla\error\error.php:136

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

Requiem
Topic Author
Offline
Junior Member

13 years 9 months ago - 13 years 9 months ago #4 by Requiem

Replied by Requiem on topic Re: An invalid post ID was requested

I fix this bug аnd now have another one

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND s.client_id = 0 GROUP BY s.userid' at line 1 SQL=SELECT s.userid, MAX(s.time) AS time FROM jos_session AS s WHERE s.userid IN (64,63,277,393,1041,1087,) AND s.client_id = 0 GROUP BY s.userid

Call stack
# Function Location
1 JSite->dispatch() Z:\home\myjob\www\index.php:68
2 JComponentHelper->renderComponent() Z:\home\myjob\www\includes\application.php:124
3 require_once() Z:\home\myjob\www\libraries\joomla\application\component\helper.php:162
4 KunenaApp->__construct() Z:\home\myjob\www\components\com_kunena\kunena.php:698
5 CKunenaView->display() Z:\home\myjob\www\components\com_kunena\kunena.php:418
6 CKunenaTools->loadTemplate() Z:\home\myjob\www\components\com_kunena\funcs\view.php:693
7 require() Z:\home\myjob\www\components\com_kunena\class.kunena.php:917
8 CKunenaView->displayMessage() Z:\home\myjob\www\components\com_kunena\template\default\view\view.php:49
9 CKunenaViewMessage->display() Z:\home\myjob\www\components\com_kunena\funcs\view.php:634
10 CKunenaTools->loadTemplate() Z:\home\myjob\www\components\com_kunena\funcs\view.php:264
11 require() Z:\home\myjob\www\components\com_kunena\class.kunena.php:917
12 CKunenaViewMessage->displayProfile() Z:\home\myjob\www\components\com_kunena\template\default\view\message.php:92
13 CKunenaTools->loadTemplate() Z:\home\myjob\www\components\com_kunena\funcs\view.php:93
14 require() Z:\home\myjob\www\components\com_kunena\class.kunena.php:917
15 KunenaUser->isOnline() Z:\home\myjob\www\components\com_kunena\template\default\view\message.profilebox.php:56
16 JDatabaseMySQL->loadObjectList() Z:\home\myjob\www\administrator\components\com_kunena\libraries\user.php:264
17 JDatabaseMySQL->query() Z:\home\myjob\www\libraries\joomla\database\database\mysql.php:458
18 JError->raiseError() Z:\home\myjob\www\libraries\joomla\database\database\mysql.php:231
19 JError->raise() Z:\home\myjob\www\libraries\joomla\error\error.php:171
20 JException->__construct() Z:\home\myjob\www\libraries\joomla\error\error.php:136

Last edit: 13 years 9 months ago by Requiem.

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

xillibit
Offline
Administrator

13 years 9 months ago #5 by xillibit

Replied by xillibit on topic Re: An invalid post ID was requested

You said that you have fixed the bug, but how do you have done this ?

Do you migrate from k1.5 with hack poll ?

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.

Requiem
Topic Author
Offline
Junior Member

13 years 9 months ago - 13 years 9 months ago #6 by Requiem

Replied by Requiem on topic Re: An invalid post ID was requested

My fix

Code:

ALTER TABLE `jos_kunena_polls` CHANGE `pollid` `id` INT( 11 ) DEFAULT NULL AUTO_INCREMENT

Maybe it`s no correct, i don`t check other code

I migrate without hack poll.

UPD
I update 1.5.3 to 1.5.12 and migrate to 1.6

Last edit: 13 years 9 months ago by Requiem.

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

xillibit
Offline
Administrator

13 years 9 months ago #7 by xillibit

Replied by xillibit on topic Re: An invalid post ID was requested

The correct table structure for the table jos_kunena_polls is :

Code:

CREATE TABLE IF NOT EXISTS `#__kunena_polls` (
				`id` int(11) NOT NULL auto_increment,
				`title` varchar(100) NOT NULL,
				`threadid` int(11) NOT NULL,
				`polltimetolive` timestamp,
				PRIMARY KEY  (`id`),
				KEY `threadid` (`threadid`)
			) DEFAULT CHARSET=utf8;

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.

Sjaak Boer
Offline
New Member

13 years 7 months ago #8 by Sjaak Boer

Replied by Sjaak Boer on topic An invalid post ID was requested.

Since I upgraded the forum on my website to 1.6 I get this message with new topics. I am not able to read them.

What can be wrong?

Thanks

Sjaak

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

Cerberus
Offline
Elite Member

13 years 7 months ago #9 by Cerberus

Replied by Cerberus on topic Re: An invalid post ID was requested.

Please post the configuration report from K1.6 admin menu. If you have installed k1.6 on a live production site i would recommend that you uninstall it again as the RC1 is not yet safe for production site.

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

Sjaak Boer
Offline
New Member

13 years 7 months ago #10 by Sjaak Boer

Replied by Sjaak Boer on topic Re: An invalid post ID was requested.

Here is the configuration report:

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: Enabled |
This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 32M | Max file upload: 2M

Kunena version detailled: Installed version: 1.6.0-RC1 | Build: 3173 | Version name: Kujadili | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]
board_title Artlantisobjects.com forum

board_offline 0

board_ofset 0

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 0

historylimit 6

shownew 0

jmambot 0

disemoticons 0

template example

showannouncement 0

avataroncat 0

catimagepath category_images/

showchildcaticon 1

annmodid 62

rtewidth 450

rteheight 300

enableforumjump 1

reportmsg 1

username 0

askemail 0

showemail 0

showuserstats 0

showkarma 0

useredit 1

useredittime 600

useredittimegrace 600

editmarkup 1

allowsubscriptions 1

subscriptionschecked 1

allowfavorites 1

maxsubject 50

maxsig 250

regonly 0

changename 0

pubwrite 0

floodprotection 0

mailmod 0

mailadmin 0

captcha 0

mailfull 1

allowavatar 1

allowavatarupload 1

allowavatargallery 1

imageprocessor none

avatarquality 65

avatarsize 200

allowimageupload 0

allowimageregupload 1

imageheight 800

imagewidth 800

imagesize 400

allowfileupload 0

allowfileregupload 1

filetypes zip,txt,doc,gz,tgz,jpg,png,tga,rar

filesize 2000

showranking 1

rankimages 1

avatar_src fb

fb_profile fb

pm_component uddeim

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 1

latestcategory

showstats 0

showwhoisonline 1

showgenstats 0

showpopuserstats 1

popusercount 5

showpopsubjectstats 1

popsubjectcount 5

usernamechange 0

rules_infb 1

rules_cid 243

rules_link www.kunena.com/

help_infb 0

help_cid 1

help_link www.kunena.com/

showspoilertag 0

showvideotag 1

showebaytag 0

trimlongurls 1

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 0

ebaylanguagecode en-us

fbsessiontimeout 900

highlightcode 0

rss_type thread

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_word_count 0

rss_old_titles 1

fbdefaultpage categories

default_sort asc

alphauserpoints 0

alphauserpointsrules 0

alphauserpointsnumchars 0

sef 1

sefcats 1

sefutf8 0

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 old_ord

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 auto

integration_avatar auto

integration_profile auto

integration_private auto

integration_activity auto

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

onlineusers 1

debug 0

catsautosubscribed 0

showbannedreason 0

version_check 1

showthankyou 1

showpopthankysoustats 1

popthankscount 5

mod_see_deleted 0

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

Time to create page: 0.447 seconds