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

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.

Important Error 500 while posting !!!

sebkun
Topic Author
Offline
Junior Member

12 years 8 months ago #1 by sebkun

Error 500 while posting !!! was created by sebkun

Hi,

Sorry to bother you but I'm facing a problem I don't understand… everytime one posts on my forum, he gets a ERROR 500.

Here is the message :

Code:

500 - 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 ') GROUP by memberid' at line 1 SQL=INSERT INTO mvj_kunena_subscriptions (thread, userid) SELECT 1929, memberid as userid FROM `mvj_community_groups_members` WHERE groupid IN (SELECT groupid FROM mvj_jsgkunena WHERE catid=) GROUP by memberid

Vous ne pouvez pas visiter cette page car :

    bookmark/favoris périmé
    Un moteur de recherche possède un listing périmé pour ce site
    une adresse erronée
    vous n'avez pas accès à cette page
    La ressource demandée n'a pas été trouvée
    Une erreur est survenue pendant l'exécution de la requête.

Veuillez essayer l'une des pages suivantes :

    Page d'accueil

Si les difficultés persistent, merci de contacter l'administrateur de ce site.

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 ') GROUP by memberid' at line 1 SQL=INSERT INTO mvj_kunena_subscriptions (thread, userid) SELECT 1929, memberid as userid FROM `mvj_community_groups_members` WHERE groupid IN (SELECT groupid FROM mvj_jsgkunena WHERE catid=) GROUP by memberid

I don't know what to doo, help mu Kunena, you're my only hope !

Here is my configuration :

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: 10 seconds | Max execution memory: 96M | Max file upload: 300M

This message contains confidential information

Joomla default template details : yoo_explorer | author: YOOtheme | version: 1.5.2 | creationdate: January 2010

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.5 | creationdate: 2011-07-27

Kunena version detailled: Installed version: 1.6.5 | Build: 5005 | Version name: Babel | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]
board_title Mangavorum

board_offline 0

board_ofset 0.00

offline_message <h2>Le forum est actuellement hors ligne pour raison de maintenance.</h2>
<div>revenez plus tard !</div>

enablerss 1

enablepdf 0

threads_per_page 20

messages_per_page 20

messages_per_page_search 15

showhistory 1

historylimit 6

shownew 1

jmambot 0

disemoticons 0

template default

showannouncement 1

avataroncat 1

catimagepath category_images/

showchildcaticon 1

annmodid 62

rtewidth 450

rteheight 300

enableforumjump 1

reportmsg 1

username 1

askemail 1

showemail 0

showuserstats 1

showkarma 1

useredit 1

useredittime 0

useredittimegrace 600

editmarkup 1

allowsubscriptions 1

subscriptionschecked 0

allowfavorites 1

maxsubject 50

maxsig 300

regonly 0

changename 0

pubwrite 0

floodprotection 5

mailmod 0

mailadmin 0

captcha 1

mailfull 1

allowavatar 1

allowavatarupload 1

allowavatargallery 1

avatarquality 65

avatarsize 2048

allowimageupload 0

allowimageregupload 1

imageheight 1080

imagewidth 1920

imagesize 200

allowfileupload 0

allowfileregupload 1

filetypes zip,txt,gz,tgz, jpg, png, gif

filesize 120

showranking 1

rankimages 1

avatar_src

fb_profile

pm_component

userlist_rows 30

userlist_online 1

userlist_avatar 1

userlist_name 1

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 0

showstats 1

showwhoisonline 1

showgenstats 1

showpopuserstats 1

popusercount 5

showpopsubjectstats 1

popsubjectcount 5

usernamechange 0

rules_infb 1

rules_cid 3305

help_infb 1

help_cid 3305

showspoilertag 1

showvideotag 1

showebaytag 1

trimlongurls 1

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 1

ebaylanguagecode fr-fr

fbsessiontimeout 7200

highlightcode 0

rss_type topic

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_author_in_title 1

rss_word_count 0

rss_old_titles 1

rss_cache 900

fbdefaultpage recent

default_sort asc

alphauserpointsnumchars 0

sef 1

sefcats 0

sefutf8 0

showimgforguest 1

showfileforguest 1

pollnboptions 8

pollallowvoteone 1

pollenabled 1

poppollscount 5

showpoppollstats 1

polltimebtvotes 00:15:00

pollnbvotesbyuser 100

pollresultsuserslist 1

maxpersotext 50

ordering_system mesid

post_dateformat datetime_today

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 jomsocial

integration_avatar jomsocial

integration_profile jomsocial

integration_private jomsocial

integration_activity jomsocial

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

onlineusers 1

debug 1

catsautosubscribed 0

showbannedreason 0

version_check 1

showthankyou 1

showpopthankyoustats 1

popthankscount 5

mod_see_deleted 0

bbcode_img_secure text

listcat_show_moderators 1

lightbox 1

activity_limit 64

show_list_time 720

show_session_type 0

show_session_starttime 0

userlist_allowed 0

userlist_count_users 1

enable_threaded_layouts 0

category_subscriptions post

topic_subscriptions every

pubprofile 1

thankyou_max 10

Third-party components: Jomsocial 2.2.3

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Enabled | System - Mootools12: Disabled | Kunena Discuss 1.6.4

Modules: Kunena Latest 1.6.2

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

xillibit
Offline
Administrator

12 years 8 months ago #2 by xillibit

Replied by xillibit on topic Re: Error 500 while posting !!!

Hello,

Maybe it's something related to jomsocial, can-you update your Jomsocial version ?

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.

sebkun
Topic Author
Offline
Junior Member

12 years 8 months ago - 12 years 8 months ago #3 by sebkun

Replied by sebkun on topic Re: Error 500 while posting !!!

well, I think I'm up-to-date !

[EDIT]
I found my pb ! It's from one plugin of lattitudeweb : JS-G Kunena suscribe. I disabled it and it works fine… hope some will read my thread on the lattitude forum to correct this bug ! :unsure:

Thanks anyway for pointing me in the right direction.

Last edit: 12 years 8 months ago by sebkun.

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

Time to create page: 0.662 seconds