Insert or Edit Not Committing
I recently installed phpLiteAdmin 1.9.7.1. When I try to either insert or update a row in any table, I receive a "success" message; however, the row is not inserted or updated. Any ideas?
Comments (10)
-
-
repo owner Please check if the problem occurs for all tables and databases or if it is only happening with one or a couple of table. Please
- create a new db using phpLiteAdmin
- create a new very simple table using phpLiteAdmin with only 2 columns a and b, both of type Text
- try to insert some values
If this works try if the same works in your original database.
If both work, can you please post the CREATE TABLE statement of the table that does not work? Are there any foreign key constraints, triggers, or indexes on that table?
-
Thanks for your quick response.
Here is what I tried to do:
-
Create a new db (called testdb). This "seemed" to work (see screenshot 1)
-
Using the "Create New Table on Database testdb" section on the successful database creation screen, I tried to create tabletest1. Instead of creating the table on testdb, it tried to create the table on the original db, k9 (see screenshot 2)
-
Even though a successful table created message was displayed, the table wasn't actually created (see screenshot 3)
-
I clicked "Return" and neither the new database nor table are displayed (see screenshot 4)
Thanks again for any help in resolving this issue.
-
-
repo owner Have you checked if creating a table on testdb work?
Is k9.sqlite an SQLite 3 or SQLite 2 database? I see from your screenshots that your PHP still supports both versions. There might be an issue that only affects SQLite 2 databases.
You can check the SQLite version of your database file if you click on the "Structure" Tab of the DB. For your testdb, it says version 3.7.4 and SQLite extension "PDO". Does this look the same for k9.sqlite? Or does it say "SQLiteDatabase" as extension and 2.x as version?
-
Creating a table did not work. k9.sqlite is 3.7.4 with PDO extension.
-
repo owner Can you please set
$debug=true
in the config and try to create a table or insert data and post the output or give a screenshot? -
I turned $debug=true. Here are the results after 1 - logging into phpliteadmin; 2- trying to create a database; 3- trying to add a table to the test database; 4-trying to add columns to the test table; 5-final result (the database and table were not created) See associated screen shots.
Thanks!
-
repo owner sorry for the late reply. Last year I could not find much time for this project.
This seemed to be some kind of permission problem, i.e. not enough file system permissions, probably on the database folder, not the database itself.
Did you find some solution? Does the problem still persist?
-
repo owner - changed status to invalid
It remains unclear what the problem was here and whether the problem still exists in the current version. -> Closing
-
repo owner - removed milestone
- Log in to comment
To clarify my issue: I updated phpLiteAdmin from 1.9.1 to 1.9.7.1. Prior to the upgrade, I was able to successfully insert, update, and delete rows. Thanks for any help!