Well I lost my ubbt_SEARCH_RESULTS table

Print Thread

Hop To

Well I lost my ubbt_SEARCH_RESULTS table #243013 05/01/2011 6:40 PM
Joined: Jan 2008 Posts: 514 DE USA Dunny addict
Dunny addict Joined: Jan 2008 Posts: 514 DE USA	Well I updated my boards to the new version of them, I imported the database and I noticed that through the import that instead of 65 tables I had 64. I for the life of me couldn't figure out why....until today... I went to do a search and got an SQL error. When I looked for the table sure enough that is the one that is missing..... IS there a way to take the table from the previous and just copy it to the other database? I can't lose the information in the new database just for this one entry. Any help would be appreciated. Dunny

Re: Well I lost my ubbt_SEARCH_RESULTS table

Dunny #243014 05/01/2011 8:13 PM

Joined: Apr 2007

Posts: 3,940

Likes: 1

SoCal, USA

SD

Former Developer

SD

Former Developer

Joined: Apr 2007

Posts: 3,940

Likes: 1

SoCal, USA

yah, no probs and you didn't really lose much either

just paste this into your Database Tools, SQL query and execute

SQL Query

CREATE TABLE IF NOT EXISTS ubbt_SEARCH_RESULTS (
  SEARCH_SESSION_ID varchar(32) NOT NULL DEFAULT '',
  SEARCH_WORDS varchar(255) DEFAULT NULL,
  SEARCH_EXCLUDED_WORDS varchar(255) DEFAULT NULL,
  SEARCH_RESULTS mediumtext,
  SEARCH_TIMESTAMP int(11) DEFAULT NULL,
  SEARCH_PREVIEW_BODY tinyint(1) DEFAULT NULL,
  SEARCH_SQL_LIMIT tinyint(2) DEFAULT NULL,
  PRIMARY KEY (SEARCH_SESSION_ID),
  KEY time_index (SEARCH_TIMESTAMP)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Re: Well I lost my ubbt_SEARCH_RESULTS table Dunny #243015 05/01/2011 8:15 PM
Joined: Jan 2008 Posts: 514 DE USA Dunny addict
Dunny addict Joined: Jan 2008 Posts: 514 DE USA	Once again SD to my rescue... you are almost my hero at this point Dunny

Re: Well I lost my ubbt_SEARCH_RESULTS table Dunny #243016 05/01/2011 8:20 PM
Joined: Jan 2008 Posts: 514 DE USA Dunny addict
Dunny addict Joined: Jan 2008 Posts: 514 DE USA	It worked perfectly thanks SD

Re: Well I lost my ubbt_SEARCH_RESULTS table Dunny #243017 05/01/2011 8:51 PM
Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA SD Former Developer
SD Former Developer Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA	no problemo

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Well I lost my ubbt_SEARCH_RESULTS table