Streams SQL error: Unknown column 'outq

Streams SQL error: Unknown column 'outq_log' in 'field list'

Streams

Mon, 19 Sep 2022 09:37:20 -0700

Bill Statler wrote the following post Mon, 19 Sep 2022 09:37:05 -0700

Streams SQL error: Unknown column 'outq_log' in 'field list'
@Streams @mike
I'm having a little problem getting any posts or comments delivered from my new (streams) instance, and I think I found a bug. Here's what I'm seeing in my log:

2022-09-19T02:56:56Z:LOG_ERR:f3babdc703:dba_driver.php:506:db_logger: dba_pdo: ERROR: insert into outq ( outq_hash, outq_account, outq_channel, outq_driver, outq_posturl, outq_async, outq_priority,
            outq_created, outq_updated, outq_scheduled, outq_notify, outq_msg, outq_log )
            values ( '19d0bf42-4d54-47c8-b861-53187664543d', 1, 3, 'nomad', 'https://forum.statler.ws/nomad', 1, 0, '2022-09-19 02:56:56', '2022-09-19 02:56:56', '2022-09-19 02:56:56', '{...lots of data omitted...}', '', '' )
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'outq_log' in 'field list'

Some digging finds that 'outq_log' is used in Code/Lib/Queue.php, but is missing from install/schema_mysql.sql. So the column is not created in the database during installation, the Queue.php function fails, and nothing goes into the queue for delivery.

Did I get that right? (It was fun detecive work in any case.)

@Bill Statler

Mon, 19 Sep 2022 13:55:15 -0700

Yes, that was good sleuthing. I'm sorry you needed it. The schema files have been updated in dev and I'll push them to release shortly.

You should be able to recover without a re-install (and even without a git pull) by visiting admin/dbsync/1260 on your site while logged in to an account with site admin privilege. That runs this specific DB migration. The migration for existing sites was there - I just missed the update to the schema files for new sites.

Sometime maybe later today or tomorrow I'm going to update the release branch again with my latest work. This has a dependency on addons so make sure you're updating with util/udall or something that picks up all project changes and not just 'git pull' which only updates core. This will require another DB migration as I'm splitting the geographical coordinates into separate lattitude/longitude fields. And this will allow us to easily measure/report distance between two entities without raising any significant performance issues.

I didn't want to push this release while @Witcraft was still having install issues, but work is backing up and I can't wait much longer.

Bill Statler

Mon, 19 Sep 2022 14:32:44 -0700

Wonderful -- thank you!

Bill Statler

Tue, 20 Sep 2022 15:07:19 -0700

Update 1260 fixed the problem. My test channel on my new instance has successfully exchanged messages with my current channel on zap.dog.

Apparently I have a working (streams) instance. Huzzah! Now I can go break more things.