search

jonrainier / DayZ-Private-Server

DayZ Private Server by Pwnoz0r
98 stars 131 forks source link

Cant get vehicle spawns #139

Closed chris0135 closed 8 years ago

chris0135 commented 9 years ago

I have downloaded the 1.8.3, and there is an issue with the function pMain. It says cannot define @root@ or something like that. Everything works fine there is just no vehicles. In Navicat Object_data has nothing in it. I even tried bringing an old object data into navicat, but those vehicles do not transfer over. Thanks in advance

Pl4nky commented 9 years ago

Edit the pMain stored procedure and change this line:

CREATE DEFINER=root@% PROCEDURE pMain(IN i INT)

to

CREATE DEFINER=dayz@localhost PROCEDURE pMain(IN i INT)

Seems the root account in the SQL DB was removed or changed to dayz, but this stored proc wasn't updated.