webERP Forum
GL Import error - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10)
+--- Thread: GL Import error (/showthread.php?tid=2587)



GL Import error - daveparrish - 10-06-2015

Hi All
I have two servers setup one lab and one production I was able to import the GL accounts into the Lab server with no problem but when I try to import into the production server I get the following error.
Both server are setup exactly the same.

Database Error 1366 :
Incorrect integer value: '' for column 'chequeno' at row 1
Database SQL Failure : The SQL that failed was
INSERT INTO gltrans (type, typeno, chequeno, trandate, periodno, account, narrative, amount, tag ) VALUES ( '0', '4', '', '2015-9-1', '4', '1000', 'Import from Facts system', '-121741.09', '' )

Any help would be appreciated.
Thanks
Davwe


RE: GL Import error - agaluski - 10-06-2015

The fields is expecting an integer, not null.
If you change your input file to have that field be '0' instead of '' does it work?

When you say both servers are exactly the same does that include the software release versions of PHP and MySQL?




RE: GL Import error - daveparrish - 10-06-2015

I did some checking the production MySQL is setup different, in the my.ini it is set to strict mode.
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
do you know what mode it needs to be and what should I change the above line to.
Thanks
Dave


RE: GL Import error - daveparrish - 10-06-2015

I got it I used the line
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
in the my.ini file.
Thanks
All