Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools
Probelm (mysql error 1136) Details »»
Probelm (mysql error 1136)
Version: , by JJB2004 JJB2004 is offline
Developer Last Online: Jul 2006 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-09-2005 Last Update: Never Installs: 0
 
No support by the author.

Hi,
I get this error when I try to add or update a warning type:

Database error in vBulletin 3.0.6:

Invalid SQL: insert into warning_types values(
'',
'Cyber',
'5',
'Anything related to cyber including agreeing to and asking for',
'99999',
'No',
'Yes',
'No',
''
)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 09th of June 2005 05:07:41 PM
Script: http://www.realmfighter.com/forums/a...admin_warn.php

Also, I if it helps I ran the query "describe warning_types" and this information came up:

tid int(15) PRI NULL auto_increment
warn_name varchar(255)
warn_points int(15) 0
warn_desc text
warn_maturity int(5) YES NULL
warn_permban char(3) YES NULL
warn_type char(3) YES NULL

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-10-2005, 05:04 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

First of all, I do not know which version of AWS you are running, but it looks as if your warning_types table is missing some columns. Add them using the following queries:

ALTER TABLE `warning_types` ADD COLUMN `warn_alert` char(3)
ALTER TABLE `warning_types` ADD COLUMN `warn_alertcomment` mediumtext

Remember to add any prefix you might be using in front of the table name.
  #3  
Old 08-25-2005, 04:16 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vB 2.3.2?? This is a vB3 hack.
  #4  
Old 08-25-2005, 04:18 AM
ChAiN LeTtEr's Avatar
ChAiN LeTtEr ChAiN LeTtEr is offline
 
Join Date: Aug 2002
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, I saw that after I posted. The error numbers were the same so it pulled it up in a search so... heh ah well.
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:46 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05163 seconds
  • Memory Usage 2,225KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete