No Edit/Delete actions under Windows local development

[quantuumsnot]

OS: Windows 8 x64 PHP: 8.0.2/7.4.3 x64 phpliteadmin: v1.9.9-dev

Under local Windows development (not tested in Linux) the buttons 'Edit' 'Delete' for each row in a table are missing

[crazy4chrissi]

Is your database writeable? Next to the database on the left, does it say [r] or [rw]? And is it a table you are viewing or is it the result of a SELECT statement or a view?

[quantuumsnot]

Read only mode, interesting since there are no restrictions by OS or 3rd party app And yes - database is writable (can do INSERT/UPDATE queries), duh

[crazy4chrissi]

You can do INSERT/UPDATE queries from within phpLiteAdmin? Or in sqlite3.exe or through another application?

Keep in mind that phpLiteAdmin accesses your database through the php process (or the webserver process, if php is running as an apache module). PHP may be running under a user which does not have enough permissions whereas sqlite3.exe running under your user may have enough permissions. This is especially likely the case if the database is placed somewhere under your user directory. Also it is important to know that sqlite always needs write permissions not only on the database, but also on the folder the database file is located in. This is because sqlite needs to write temporary journal files there when updating.

[quantuumsnot]

From sqlite3.exe, phpliteadmin and my app PHP is used only with built-in webserver with this command: php.exe -S 127.0.0.1:65000 -t "D:\myrepo"

[crazy4chrissi]

Hmmm. But we are talking about a table, not a view, right? And you are in the "Browse" tab or "Search" tab of a table, not the "SQL" tab? Could you post a screenshot?

[quantuumsnot]

Yeah, one moment: missing delete for table row