contao/import — Issue #3466: SQL error on page duplicate after paste into using MySQLi driver
Author: importer
Created: 2011-11-29 21:38:29+00:00
State: open
Labels: backend, Defect, Invalid

**same as ticket 3409**
default query insert for column author should be 0 instead of empty string

Fatal error: Uncaught exception Exception with message Query error: Incorrect integer value: '' for column 'author' at row 1 (INSERT INTO tl_article (pid, sorting, tstamp, title, alias, author, inColumn, keywords, showTeaser, teaserCssID, teaser, printable, cssID, space, published, start, stop) VALUES (55, '128', 1315944182, 'Some pagename', '', '', 'main', NULL, '', 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '')) thrown in ....\system\libraries\Database.php on line 677

Related issues: #3409

--- _Originally created by davor on September 13th, 2011, at 10:14pm (ID 3466)_