Please help my custom furni wont work :(

Results 1 to 7 of 7
  1. #1
    Novice drsaad is offline
    MemberRank
    Jan 2014 Join Date
    Tilburg, NetherLocation
    4Posts

    config Please help my custom furni wont work :(

    this is the code i am using


    INSERT INTO `items` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES
    (78092011, 'hh_santaclauss', 'hh_santaclauss', 's', 1, 1, 1, '0', '0', '0', 15040909, '1', '1', '0', '0', '1', 'default', 4, '0');


    INSERT INTO `catalog_items_copy` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
    (78092011, '94', '78092011', 'hh_santaclauss', '50000', '0', '1');


    i am getting this error


    #1054 - Unknown column 'id' in 'field list'


  2. #2
    Apprentice aidildaniel is offline
    MemberRank
    Dec 2012 Join Date
    MalaysiaLocation
    15Posts

    Re: Please help my custom furni wont work :(

    ID maybe has been used, so use another number.

    - - - Updated - - -

    Try Using This :


    PHP Code:
    INSERT INTO `items` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES(`135790`, `hh_santaclauss`, `hh_santaclauss`, `s`, `1`, `1`, `1`, `0`, `0`, `0`, `15040909`, `1`, `1`, `0`, `0`, `1`, `default`, `4`, `0`); 

    PHP Code:
    INSERT INTO `catalog_items_copy` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES(`135790`, `94`, `135790`, `hh_santaclauss`, `50000`, `0`, `1`); 
    Last edited by aidildaniel; 19-01-14 at 11:51 AM.

  3. #3
    Novice drsaad is offline
    MemberRank
    Jan 2014 Join Date
    Tilburg, NetherLocation
    4Posts

    Re: Please help my custom furni wont work :(

    wont work

  4. #4
    Apprentice aidildaniel is offline
    MemberRank
    Dec 2012 Join Date
    MalaysiaLocation
    15Posts

    Re: Please help my custom furni wont work :(

    ._. , wat the error? and wat emu you use?

  5. #5
    Novice drsaad is offline
    MemberRank
    Jan 2014 Join Date
    Tilburg, NetherLocation
    4Posts

    Re: Please help my custom furni wont work :(

    Quote Originally Posted by aidildaniel View Post
    ._. , wat the error? and wat emu you use?
    Butterfly and using phpcms

  6. #6
    Enthusiast EntityRetros is offline
    MemberRank
    Jan 2014 Join Date
    United KingdomLocation
    25Posts

    Re: Please help my custom furni wont work :(

    The error is saying that there is no column called ID to insert data in to. Maybe it is something like item_id? I'm not too experienced with Butterfly emulator and database so I am not sure, but give it a go anyway.
    Good luck!

  7. #7
    Enthusiast feyestan is offline
    MemberRank
    Jan 2009 Join Date
    HollandLocation
    44Posts

    Re: Please help my custom furni wont work :(

    Change items to items_base thats the correct table



Advertisement