avandenberghe / bbguild

Guild manager for phpBB 3.2
https://www.avathar.be
GNU General Public License v2.0
3 stars 0 forks source link

sql error in UCP when updating non-wow character #222

Closed avandenberghe closed 10 years ago

avandenberghe commented 10 years ago

when updating non-wow character from ucp :

    General Error
    SQL ERROR [ mysqli ]

    Column 'member_portrait_url' cannot be null [1048]

    SQL

    UPDATE phpbb_bbdkp_memberlist SET member_name = 'Liu', member_realm = 'Seafarer\'s Rest', member_region = 'eu', member_status = 1, member_level = 80, member_race_id = 4, member_class_id = 6, member_role = 'DPS', member_rank_id = 0, member_gender_id = '0', member_comment = 'Liu has been added as a member of your guild on May 19, 2014, 1:41 pm', member_guild_id = 1, member_outdate = 1924902000, member_joindate = 1400450400, phpbb_user_id = '2', member_armory_url = '', member_portrait_url = NULL, member_achiev = 0, game_id = 'gw2', member_title = 'Ra', deactivate_reason = NULL, last_update = 1400492501 WHERE member_id= 1

    BACKTRACE

    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/includes/db/dbal.php
    LINE: 757
    CALL: trigger_error()

    FILE: [ROOT]/includes/db/mysqli.php
    LINE: 189
    CALL: dbal->sql_error()

    FILE: [ROOT]/includes/bbdkp/controller/members/Members.php
    LINE: 655
    CALL: dbal_mysqli->sql_query()

    FILE: [ROOT]/includes/ucp/ucp_dkp.php
    LINE: 284
    CALL: bbdkp\controller\members\Members->Updatemember()

    FILE: [ROOT]/includes/functions_module.php
    LINE: 507
    CALL: ucp_dkp->main()

    FILE: [ROOT]/ucp.php
    LINE: 327
    CALL: p_master->load_active()
    Please notify the board administrator or webmaster: