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.

Datenbank Error

Jetzt mitmachen!

Benutzer online in diesem Thema