View Single Post
  #70  
Old 09-13-2005, 11:56 AM
wcbryant wcbryant is offline
 
Join Date: Dec 2003
Location: Florida
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just upgraded from RC2 to RC3 this morning, and installed AWS shortly thereafter. Everything seemed to go smoothly, and I've set the new options, but I'm getting some errors;

When warning a dummy account;
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
update user set warning_level='10', warnings='1' where userid='5264';

MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Tuesday, September 13th 2005 @ 05:42:18 AM
Script       : http://www.sitename.com/forum/Warn.php
Referrer     : http://www.sitename.com/forum/Warn.php?do=WarnUser&id=5264&post=261259
IP Address   : xx.xx.xx.xx
Username     : Clarity
Classname    : vB_Database_MySQLi
When hitting (in admincp) Statistics - Warnings Per User;

Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;

MySQL Error  : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date         : Tuesday, September 13th 2005 @ 05:54:06 AM
Script       : http://www.sitename.com/forum/admincp/admin_warn.php?act=viewwarnedusers&type=warnings
Referrer     : http://www.sitename.com/forum/admincp/index.php?do=nav
IP Address   : xx.xx.xx.xx
Username     : Clarity
Classname    : vB_Database_MySQLi
Sounds like I'm missing a column, but not sure how or why. Any ideas? Been poking around for about an hour, not sure where the issue is. I did have the 3.0.x version installed before moving up to 3.5.0, perhaps when it discovered the old tables, it didn't create some new one somehow? No idea.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01065 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
  • (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