Can't get schema version! Does `schema_info` exist?

[ibarhim_95]

:: OTServ Version 0.6.4_SVN
:: ============================================================================
::
:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Using data directory data/... [done]
:: Checking Database Connection...
[Warning] max_allowed_packet might be set too low for binary map storage.
Use the following query to raise max_allow_packet: SET GLOBAL max_allowed_packet = 16777216;[done]
:: Checking Schema version... mysql_real_query(): SELECT `value` FROM `schema_info` WHERE `name` = 'version';: MYSQL ERROR: Table 'otserv.schema_info' doesn't exist
mysql_store_result(): SELECT `value` FROM `schema_info` WHERE `name` = 'version';: MYSQL ERROR: Table 'otserv.schema_info' doesn't exist




Can someone help me Pls

 

[Random Number]

:: OTServ Version 0.6.4_SVN
:: ============================================================================
::
:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Using data directory data/... [done]
:: Checking Database Connection...
[Warning] max_allowed_packet might be set too low for binary map storage.
Use the following query to raise max_allow_packet: SET GLOBAL max_allowed_packet = 16777216;[done]
:: Checking Schema version... mysql_real_query(): SELECT `value` FROM `schema_info` WHERE `name` = 'version';: MYSQL ERROR: Table 'otserv.schema_info' doesn't exist
mysql_store_result(): SELECT `value` FROM `schema_info` WHERE `name` = 'version';: MYSQL ERROR: Table 'otserv.schema_info' doesn't exist




Can someone help me Pls

Just do what it says, go into the database click on the sql tab and paste in, click the go button.

SET GLOBAL max_allowed_packet = 16777216;

For the other error try this, same as above copy and paste.

CREATE TABLE `schema_info` (
    `name` VARCHAR(255) NOT NULL,
    `value` VARCHAR(255) NOT NULL,
    PRIMARY KEY (`name`)
) ENGINE = InnoDB;

INSERT INTO `schema_info` (`name`, `value`) VALUES ('version', 25);

 

[ibarhim_95]

My shop system doesn't work. :/

My shop system doesn't work. :/

Just do what it says, go into the database click on the sql tab and paste in, click the go button.

SET GLOBAL max_allowed_packet = 16777216;

For the other error try this, same as above copy and paste.

CREATE TABLE `schema_info` (
    `name` VARCHAR(255) NOT NULL,
    `value` VARCHAR(255) NOT NULL,
    PRIMARY KEY (`name`)
) ENGINE = InnoDB;

INSERT INTO `schema_info` (`name`, `value`) VALUES ('version', 25);

My shop system doesn't work. :/

 

[Raggaer]

My shop system doesn't work. :/






My shop system doesn't work. :/

The image is broken

 

[ibarhim_95]

The image is broken

Oh sorry Here

 

[Raggaer]

Oh sorry Here

That does not look like broken, check your config.php file maybe you need to enable the shop system