Jump to content

Batnik

Members
  • Posts

    199
  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by Batnik

  1. Due to index size restrictions in MySQL, this does mean we need to re-create a handful of indexes to fit within MySQL’s rules. Using a standard configuration, MySQL allows 767 bytes per index, which for utf8 means 767 bytes / 3 bytes = 255 characters. For utf8mb4, that means 767 bytes / 4 bytes = 191 characters.

    im creating a converter now, i will no longer wait for invision, should be done next days.

  2. yep i just checked the box for UTF-8 tooo, didnt really realize that it can not be undone .................

    the converter is a script that can be done in max. 5 hours but i wait until invision does it ...

     

  3. There is one setting now:
    Moderate new records

    But one VERY Important setting is missing:
    Moderate records changes

    Without this setting the whole system is useless as the user can post cool new posts and after they get approved they are posting porn stuff in it ... and i dont even get informed about post changes AT ALL!!! do i always have to get there and see if there is changed content ... every hour, every minute?

    So why dont moderate post changes?

    Here is a possible solution:

    1. after the user changes the post
      1. inform moderator
      2. save a copy of this post: "set this post for moderation"
      3. from now on this user sees only this "edit-copy" of this post, all other users see the original post
      4. let the user edit this copy so many times he wants to
      5. after every submit, the post is sent for submiting (if revisions are enabled only this revision)
      6. no need to hide or delete the original post unit changes are confirmed as its different postID
      7. if revisions are enabled => use it insead of postID or always use revisions when wiki-editing is enabled
    2. after the moderator confirmed the changes
      1. ovverride the orginal post with the new version
      2. delete the copy or save a revision
      3. inform user => post approved

    This system right now makes absolutely no sense without changes-moderation. So please make some changes or disable it completly.

    What you think?

  4. I got something for you:
    
    # For each database:
    ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
    # For each table:
    ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    # For each column:
    ALTER TABLE table_name CHANGE column_name column_name VARCHAR(XXXXX) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    # (Dont blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
  5. I installed my Forums without utf8mb4, thats pain in the ass. There are several errors resulting in inconstistent Datebase-Tables, empty Threads etc.

    The Emojis-Fix from 4.0.8 only fixes the Emojis ...

    How can i reconvert Everything to utf8mb4 ???
    As i see there is no Converter for IPS4.

×
×
  • Create New...