Question: how to fix the error?

You have an error in your SQL syntax; MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS aq. ( id int(255) NOT NULL AUTO_INCREMENT, ' at line 1

 public function install_file($file){ $filen = fopen($file,'r'); $query = fread($filen, filesize($file)); //if( $i = $this->mysqli->multi_query($query); //){ if( $this->mysqli->errno ) { echo $this->mysqli->error; } //return $i; //}// else return false; }

Server type: MySQL Server version: 5.6.15-log - MySQL Community Server (GPL) Server encoding: UTF-8 Unicode (utf8)

 CREATE TABLE IF NOT EXISTS `aq` ( `id` int(255) NOT NULL AUTO_INCREMENT, `a` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `q` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `attachment` text COLLATE utf8_unicode_ci, `sticker_id` int(200) DEFAULT NULL, `call` int(255) NOT NULL, `emoti` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1012 ;
  • one
    What do you have in the query before this create table? Mysql in error writes the place from which the error began. And the error is usually up to this point. - Small

0