Previous Thread
Next Thread
Print Thread
Hop To
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
Quote
We Encountered A Problem
Script: C:\inetpub\wwwroot\forums\libs\html.inc.php
Line: 470
SQL Error: The table 'ubbt_online' is full
SQL Error: 1114

Query:

REPLACE INTO
ubbt_ONLINE
(ONLINE_DISPLAY_NAME, USER_ID, ONLINE_LAST_ACTIVITY, ONLINE_SCRIPT_NAME, ONLINE_BROWSING_FORUM, ONLINE_USER_TYPE, ONLINE_USER_IP, ONLINE_REFERER, ONLINE_AGENT, ONLINE_POST_ID, ONLINE_POST_SUBJECT)
VALUES
('Adam Ant', 2, 1628168789, 'cfrm', '', 'r', '192.168.1.67', 'https://game-master.net/forums/ubbthreads.php/forums/11/1/developers', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 0, '')

Each morning I check my server events and saw many errors in my EventViewer of this form:
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: The table 'ubbt_online' is full

I then went and tried to load a page on my UBB and got the above error.
It looks to me that I was attacked, and someone probably with a bot or something, filled up my database table.

I'm able to get into the control panel, but I cannot get to forums.

Update: I was able to get to the control panel, and I really didn't know what to do, but I went to Cache Manager/Update Cache and now I can see my forums and I made a temp post and was able to delete it.

Anyone have any idea what's going on?


Member since November 2004
Gold Member since Feb 2008
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Read This


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
Very good... I will make the change.
Damn hackers ... that's what I get for trying to launch a game with lots of competition :/

Is there a way to have UBB recognize what's happening and just firewall these bastards?


Member since November 2004
Gold Member since Feb 2008
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
myself I use cloudflare which helps mitigate most of it.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
I added the lines to SQL Query
alter table ubbt_ONLINE ENGINE=MyISAM
alter table ubbt_TOPIC_VIEWS ENGINE=MyISAM

But I get the following error when I execute:
Quote
Script: C:\inetpub\wwwroot\forums\admin\dodbcommand.php
Line: 83
SQL 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 'alter table ubbt_TOPIC_VIEWS ENGINE=MyISAM' at line 2
SQL Error: 1064

Query:
alter table ubbt_ONLINE ENGINE=MyISAM
alter table ubbt_TOPIC_VIEWS ENGINE=MyISAM

Is MyISAM just a placeholder for my database name? Do I need to change that to MySQL?


Member since November 2004
Gold Member since Feb 2008
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
submit each sql line one at a time.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
That did it.
ty smile


Member since November 2004
Gold Member since Feb 2008

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)