Jump to content


Dr. McKay

  • Posts

  • Joined

  • Last visited

 Content Type 



IPS4 Providers

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog



Everything posted by Dr. McKay

  1. I recently migrated my IPS3 install to a new server where I installed MySQL 8 instead of 5. Trying to get IPS3 working with MySQL 8 proved to be a great challenge, so I just bit the bullet and migrated to IPS4 and wrote off my incompatible apps and hooks. However, I ran into a bug in the IPS4 updater. As per the MySQL manual, MEMBER was added as a reserved keyword in 8.0.17 (will be made non-reserved in 8.0.19, which isn't yet released). applications/core/setup/upg_40000/upgrade.php includes this query: $toRun = \IPS\core\Setup\Upgrade::runManualQueries( array( array( 'table' => 'core_voters', 'query' => "ALTER TABLE " . \IPS\Db::i()->prefix . "core_voters ADD COLUMN poll MEDIUMINT UNSIGNED NOT NULL COMMENT 'The poll ID', ADD INDEX poll (poll), DROP INDEX tid, ADD INDEX member(member_id, poll)" ) ) ); This fails when running MySQL >=8.0.17. The last line of the query should instead be ADD INDEX `member`(member_id, poll) with backticks. Would be great to have this fixed so nobody else gets bitten by this.
  2. I tried disabling native prefixes in IPS' settings as I don't need to use them, but it also hid the advanced prefix menu.
  3. Am I going to need to manually edit the theme to remove/hide that menu?
  4. That is the "new topic" page.
  5. If I want to require a prefix in a particular forum but only from a closed set, how can I remove the "item prefix" dropdown where the user can select one of their tags to use as a prefix? In practice this doesn't do anything except it hides that tag that the user selects from view, and the prefix they pick in the other box is the one that's used.
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy