Datenbank Error

Marku

Hallo ihr lieben,

Ich benutze seit einigen Tagen das iBabbo CMS, welche man hier auffindet.
Sobald ich in Navicat die Datenbank einziehen will erscheinen einige error.

Code

[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('988', '0', '2644', '', '', '1453737409', '3052', 'SeroX');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('991', '0', '2645', '', '', '1453740042', '3057', 'Fabian');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('993', '0', '2644', '', '', '1453741166', '3307', 'xSerkan');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('995', '0', '2644', '', '', '1453741486', '2864', 'MOD-Orangebut');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1000', '0', '3035', '', '', '1453753107', '3319', 'TagShai');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1002', '0', '2636', '', '', '1453758569', '2638', 'MOD-Intoxicated');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1004', '0', '2645', '', '', '1453758865', '3140', 'Scary');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1019', '0', '2644', '', '', '1453825278', '3057', 'Fabian');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1021', '0', '3035', '', '', '1453825623', '3057', 'Fabian');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1024', '0', '3035', '', '', '1453828385', '2968', 'Canki');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1043', '0', '2644', '', '', '1453838705', '3346', 'Dario');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1046', '0', '2644', '', '', '1453908227', '3228', 'Pomeji');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1049', '0', '2815', '', '', '1453909571', '3228', 'Pomeji');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1051', '0', '2644', '', '', '1453913720', '3363', 'Paranox');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1064', '0', '3273', '', '', '1453995828', '3038', 'xEnzo');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1068', '0', '2644', '', '', '1454006463', '3398', 'Rebug');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1072', '0', '3035', '', '', '1454011835', '3400', 'Enrico');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1075', '0', '3408', '', '', '1454020384', '2638', 'MOD-Intoxicated');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1081', '0', '2644', '', '', '1454071033', '3110', 'Delax');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1084', '0', '2644', '', '', '1454073559', '3397', 'Marvin');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1126', '0', '2645', '', '', '1454074237', '3358', 'Goldi');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1129', '0', '2633', '', '', '1454082220', '2982', 'Gold');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1133', '0', '2645', '', '', '1454084663', '3353', 'lukasdustin');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1135', '0', '2633', '', '', '1454084992', '3228', 'Pomeji');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1141', '0', '2633', '', '', '1454087712', '3058', 'hopeful');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1144', '0', '2635', '', '', '1454089816', '3344', 'Smoth');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1146', '0', '2815', '', '', '1454089833', '3344', 'Smoth');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1148', '0', '2644', '', '', '1454090493', '3187', 'Serkan');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1153', '0', '2635', '', '', '1454092408', '2995', 'ol4');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1155', '0', '2644', '', '', '1454092423', '2995', 'ol4');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1157', '0', '2645', '', '', '1454093728', '2752', 'Adminal');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1159', '0', '2635', '', '', '1454094486', '3443', 'Serh4t');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1161', '0', '2644', '', '', '1454094969', '3353', 'lukasdustin');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1176', '0', '2635', '', '', '1454112134', '3387', 'Lippenlesen');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1180', '0', '2635', '', '', '1454113469', '3345', 'ByTheWay');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1187', '0', '2644', '', '', '1454149733', '3464', 'Robin.');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1192', '0', '2636', '', '', '1454158611', '3387', 'Lippenlesen');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1194', '0', '2815', '', '', '1454158781', '3461', 'Antichristin');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1196', '0', '2815', '', '', '1454160656', '3335', 'Dosis');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1210', '0', '2644', '', '', '1454194456', '3499', 'MarcYG');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1214', '0', '3035', '', '', '1454201560', '3115', 'Aru');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1216', '0', '2635', '', '', '1454202419', '3509', 'Marco.x3');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1218', '0', '3035', '', '', '1454237133', '3387', 'Lippenlesen');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1226', '0', '2644', '', '', '1454248828', '2766', 'sky31');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1240', '0', '2644', '', '', '1454252139', '3527', 'TumblrGirl');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1252', '0', '3537', '', '', '1454260535', '3509', 'Marco.x3');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1256', '0', '2633', '', '', '1454263194', '3539', 'Login');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1258', '0', '3035', '', '', '1454263532', '3539', 'Login');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1262', '0', '3293', '', '', '1454263783', '2943', 'Onur');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1264', '0', '2633', '', '', '1454263945', '2943', 'Onur');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1266', '0', '2633', '', '', '1454264040', '3509', 'Marco.x3');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1268', '0', '2633', '', '', '1454264365', '3110', 'Delax');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1276', '0', '2636', '', '', '1454274751', '3546', 'Kai');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1285', '0', '3035', '', '', '1454325154', '3417', 'Managment');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1287', '0', '2635', '', '', '1454326676', '3551', 'Make');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1290', '0', '2645', '', '', '1454331407', '3527', 'TumblrGirl');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1293', '0', '3035', '', '', '1454341786', '3551', 'Make');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1295', '0', '2645', '', '', '1454344370', '3562', 'Nxdelstxch');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1299', '0', '3035', '', '', '1454348325', '3546', 'Kai');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1311', '0', '2652', '', '', '1454422878', '3521', 'safira');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1314', '0', '2635', '', '', '1454442880', '3590', 'Stinkefisch');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1316', '0', '2645', '', '', '1454442884', '3590', 'Stinkefisch');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1318', '0', '2635', '', '', '1454444616', '3601', 'Ezra');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1326', '0', '2644', '', '', '1454526053', '3601', 'Ezra');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1337', '0', '2645', '', '', '1454612288', '3623', 'lennard.');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1342', '0', '2645', '', '', '1454626970', '3035', 'BroadWaY');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1357', '0', '2644', '', '', '1454690563', '3478', '.Ali.');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1368', '0', '2815', '', '', '1454711867', '3449', 'Sephora');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1370', '0', '2635', '', '', '1454715991', '3648', 'Tiim');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1373', '0', '3035', '', '', '1454754844', '2645', 'Armen');
[Err] 1265 - Data truncated for column 'gender' at row 1
[Err] INSERT INTO `friend_stream` VALUES ('1379', '0', '3035', '', '', '1454765063', '2638', 'MOD-Intoxicated');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Alles anzeigen

Könnte mir jemand dabei helfen? lg,

M.Sa

higoka

Versuch mal zuerst diesen SQL zu importieren und danach deiner.

SQL

SET @@global.sql_mode= '';

Und wenn das nicht geht, importier das zuerst:

SQL

ALTER TABLE friend_stream MODIFY gender VARCHAR(255) NOT NULL DEFAULT '';

Marku

Lösung: Danke an @Rarely

1. Öffne den Editor
2. Schreibe folgenden Text hinein ' SET @@global.sql_mode= ''; ' (ohne ' )
3. Speicher die Datei als Funktionslos.sql ein
4. Und zieh die SQL daraufhin in die Datenbank
5. Nun sollte deine Datenbank problemlos Funktionieren.

plex

CLOSED
Problem gelöst.

Jetzt mitmachen!