bundle/bundle command don't work properly

Issue #953 resolved
Oscuridad created an issue

Description: When using :bundle, the comman doesn't add an ID on the catalog_pages, and even if you add the ID by yourself the bundle doens't show up.

Long Description: So there is no much to add, I was messing around with the :bundle command and when I used the command it would add all the information to catalog_pages with the only excepcion of the ID, for what I saw on emulator_texts, I should get a message saying "Roombundle succesfully created with page id %id%", but since this doesn't add the ID you never actually get said message.

Also, if once you add the proper ID to the catalog, you update the catalogue the page will show up but the items in the bundle will not.

Media: https://www.youtube.com/watch?v=SSst6KJiBHE (sorry about the lags, my computer is feeling old :P)

Comments (6)

  1. Oliver

    Can replicate. It didn't fill the "room_id"-column and "page_id"-column. Also the badges don't work which have a different issue already. However, the bundles can easily be fixed from database. Bundle-command is just deluxe tbh. :P

  2. Wesley repo owner

    Fixed in 1.12.0.

    Or run this:

    ALTER TABLE `catalog_pages` CHANGE `page_headline` `page_headline` VARCHAR(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_teaser` `page_teaser` VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_special` `page_special` VARCHAR(2048) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_text1` `page_text1` VARCHAR(2048) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_text2` `page_text2` VARCHAR(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_text_details` `page_text_details` VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CHANGE `page_text_teaser` `page_text_teaser` VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
    
  3. iPrinz96

    I have run this code. But not reaction. I have restart the Emulator, after this SQL command.

    But dont work :/

  4. Oscuridad reporter

    I've run the command and tried (showed two errors messages about Column 'page_layout' has duplicated value 'pets2' in ENUM and Column 'page_layout' has duplicated value 'pets3' in ENUM) and didn't work, the query added 0 to the id. Also tried making a new bundle, nothing, and last making a new bundle and running the SQL query, same result.

    I'll wait to the release of 1.12.0 to try out and then update this :)

  5. Log in to comment