Error in SQL query:
-- --------------------------------------------------------
-- Table structure for table `member`
CREATE TABLE `member` (
`memberID` int(10) UNSIGNED NOT NULL,
`instaID` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
`profilePhoto` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
`fullName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
`password` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
`followingCount` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
`followerCount` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
`followCredit` int(10) UNSIGNED NOT NULL DEFAULT '10',
`likeCredit` int(10) UNSIGNED NOT NULL DEFAULT '50',
`commentCredit` int(10) UNSIGNED NOT NULL DEFAULT '5',
`storyCredit` int(10) UNSIGNED NOT NULL DEFAULT '10',
`videoCredit` int(11) UNSIGNED NOT NULL DEFAULT '50',
`saveCredit` int(11) UNSIGNED NOT NULL DEFAULT '50',
`commentLikeCredit` int(10) UNSI [...]
MySQL Output:
Error #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT = DYNAMIC or ROW_FORMAT = COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline
Hello friends, I don't have any issues when importing from YoncuSQL, but I encounter this error when importing to the hosting I purchased from GüzelHostt. What could be the problem? I have contacted customer service, and they are looking into it, but I opened this topic to understand the cause of the problem. I would be very pleased if you could help. Thank you in advance. ???
-- --------------------------------------------------------
-- Table structure for table `member`
CREATE TABLE `member` (
`memberID` int(10) UNSIGNED NOT NULL,
`instaID` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
`profilePhoto` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
`fullName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
`password` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
`followingCount` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
`followerCount` varchar(10) COLLATE utf8_turkish_ci DEFAULT NULL,
`followCredit` int(10) UNSIGNED NOT NULL DEFAULT '10',
`likeCredit` int(10) UNSIGNED NOT NULL DEFAULT '50',
`commentCredit` int(10) UNSIGNED NOT NULL DEFAULT '5',
`storyCredit` int(10) UNSIGNED NOT NULL DEFAULT '10',
`videoCredit` int(11) UNSIGNED NOT NULL DEFAULT '50',
`saveCredit` int(11) UNSIGNED NOT NULL DEFAULT '50',
`commentLikeCredit` int(10) UNSI [...]
MySQL Output:
Error #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT = DYNAMIC or ROW_FORMAT = COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline
Hello friends, I don't have any issues when importing from YoncuSQL, but I encounter this error when importing to the hosting I purchased from GüzelHostt. What could be the problem? I have contacted customer service, and they are looking into it, but I opened this topic to understand the cause of the problem. I would be very pleased if you could help. Thank you in advance. ???