Previous Thread
Next Thread
Print Thread
Hop To
UBB Error #254579 01/10/2014 11:51 AM
Joined: Feb 2008
Posts: 43
Titen Offline OP
newbie
OP Offline
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


Tim Tenold

www.inliners.org
Re: UBB Error [Re: Titen] #254617 01/14/2014 3:37 PM
Joined: Jun 2006
Posts: 811
Mitch P. Offline
old hand
Offline
old hand
Joined: Jun 2006
Posts: 811
Any luck on this?

Re: UBB Error [Re: Mitch P.] #254751 01/31/2014 11:05 AM
Joined: Feb 2008
Posts: 43
Titen Offline OP
newbie
OP Offline
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


Tim Tenold

www.inliners.org
Re: UBB Error [Re: Titen] #255687 07/15/2014 9:58 AM
Joined: Feb 2008
Posts: 43
Titen Offline OP
newbie
OP Offline
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


Tim Tenold

www.inliners.org
Re: UBB Error [Re: Titen] #255688 07/15/2014 12:08 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
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.
Need to Upgrade?
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!
Re: UBB Error [Re: Titen] #255689 07/15/2014 2:45 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
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
Re: UBB Error [Re: Gizmo] #255949 10/23/2014 3:04 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
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
Re: UBB Error [Re: Titen] #255950 10/23/2014 3:11 PM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
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 // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: UBB Error [Re: Titen] #255951 10/23/2014 3:24 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
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
Re: UBB Error [Re: Titen] #255952 10/23/2014 3:25 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Oh, and I need a "ubb 15 years" badge please wink


- Allen
- ThreadsDev | PraiseCafe
Re: UBB Error [Re: AllenAyres] #255953 10/23/2014 3:36 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
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
Re: UBB Error [Re: AllenAyres] #255954 10/23/2014 3:37 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
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
Re: UBB Error [Re: AllenAyres] #255955 10/23/2014 3:40 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
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.
Need to Upgrade?
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!
Re: UBB Error [Re: Titen] #255956 10/23/2014 3:40 PM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
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 // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: UBB Error [Re: Gizmo] #255957 10/23/2014 3:41 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
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
Re: UBB Error [Re: Ruben] #255959 10/23/2014 3:54 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
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
Re: UBB Error [Re: Titen] #255960 10/23/2014 4:00 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
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
Re: UBB Error [Re: AllenAyres] #255963 10/23/2014 4:46 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
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.
Need to Upgrade?
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!
Re: UBB Error [Re: AllenAyres] #255965 10/23/2014 5:25 PM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
Originally Posted by AllenAyres
Oh, and I need a "ubb 15 years" badge please wink


Enjoy smile

[Linked Image]


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: UBB Error [Re: isaac] #255982 10/27/2014 10:13 AM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
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]


Thank you! smile


- Allen
- ThreadsDev | PraiseCafe
Re: UBB Error [Re: Titen] #255983 10/27/2014 11:05 AM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
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.
Need to Upgrade?
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!
Re: UBB Error [Re: Gizmo] #255988 10/28/2014 12:26 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
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
Re: UBB Error [Re: Gizmo] #255989 10/28/2014 12:42 PM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
Originally Posted by Gizmo
I wonder if we can edit ourselves in the CP, then set a 15 year badge, lol.


Within http://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 // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: UBB Error [Re: Titen] #255991 10/28/2014 4:23 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
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.
Need to Upgrade?
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!

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, JAISP), 44 guests, and 347 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)