vb.org Archive - Advanced Warning System (Beta Version)

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=...571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

Delphiprogrammi

08-15-2006 09:36 AM

Quote:

Originally Posted by Tayeb

you don't have a warning_bans field in the user table ? try this

Code:

DESCRIBE user;

if the warning_bans field is not there

Code:

ALTER TABLE user ADD warning_bans INT(2) DEFAULT '0';

*=keep table prefixes in mind or the queries won't work

UZFRED

08-15-2006 10:21 AM

How can I fully uninstall this modification so I'm sure nothing is left in my database?

Delphiprogrammi

08-15-2006 03:51 PM

Quote:

Originally Posted by UZFRED

How can I fully uninstall this modification so I'm sure nothing is left in my database?

uninstall the product.All associated settings & phrases & templates will be deleted (don't forget to delete the files from your webspace)If you are still able to find database entries that belong to this system then you have a verry old version installed which you have never deleted ?

if you used a version from before 3.5.x (thus before the product system was introduced) and you didin't run the uninstaller before installing the 3.5.x port then that stuff will be still in your databse

dutchbb

08-16-2006 02:53 PM

Quote:

Originally Posted by Delphiprogrammi

you need a slightly different query for the infraction system

Code:

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

*= don't forget table prefixes

Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got

Quote:

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

#1060 - Duplicate column name 'warnings'

What should I do?
Thank you

Delphiprogrammi

08-17-2006 07:12 PM

Quote:

Originally Posted by Triple_T

Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got

What should I do?
Thank you

if the warning_bans field is in the user table MySQL should not tell you the field is missing ..

Delphiprogrammi

08-17-2006 07:17 PM

3.6.0 is running on my live board :D we are getting there ....

dutchbb

08-17-2006 09:59 PM

Quote:

Originally Posted by Delphiprogrammi

if the warnings field is in the user table MySQL should not tell you the field is missing ..

I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

Delphiprogrammi

08-18-2006 09:42 AM

Quote:

Originally Posted by Triple_T

I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

yes that can cause database errors run this

Code:

ALTER TABLE user DROP warning_bans;

ALTER TABLE user ADD COLUMN warning_bans INT(2) DEFAULT '0';

now i would test it.Define a warningtype that would cause a ban when it get's issued and see what happends

All times are GMT. The time now is 04:30 AM.

Page 110 of 113

110

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03490 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: