Solved error while create character ZNOTE ACC

[tuduras]

Hello, last I added some querry with autoloot and occurs error when I want to create character, anyone know how to solve it?
help ;p
PS: I dont have backup

 

[Forkz]

Hello, last I added some querry with autoloot and occurs error when I want to create character, anyone know how to solve it?View attachment 95678
help ;p
PS: I dont have backup

You need to correct the query where you add the "autoloot" to the database during character creation.

 

[VitoxMaster]

Probably you defined column as a NOT NULL so it requires some value when u create row in that table.
ALTER TABLE <your table>
ALTER autoloot SET DEFAULT 0;

or


ALTER TABLE <your table>
MODIFY autoloot <data_type> NULL;

 

[tuduras]

Thankx Mates , I've found backup from start server. Thanks GUys ;p

PS:
ALTER TABLE <your table>
ALTER autoloot SET DEFAULT 0;

what is "your table"?

 

[VitoxMaster]

Name of the table where you have that "autoloot" column.

 

[tuduras]

CREATE TABLE `player_autoloot` (
  `player_id` int NOT NULL,
  `autoloot_list` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `player_autoloot`
--

INSERT INTO `player_autoloot` (`player_id`, `autoloot_list`) VALUES
(2192, 'dhpó&'),
(2193, 'dhpó&'),
(2194, 'dhpó&'),
(2195, 'dhpó&'),
(2196, 'dhpó&'),
(2197, 'dhpó&'),
(2198, 'dhpó&');

Maybe
ALTER TABLE <player_autoloot>
ALTER autoloot SET DEFAULT 0;

? this UP doesnt work

 

[Ianoyo]

ALTER TABLE `player_autoloot`
ALTER `autoloot` SET DEFAULT 0;

 

[tuduras]

I've already uploaded backup but thanks