Solved "Forum is down for maintenance" issues

I get this message today:

Forum is down for maintenance
Check back soon!

Look here -> www.gameworld.gr/forum

I didn't change any files! Is this really a maintenance from your own side? And how long does it last? It's the first time I wake up early and I already see it for half an hour! There might be an issue here or hacking attempt, whatever!

I need immediate solution because people need to vote in a contest that is running!

Also this poll has dozens of pages (they might be over 50 pages of posts) and I hope that there is no mysql error due to Kunena!


Report Configuration

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 '-08-2014' at line 1 SQL=SHOW FULL FIELDS FROM jos_kunena_messages29-08-2014

Database collation check:

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 72000 seconds | Max execution memory: 2048M | Max file upload: 1024M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
137	Forum	mainmenu	view=home&defaultmenu=794	forum
888	Προφίλ	mainmenu	view=user	forum/profile
890	Αναζήτηση	mainmenu	view=search	forum/search
891	Τα θέματά μου	mainmenu	view=topics&layout=user&mode=default&modetype=	forum/mytopics
892	Νέα θέματα	mainmenu	view=topics&layout=posts&mode=recent&userid=	forum/newtopics
876	Forum	kunenamenu	view=home&defaultmenu=878	kunena
877	Index	kunenamenu	view=category&layout=list&catid=0	kunena/index
878	Recent Topics	kunenamenu	view=topics&mode=replies	kunena/recent
879	New Topic	kunenamenu	view=topic&layout=create	kunena/newtopic
880	No Replies	kunenamenu	view=topics&mode=noreplies	kunena/noreplies
881	My Topics	kunenamenu	view=topics&layout=user&mode=default	kunena/mylatest
882	Profile	kunenamenu	view=user	kunena/profile
883	Help	kunenamenu	view=misc	kunena/help
884	Search	kunenamenu	view=search	kunena/search
886	Edit profile	kunenamenu	view=user&layout=edit	kunena/edit-profile
885	Forum	mainmenu	Itemid=876	kunena-2014-08-26
887	Edit forum profile	gameworld	view=user&layout=edit	edit-forum-profile

Joomla default template details : whiteboard | author: Opensource | version: 2.6 | 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	30
messages_per_page	15
messages_per_page_search	20
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	350
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	999999
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	150
maxsig	9999
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	100
avatarsize	2048
imageheight	3000
imagewidth	3000
imagesize	500
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	500
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	27,85,81,59,31,30,78,19,58,83,44,13,50,23,33,34,35,38,42,2,88,91,7,84,57,64,63,5,4,90,60
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	60
trimlongurlsback	30
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	3600
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
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	50
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	999
ordering_system	mesid
post_dateformat	datetime
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	60
thumbwidth	60
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
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	20
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	180
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
enablepdf	1
jmambot	0
annmodid	62
changename	0
userlist_username	1
userlist_usertype	0
rules_infb	1
help_infb	1
sefutf8	0
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

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

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
el-GR	Greek
en-GB	English (United Kingdom)

Third-party components: Jomsocial 3.2.1.4

Third-party SEF components: None

Plugins: Search - Kunena Search 3.0.1 | JomSocial - My Kunena Forum Menu 2.0.3 | JomSocial - My Kunena Forum Posts 2.0.3 | JomSocial - Kunena Groups 2.0.3

Modules: Kunena Latest 3.0.1 | Kunena Search 3.0.1

Edit: Forum is back online. I changed session from 3600 seconds to 1800 and cache time from 3 minutes to 5 minutes.

Question: How can I configure the forum maintenance to be scheduled in the day/hour that I want?

Thank you.

Hello,

The forum goes in maintenance mode when you try to install a new version and it's fails.
Untill this issue is solved the forum stays in maintenance mode.

You see the following SQL error when you are in the page to generate configuration report ?

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 '-08-2014' at line 1 SQL=SHOW FULL FIELDS FROM jos_kunena_messages29-08-2014

"Forum is down for maintenance" again.





I don't have the latest version. But I didn't have the latest version for weeks! So why is the component insisting to install the new version by making me lose my patience?

Look at those errors!



How can I solve them and how can I disable maintenance. I want the maintenance to happen only Sunday early morning 03:00 local time. Once per week! Nothing else! We have 12 o clock in the afternoon and Iam losing viewers right now which try to access the forum!

So give me exact instructions on how to set it once per week at the above hour.
Thanks.


ps. That is the error:

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 '-08-2014' at line 1 SQL=SHOW FULL FIELDS FROM jos_kunena_messages29-08-2014

You need to check the permissions under /joomla/cache because Joomla! can't write in it

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 '-08-2014' at line 1 SQL=SHOW FULL FIELDS FROM jos_kunena_messages29-08-2014

The query is incorrect it should be SHOW FULL FIELDS FROM jos_kunena_messages

Check that you have under plugin - system the plugin Kunena right installed and enabled

Forum goes in maintenance mode if something is broken into Kunena or if you are installing/updating Kunena

Ok, I have lots of questions:
1)The "Forum is down for maintenance" and all those errors dissapear only when I purge cache through SSH. So that is the issue. You are saying that I should give 775 permissions to all folders under /cache ? Or even 777 ? Before the permissions were 755 and now I did it 775. Would that be ok?
2)Why does the maintenance cause issues to JComments? Comments temporarily dissapear from all articles while noone can leave a comment. Why are those connected to each other?
3)My hard disk was out of space when I found those errors today. Do you think that this is related somehow with the maintenance not going on?
4)Am I required to upgrade to the latest version? Does "Forum is down for maintenance" appear more often so that I will have to upgrade?


Please reply in numbers.

OFF-TOPIC: Also I wait for a reply HERE for weeks !

1°) The permissions set to 775 are ok, you need to check too that the owner of cache directory is right the server apache to let Joomla! to be able to write by himself in cache directory
2°) There are nothing related to JComments and Kunena, i don't see what thing can cause that
3°) If you hard disk is full, you can't save new data int database, you need to have empty space else you will into issues. You need to check mysqll and apache to see what it say maybe you will discover some issues.
4°) During the upgrade process the "Forum is down for maintenance" will appear

Your site is hosted by a hoster or locally ?