Field 'userlevelid' doesn't have a default value

PHPMaker General Discussion (PHPMaker)
1

hi

i have problem with this error when i save data in table master detail :
/www/wwwroot/xxxxxx/monev/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php(116): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field ‘userlevelid’ doesn’t have a default valuein my computer application work well but in live server show that error
in userpanel before i save the data show userlevel line but when i save data userpanel show ‘undefined’ in userlevel line, then show that error
how to solve that problem?TIA

2

You better check the table schema of user level table on your live sever, if it is not an autoincement field, you need to provide the user level ID when you add a new user level. Always make sure the table schema are the same on development and production environment.

3

Thank You for your information
Error has gonebut now i have a problem when copy data after save the page not back to listpage…in my computer application work well but in the server that problem shownhow to solve that problemTIA

4

Make sure you have updated table schema of the database on your server also.

5

thank you…table schema on computer and server also same toomay be another solution?TIA

6

You may enable debug and also check the HTTP response to expose the cause of the issue.

7

iam sorry for my mistakethis problem cause my server use proxyis there anyway to make phpmaker compatible with proxy?

TIA

8

nabilahasna wrote:

/www/wwwroot/xxxxxx/monev/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php(116):
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field ‘userlevelid’ doesn’t have a default value

That is a PHP error, not database connection error, it does not seem like related to proxy server.Did you mean your web server is not behind proxy server but the database server is? You may explain in more detail.