Previous Thread
Next Thread
Print Thread
Hop To
#254579 01/10/2014 12:51 PM
Joined: Feb 2008
Posts: 43
newbie
newbie
Joined: Feb 2008
Posts: 43
I have also been flooded with the Chinese spammers, but my big problem is I cannot access my forum or admin panel. I am blocked with a SQL error when I try to log in, if I go to the mysqladmin it tells me the field is 'in use', what can I do? -
--------------------------------------
UBB Error We encountered a problem. The reason reported was
Script: /hermes/bosweb25b/b309/ipw.timtenold/public_html/inliners/ubbthreads/libs/ubbthreads.inc.php
Line#: 2890
SQL Error: Incorrect file format 'ubbt_PORTAL_BOXES'
SQL Error #: 130
Query: update ubbt_PORTAL_BOXES set PORTAL_LOCK = '1389372275' where ((1389372275 - PORTAL_LAST_BUILD > PORTAL_CACHE) and (PORTAL_LOCK = '0' or (PORTAL_LOCK > 0 and (1389372275 - PORTAL_LOCK > 120)))) and PORTAL_CACHE <> '0'
---------------------------------------
Please click back to return to the previous page.


Thanks,

Tim Tenold
www.inliners.org -Bulletin Board

Titen #254617 01/14/2014 4:37 PM
Joined: Jun 2006
Posts: 811
old hand
old hand
Joined: Jun 2006
Posts: 811
Any luck on this?

Mitch P. #254751 01/31/2014 12:05 PM
Joined: Feb 2008
Posts: 43
newbie
newbie
Joined: Feb 2008
Posts: 43
Thanks for asking, I have an open support ticket but haven't had any results yet. I am running 7.2.2 and I am not sure if I can upgrade with this error. I can't get access to the field to do anything, even if I knew what to do.

Tim

Titen #255687 07/15/2014 10:58 AM
Joined: Feb 2008
Posts: 43
newbie
newbie
Joined: Feb 2008
Posts: 43
I haven't found anyone to help with this problem, IPOWER says to go to UBB and UBB says to go to IPOWER, I don't have the knowledge to fix it myself.

Now I have another problem which has shut everyone out from viewing posts:
>
We encountered a problem. The reason reported was
Script: /hermes/bosweb25b/b309/ipw.timtenold/public_html/inliners/ubbthreads/scripts/showflat.inc.php
Line#: 425
SQL Error: The table 'ubbt_TOPIC_VIEWS' is full
SQL Error #: 1114
Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( '9778' )

Please click back to return to the previous page
>

Can anyone provide help with this one?

Thanks,

Tim Tenold
Titen

Titen #255688 07/15/2014 1:08 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Quoting Rick on this thread:
Quote
Basically this means that the size of the ubbt_ONLINE table is larger than the max_heap_table_size setting in the mysql config.

There are a couple ways to fix this. If this is your own server, then you can increase the max_heap_table_size setting and restart MySQL, otherwise you'll probably need to decrease the online activity setting in the control panel, so it tracks for a less amount of time.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Titen #255689 07/15/2014 3:45 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Another unlimited shared hosting plan that does in fact have limits.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Gizmo #255949 10/23/2014 4:04 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Originally Posted by Gizmo
Quoting Rick on this thread:
Quote
Basically this means that the size of the ubbt_ONLINE table is larger than the max_heap_table_size setting in the mysql config.

There are a couple ways to fix this. If this is your own server, then you can increase the max_heap_table_size setting and restart MySQL, otherwise you'll probably need to decrease the online activity setting in the control panel, so it tracks for a less amount of time.


I am seeing this on my site now. What setting is Rick talking about decreasing? The 'who's online' time or the cookie time or something else? I've decreased both and am getting no where fast.


- Allen
- ThreadsDev | PraiseCafe
Titen #255950 10/23/2014 4:11 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
AA -

In your php.ini (for PHP5.2.1+) your memory limit should be set at least to 128M
; Maximum amount of memory a script may consume
memory_limit = 128M

Your server really should be running on at least PHP 5.2.1 - for major stability and security enhancements
for more information, visit http://php.net/releases/5_2_1.php

in PHP 5.2.0, the default was "16M"
prior to PHP 5.2.0, the default was "8M"
for more information, visit http://php.net/memory-limit


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
Titen #255951 10/23/2014 4:24 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Thank you smile

I am running current versions of plesk and it has mysql 5.5.36 and php 5.4.25 installed. It looks like the limit is set to 16MB as that's the size of the table.

I just emptied it, that didn't seem to break the site so we'll see.

I noticed above that Titen was having issues with Chinese spammers, and that's what I've been having. I had to put up a registration queue to stop the spam. Maybe their bots were trying to overwhelm the site, who knows.


- Allen
- ThreadsDev | PraiseCafe
Titen #255952 10/23/2014 4:25 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Oh, and I need a "ubb 15 years" badge please wink


- Allen
- ThreadsDev | PraiseCafe
AllenAyres #255953 10/23/2014 4:36 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
FYI, to your question
The setting is:
Control Panel » Display Options
Whos online
Who's Online Timeframe:
You either have a extremely long duration or a pot full of visitors.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
AllenAyres #255954 10/23/2014 4:37 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink
Not here yet. laugh


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
AllenAyres #255955 10/23/2014 4:40 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink
I cannot edit mods :/


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Titen #255956 10/23/2014 4:40 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
I usually have between 400 and 1,800 visitors online at any given time (thanks to having a niche topic, a lot of information, and some hard earned seo)

I also have about 580 lines in my spiders/bots list.
https://www.ubbdev.com/spider-list/

UBBT can handle it, no problem. Just need to make sure you're giving php enough memory to work with.


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
Gizmo #255957 10/23/2014 4:41 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by Gizmo
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink
I cannot edit mods :/
Allen is talking 15 years!


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Ruben #255959 10/23/2014 4:54 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Originally Posted by Ruben
Allen is talking 15 years!


Around there somewhere... my site says I joined 9/29/1999 and that was at least the second install before I stopped breaking it wink


- Allen
- ThreadsDev | PraiseCafe
Titen #255960 10/23/2014 5:00 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
What I meant was there is only a 10year badge. And as Giz noted we don't have access to turn it on for Mods.
So you need to request at least the 10 year badge from Brooks.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
AllenAyres #255963 10/23/2014 5:46 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by AllenAyres
Around there somewhere... my site says I joined 9/29/1999 and that was at least the second install before I stopped breaking it wink
come on AA, COMPLETELY stock? wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
AllenAyres #255965 10/23/2014 6:25 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink

Enjoy smile

[Linked Image from id242.com]


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
isaac #255982 10/27/2014 11:13 AM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Originally Posted by id242
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink

Enjoy smile

[Linked Image from id242.com]


Thank you! smile


- Allen
- ThreadsDev | PraiseCafe
Titen #255983 10/27/2014 12:05 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I wonder if we can edit ourselves in the CP, then set a 15 year badge, lol.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #255988 10/28/2014 1:26 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Originally Posted by Gizmo
I wonder if we can edit ourselves in the CP, then set a 15 year badge, lol.


Good question, not sure how to update the icon.


- Allen
- ThreadsDev | PraiseCafe
Gizmo #255989 10/28/2014 1:42 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Gizmo
I wonder if we can edit ourselves in the CP, then set a 15 year badge, lol.

Within https://www.ubbcentral.com/forums/ubbthreads.php/ubb/editbasic.html
there is an option called, "Custom Title" - its located right beneath "Verify Password."
UBBCentral has the option turned off.

But if it was turned on for your use group at
Control Panel > Site Permissions > Can set a Custom Title (bottom of second column)
and (for this example) it was set for 38 characters or more....

You could enter "<a href=http://id242.com/woof/15.png>" to have it display.

UBBT does not process Custom Titles as UBBCODE, but it does allow HTML. So your string will need to be in HTML. This is still an unfixed security hole within UBBT (A 10 year old security hole, introduced around 2004) for anyone enabling this on their site with a large amount of character allowed. So take that warning as a small grain of salt before enabling that feature on your site. A setting of 16 Chars could be fine, though.


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
Titen #255991 10/28/2014 5:23 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I don't think it's enabled for any group, hence the wonder of if we can edit ourselves; which we can by playing with the URL tongue.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

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
1 members (Havenofsobriety), 458 guests, and 91 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)