[Solved] Unable To Write Into Db

[federicorussi]

dear,

after the repair of the db by the admin I'm unable to write on the db, only read.

the db is fedeener_marcatempo.

Regards

[wolstech]

This support request is being escalated to our root admin.

[Krydos]

Are you saying that INSERT queries not working? Can you post an error message?

[federicorussi]

no error is showing. the queries seems to finish well but no data have been saved.

[Krydos]

Can you post the query that isn't working, and the username of the account that is running that query?

[federicorussi]

$query="INSERT INTO dispositivi VALUES ('','$apikey','$dispositivo')";

 

user: fedeener

[Krydos]

Your password has been manually reset, tested, and emailed to your contact email address.

mysql> select * from dispositivi;
+----+----------------------------------+--------------------------------------+
| id | apikey                           | chiave                               |
+----+----------------------------------+--------------------------------------+
|  3 | c286419dd7e831876f246c31ecece481 | 00000000-1c38-88b5-1599-90314fe98fb8 |
+----+----------------------------------+--------------------------------------+
1 row in set (0.00 sec)

mysql> INSERT INTO dispositivi VALUES ('','933hjrih3rh','00000000-783j-u937-jks9');
ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1

mysql> INSERT INTO dispositivi VALUES ('4','933hjrih3rh','00000000-783j-u937-jks9');
Query OK, 1 row affected (0.00 sec)

mysql> select * from dispositivi;                                                                                             +----+----------------------------------+--------------------------------------+
| id | apikey                           | chiave                               |
+----+----------------------------------+--------------------------------------+
|  3 | c286419dd7e831876f246c31ecece481 | 00000000-1c38-88b5-1599-90314fe98fb8 |
|  4 | 933hjrih3rh                      | 00000000-783j-u937-jks9              |
+----+----------------------------------+--------------------------------------+
2 rows in set (0.00 sec)

mysql> delete from dispositivi where id = '4';
Query OK, 1 row affected (0.00 sec)

As you can see the user fedeener can select, insert, and delete from the table fedeener_marcatempo.dispositivi. However, the error is that it doesn't like the '' value for the id column. Let us know if you need any further assistance.