Jump to content
  • 0

Plaese help, DB error


Question

Posted (edited)

////cmd.exe - charserv

: DB error - Table '(Server name).bonus_script' doesn't exist

	[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)


////cmd.exe -mapserv

[Status]: Connecting to 127.0.0.1:6121
[Error]: make_connection: connect failed (socket #2, error 10061: No connection could be made because the target machine actively refused it.
)!

I used "Revision 17726"  Im alreay setting all about char inter map main.

I used Windows 10 Pro

Please, help. :(

Edited by Tymegg

1 answer to this question

Recommended Posts

  • 0
Posted

Hello, on your mapserver it said that it did not detect .bonus_script or it does not exist.

Make a blank SQL file and paste this

CREATE TABLE IF NOT EXISTS `bonus_script` (
  `char_id` INT(11) UNSIGNED NOT NULL,
  `script` TEXT NOT NULL,
  `tick` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `icon` SMALLINT(3) NOT NULL DEFAULT '-1'
) ENGINE=InnoDB;

execute and try again. If you don't know how to make a blank SQL file please refer to this "Part 7: Installing files/tables"

 

  • Upvote 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...