AAC Znote AAC - SQL error Table doesnt exist server_record

[ItsMeMagic]

string(61) "SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)
Table 'fort.server_record' doesn't exist

What is the correct command to execute the table?

help?

 

[Aelu]

CREATE TABLE IF NOT EXISTS `server_record` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[ItsMeMagic]

ty !!

and what about this?

string(61) "SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'record' in 'order clause'

 

[Aelu]

I think that's saying that the column "record" doesn't exist in "server_record". Try this:

ALTER TABLE server_record ADD record VARCHAR(255);