โดย alonglot » 07/08/2019 2:19 pm
กดอัพโหลดแล้วขึ้น
JInstaller: :Install: Error SQL All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Extension ติดตั้ง: SQL error processing query: DB function failed with error number 1171
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
SQL =
CREATE TABLE IF NOT EXISTS `#__mzc_config` (
`id` int(11) NULL auto_increment,
`count_products_to_page` int(4) NULL,
`count_products_to_row` int(2) NULL,
`count_category_to_row` int(2) NULL,
`image_category_width` int(4) NULL,
`image_category_height` int(4) NULL
ประมาณนี้จะแก้ยังไงครับ
ใช้ joomla 3.9.10
Apache Web Server Version 2.4.39
PHP Script Language Version 7.3.8
MySQL Database Version 8.0.17
phpMyAdmin Database Manager Version 4.9.0.1
กดอัพโหลดแล้วขึ้น
JInstaller: :Install: Error SQL All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Extension ติดตั้ง: SQL error processing query: DB function failed with error number 1171
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
SQL =
CREATE TABLE IF NOT EXISTS `#__mzc_config` (
`id` int(11) NULL auto_increment,
`count_products_to_page` int(4) NULL,
`count_products_to_row` int(2) NULL,
`count_category_to_row` int(2) NULL,
`image_category_width` int(4) NULL,
`image_category_height` int(4) NULL
ประมาณนี้จะแก้ยังไงครับ
ใช้ joomla 3.9.10
Apache Web Server Version 2.4.39
PHP Script Language Version 7.3.8
MySQL Database Version 8.0.17
phpMyAdmin Database Manager Version 4.9.0.1