- Posts: 23
- Thank you received: 0
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
Important SQL Problems and _jos Suffix Problem(Important)
15 years 2 months ago #1
by koraykupe
SQL Problems and _jos Suffix Problem(Important) was created by koraykupe
Firstly, thanks for the development.
I installed Kunena 1.0.7 on my Joomla 1.5.9 two sites.
One site is clean Joomla 1.5.9, other is use also Fireboard. This problems appear both of them.
When i open a new thread that have 'Turkish chacters (ö,ı,İ,ğ,Ğ,ü,Ü,Ö,ş,Ş)' on title, it gives sql error and debug info. But when i use 'Turkish characters' in a reply, no problem.
And again,
if i click 'My show latets post'
other errors like this...
I don't use jos_ suffix on my db tables. Maybe for that?
I installed Kunena 1.0.7 on my Joomla 1.5.9 two sites.
One site is clean Joomla 1.5.9, other is use also Fireboard. This problems appear both of them.
When i open a new thread that have 'Turkish chacters (ö,ı,İ,ğ,Ğ,ü,Ü,Ö,ş,Ş)' on title, it gives sql error and debug info. But when i use 'Turkish characters' in a reply, no problem.
And again,
if i click 'My show latets post'
Code:
Fatal error: Unable to get unread messages count and first id.\nDB function failed with error number 1146
Table 'XXXX_vt.jos_fb_messages' doesn't exist SQL=SELECT thread, MIN(id) AS lastread, SUM(1) AS unread FROM jos_fb_messages WHERE thread IN ('6686','10153','5707','10118','3095','10160','10155','10154','10152','10151','10150','10149','10147','9998','10143','10114','9557','10138','10135','7132') AND time>'1233666564' GROUP BY thread
SQL =
SELECT thread, MIN(id) AS lastread, SUM(1) AS unread FROM jos_fb_messages WHERE thread IN ('6686','10153','5707','10118','3095','10160','10155','10154','10152','10151','10150','10149','10147','9998','10143','10114','9557','10138','10135','7132') AND time>'1233666564' GROUP BY thread
in /home/XXXX/public_html/components/com_kunena/lib/kunena.debug.php on line 37
other errors like this...
I don't use jos_ suffix on my db tables. Maybe for that?
Please Log in or Create an account to join the conversation.
15 years 2 months ago #2
by Matias
Replied by Matias on topic Re:SQL Problems and _jos Suffix Problem(Important)
It's already fixed in SVN. We are working hard to fix our last show stopper bug.
In the mean time you can uninstall Kunena and install FB, if you're installed beta release to your live sites.
In the mean time you can uninstall Kunena and install FB, if you're installed beta release to your live sites.
Please Log in or Create an account to join the conversation.
- jozborn060
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
15 years 2 months ago #3
by jozborn060
Replied by jozborn060 on topic Re:SQL Problems and _jos Suffix Problem(Important)
A quick fix is to edit latestx.php and showcat.php and replace "jos_fb" with "#__fb"
Please Log in or Create an account to join the conversation.
15 years 3 weeks ago #4
by costicanu
Replied by costicanu on topic Re:SQL Problems and _jos Suffix Problem(Important)
Thank you jozborn060. The replace is working.
Please Log in or Create an account to join the conversation.
Time to create page: 0.346 seconds