I can't fix new stuff to Catalogue i get error

Results 1 to 15 of 15
  1. #1
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    ! I can't fix new stuff to Catalogue i get error

    I get this error when i try to fix new custom furni and more

    [SQL]INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES (1875612, '59', '1875612', 'Siège Public #3 ', '5', '0', '0', '1');
    [Err] 1364 - Field 'song_id' doesn't have a default value


  2. #2
    Retired Robot is offline
    Grand MasterRank
    Apr 2015 Join Date
    EnglandLocation
    720Posts

    Re: I can't fix new stuff to Catalogue i get error

    Go in your catalog_items and count how many columns there are altogether, then u may find your problem there as the sql that your trying to run isn't working due to columns missing.

  3. #3
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Robot View Post
    Go in your catalog_items and count how many columns there are altogether, then u may find your problem there as the sql that your trying to run isn't working due to columns missing.

    Can you come teamviewer and help me? please

  4. #4
    Retired Robot is offline
    Grand MasterRank
    Apr 2015 Join Date
    EnglandLocation
    720Posts

    Re: I can't fix new stuff to Catalogue i get error

    Theirs no need for me to come on teamview bud, just count how many columns u got in your catalog_items table?

  5. #5
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    16 columns

  6. #6
    Retired Robot is offline
    Grand MasterRank
    Apr 2015 Join Date
    EnglandLocation
    720Posts

    Re: I can't fix new stuff to Catalogue i get error

    Then theres your problem, the sql above only has 9 columns, you need another 7 :)

  7. #7
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Robot View Post
    Then theres your problem, the sql above only has 9 columns, you need another 7 :)

    okay but what for emulator should i use who is easy to setup and there is good catalogue??

  8. #8
    Elite Member Pastie is offline
    Member +Rank
    May 2014 Join Date
    FranceLocation
    133Posts

    Re: I can't fix new stuff to Catalogue i get error

    You can use Phoenix if you want the old look, or Azure / Nova if you want the new look.
    You can find and download custom catalogues for the emulators, or create your own.

    Thanks,
    Pastie.

  9. #9
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Pastie View Post
    You can use Phoenix if you want the old look, or Azure / Nova if you want the new look.
    You can find and download custom catalogues for the emulators, or create your own.

    Thanks,
    Pastie.
    But i have gte emulator r63b and i want that emulator but i want someone help me fix the problem :(

  10. #10
    Elite Member Pastie is offline
    Member +Rank
    May 2014 Join Date
    FranceLocation
    133Posts

    Re: I can't fix new stuff to Catalogue i get error

    What do you need help with? @Robot said what you have to do to fix the SQL...
    If you don't know how to add these columns to your sql, you can find a sql generator or something for Gold Tree Emulator.

    Thanks,
    Pastie.

  11. #11
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Pastie View Post
    What do you need help with? @Robot said what you have to do to fix the SQL...
    If you don't know how to add these columns to your sql, you can find a sql generator or something for Gold Tree Emulator.

    Thanks,
    Pastie.


    i fixed it but when i get the new stuff to catalogue it didn't show up :(

  12. #12
    Elite Member Pastie is offline
    Member +Rank
    May 2014 Join Date
    FranceLocation
    133Posts

    Re: I can't fix new stuff to Catalogue i get error

    Did you add the swfs and the furnidata?

  13. #13
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Pastie View Post
    Did you add the swfs and the furnidata?


    yes i did that

  14. #14
    Elite Member Pastie is offline
    Member +Rank
    May 2014 Join Date
    FranceLocation
    133Posts

    Re: I can't fix new stuff to Catalogue i get error

    If it didn't show up in the catalogue at all, maybe you forgot to update the catalogue? Use :update_catalogue or restart your emulator.

  15. #15
    Elite Member Zlatan is offline
    Member +Rank
    Aug 2015 Join Date
    130Posts

    Re: I can't fix new stuff to Catalogue i get error

    Quote Originally Posted by Pastie View Post
    If it didn't show up in the catalogue at all, maybe you forgot to update the catalogue? Use :update_catalogue or restart your emulator.

    i already did but nothing happens, can you show me how to fix new stuff to catalogue r63b GTE?



Advertisement