Help Catalog_items?

[xSeanx]

Hello i tryed to use a New Catalog_items from rz never worked ;/ and i dont know how to back up cata_items so im asking does anyone here have the Catalog_items.sql from phoenix 3.11.0 or a Catalog_items sql code? for it please thanks

 

[Sab]

If you don't know how to work with catalogue, Stop bothering with making a hotel lel.

You're post was really unnecessary, grow up.

How to back up DB files in Navicat:
First right click the table.
Image:

You must be registered for see links

Click dump sql.
Find the file location of where you want to put it the back up file.
Done.

 

[xSeanx]

but i got users on my hotel i dont wanna delete thats why im asking for the file or sql code so i can still keep my users

 

[Sab]

but i got users on my hotel i dont wanna delete thats why im asking for the file or sql code so i can still keep my users

You wont lose your users. (don't delete users table) Just replace your cata_items, furniture, and cata_pages sqls with the ones you have.

 

[xSeanx]

as of right now im using xammp i know people gonna say use navicat i will but for now im running xammp ddos protection and had to problems yet so its not to bad

i tryed to copy it from the emu sql and it said error ? can you get catalogue_items.sql or code for me mate? the one i got now has black boxs ect :/

 

[Sab]

i tryed to copy it from the emu sql and it said error ? can you get catalogue_items.sql or code for me mate? the one i got now has black boxs ect :/

Redownload your emu. Copy and paste the cata SQLs import them to your DB.

 

[xSeanx]

i tryed to copy all the code and put it in there and this is what it comes up with can you help me please

Error
SQL query:

-- -- Dumping data for table `catalog_items` -- INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`, `achievement`) VALUES (1, 134, '19942', 'byesw_hand', 25, 0, 0, 1, '0', 0), (2, 134, '19943', 'byesw_hotel', 25, 0, 0, 1, '0', 0), (3014, 15, '19896', 'wallpaper_single_114', 3, 0, 0, 1, '0', 0), (3015, 15, '19896', 'wallpaper_single_115', 3, 0, 0, 1, '0', 0), (3016, 15, '19896', 'wallpaper_single_201', 3, 0, 0, 1, '0', 0), (3017, 15, '19896', 'wallpaper_single_202', 3, 0, 0, 1, '0', 0), (3018, 15, '19896', 'wallpaper_single_203', 3, 0, 0, 1, '0', 0), (3019, 15, '19896', 'wallpaper_single_204', 3, 0, 0, 1, '0', 0), (3020, 15, '19896', 'wallpaper_single_204', 3, 0, 0, 1, '0', 0), (3021, 15, '19896', 'wallpaper_single_205', 3, 0, 0, 1, '0', 0), (3022, 15, '19896', 'wallpaper_single_206', 3, 0, 0, 1, '0', 0), (3023, 15, '19896', 'wallpaper_single_207', 3, 0, 0, 1, '0', 0), (3024, 15, '19[...]

MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

 

[Hindi]

i tryed to copy all the code and put it in there and this is what it comes up with can you help me please

Error
SQL query:

-- -- Dumping data for table `catalog_items` -- INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`, `achievement`) VALUES (1, 134, '19942', 'byesw_hand', 25, 0, 0, 1, '0', 0), (2, 134, '19943', 'byesw_hotel', 25, 0, 0, 1, '0', 0), (3014, 15, '19896', 'wallpaper_single_114', 3, 0, 0, 1, '0', 0), (3015, 15, '19896', 'wallpaper_single_115', 3, 0, 0, 1, '0', 0), (3016, 15, '19896', 'wallpaper_single_201', 3, 0, 0, 1, '0', 0), (3017, 15, '19896', 'wallpaper_single_202', 3, 0, 0, 1, '0', 0), (3018, 15, '19896', 'wallpaper_single_203', 3, 0, 0, 1, '0', 0), (3019, 15, '19896', 'wallpaper_single_204', 3, 0, 0, 1, '0', 0), (3020, 15, '19896', 'wallpaper_single_204', 3, 0, 0, 1, '0', 0), (3021, 15, '19896', 'wallpaper_single_205', 3, 0, 0, 1, '0', 0), (3022, 15, '19896', 'wallpaper_single_206', 3, 0, 0, 1, '0', 0), (3023, 15, '19896', 'wallpaper_single_207', 3, 0, 0, 1, '0', 0), (3024, 15, '19[...]

MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

It means there already exists an id with that entry, Try changing the ID number manually in the SQL's or deleting those from the database.

 

[xSeanx]

will it work if i drop the catalogue_items then put that in?

 

[Tony Wolf]

Just delete catalogue_items from your db, and importer new catalog_items you will add on your db! Hope it's helped you