Can't get data to go to mysql without using private ip address

[stcloudpc.com]

1264 - Out of range value adjusted for column 'sort_order' at row 1

 

insert into categories (sort_order, parent_id, date_added) values ('', '0', now())

 

[TEP STOP]

 

 

Server is in DMZ on router.

 

added public ip to mysql user rights

 

If I set all the address in the configure files to the private 192.168.1.xxx address everything works fine.

 

HELP!