contao/import — Issue #2830: tl_member.autologin UNIQUE KEY blocks single line Dump insertion
Author: importer
Created: 2011-11-29 20:21:46+00:00
State: open
Labels: Defect, frontend

When restoring or adding a single line insert into tl_member, the UNIQUE KEY definition of autologin blocks the insertion

Required empty table tl_member and insert following data :

```
INSERT INTO `tl_member` VALUES(1, 1259754224, 'John', 'Smith', '238201200', 'male', '', '', '', '', '', '', '', '', '', 'j.smith@musicacademy.com', '', '', 0x613a313a7b693a303b733a313a2232223b7d, '1', 'j.smith', '3b842bcd6faab4047ab49f9a99fa0704b9c9d2d7', '', '', '', '', '', 3, 0, '', 1259754224, 0, 0, '', 0, 0x613a303a7b7d, '');
INSERT INTO `tl_member` VALUES(2, 1259754224, 'Donna', 'Evans', '191635200', 'female', '', '', '', '', '', '', '', '', '', 'd.evans@musicacademy.com', '', '', 0x613a313a7b693a303b733a313a2231223b7d, '1', 'd.evans', '4f40b339470ac4d7c071670a9033d0ca1d234922', '', '', '', '', '', 3, 0, '', 1259754224, 0, 0, '', 0, 0x613a303a7b7d, '');
INSERT INTO `tl_member` VALUES(3, 1259754224, 'John', 'Doe', '0', '', '', '', '', '', '', '', '', '', '', 'j.doe@musicacademy.com', '', '', 0x613a323a7b693a303b733a313a2232223b693a313b733a313a2231223b7d, '1', 'j.doe', '7a86a8cf9d7510cc4661b217133f2eed37981b75', '', '', '', '', '', 3, 0, '', 1259754224, 0, 0, '', 0, '', '');
```

Results in : #1062 - Duplicate entry '' for key 'autologin'

Your Table definition is here : http://dev.contao.org/projects/typolight/repository/entry/tags/contao-2.9.3/system/modules/backend/config/database.sql#L238

But the autologin column is never used in the source code.

--- _Originally created by lindesbs on January 28th, 2011, at 12:35pm (ID 2830)_