vb.org Archive
Page 29 of 29 « First 192728 29
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

Delphiprogrammi 12-07-2006 08:56 PM
Quote:
Originally Posted by wcbryant (Post 1134052)
I recently uninstalled this add-on through the product manager, as I've been having some slow load issues, and I've been going out of my way to cut down on the number of hacks I use. After doing so, when admins try to create new user accounts through admincp, they're getting this error;

Code:
Database error in vBulletin 3.6.4:
 
Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 131072, options - 131072, options),
        options = IF(options & 4096, options - 4096, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Newbie',
    customtitle = 0,
    username = '*',
    email = '*@yahoo.com',
    languageid = 0,
    homepage = '',
    birthday_search = '',
    birthday = '',
    showbirthday = 2,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '164.62.*.*',
    posts = 6,
    vbookie_cash = 500,
    usergroupid = 2,
    membergroupids = '22',
    reputationlevelid = 2,
    reputation = -750,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 1,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '-5',
    daysprune = -1,
    joindate = 1102184940,
    lastactivity = 1165522680,
    lastpost = 1165522140,
    vbp_receivespoints = 1,
    vbp_storeaccess = 1,
    vbbux = 993.911,
    vbbank = 0,
    vbp_nextbankinterest = 0,
    vbp_genericperm = 0,
    vbp_modperm = 0,
    vbp_adminperm = 0,
    vbp_nametextcolor = '',
    vbp_nameglowcolor = '',
    vbp_nameshadowcolor = '',
    vbp_namefonttype = '',
    vbp_titletextcolor = '',
    vbp_titleglowcolor = '',
    vbp_titleshadowcolor = '',
    vbp_titlefonttype = '',
    vbp_changealwaysitems = '',
    ### Bitfield: user.vbp_displayflags ###
        vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
    ### Bitfield: user.vbp_otherflags ###
        vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
    ### Bitfield: user.vbp_immunity ###
        vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
    displaygroupid = '2'
WHERE userid = 1719;
 
MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date        : Thursday, December 7th 2006 @ 01:18:30 PM
Script      : http://www.buckeyeplanet.com/forum/admincp/user.php?do=update
Referrer    : http://www.buckeyeplanet.com/forum/admincp/user.php?do=edit&u=1719
IP Address  : 165.166.*.*
Username    : (admin-name)
Classname    : vB_Database_MySQLi
I've read through the archive I used to download, and tried to page through these 75 pages as best I can looking for a clear cut solution, but if one exists, I've over looked it.

Is this as easy as running a couple queries to complete the uninstall, and if so, where might I find those (I have no real comfort level with mysql myself), either way, will any change I make interfere with vB's built in warning system?

Thanks in advance for any help. I probably should have just left AWS disabled instead of flat uninstalling it, but like I said, trying to slim down.
the warnings field belongs the vbulletin infractions system.Hoever if you used the system on a 3.5.x (any release) then this would cause that field to be deleted when you uninstalled this hack.This problem can be solved by

[SQL]
ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';
[/SQL]

Your problem is most likely caused by running vb 3.5.x then you upgraded to 3.6 and you uninstalled the 3.5.x version of this hack which would delete the warnings field.Run the query and that error should be gone

wcbryant 12-09-2006 01:19 AM
Thanks so much, Delphi, that did the trick. Felt silly asking, and figured it would be something simple like that, but didn't want to make anything worse.

tank14 12-31-2006 08:39 PM
In the advanced warning system, I get an error, when I try to add a number here...Warnings Number LimitMembers are also banned when they accumulate this number of warnings....I would much rather use this, but when I change it, it goes completely BLANK...LOL Please help I love this hack system =P

tank14 12-31-2006 08:41 PM
I noticed something else, I dont even get a little question mark on it.

tank14 12-31-2006 08:54 PM
I also have this???

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE user SET warning_level='10', warnings='1' WHERE userid='2';

MySQL Error : Unknown column 'warning_level' in 'field list'
Error Number : 1054
Date : Sunday, December 31st 2006 @ 04:53:29 PM
Script : http://xboxcrave.com/vb/Warn.php
Referrer : http://xboxcrave.com/vb/Warn.php?do=...r&id=2&post=18
IP Address : 69.243.173.129
Username : Jagged X sL4Sh
Classname : vb_database

tank14 12-31-2006 10:42 PM
Sorry, I went to vb 3.6.x for the version I need..Thanks!

kofoid 01-06-2007 05:35 PM
None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??

Delphiprogrammi 01-06-2007 06:53 PM
Quote:
Originally Posted by kofoid (Post 1152070)
None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??
that's normal.You need to edit each template seperatly.We are not allowed to distrubute anything that's part of vbulletin.So you need to goto your style manager and edit this vBulletin templates
  • postbit & postbit_legacy
  • MEMBERINFO
  • memberinfo_resultbits
  • navbar
  • pm_newpm

if you do not understand howto do this give me a yell and i will explain in detail


All times are GMT. The time now is 03:11 PM.
Page 29 of 29 « First 192728 29
Show 40 post(s) from this thread on one page

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.02753 seconds
  • Memory Usage 1,753KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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