Talaysen Posted May 10, 2013 Group: Members Topic Count: 27 Topics Per Day: 0.01 Content Count: 161 Reputation: 5 Joined: 02/07/13 Last Seen: March 25, 2016 Share Posted May 10, 2013 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; Quote Link to comment Share on other sites More sharing options...
anakpondok Posted June 8, 2013 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 5 Reputation: 0 Joined: 03/21/13 Last Seen: June 25, 2013 Share Posted June 8, 2013 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Question
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;
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.