The Arcive of Official vBulletin Modifications Site.

Shazz · #1 07-18-2006, 03:48 PM

PHP Code:


			
Database error in vBulletin 3.5.4:



Invalid SQL:

UPDATE user SET

    ### Bitfield: user.options ###

        options = IF(options & 8, options - 8, options),

        options = IF(options & 1024, options - 1024, options),

        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 & 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),

    usertitle = 'Banned',

    customtitle = 0,

    username = 'CAp i TOLL Z',

    email = 'ass@aim.com',

    languageid = 1,

    homepage = '',

    birthday_search = '1975-03-04',

    birthday = '03-04-1975',

    showbirthday = 2,

    icq = '',

    aim = '',

    yahoo = '',

    msn = '',

    skype = '',

    parentemail = '',

    posts = 1,

    referrerid = '221',

    ipaddress = '*edit out',

    acceptbattles = 1,

    battle_wins = 0,

    battle_losses = 0,

    battle_ko = 0,

    usergroupid = 8,

    reputationlevelid = 5,

    reputation = 10,

    pmpopup = 0,

    autosubscribe = -1,

    threadedmode = 0,

    showvbcode = 1,

    styleid = 0,

    timezoneoffset = '-5',

    daysprune = 0,

    joindate = 1151804880,

    lastactivity = 1151805420,

    lastpost = 1151805060,

    advpmoptions_savecopy = 1,

    advpmoptions_receipt = 0,

    advpmoptions_deleteoriginal = 0,

    membergroupids = '',

    vbp_receivespoints = 1,

    vbp_storeaccess = 1,

     = 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)

WHERE userid = 223;



MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0,

    vbp_nextbankinterest = 0,

    vbp_genericperm = 0,

    vbp_m

Error Number : 1064

Date         : Tuesday, July 18th 2006 @ 12:44:44 PM

Script       : http://www.dawritersblock.com/admincp/user.php

Referrer     : http://www.dawritersblock.com/admincp/user.php?do=edit&u=223

IP Address   : *edit out

Username     : Shazz

Classname    : vb_database

It happends when i try and Update someones profile.
Like Search Users> change something then hit save.
This happends =\
I haven't installed any hacks or plugins..
________
Ducati 350 Desmo

ericgtr · #2 07-18-2006, 09:31 PM

Are you sure you don't have any mods installed? I don't believe nextbankinterest is a default table. Do you (or did you) have any point system installed? If so I would disable or uninstall it and try again.

Shazz · #3 07-18-2006, 10:23 PM

Yea i found out that was the problem when i ran GZIP
thanx though
________
Ford Maverick history

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03545 seconds Memory Usage 2,245KB Queries Executed 13 (?)
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)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (3)post_thanks_box (3)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit_info (3)postbit (3)postbit_onlinestatus (3)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_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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!