Printable View
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
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.
Quote:
Originally Posted by Robot
Can you come teamviewer and help me? please
Theirs no need for me to come on teamview bud, just count how many columns u got in your catalog_items table?
16 columns
Then theres your problem, the sql above only has 9 columns, you need another 7 :)
Quote:
Originally Posted by Robot
okay but what for emulator should i use who is easy to setup and there is good catalogue??
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 :(Quote:
Originally Posted by Pastie
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.
Quote:
Originally Posted by Pastie
i fixed it but when i get the new stuff to catalogue it didn't show up :(
Did you add the swfs and the furnidata?
Quote:
Originally Posted by Pastie
yes i did that
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.
Quote:
Originally Posted by Pastie
i already did but nothing happens, can you show me how to fix new stuff to catalogue r63b GTE?