MoopleDev Rev 120 Error? Help Me please

[NeorzRiel]

Hi i need some help with problem.I want to create an admin account for the server, however the navicat or mysqlquerybrowser doesnt show the an account table for me to input and execute it.
Do i have to create it or input values in the script in mysqlquerybrowser. Please do guide me.
I tried launching the sever and it is success but cannot log in as there is no account.

Source:MoopleDev Rev 120
IMG for reference
Navicat 8.0
2016-09-07d2ee.png - imgup.net
MySQLquerybrowser
2016-09-07307e.png - imgup.net

[MentaL]

[Eric]

Try executing your query again. You're missing way too many tables, and most importantly the accounts table indeed. It shows it's dropping and creating it in MySQL, what happened? Did you touch the SQL? Executing the MoopleDEV.sql file should work just fine.

[NeorzRiel]

Try executing your query again. You're missing way too many tables, and most importantly the accounts table indeed. It shows it's dropping and creating it in MySQL, what happened? Did you touch the SQL? Executing the MoopleDEV.sql file should work just fine.

Well i did not touch it at all and i kept executing it many times

[Eric]

Well i did not touch it at all and i kept executing it many times

Oh my bad, I didn't even notice the errors being thrown. You're getting an invalid date for birthday. 0000-00-00 doesn't work in newer MySQL versions, you have to put a real minimum date now. If it's easier for you, just put today's date or something. Real date would probably be time(0), but 2016-09-06 would work if you're lazy and don't care (it's just defaults anyways).

[NeorzRiel]

what about tempban?

[Eric]

what about tempban?

For bans, you just need the date to be old so that it thinks it ended. You can again do time(0), or you can do something like make it yesterday's date lol. If the time can't be 00:00:00 which is weird because usually it's 24hour time, make it 12:00:00. Just don't put today's date, it'll think you're banned.

[NeorzRiel]

ooh it works but now how do i edit the account i try to use edit but it pops up like this
should i use navicat to do what
2016-09-07b163.png - imgup.net

[Eric]

ooh it works but now how do i edit the account i try to use edit but it pops up like this
should i use navicat to do what
2016-09-07b163.png - imgup.net

Instead of right-clicking accounts and clicking edit, just double-click accounts. At the bottom you'll see "Edit". Click that. Then, double click in the name box, and enter your username. Do the same for password. Then click Apply Changes, which should be right next to the Edit button.