Site icon Learning & Doing

Error install Plogger di cpanel

Error :

 

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’Type=MyISAM DEFAULT CHARACTER SET UTF8\’ at line 6\’ (length=184)

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’Type=MyISAM DEFAULT CHARACTER SET UTF8\’ at line 8\’ (length=184)

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'(14) NOT NULL,
`date_submitted` timestamp(14) NOT NULL,
`EXIF_date_taken` varc\’ at line 7\’ (length=226)

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’Type=MyISAM DEFAULT CHARACTER SET UTF8\’ at line 12\’ (length=185)

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’Type=MyISAM DEFAULT CHARACTER SET UTF8\’ at line 29\’ (length=185)

string \’You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’Type=MyISAM DEFAULT CHARACTER SET UTF8\’ at line 6\’ (length=184)

 

Solusi

edit file : plog-admin\\includes\\install-functions.php

1. ganti Type=MyISAM\” with \”Engine=MyISAM

2. ganti

`date_modified` timestamp(14) NOT NULL,
`date_submitted` timestamp(14) NOT NULL,

to:
`date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`date_submitted` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\',

Exit mobile version