Merged "You are banned until today" message - for many days - at my website.

www.siteground.com/tutorials/phpmyadmin/

Good guide on how to use phpMyAdmin

Sozzled is right, you need to change non-null values on #__kunena_users.banned field to NULL.

Hi, I'm trying for a long time to solve this problem.
I can't find the solution.
I have past many hours without solution..

When I log in on my phpmyadmin, it tells me: # 2002 Can not log in to the MySQL server.



Can you help me to definitively resolve this situation that it have create much problems from 2 months on my Kunena forum?
They were two months that all users of my web site can't use the forum..

It's very annoying..beacuse i have never change the settings of the forum..

thank you very much

Matias wrote: Sozzled is right, you need to change non-null values on #__kunena_users.banned field to NULL.

I don't understand where i change this parameters..
Can you be more easy in the explanation, please?

It's very much time that i stay in this situation..........

You have to change all non-null values on #__kunena_users.banned field to NULL.

These things are not "parameters". These things are values in a database table.

phpMyAdmin is one tool you can use to change data in a database. There are other tools.

We cannot help you until you've solved your phpMyAdmin issues. As a hint, try to use the same user and password that you are using in Joomla. If you don't remember the password, you can at least find it from configuration.php file in Joomla root.

After migrating the Kunena data tables from Joomla 1.5.26 to 2.5.13, [strike]none of the categories are visible (not in the front end, and not even in the Category Manager of the back end), and I can't do anything in the back end because[/strike] it tells me "You are banned until Today".

[strike]When I look in phpMyAdmin at the users table and at the categories table, I can't see what's wrong.[/strike]

Here is a user row (with header):

[strike]And here are the first two category table rows (the main parent board plus the first category that can have posts):[/strike]
Can anyone spot the problem? Thank you for your attention.

And here is my config report:

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: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 256M | Max file upload: 2M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
100155	Forum	othermenu	view=home&defaultmenu=117	forum
100156	Index	othermenu	view=category&layout=list	forum/index
100157	Recent Topics	othermenu	view=topics&mode=replies	forum/recent
100158	New Topic	othermenu	view=topic&layout=create	forum/newtopic
100159	No Replies	othermenu	view=topics&mode=noreplies	forum/noreplies
100160	My Topics	othermenu	view=topics&layout=user&mode=default	forum/mylatest
100161	Profile	othermenu	view=user	forum/profile
100162	Help	othermenu	view=misc	forum/help
100163	Search	othermenu	view=search	forum/search
100030	Forum	kunenamenu	view=home&defaultmenu=100031	forum-sp-328487765
100031	Index	kunenamenu	view=category&layout=list	forum-sp-328487765/index
100032	Recent Topics	kunenamenu	view=topics&layout=default&mode=replies	forum-sp-328487765/recent
100033	New Topic	kunenamenu	view=topic&layout=create	forum-sp-328487765/newtopic
100034	No Replies	kunenamenu	view=topics&layout=default&mode=noreplies	forum-sp-328487765/noreplies
100035	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum-sp-328487765/mylatest
100036	Profile	kunenamenu	view=user	forum-sp-328487765/profile
100037	Rules	kunenamenu	view=misc	forum-sp-328487765/rules
100038	Help	kunenamenu	view=misc	forum-sp-328487765/help
100039	Search	kunenamenu	view=search	forum-sp-328487765/search
100040	Forum	mainmenu	Itemid=100030	kunenaforum
91	Discussion Forums	mainmenu	option=com_kunena	discussion-forums-sp-974266320
100195	Discussion Forums	top-toolbar-menu	option=com_kunena	discussion-forums-sp-974266321

Joomla default template details : js_novitas | author: Joomlashack | version: 1.0.6 | creationdate: Unknown

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 3.0.1 | creationdate: 2013-06-29

Kunena version detailed: Kunena 3.0.1 | 2013-06-29 [ Noordwijkerhout ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
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	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
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	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
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	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	1
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	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
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

| 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 Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

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

Third-party components: CommunityBuilder 1.9 | UddeIM 3.1

Third-party SEF components: None

Plugins: Search - Kunena Search 3.0.1 | Content - Kunena Discuss 3.0.1

Modules: Kunena Latest 3.0.1 | Kunena Stats 3.0.1 | Kunena Login 3.0.1 | Kunena Search 3.0.1

Have you tried using the Kunena Forum Tools to Recount Statistics and Synchronise Users?

*** Topics merged by moderator ***

One subject per topic, please. The answer to the "you are banned until today" problem is answered in this topic.

We will have to deal with the second question about categories "not visible" in a separate topic.

1.
Does that mean that you looked at the snippet I posted of the Kunena 3.0.1 users table and found it correct as to structure as well as field values?

2.
Before posting, I had already checked the kunena banned table, and the only people who are in it are the few people who should be. This seemed so obvious that I did not mention it before.

3.
In this thread that you merged mine with, the only suggestion that I hadn't already tried and addressed in my post was to look at the core Joomla users table, in case Kunena is reacting to that. I have now done so. It is correct, the users there are active.

4.
I did find one anomaly in the core users table, but that is not the source of the problem. As part of the migration, SP UPgrade had changed the Name and the Email of the old site's Super Admin, and disabled that user (by unconfirming and unapproving it), but preserved the Super User of the bare Joomla 2.5 site.

I had seen that right away, as that appeared as a notice in SP Upgrade's migration report. So in the back end, I immediately changed the ID and Email back, and reenabled it. And I have been logging in to administer the new site using both of the two usernames. And both work successfully to administer the site, DESPITE the info in the following paragraph:

So it was not until now, responding to this thread, that I looked at he core user table. And I found that SP Upgrade had also changed my old admin user account's type, from "Super Admin" to "deprecated". So I have now changed it to "Super Users".

Of course, this is not the source of the problem, because both my old and new admin accounts have the "Banned until Today" appearing atop the Kunena back end, and neither is a moderator either!

And this is still the case even after the recent usertype edit.

5.
I don't think these threads should have been merged, since my problems probably have a common cause, related to the migration, while the original poster's problem appeared suddenly and without migration. And the fact that the categories (all enabled/published in the category table) are not being shown at all in the back end (which should list them even if unpublished), suggests a systematic migration problem that might be diagnosed better by knowing of the existence of both problems. They are linked in that they were triggered together.

6.
In the back end Kunena Users page, both of my admin accounts show as NOT banned; but no matter which I am logged in with, I see the “You are banned for today” notice at the top of that page, and cannot do any operations on the users. If I try to make a change, a red message appears atop the page, saying: "You need to be moderator in order to perform moderation actions." (Neither of these users is listed as moderator either! The old site's Super Admin was indeed moderator of all forums.)

No pages on the new site are generating any errors. But Kunena on the new site does not see its categories, AND the modules do not see the topics. In the front end, it’s exactly as if the categories were unpublished, except that the data tables say they are.

7.
In preparation for the migration, I upgraded the old site from Kunena 1.7.x to 2.0.4. For that same reason, I also upgraded Community Builder to 1.9 and switched this site to php 5.3 from 5.2 (on my dual-php-configured VPS).

After this, the old site still properly displayed and managed all Kunena 2.0.4 data in the back-end; and all the forum topics, categories, and contents appeared in modules throughout the site; but the site would throw Server 500 Errors if navigating to the Kunena component page itself.

The error message suggested that the problem was with the cb_login module. It and Kunena appeared incompatible after the upgrades, and I found a thread in this Kunena forum all about it. There, you blamed CB and directed users to the CB forum. So I did not think that this should prevent me from migrating Kunena, which I did.

I also migrated CB 1.9 which appears to work fine on the new site.

The results of all this activity are as described in item 6 above. No pages on the new site are generating any errors.

8.
Can anyone suggest a next step toward diagnosing this phenomenon?

Thank you for your attention.