Sader hourly point

[Dolphin86]

hye im not sure why but everytime i restart my server it will give this error

[SQL]: DB error - CREATE command denied to user 'server'@'localhost' for table '                                                                                        sader_variables_log'
[Debug]: at script.cpp:16825 - CREATE TABLE IF NOT EXISTS sader_variables_log                                                                                         (unique_id INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0',ip VARCHAR(100) NOT NULL                                                                                        ,variable VARCHAR(32) NOT NULL, index INT NOT NULL, value INT NOT NULL,ac                                                                                        count_id INT NOT NULL,char_id INT NOT NULL,char_name VARCHAR(30) NOT NULL)                                                                                         ENGINE=MyISAM
[Debug]: Source (NPC): sader_Hourly_Rewards (invisible/not on a map)

 

[sader1992]

try to directly run the command into your sql , in the log database

CREATE TABLE IF NOT EXISTS `sader_variables_log` (`unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0',`ip` VARCHAR(100) NOT NULL,`variable` VARCHAR(32) NOT NULL, `index` INT NOT NULL, `value` INT NOT NULL,`account_id` INT NOT NULL,`char_id` INT NOT NULL,`char_name` VARCHAR(30) NOT NULL) ENGINE=MyISAM

 

[Dolphin86]

52 minutes ago, sader1992 said:

try to directly run the command into your sql , in the log database

CREATE TABLE IF NOT EXISTS `sader_variables_log` (`unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0',`ip` VARCHAR(100) NOT NULL,`variable` VARCHAR(32) NOT NULL, `index` INT NOT NULL, `value` INT NOT NULL,`account_id` INT NOT NULL,`char_id` INT NOT NULL,`char_name` VARCHAR(30) NOT NULL) ENGINE=MyISAM

 

stiil same i think 

[SQL]: DB error - CREATE command denied to user 'server'@'localhost' for table '                                                                                        sader_variables_log'
[Debug]: at script.cpp:16825 - CREATE TABLE IF NOT EXISTS `sader_variables_log`                                                                                         (`unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0',`ip` VARCHAR(100) NOT NULL                                                                                        ,`variable` VARCHAR(32) NOT NULL, `index` INT NOT NULL, `value` INT NOT NULL,`ac                                                                                        count_id` INT NOT NULL,`char_id` INT NOT NULL,`char_name` VARCHAR(30) NOT NULL)                                                                                         ENGINE=MyISAM
[Debug]: Source (NPC): sader_Hourly_Rewards (invisible/not on a map)

 

[sader1992]

make sure the connection info to your log database in your server config is right , make sure you have sader_variables_log table in your log database , if it's there , try to delete it and recreate it

[Dolphin86]

3 minutes ago, sader1992 said:

make sure the connection info to your log database in your server config is right , make sure you have sader_variables_log table in your log database , if it's there , try to delete it and recreate it

should i put in my vps ip in that command? since mysql are inside my vps