网页在本地服务器上运行良好，但在线却没有

Question

I have a school managment software built with PHP. When I run it on my local server it works fine but when I uploaded it to a remote server it gives me an error:

Error Number: 1364

Field 'religion' doesn't have a default value

INSERT INTO `teacher` (
    `name`,
    `birthday`,
    `sex`,
    `address`,
    `phone`,
    `email`,
    `password`
) VALUES (
    'teacher1',
    '08/09/2016',
    'male',
    'Dir Upper Pakistan',
    '0944840412',
    '[e-mail]',
    '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'
);

Filename: controllers/Admin.php

Line Number: 41

Also, it works fine on a free webhosting server but on another web host it sometimes works and sometimes gives the error.

Answer 1

Looks like the root of the issue is database table strucutre difference between local environment and live. Try ONE of the following solutions:

1.Edit your query in php to include religion:

INSERT INTO teacher (name, birthday, sex, address, phone, email, password, religion)
VALUES ('teacher1', '08/09/2016', 'male', 'Dir Upper Pakistan', '0944840412', '[e-mail]', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 'myreligion')

2.Update your table structure so religion field is set to allow null values