View Single Post
  #304  
Old 12-14-2004, 07:54 PM
SamirDarji SamirDarji is offline
 
Join Date: Apr 2004
Posts: 645
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, here's what I got back from the SQL Query:
Code:
Database forum - Table warning_options running on hsvtest.ods.org 
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: alter table warning_options 
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

SQL-query :  

alter table warning_options add `hierarchical` char(3), add `automatic` char(3), add `automatic_warner` int(10) unsigned, add `warner` int(15), add `troll_usergroup_id` varchar(10), add `aprotected_usergroups` varchar(0), add `restore_groupid` smallint(5) unsigned, add `incr_ban_days` char(3), add `max_no_bans` int(5), add `viewoption` char(3), add `multiple_per_post` char(3), add `send_pm_warning` char(3), add `send_em_warning` char(3), add `historical` char(3), add `allowoffpost` char(3), add `warnings_per_page` int(3)"; 

MySQL said: 


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead
I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01285 seconds
  • Memory Usage 1,767KB
  • 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_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