Merged [Merged topic] An invalid post ID was requested

After upgrade to 1.6

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.

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

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

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

Do you migrate from k1.5 with hack poll ?

My fix

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