View Single Post
  #653  
Old 11-17-2005, 10:57 AM
one9er one9er is offline
 
Join Date: Mar 2005
Location: USA
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by tnguy3n
Did you read the MySQL warning? your userpage table doesn't exist.
you can insert it manually if the installer doesn't create the table.
PHP Code:
CREATE TABLE userpage (
  
userid int(15unsigned NOT NULL default '0',
  
pagedata text NOT NULL,
  
rating int(11NOT NULL default '0',
  
dateline int(10NOT NULL default '0',
  
username varchar(255NOT NULL default '',
  
views int(10NOT NULL default '0',
  
numvotes int(11NOT NULL default '0',
  
votetotal int(11NOT NULL default '0',
  
PRIMARY KEY  (userid)
TYPE=MyISAM 
need to know a bit about mysql + php to run a website.
Did that, now I get something about the userID?

Quote:
Database error in vBulletin 3.5.1: Invalid SQL: SELECT * FROM userpage WHERE userid=0; MySQL Error : Unknown column 'userid' in 'where clause' Error Number : 1054 Date : Thursday, November 17th 2005 @ 01:32:41 PM Script : http://charlie11acr.org/ Referrer : IP Address : 00.00.000.00 Username : Unregistered Classname : vb_database
Just need to get some help and then delete this plugin.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01212 seconds
  • Memory Usage 1,780KB
  • 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_php
  • (2)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