Thread: Miscellaneous Hacks - Rules and User Agreement Hack
View Single Post
  #219  
Old 09-22-2006, 10:46 AM
Kriminal's Avatar
Kriminal Kriminal is offline
 
Join Date: Dec 2004
Location: Buenos Aires
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by nimonogi
The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.

Code:
Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack 
  	  			(forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
  	  			 usernames, postmore, postless, joindateafter, joindatebefore, 
  	  			 lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore, 
				 conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch) 
  	  			 values ('6', 'Text', 'Text[/b]', '', '0', 
  	  			 '2', '', '', '', '0', 
  	  			 '10', UNIX_TIMESTAMP(''), 
  	  			 UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''), 
  	  			 UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''), 
 	  			 UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '', 
 	  			 '0');

MySQL Error  : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date         : Friday, September 22nd 2006 @ 05:55:25 AM
Script       : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer     : http://www.domain.com/login.php?do=login
IP Address   : ***
Username     : ***
Classname    : vb_database
If you have installed this hack previously, yo must alter table manually and change field repeat as repeated.
You may run this query:

Code:
alter table `ruleshack` change `repeat` `repeated` smallint (1)  DEFAULT '0' NOT NULL
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01399 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)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