[Solved] Need SQL help

[rayhanalka]

hi anyone can help me about this?

actually the server running fine. But the picture shownthese SQL error why?...

Edited February 1, 2017 by rayhanalka

[Sryx]

CREATE TABLE IF NOT EXISTS `logs` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `user` varchar(23) NOT NULL default '',
  `rcode` tinyint(4) NOT NULL default '0',
  `log` varchar(255) NOT NULL default '',
  INDEX (`ip`)
) ENGINE=MyISAM ;

You're missing "logs" "table" which has the same column of "loginlogs" from "logs.sql".

Use the code to create "logs" table.

Edited February 1, 2017 by Sryx

[rayhanalka]

4 hours ago, Sryx said:

CREATE TABLE IF NOT EXISTS `logs` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `user` varchar(23) NOT NULL default '',
  `rcode` tinyint(4) NOT NULL default '0',
  `log` varchar(255) NOT NULL default '',
  INDEX (`ip`)
) ENGINE=MyISAM ;

You're missing "logs" "table" which has the same column of "loginlogs" from "logs.sql".

Use the code to create "logs" table.

thank you, it's work like magic