S.a arkadaslar instaweb sql import ediyorum cpanel
Hostingde sorunsuz upload oluyor fakat
Ispmanager ve directadmin boyle hata ile karsilasiyorum
admin ve bayi 2 tanesi ekleniyor
Hata
SQL sorgusu:
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `bayi_islem`
--
CREATE TABLE `bayi_islem` (
`bayiIslemID` int(10) NOT NULL,
`bayiID` int(10) UNSIGNED NOT NULL,
`islemTip` varchar(10) COLLATE utf8_turkish_ci NOT NULL,
`mediaID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`mediaCode` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`userID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`userName` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`allComments` longtext COLLATE utf8_turkish_ci DEFAULT NULL,
`imageUrl` longtext COLLATE utf8_turkish_ci NOT NULL,
`minKrediTotal` int(11) UNSIGNED DEFAULT NULL,
`maxKrediTotal` int(11) UNSIGNED DEFAULT NULL,
`krediTotal` int(10) UNSIGNED NOT NULL,
`krediLeft` int(10) UNSIGNED NOT NULL,
`startDate` timestamp NULL DEFAULT NULL,
`endDate` timestamp NULL DEFAULT NULL,
`isActive` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`eklen****rihi` timestamp NOT NULL DEFAULT c[...]
MySQL çıktısı: Belgeler
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Hostingde sorunsuz upload oluyor fakat
Ispmanager ve directadmin boyle hata ile karsilasiyorum
admin ve bayi 2 tanesi ekleniyor
Hata
SQL sorgusu:
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `bayi_islem`
--
CREATE TABLE `bayi_islem` (
`bayiIslemID` int(10) NOT NULL,
`bayiID` int(10) UNSIGNED NOT NULL,
`islemTip` varchar(10) COLLATE utf8_turkish_ci NOT NULL,
`mediaID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`mediaCode` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`userID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`userName` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`allComments` longtext COLLATE utf8_turkish_ci DEFAULT NULL,
`imageUrl` longtext COLLATE utf8_turkish_ci NOT NULL,
`minKrediTotal` int(11) UNSIGNED DEFAULT NULL,
`maxKrediTotal` int(11) UNSIGNED DEFAULT NULL,
`krediTotal` int(10) UNSIGNED NOT NULL,
`krediLeft` int(10) UNSIGNED NOT NULL,
`startDate` timestamp NULL DEFAULT NULL,
`endDate` timestamp NULL DEFAULT NULL,
`isActive` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`eklen****rihi` timestamp NOT NULL DEFAULT c[...]
MySQL çıktısı: Belgeler
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause