Fix export (#5927)

Regression from https://github.com/FreshRSS/FreshRSS/pull/5830

2 files changed, 15 insertions, 0 deletions

diff --git a/app/Models/DatabaseDAO.php b/app/Models/DatabaseDAO.php
index 05ca98355..7dbe1db3f 100644
--- a/app/Models/DatabaseDAO.php
+++ b/app/Models/DatabaseDAO.php
@@ -407,4 +407,17 @@ SQL;
 			}
 		}
 	}
+
+	/**
+	 * Ensure that some PDO columns are `string` and not `bigint`.
+	 * @param array<string|int|null> $table
+	 * @param array<string> $columns
+	 */
+	public static function pdoString(array &$table, array $columns): void {
+		foreach ($columns as $column) {
+			if (isset($table[$column])) {
+				$table[$column] = (string)$table[$column];
+			}
+		}
+	}
 }
diff --git a/app/Models/TagDAO.php b/app/Models/TagDAO.php
index bd52223a8..8587e576f 100644
--- a/app/Models/TagDAO.php
+++ b/app/Models/TagDAO.php
@@ -147,6 +147,8 @@ SQL;
 			return;
 		}
 		while ($row = $stm->fetch(PDO::FETCH_ASSOC)) {
+			FreshRSS_DatabaseDAO::pdoInt($row, ['id_tag']);
+			FreshRSS_DatabaseDAO::pdoString($row, ['id_entry']);
 			yield $row;
 		}
 	}