My admin account sees a FLOODING from SQL commands in EasyDiscuss

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
antifmradio
Joomla! Explorer
Joomla! Explorer
Posts: 414
Joined: Sun Feb 07, 2010 3:22 pm
Location: NJ NYC
Contact:

My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by antifmradio » Wed Sep 08, 2021 10:02 pm

Just looking to see if anything like this has happened to anyone else. Its about flood protection.

Problem:
I cant post new topics on my message board after adding 40 thousand new rows to an sql table.

How did it happen:
So im using StackIdeas EasyDiscuss forum component.
I installed it and did some mods to link it correctly to my music database in my radio station.
There are 40 thousand audio files to link to. I was able to create a CSV file (two of them) so i can basically inject upwrds of 80,000 new lines in the sql database tables just for the forum.

80,000 new row is split between THREADS and POSTS. So its actually creating 40,000 new topics.

Ok so. Once i create the files and upload them into the phpMyAdmin area, it creates that many topics in a matter of about 4 minutes or less.

Each topic (in the sql commands) is shown as created by "My Admin Account Username"

The result:
I can do anything i need to when logged in as ADMIN on the front end of the site, but if i try to create a new topic on the forum, using the front end, the entire site times out.
This is ONLY for my account. I had someone else test out creating a topic and it worked for them.
I created a new account and set it as ADMIN, and there too, i can create new topics on the front end.

The fix:
I am trying to find anything in the back end of the site that protects against flooding but i see nothing so far. Because its only the admin account that cant create topics.
There is NO flooding protection setup on the forums cofiguration.


Thoughts?
Last edited by toivo on Wed Sep 08, 2021 11:24 pm, edited 1 time in total.
Reason: mod note: moved from 3.x Administration, retitled

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17425
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by toivo » Thu Sep 09, 2021 7:53 am

antifmradio wrote:
Wed Sep 08, 2021 10:02 pm
So im using StackIdeas EasyDiscuss forum component. I installed it and did some mods to link it correctly to my music database
If you customised the paid EasyDiscuss component, is it possible that those modifications are causing the issue in the creation of new topics?
Toivo Talikka, Global Moderator

antifmradio
Joomla! Explorer
Joomla! Explorer
Posts: 414
Joined: Sun Feb 07, 2010 3:22 pm
Location: NJ NYC
Contact:

Re: My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by antifmradio » Thu Sep 09, 2021 8:33 am

toivo wrote:
Thu Sep 09, 2021 7:53 am
antifmradio wrote:
Wed Sep 08, 2021 10:02 pm
So im using StackIdeas EasyDiscuss forum component. I installed it and did some mods to link it correctly to my music database
If you customised the paid EasyDiscuss component, is it possible that those modifications are causing the issue in the creation of new topics?
I didnt customize it.
I only used the phpMyAdmin to add a pass of new topics to it quickly.

Also that would imply that NO users can create new topics.
As i noted above, If i am not logged in as my admin account (user42)
but i AM logged in as some other admin account, i can create new topics from the front end.

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17425
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by toivo » Thu Sep 09, 2021 9:19 am

antifmradio wrote:
Thu Sep 09, 2021 8:33 am
If i am not logged in as my admin account (user42)
Probably nothing to do with the issue, but was your 3.x site migrated from an earlier version of Joomla? The first user created by Joomla 3.x has usually a different id.
Toivo Talikka, Global Moderator

antifmradio
Joomla! Explorer
Joomla! Explorer
Posts: 414
Joined: Sun Feb 07, 2010 3:22 pm
Location: NJ NYC
Contact:

Re: My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by antifmradio » Thu Sep 09, 2021 1:33 pm

toivo wrote:
Thu Sep 09, 2021 9:19 am
antifmradio wrote:
Thu Sep 09, 2021 8:33 am
If i am not logged in as my admin account (user42)
Probably nothing to do with the issue, but was your 3.x site migrated from an earlier version of Joomla? The first user created by Joomla 3.x has usually a different id.
no migration taken place at all.

THe sites been on the same server for months.
Operating just fine as i develop and debug things.
no custom coding has been done to any components. Just editing config settings for them.

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17425
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: My admin account sees a FLOODING from SQL commands in EasyDiscuss

Post by toivo » Thu Sep 09, 2021 11:32 pm

Then the developer of this paid extension, StackIdeas, would the best place to seek assistance.
Toivo Talikka, Global Moderator


Locked

Return to “Extensions for Joomla! 3.x”