> On Sep 2, 2024, at 6:01 PM, Wolfgang Zenker <wolfg...@lyxys.ka.sub.org> wrote:
>
> Am Mon, Sep 02, 2024 at 05:19:01PM +0200 schrieb Moin Rahman:
>>> On Sep 2, 2024, at 5:10 PM, Wolfgang Zenker <wolfg...@lyxys.ka.sub.org>
>>> wrote:
>
>>> I have a problem with using the PHP sqlite3 module in the 2024Q3 branch.
>>> Scripts segfault on calling
>>> $dbObj = new SQLite3('example.db');
>>> Tested with php 8.2 and 8.3, strongly suspect the other versions have
>>> the problem as well.
>
>>> For which port(s) should I open a problem report here? The culprit could
>>> be either the php-port, the php-sqlite3 subport or the sqlite3 port.
>>> I built a small test environment and the sqlite3 cli tool works ok,
>>> and I don't see much changes in the php-sqlite3 subports, so I suspect
>>> the problematic part is in the php ports.
>
>>> The problem did not exist in the 2024Q2 branch and does not exist in
>>> HEAD.
>
>>> Does it make sense to open problem reports on the quarterly branch at
>>> all or should I ask the maintainers to MFH the php and sqlite3 ports?
>>>
>>> Looking forward to your suggestions.
>
>> Please share the details of the exact versions of the ports.
>
>> Kind regards,
>> Moin
>
> Failing setup on php 8.2:
> - php82-8.2.20
> - php82-sqlite3-8.2.20
> - sqlite3-3.46.0,1
>
> Failing setup on php 8.3:
> - php83-8.3.8
> - php83-sqlite3-8.3.8
> - sqlite3-3.46.0,1
>
> php 8.1 and php 8.4 setups not tested yet.
>
> Working versions from 2024Q2 branch:
> - php82.8.2.18 / php83-8.3.6
> - php82-sqlite3-8.2.18 / php83-sqlite3-8.3.6
> - sqlite3-3.45.1,1
>
> How to reproduce:
>
> 1) Build a small test-database
> $ sqlite3 example.db
> SQLite version 3.46.0 2024-05-23 13:25:27
> Enter ".help" for usage hints.
> sqlite> create table people(name text, role text);
> sqlite> insert into people values('Alice', 'restaurant');
> sqlite> insert into people VALUES ('Bob', 'your uncle');
> sqlite> .quit
>
> 2) Use a small php script sqlitetest.php
> <?php
>
> $dbObj = new SQLite3('example.db');
> $results = $dbObj->query("SELECT * FROM people WHERE role = 'your uncle'");
>
> while ($row = $results->fetchArray()) {
> printf("%s's %s\n", $row['name'], $row['role']);
> }
> ?>
>
> 3) verify database works with sqlite3 cli
> $ sqlite3 example.db
> SQLite version 3.46.0 2024-05-23 13:25:27
> Enter ".help" for usage hints.
> sqlite> select name from people where role = 'your uncle';
> sqlite> .quit
>
> should return "Bob".
>
> 4) test php script
> $ php sqlitetest.php
>
> returns Segmentation fault
>
> Hi, You said that it works on HEAD. I can merge the latest PHP into the quarterly branch. But unfortunately I cannot merge sqlite3. Current sqlite3 version in HEAD is 3.46.1. I will merge the latest php into quarterly sometimes tomorrow. Kind regards, Moin
signature.asc
Description: Message signed with OpenPGP
