search

Buzzinoffbond / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
0 stars 0 forks source link

ERROR: datatype mismatch #257

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Trying to add a new row in the database
2.
3.

What is the expected output? What do you see instead?
A new column in the database.. but instead it gives me this error, or simply 
wont display it on the web form. 

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?
PDO

Please provide any additional information below.

Original issue reported on code.google.com by rosemary...@gmail.com on 7 Jul 2014 at 10:05

GoogleCodeExporter commented 9 years ago 
This is most likely because you are trying to insert something like characters 
into a integer ID column.
SQLite does not usually enforce data types except on integer columns that are 
primary keys. This is due to SQLite using these integers as internal rowids.

What is your CREATE TABLE SQL statement and what values are you trying to 
insert?

Original comment by crazy4ch...@gmail.com on 8 Jul 2014 at 8:02

GoogleCodeExporter commented 9 years ago 
Closed (not enough feedback)

Original comment by crazy4ch...@gmail.com on 27 Dec 2014 at 11:16