inserting or editing rows in columns containing : causes "schema missmatch" error

Issue #314 resolved
phpLiteAdmin repo owner created an issue
  1. CREATE TABLE 'ad' ('ad:sf' INTEGER)
  2. Try to insert data using the "INSERT" tab --> ERROR - schema missmatch
  3. Manually insert a row using SQL tab and the following query: INSERT INTO "ad" VALUES(1);
  4. Go to the "browse" tab and try to edit the row from 1 to 2. --> ERROR: This may be a bug that needs to be reported at https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open

i don't see a reason we have the fieldStr at all. I think the assumption that the schema does not change while we insert or edit rows is okay.

Comments (2)

  1. Log in to comment