Errors on startup related to interreg table

[Talaysen]

Server OS: CentOS 6

rAthena SVN: 17325

Ragnarok & Logs = same DB.

 

Getting errors on startup:

DB error - Table 'dbname.interreg' doesn't exist

[Debug]: at itemdb.c:1310 - SELECT `value` FROM `interreg` WHERE `varname` = unique_id

[Error]: itemdb_uid_load: Unable to fetch unique_id data

 

When I attempt to run the SQL queries for SVNs 17080, 17080_log, 17086, I get:

SQL query:


CREATE TABLE IF NOT EXISTS `interreg` (
`varname` varchar( 11 ) NOT NULL ,
`value` varchar( 20 ) NOT NULL ,
PRIMARY KEY ( `varname` )

) ENGINE = InnoDB;

[anakpondok]

try changing it into
 

CREATE TABLE IF NOT EXISTS `interreg` (
`varname` varchar(11) NOT NULL ,
`value` varchar(20) NOT NULL ,
PRIMARY KEY ( `varname` )
) ENGINE = InnoDB;

 

and you can also try just incase to change ` into ' for varchars type

Edited June 8, 2013 by anakpondok