View Single Post
  #5  
Old 10-08-2013, 12:32 AM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I tried phpMyAdmin first. Then I tried to run the querys through tools.php, since I can't get the forum to load without vb_session. Sorry, I thought the 0s went out once you added the CHARS. That's what I get for guessing.

--------------- Added [DATE]1381199746[/DATE] at [TIME]1381199746[/TIME] ---------------

Quote:
Originally Posted by nerbert View Post
Try this:
[sql]
CREATE TABLE vb_session (
sessionhash CHAR(32) NOT NULL DEFAULT '',
userid INT(10) NOT NULL DEFAULT '0',
host CHAR(15) NOT NULL DEFAULT '',
idhash CHAR(32) NOT NULL DEFAULT '',
lastactivity INT(10) NOT NULL DEFAULT '0',
location CHAR(255) NOT NULL DEFAULT '',
useragent CHAR(100) NOT NULL DEFAULT '',
styleid SMALLINT(5) NOT NULL DEFAULT '0',
languageid SMALLINT(5) NOT NULL DEFAULT '0',
loggedin SMALLINT(5) NOT NULL DEFAULT '0',
inforum SMALLINT(5) NOT NULL DEFAULT '0',
inthread INT(10) NOT NULL DEFAULT '0',
incalendar SMALLINT(5) NOT NULL DEFAULT '0',
badlocation SMALLINT(5) NOT NULL DEFAULT '0',
bypass TINYINT(4) NOT NULL DEFAULT '0',
profileupdate SMALLINT(5) NOT NULL DEFAULT '0',
PRIMARY KEY (sessionhash)
);
[/sql]

But there are a lot of people here a lot better than I am with sql.

Where are you doing this? In your admin CP? I would just do it with phpMyAdmin in cPanel.

EDIT: What happened to all those default values of '0'? Those should all be in there. I put them back in.
Oh brother, I was running them through the wrong box in phpMyAdmin. <facepalm> Can you tell I don't know what I'm doing? This worked. Thanks!

But...

Yeah, I just now noticed that I'm missing more than vb_session. vb_user is gone, too. I hate SSL, but I'm going to see if I can run one of my last backups. It's probably not very current. But I seldom did them when my site started slowing down. Thanks again, though.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02076 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete