I posted this on the Drupal core issue #286986: MySQL: SHOW TABLES LIKE database.tablename doesn't work in which apparently the patches continued to fail testing. Clearly this was a result of the reviewer thinking it was for Drupal 7. I do not currently work in Drupal 7 so if someone could be kind enough to roll this patch for that version, I would appreciate it. I have attached the Drupal 5 equivalents here.

If someone rolls this for 7, please post it back on the correct issue.

#286986: MySQL: SHOW TABLES LIKE database.tablename doesn't work

Thank you.

CommentFileSizeAuthor
mysql-multisitefix.patch661 byteswebkenny
mysqli-multisitefix.patch664 byteswebkenny

Comments

damien tournoud’s picture

damien tournoud commented
Status: Needs review » Closed (duplicate)

In that case, this is a duplicate of #286986: MySQL: SHOW TABLES LIKE database.tablename doesn't work. We generally don't open several tickets for the same issue across core versions.

sethcohn’s picture

sethcohn commented
Version: 5.12 » 5.x-dev
Status: Closed (duplicate) » Patch (to be ported)

webkenny made clear why he opened a new ticket: the autopatcher kept rejecting his posted patches, since they were for 5.x, and don't apply to 7.x (which is what autopatcher was doing), and having a label of 'patch fails' is unlikely to get much (good) attention, and it's much better to have a patch for 5.x out there for those who need it, and also get it ported to 7.x by someone qualified to do so, who can post it back in the correct ticket (which webkenny openly linked to in the first place)

This patch works for me, on 5.x.

If you'd like to be helpful, port his simple fix to 7.x's similar but different structure for database core code, and maybe we might even get a backport for 6.x too.

damien tournoud’s picture

damien tournoud commented
Status: Patch (to be ported) » Closed (duplicate)

This will have to go in D7 and D6 first. Please suffix your patches with "-d5" for the test bot not to try to apply them (for example: mysqli-multisitefix-d5.patch). Back to duplicate: review and discussion about that patch have to happen in the other issue.