Skip to content
View in the app

A better way to browse. Learn more.

ernestdefoe.online

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
ernestdefoe.online

Extensions, themes & support for Flarum and Invision Community

Vibe coding for the community web. Report a bug, request a feature, or dig into the source — this is where the tools you use get built, in the open.

We do custom Bespoke Invision Community apps. If you have an idea for something you want then use the contact form to get in touch with us.
Knowledge base

Things that cost me a day, so they cost you none

Working notes from building Invision Community and Flarum applications. Mostly the failures that give no error at all — the ones where everything installs cleanly and quietly does the wrong thing.

92 articles

Invision Community 5

86 articles

Extensions and contracts

39

What each extension point is for, what it must declare, and what happens when it is wrong — which is usually nothing visible.

Languages and text

5

The string table, translation, and the places where text does not appear where you expected it to.

Theming, templates and forms

9

Theme hooks, CSS that survives both colour schemes, and building forms that do not throw on render.

Background work and scheduled tasks

5

The queue system, work that has to happen after the response, and jobs that finish without doing anything.

Data, settings and storage

11

The database layer, settings, tags, file storage, and backing up a live site.

AI features and expectations

5

What these features do, what they cost, and what buyers reasonably but wrongly assume they do.

Application structure and releases

11

The JSON files an application is made of, versioning and upgrade steps, and testing from the command line.

Realtime, chat and calls

1

WebSocket gateways, relays and the server-side pieces live features depend on — where "it works when I test it" and "it works for your members" are different claims.

Nothing matches that.

Db::insert() third and fourth arguments do very different things

Two boolean flags in a row, easy to transpose, and they mean opposite things. Getting them the wrong way round produces data corruption rather than an error.

The signature

public function insert(
    string $table,
    Select|array $set,
    bool $odkUpdate = FALSE,      // 3rd: ON DUPLICATE KEY UPDATE
    bool $ignoreErrors = FALSE    // 4th: INSERT IGNORE
): int|string|mysqli_stmt

What each does

CallOn a duplicate key
insert( $t, $v )Throws
insert( $t, $v, TRUE )Overwrites the existing row with your values
insert( $t, $v, FALSE, TRUE )Keeps the existing row and does nothing

Why transposing them is worse than an error

Say you keep a counter and want "insert if new, otherwise leave alone":

// WRONG - resets the counter every time
Db::i()->insert( 'myapp_counts', array( 'key' => $k, 'uses' => 1, 'ignored' => 0 ), TRUE );

// RIGHT - insert if new, otherwise leave the existing row alone
Db::i()->insert( 'myapp_counts', array( 'key' => $k, 'uses' => 1, 'ignored' => 0 ), FALSE, TRUE );

The wrong version runs without complaint and silently resets uses to 1 and ignored to 0 on every call. Nothing is logged, nothing throws, and the bug only shows up as counters that never climb.

Which one you actually want

  • Caching a computed value that should refresh — ON DUPLICATE KEY UPDATE (3rd argument).
  • Recording that something happened, where the first record is the true one — INSERT IGNORE (4th argument).
  • Genuinely new rows only — neither, and let it throw. A duplicate key is information.

If you want neither semantic, use Db::i()->replace(), which is a real REPLACE INTO — note that deletes and re-inserts, so any column you omit reverts to its default.

Verified against

Invision Community 5.0.19, by reading system/Db/Db.php.


User Feedback

Recommended Comments

There are no comments to display.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.