UBB.Developers Forums UBB.threads 7 Development How Do I? Corrupt Who's Online

Hi Guys

First of all, I just want to say Merry Christmas from England and thanks for all your help in the past. I tend to only pop up when I have a problem but I do lurk and I hope in time to be able to get some more time for myself to participate.

I'm having problems with Threads again. It usually crashes when there are around 400 people online at any one time. What's the most of users you have experienced without problems as a matter of interest?

At the moment the following message is displayed (see below) and I am told my Who's Online has corrupted itself. Any ideas what this means and what should be done? I'm just trying to understand it myself and no doubt I will hire someone to help put this right if it's not corrected today by the hosts.

Is it possible to hack out the who's online feature or should this not be necessary? Apparently it was accouting for 35.460 queies a second earlier today



SQL ERROR: Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Extra,O_Read,O_Type) VALUES ('KopTalk','5790','1072109950','postlist','oldskool','-1-2-3-4-','r')
Table 'threads.w3t_Online' doesn't exist Admin | Entrance |

Main Index | My Home | Who's Online | FAQ | Logout | Mark all read


SQL ERROR: Unable to do_query: SELECT O_Type,O_Extra,COUNT(*) FROM w3t_Online WHERE O_Extra LIKE 'oldskool%' GROUP BY O_Type
Table 'threads.w3t_Online' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forums/mysql.inc.php on line 130

What version are you running?

It looks like the online table doesn't exist. Depending on what version you have, look inside the createtable.php script for the command where that table gets created. You can use that to recreate it.

Thankfully it's just temporary data - so nothing is lost with it being gone.

UBB.threads™ 6.2.3 Josh. Where do I find this file please?

This should do it:



I think that'll do it.

Improvements were made with indexes in this area in 6.4 to help prevent corruption.

[]JoshPet said:
This should do it:



I think that'll do it.

Improvements were made with indexes in this area in 6.4 to help prevent corruption. [/]

Sorry to be lame but where do I put this code Josh

Admin -> SQL Queries.

I went to SQL command and did what you said and received this Josh:

SQL ERROR: Unable to do_query: CREATE TABLE w3t_Online( O_Username $varchar(64), O_Uid $int9 NOT NULL, O_Last $int9 DEFAULT '0' NOT NULL, O_What $varchar(64), O_Extra $varchar(200), O_Read $varchar(255), O_Type $varchar(1) NOT NULL ,UNIQUE Oindx1 (O_Username), INDEX Oindx2 (O_Last), INDEX type_index(O_Type) )
You have an error in your SQL syntax near '$varchar(64), O_Uid $int9 NOT NULL, O_Last $int9 DEFAULT '0' NOT NULL, O_What' at line 2 row(s) affected by your query.

Remove the $ 's from the query

should be

CREATE TABLE w3t_Online(
O_Username varchar(64),
O_Uid int9 NOT NULL,
O_Last int9 DEFAULT '0' NOT NULL,
O_What varchar(64),
O_Extra varchar(200),
O_Read varchar(255),
O_Type varchar(1) NOT NULL
,UNIQUE Oindx1 (O_Username),
INDEX Oindx2 (O_Last),
INDEX type_index(O_Type)
)

I tried that also and received the error below. Allen is upgrading my Threads tonight, should that correct this problem?

Results from your SQL command

Here are the results of your command: "CREATE TABLE w3t_Online( O_Username varchar(64), O_Uid int9 NOT NULL, O_Last int9 DEFAULT '0' NOT NULL, O_What varchar(64), O_Extra varchar(200), O_Read varchar(255), O_Type varchar(1) NOT NULL ,UNIQUE Oindx1 (O_Username), INDEX Oindx2 (O_Last), INDEX type_index(O_Type) )".
SQL ERROR: Unable to do_query: CREATE TABLE w3t_Online( O_Username varchar(64), O_Uid int9 NOT NULL, O_Last int9 DEFAULT '0' NOT NULL, O_What varchar(64), O_Extra varchar(200), O_Read varchar(255), O_Type varchar(1) NOT NULL ,UNIQUE Oindx1 (O_Username), INDEX Oindx2 (O_Last), INDEX type_index(O_Type) )
You have an error in your SQL syntax near 'int9 NOT NULL, O_Last int9 DEFAULT '0' NOT NULL, O_What varchar(64), O_Ext' at line 3 row(s) affected by your query.

Interesting Lets try it again

CREATE TABLE `w3t_Online` (
`O_Username` varchar(64) NOT NULL default '',
`O_Last` int(9) unsigned NOT NULL default '0',
`O_What` varchar(64) default NULL,
`O_Extra` varchar(200) default NULL,
`O_Read` varchar(255) default NULL,
`O_Type` char(1) NOT NULL default '',
`O_Uid` int(9) default NULL,
`O_IPaddy` varchar(15) default NULL,
`O_Board` varchar(100) default NULL,
UNIQUE KEY `Oindx1` (`O_Username`),
KEY `Oindx2` (`O_Last`),
KEY `type_index` (`O_Type`)
) TYPE=MyISAM;

#

[]Omegatron said:
Interesting Lets try it again

CREATE TABLE `w3t_Online` (
`O_Username` varchar(64) NOT NULL default '',
`O_Last` int(9) unsigned NOT NULL default '0',
`O_What` varchar(64) default NULL,
`O_Extra` varchar(200) default NULL,
`O_Read` varchar(255) default NULL,
`O_Type` char(1) NOT NULL default '',
`O_Uid` int(9) default NULL,
`O_IPaddy` varchar(15) default NULL,
`O_Board` varchar(100) default NULL,
UNIQUE KEY `Oindx1` (`O_Username`),
KEY `Oindx2` (`O_Last`),
KEY `type_index` (`O_Type`)
) TYPE=MyISAM;

# [/]

That appears to have worked

What a star!

Yep some server like the tildies others dont.

I'm not tech minded at all so this baffles me but hey, it worked. Thanks pal!

It didn't work with the # at the end but did with that removed.

yay - thanks Omegatron - I did a "drive by" reading of stuff on my way out the door earlier.

[]JoshPet said:
yay - thanks Omegatron - I did a "drive by" reading of stuff on my way out the door earlier. [/]

Slacking, eh