Title: nbi1's Replies | WordPress.org

---

# nbi1

  [  ](https://wordpress.org/support/users/nbi1/)

 *   [Profile](https://wordpress.org/support/users/nbi1/)
 *   [Topics Started](https://wordpress.org/support/users/nbi1/topics/)
 *   [Replies Created](https://wordpress.org/support/users/nbi1/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/nbi1/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/nbi1/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/nbi1/engagements/)
 *   [Favorites](https://wordpress.org/support/users/nbi1/favorites/)

 Search replies:

## Forum Replies Created

Viewing 15 replies - 1 through 15 (of 21 total)

1 [2](https://wordpress.org/support/users/nbi1/replies/page/2/?output_format=md)
[→](https://wordpress.org/support/users/nbi1/replies/page/2/?output_format=md)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] SESSION variable ‘max_allowed_packet’ is read-only](https://wordpress.org/support/topic/session-variable-max_allowed_packet-is-read-only/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/session-variable-max_allowed_packet-is-read-only/#post-15420282)
 * Thanks, I’ll check that out.
 * How do I check the plugin version in a scenario like this where the installer
   hasn’t completed yet? Can’t go to the WP dashboard because installation hasn’t
   finished. wp-cli can’t help because the dashboard isn’t available. Is your plugin
   version a string in one of the files?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] SESSION variable ‘max_allowed_packet’ is read-only](https://wordpress.org/support/topic/session-variable-max_allowed_packet-is-read-only/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/session-variable-max_allowed_packet-is-read-only/#post-15416651)
 * As an experiment I commented out line 60. Line 85 also required ‘GLOBAL’. With
   these 2 changes the installer completed successfully. Hopefully the installation
   isn’t hosed, at least according to the installer there were no problems (with
   these fixes in place).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] installer broken – check collation capability incorrect](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/#post-15416430)
 * Your workaround solves the problem, thank you. Now I’ve got other issues to deal
   with, but at least the collation check isn’t derailing the process.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] installer broken – check collation capability incorrect](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/#post-15415908)
 * Thanks, that’s what I was looking for. I’ll give that a try. I opened a ticket
   just to make sure this issue gets tracked. I think the fixes I proposed will 
   work just fine – I assumed it’s just a matter of constructing a correct collation
   list when the archive is built and your suggested workaround indicates that this
   is the case.
    -  This reply was modified 4 years, 2 months ago by [nbi1](https://wordpress.org/support/users/nbi1/).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] installer broken – check collation capability incorrect](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/#post-15413621)
 * Figured it out. My instincts about an incorrect check were on target – the installer
   is indeed performing an invalid check.
 * During the backup of the original you execute the above query to get the list
   of collations. That’s fine. But when you store the list in the installer you 
   store utf8_general_ci when in fact utf8_general_ci does not appear in the query
   result! Why? Because you find utf8mb3_general_ci which is an alias for utf8_general_ci
   and you unalias before storing the list. So at the restore end of the operation
   the installer consults the list which includes utf8_general_ci and the validation
   fails because it’s not found in the server collation list. But it is there – 
   as the alias utf8mb3_general_ci ! Actually the installer hints at this problem
   with its output – it should not be showing utf8_general_ci it should show utf8mb3_general_ci
   because the aliased form is used in newer versions of MariaDB (I didn’t know 
   that until I researched this issue).
 * So the fix consists of 2 checks when backing up:
    1. If the collation query returns
   utf8mb3_general_ci store that – do not store the unaliased utf8_general_ci. 2.
   If the collation query returns utf8_general_ci (old MariaDB) store the alias 
   utf8mb3_general_ci instead.
 * These checks will ensure that with a newer (older doesn’t make sense) MariaDB
   the installer will properly try to match utf8mb3_general_ci in its list against
   utf8mb3_general_ci in the server collation list.
 * This fix will solve the problem for anyone going through the backup/restore cycle
   for the first time. It won’t help those like me who already have an installer
   backup set with utf8_general_ci instead of utf8mb3_general_ci. Couple of possible
   solutions for that: 1. a standalone tool/script that fixes the installer’s collation
   list, or 2. add installer option to handle this case (can’t just omit this validation
   because if utf8mb3_general_ci is missing from the server then there is a real
   problem). Manually hacking the installer list would probably work if I knew where
   it was buried, but I’m sure you don’t want the headaches resulting from asking
   users to do this.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] installer broken – check collation capability incorrect](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/#post-15413215)
 * Sorry, didn’t see your response when I posted – disregard my last post. Based
   on your response I have a theory on what might be going on, but I’ll need to 
   do some testing to confirm.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] installer broken – check collation capability incorrect](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/installer-broken-check-collation-capability-incorrect/#post-15413195)
 * My guess is that the bug consists of just looking for ‘utf8’ to infer which collations
   are needed. This wouldn’t be a problem with older versions of MariaDB (pre 10.6.4?)
   because these older server versions still included utf8/utf8_general_ci. So even
   if utf8 is erroneously flagged as needed it’ll still get past the installer because
   the server supports it. But the newer versions (10.6.4+) do not so the bug is
   exposed. Googling shows numerous reports about the MariaDB utf8 problem, this
   is typical: [https://www.mail-archive.com/misc@openbsd.org/msg179329.html](https://www.mail-archive.com/misc@openbsd.org/msg179329.html).
   If my guess is correct the fix should be simple – don’t look for ‘utf8’, look
   for ‘utf8mb4’.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] PHP 8.1 Compatibility…](https://wordpress.org/support/topic/php-8-1-compatibility-2/)
 *  [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/php-8-1-compatibility-2/#post-15410225)
 * The plugin might be 8.1 compatible, but installer.php is not.
 * /var/log/apache2/error.log:
    [Mon Feb 28 00:04:57.016844 2022] [php:error] [pid
   24518] [client 192.168.1.5:50674] PHP Fatal error: Array and string offset access
   syntax with curly braces is no longer supported in /var/www/html/installer.php
   on line 632
 * I had backed up my WP installation over a year ago and only recently attempted
   a restore when I encountered this. This and other problems surfaced in a number
   of plugins that weren’t updated for php8.1.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] formatting post text](https://wordpress.org/support/topic/formatting-post-text/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/formatting-post-text/#post-12456668)
 * WPematico supposedly can find images in source articles and set them to be the
   featured image, but that isn’t working. I just found one of your tutorials on
   featured image which seems to contain code for extracting the first found article
   image as the featured. I’ll give that a try.
 * Regarding the display of the image I may have misunderstood something in the 
   docs. I took image_size=”thumbnail” to mean scale & display the featured image.
   It seemed to me that the presence of “image_size” would make include_image=”true”
   unnecessary since one wouldn’t use “image_size” unless the intent was to display
   the image. But based on your comment both are necessary if one wants to display
   a thumbnail?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] how to display post source?](https://wordpress.org/support/topic/how-to-display-post-source/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/how-to-display-post-source/#post-12456534)
 * I’m using WPematico for feed aggregation. You are correct, a unique category 
   for each source is a good solution. Another possibility is creating a unique 
   campaign for each source.
 * The next 2 issues to grapple with are the publication dates of the articles in
   the posts (for which I can’t find a parameter) and setting an article image to
   be the featured image.
 * I’ll probably need to create a custom template as well, but I found a straightforward
   recipe for doing that so that won’t be an impediment. Regarding the publication
   date maybe I missed something while looking at the parameter listing. It just
   seems like that would be a commonly used data item to be displayed.
 * Many thanks.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WPeMatico RSS Feed Fetcher] set featured image not working](https://wordpress.org/support/topic/set-featured-image-not-working-17/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/set-featured-image-not-working-17/#post-12452035)
 * I aggregate multiple feeds and I checked the page source of the feed items – 
   they definitely contain images (). Yes, I had already looked at that article 
   and used the recommended global settings.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] Grid not working anymore](https://wordpress.org/support/topic/grid-not-working-anymore/)
 *  [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/grid-not-working-anymore/#post-12378326)
 * Thanks – greatly appreciated.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] Grid not working anymore](https://wordpress.org/support/topic/grid-not-working-anymore/)
 *  [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/grid-not-working-anymore/#post-12374744)
 * The CSS works ok – the problem was that I didn’t set the featured image. Duh.
 * There are however annoyingly large gaps between adjacent columns of the grid 
   that I can’t seem to shrink even with your suggested CSS. This may be a problem
   with the formatting of the posts themselves though.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] Post Grid not working](https://wordpress.org/support/topic/post-grid-not-working-4/)
 *  Thread Starter [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/post-grid-not-working-4/#post-12374628)
 * Sigh – I’m such an idiot. I forgot about the warnings involving the “featured
   image”. It’s easy to forget about that because if the post contains an embedded
   image it will display correctly via the single template. But as far as post grids
   go the “featured image” is *required*. I need to get into the habit of always
   setting the “featured image” even if it duplicates the embedded image. Since 
   grids seem to require this I’m not sure why the default simply doesn’t set the“
   featured image” using the first embedded image.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Display Posts - Easy lists, grids, navigation, and more] Grid not working anymore](https://wordpress.org/support/topic/grid-not-working-anymore/)
 *  [nbi1](https://wordpress.org/support/users/nbi1/)
 * (@nbi1)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/grid-not-working-anymore/#post-12374384)
 * Similar problem, but I can’t get your CSS to work. What structure does navigator
   show for the parent elements of your short code?

Viewing 15 replies - 1 through 15 (of 21 total)

1 [2](https://wordpress.org/support/users/nbi1/replies/page/2/?output_format=md)
[→](https://wordpress.org/support/users/nbi1/replies/page/2/?output_format=md)