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

Question MySQL Syntax Error

More
17 years 2 months ago - 17 years 2 months ago #1757 by Lintzy
MySQL Syntax Error was created by Lintzy
The user dazzafact gets a Fatal Error on his Website (php:5 mysql:5.0.67: Joomla:1.5.9)

Fatal error: Unable to load messages.\nDB function failed with error number 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 'SELECT thread, MAX(time) AS lastpost FROM joom SQL=SELECT a.thread, a.subject, b.lastpost FROM joomla_fb_messages AS a JOIN ( SELECT thread, MAX(time) AS lastpost FROM joomla_fb_messages WHERE time >'1231498817' AND hold=0 AND moved=0 AND catid IN (1,2,3,5) GROUP BY 1) AS b ON b.thread = a.thread WHERE a.parent=0 AND a.moved=0 AND a.hold=0 GROUP BY a.thread ORDER BY b.lastpost DESC LIMIT 100
SQL =

SELECT
a.thread,
a.subject,
b.lastpost
FROM
joomla_fb_messages AS a
JOIN ( SELECT thread, MAX(time) AS lastpost
FROM joomla_fb_messages
in /www/htdocs/v120358/joomla/components/com_kunena/lib/kunena.debug.php on line 37

:blink: Now, it is another error message:
jtablesession :: Store Failed
DB function failed with error number 1146
Table 'v120358.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '62485884bd903d89a14b27ca3c32d6b3','1234092662','','0','1','0' )
Last edit: 17 years 2 months ago by Lintzy.

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

More
17 years 2 months ago - 17 years 2 months ago #1844 by Lintzy
Replied by Lintzy on topic Re:MySQL Syntax Error
Any Idea? We have tried to find the solution by installing from folder /tmp on server. Before all has been deleted in Database and on server (old Fireboard-files, Kunena-files and so on). But this did not help.

It is implausible, but could it be a wwwrun and ftpuser Problem? Joomla needs wwwrun and if some files run under ftp-user, the database can not be read correctly? But this is only my phantasy, I'll think :P
Last edit: 17 years 2 months ago by Lintzy.

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

More
17 years 2 months ago #1898 by Matias
Replied by Matias on topic Re:MySQL Syntax Error
Ok, you can answer in that other thread that the installation failed. Joomla uses too slow unzip, so the installation just takes too much time. Best solution would to add php timeout to 60-90 secs.

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

More
17 years 2 months ago #1899 by fxstein
Replied by fxstein on topic Re:MySQL Syntax Error
FYI

Joomla 1.0.x uses external unzip and installs Kunena as fast as 1-2 sec.

Joomla 1.5.x uses internal unzip and installs of Kunena can take as much as 60-120 sec.

To be on the safe side php timeout should be set to 120 sec - at least for the install and upgrade.

We are looking into options for future releases to detect the timeout and recover from it. Might have to write an improvement for the Joomla 1.5 installer itself.

fxstein
We love stars on the Joomla Extension Directory . :-)

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

More
17 years 2 months ago - 17 years 2 months ago #1902 by Lintzy
Replied by Lintzy on topic Re:MySQL Syntax Error
Matias wrote:

Ok, you can answer in that other thread that the installation failed. Joomla uses too slow unzip, so the installation just takes too much time. Best solution would to add php timeout to 60-90 secs.


How to add php timeout to 60-90 (120) secs?
Last edit: 17 years 2 months ago by Lintzy.

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

More
17 years 2 months ago #1905 by johnnydement
Replied by johnnydement on topic Re:MySQL Syntax Error
that depends on isp, but basically you must edit the php.ini file in your server ;)

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

Time to create page: 0.246 seconds