View Single Post
  #193  
Old 12-19-2005, 01:39 AM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's really weird. Somehow it thinks you already have the quotes table when apparently you don't. Run these two queries to add the tables:

Code:
CREATE TABLE $TPquotes (
	quoteid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	quote MEDIUMTEXT NOT NULL,
	author VARCHAR(75) NOT NULL,
	userid INT(10) UNSIGNED NOT NULL DEFAULT 0,
	approved TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
	votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0,
	rating MEDIUMINT(10) NOT NULL DEFAULT 0,
	average FLOAT(3, 2) NOT NULL DEFAULT 0.00,
	context VARCHAR(250),
	PRIMARY KEY (quoteid),
	INDEX (rating),
	INDEX (average),
	KEY approved (approved))
Code:
CREATE TABLE $TPquoteratings (
	quoteid INT(10) UNSIGNED NOT NULL,
	userid INT(10) UNSIGNED NOT NULL,
	rating TINYINT(1) NOT NULL,
	PRIMARY KEY (quoteid, userid))
As always, replace $TP with your table prefix.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01141 seconds
  • Memory Usage 1,764KB
  • 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
  • (2)bbcode_code
  • (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