TULIPS/September 12th, 2024

Welcome to our eleventh TULIPS (Thursday Updates & Logs Improving Platform Software)! You can read the previous one if you haven't yet.

These posts will be made whenever we have enough development updates to make a post, usually on Thursdays.

Live now

• We've added a message to our servicedesk portal to clarify that making accounts here is not the same as making wiki.gg accounts. Hopefully this clears things up for new users!
• Our database server infrastructure has been upgraded, and its reliability should be far better than before.

  There is one side effect of this change:

  • If you edit or delete pages in rapid succession (i.e. with a bot), you may get an error, "The database has been automatically locked while the replica database servers catch up to the primary"
  • The solution to this is to retry in about 2-5 seconds
  • PWB and AWB should handle this without issue, but the error handling in mwclient is not great and mwclient may crash, so you may have to add your own additional retries (or sleep longer)

• A new form for reporting bad advertisements has been added to our servicedesk portal.

Cargo

• GREATEST and LEAST are now allowed in Cargo queries on all wikis.
  • Syntax: GREATEST(col1, col2, col3)=MaxValue, LEAST(col1, col2, col3)=MinValue
  • Contrast to MAX(col)=MaxValue MIN(col)=MinValue, which returns the smallest or largest value within the entire set of rows specified by the where and/or group by conditions
  • So: GREATEST/LEAST for multiple columns in each row, MAX/MIN for multiple rows and one column

DRUID

• Collapsible sections now show chevrons instead of +/- (CSS change)
• The CSS now has some additional comments to make it clearer to see what you should and shouldn't edit
• The default loadout wiki version of DRUID has been updated to the current support wiki version (including the above changes)

Default loadout wiki

The Default Loadout Wiki now comes with collapsible sidebar sections as a non-default gadget. Feel free to copy this to your wiki if your theme is already DLW-based; you can make it default if that's appropriate for your wiki's sidebar.

Known issues

• Extension:InputBox doesn't permit empty fields when editing a page with real-time previews.