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.

Solved SQL error when trying to submit a new post to a migrated Kunena 3.0.6

Jonty83
Topic Author
Offline
New Member

9 years 7 months ago #1 by Jonty83

SQL error when trying to submit a new post to a migrated Kunena 3.0.6 was created by Jonty83

Hi,

I recently updated my homepage from Joomla 1.5 to the latest relase. For this purpose I installed a complete fresh latest Joomla version and installed Kunena 3.0.6 and CB 1.9.1

I updated on the old hompage to Kunena 2.0.4 to have the same SQL database structure. Then I copied all tables from the old database into the new database (also migrating all users and CB 1.9.1).

I see all forum posts and categories as well as users.

When I try to submit a new post somewhere I get the following error message:

#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 ' 'test')' at line 1 SQL=INSERT INTO jo3_kunena_messages_text (mesid, message) VALUES (, 'test')

MySQL version: 5.5.31

The Kunena configuration report is:

This message contains confidential information

Database collation check: The collation of your table fields are correct

Joomla! SEF: Disabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 92M | Max file upload: 38M

Kunena menu details:

Warning: Spoiler!

ID Name Menutype Link Path

270 Forum internmenue view=category&layout=list&catid=0 forumkunena

260 Forum kunenamenu view=home&defaultmenu=262 kunena

261 Index kunenamenu view=category&layout=list kunena/index

262 Aktuell kunenamenu view=topics&mode=replies kunena/aktuell

263 Neues Thema kunenamenu view=topic&layout=create kunena/neuesthema

264 Ohne Antwort kunenamenu view=topics&mode=noreplies kunena/ohneantwort

265 Meine Themen kunenamenu view=topics&layout=user&mode=default kunena/meinethemen

266 Profil kunenamenu view=user kunena/profil

267 Hilfe kunenamenu view=misc kunena/hilfe

268 Suche kunenamenu view=search kunena/suche

269 Forum mainmenu Itemid=260 kunena-2014-08-21

Joomla default template details : beez3 | author: Angie Radtke | version: 3.1.0 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.6 | creationdate: 2014-07-28

Kunena version detailed: Kunena 3.0.6 | 2014-07-28 [ Tala ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:

board_offline 0

enablerss 1

threads_per_page 20

messages_per_page 15

messages_per_page_search 15

showhistory 1

historylimit 6

shownew 1

disemoticons 0

template default

showannouncement 0

avataroncat 0

catimagepath category_images/

showchildcaticon 1

rtewidth 450

rteheight 300

enableforumjump 1

reportmsg 1

username 0

askemail 0

showemail 0

showuserstats 1

showkarma 0

useredit 1

useredittime 0

useredittimegrace 600

editmarkup 1

allowsubscriptions 1

subscriptionschecked 0

allowfavorites 1

maxsubject 50

maxsig 300

regonly 1

pubwrite 0

floodprotection 0

mailmod 0

mailadmin 0

captcha 0

mailfull 1

allowavatarupload 1

allowavatargallery 1

avatarquality 65

avatarsize 2048

imageheight 576

imagewidth 720

imagesize 150

filetypes txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2

filesize 4000

showranking 1

rankimages 1

userlist_rows 30

userlist_online 1

userlist_avatar 1

userlist_name 1

userlist_posts 1

userlist_karma 0

userlist_email 0

userlist_joindate 1

userlist_lastvisitdate 0

userlist_userhits 0

latestcategory 0

showstats 1

showwhoisonline 0

showgenstats 1

showpopuserstats 0

popusercount 5

showpopsubjectstats 1

popsubjectcount 5

usernamechange 0

showspoilertag 1

showvideotag 1

showebaytag 0

trimlongurls 1

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 0

ebaylanguagecode en-us

sessiontimeout 1800

highlightcode 0

rss_type recent

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

defaultpage recent

default_sort asc

sef 1

showimgforguest 1

showfileforguest 1

pollnboptions 4

pollallowvoteone 1

pollenabled 1

poppollscount 5

showpoppollstats 0

polltimebtvotes 00:15:00

pollnbvotesbyuser 100

pollresultsuserslist 1

maxpersotext 50

ordering_system mesid

post_dateformat datetime

post_dateformat_hover ago

hide_ip 1

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

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

debug 0

catsautosubscribed 0

showbannedreason 0

version_check 1

showthankyou 1

showpopthankyoustats 0

popthankscount 5

mod_see_deleted 0

bbcode_img_secure text

listcat_show_moderators 1

lightbox 1

show_list_time 720

show_session_type 0

show_session_starttime 0

userlist_allowed 1

userlist_count_users 1

enable_threaded_layouts 0

category_subscriptions post

topic_subscriptions every

pubprofile 0

thankyou_max 10

email_recipient_count 0

email_recipient_privacy bcc

captcha_post_limit 0

keywords 0

userkeywords 0

image_upload registered

file_upload registered

topic_layout flat

time_to_create_page 1

show_imgfiles_manage_profile 1

hold_newusers_posts 0

hold_guest_posts 0

attachment_limit 8

pickup_category 0

article_display intro

send_emails 1

fallback_english 1

cache 1

cache_time 60

iptracking 1

rss_feedburner_url

autolink 1

access_component 1

statslink_allowed 1

superadmin_userlist 0

userlist_usertype 0

sefutf8 0

enablepdf 1

jmambot 1

annmodid 62

changename 0

userlist_username 1

rules_infb 0

help_infb 0

onlineusers 1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:

de-DE German (DE-CH-AT)

en-GB English (United Kingdom)

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	15
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	default
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	0
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
imageheight	576
imagewidth	720
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	4000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	0
showgenstats	1
showpopuserstats	0
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	recent
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
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	0
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	datetime
post_dateformat_hover	ago
hide_ip	1
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
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
userlist_usertype	0
sefutf8	0
enablepdf	1
jmambot	1
annmodid	62
changename	0
userlist_username	1
rules_infb	0
help_infb	0
onlineusers	1

Joomla! languages installed:
de-DE	German (DE-CH-AT)
en-GB	English (United Kingdom)

Third-party components: CommunityBuilder 1.9.1 | UddeIM 3.4

Third-party SEF components: None

Plugins: None

Modules: None

Thank you,
Christian

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

Jonty83
Topic Author
Offline
New Member

9 years 7 months ago #2 by Jonty83

Replied by Jonty83 on topic SQL error when trying to submit a new post to a migrated Kunena 3.0.6

I uninstalled Kunena, removed all tables from the database, reinstalled Kunena and moved every table manually. Now it works...

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

Time to create page: 0.414 seconds