GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — DBAL insert with PostgreSQL throws "…invalid input syntax for type boolean: """" · Issue #1398 · php-enqueue/enqueue-dev Open DescriptionI ran into this issue where our messages wont be inserted into the PostgreSQL enqueue table using the DBAL adapter. After some investigation I found that the File: DbalContext.php public function createDataBaseTable(): void { // … // here it gets created as a boolean $table->addColumn('redelivered', DbalType::BOOLEAN, ['notnull' => false]); // … } File: DbalProducer.php $rowsAffected = $this->context->getDbalConnection()->insert($this->context->getTableName(), $dbalMessage, [ 'id' => DbalType::GUID, 'published_at' => DbalType::INTEGER, 'body' => DbalType::TEXT, 'headers' => DbalType::TEXT, 'properties' => DbalType::TEXT, 'priority' => DbalType::SMALLINT, 'queue' => DbalType::STRING, 'time_to_live' => DbalType::INTEGER, 'delayed_until' => DbalType::INTEGER, // here it is defined as a SMALLINT 'redelivered' => DbalType::SMALLINT, 'delivery_id' => DbalType::STRING, 'redeliver_after' => DbalType::BIGINT, ]); If I manually change it to Have I done something wrong or is this a bug? ActivityMetadataMetadataAssigneesLabelsNo labels TypeProjectsMilestoneRelationshipsDevelopmentIssue actions |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |