Compiling Mangos for the first time, cd mangos/src/bindings/scripts/sql not found

[Remuss]

Hey guys :-) First time compiling (Mangos One) and I've run into an issue.

When typing the command cd mangos/src/bindings/scripts/sql in git it answers ''no such file or directory''.

Thought it might have something to do with

change

# add_subdirectory(scripts)

to

add_subdirectory(scripts)

Because I can't seem to find ''# add_subdirectory(scripts)'' in my CMakeLists. What I see is this:

add_subdirectory(src)

# if(SQL)

# add_subdirectory(sql)

# endif()

Any suggestions on how to solve this?

[Remuss]

Anyone? :confused:

[Hikari]

The scripts library was moved into the core and is now located at src/scripts.

So the path you're looking for is mangos/src/scripts/sql.

[Remuss]

The scripts library was moved into the core and is now located at src/scripts.

So the path you're looking for is mangos/src/scripts/sql.

cd ../..

cd mangos/src/scripts/sql

mysql -u root -p mangos < mangos_scriptname_clear.sql

mysql -u root -p mangos < mangos_scriptname_full.sql

mysql -u root -p scriptdev2 < scriptdev2_create_structure_mysql.sql

mysql -u root -p scriptdev2 < scriptdev2_script_full.sql

Still getting the ''no such file or directory''.

[wolverine]

Alright. I just downloaded a new copy of the 0 repo this morning. The directory is

C:\MangosZero\server\sql

Sorry, I'm on windows at the moment, or I would use /'s.

[Remuss]

Alright. I just downloaded a new copy of the 0 repo this morning. The directory is

C:\MangosZero\server\sql

Sorry, I'm on windows at the moment, or I would use /'s.

Don't think that's where the files I need is, those are the ones I got into the db at the previous step.

I think this is where it want directions to

or here

So I guess that would be

cd ../..

cd mangos/src/scripts/sql

mysql -u root -p mangos < mangos_scriptname_clear.sql

mysql -u root -p mangos < mangos_scriptname_full.sql

mysql -u root -p scriptdev2 < scriptdev2_create_structure_mysql.sql

mysql -u root -p scriptdev2 < scriptdev2_script_full.sql

But again, this is the result

[Hikari]

Are you sure you're in the right directory. It seems like you're executing the change dir command on the root drive, so you're not there where you want to go.

Try

cd C:\MangosSource\mangos\src\scripts\sql

and then executing the sql files again.

[Remuss]

Are you sure you're in the right directory. It seems like you're executing the change dir command on the root drive, so you're not there where you want to go.

Try

cd C:\MangosSource\mangos\src\scripts\sql

and then executing the sql files again.

It didn't work... God it's frustrating :c

Edit:

Think I have adressed the issue, and I ain't proud of it...

Think it's because I didn't check the box with the ''Git Bash Here'' when installing git.

I'm re-doing the whole thing now and it already seem to be acting different :-) I apologies for my stupidity haha

[Hikari]

The error message is quite obvious and according to your screenshots the files are apparently there. Therefore you must be in the wrong directory.

Since it seems like you've physical access to the server, what happens if you use command prompt instead of Mingw? Or maybe you can use a MySQL Client like SQLyog or HeidiSQL in order to execute the files against the database.

Or you could move the sql files to the place where your mysql.exe is located and execute them from there.

[Remuss]

The error message is quite obvious and according to your screenshots the files are apparently there. Therefore you must be in the wrong directory.

Since it seems like you've physical access to the server, what happens if you use command prompt instead of Mingw? Or maybe you can use a MySQL Client like SQLyog or HeidiSQL in order to execute the files against the database.

Or you could move the sql files to the place where your mysql.exe is located and execute them from there.

I tried to do it manually by executing them into SQLyog and it went smooth until I executed this scriptdev2_create_structure_pgsql and got 5 errors

All though I can see the tables that the sql should create

[wolverine]

Alright. I think I finally found what you are looking for...

C:\MangosZero\server\src\bindings\scripts\sql

I hope this finally helps.

[Remuss]

Alright. I think I finally found what you are looking for...

C:\MangosZero\server\src\bindings\scripts\sql

I hope this finally helps.

It just won't work... I've been trying to compile different cores the last two days, still haven't been able to get one done. I must be cursed or something, because I'm really just following the instructions and then suddenly something is different and I'm screwed :3 Guess god want me to use repacks for the rest of my life

[Hikari]

[..] it went smooth until I executed this scriptdev2_create_structure_pgsql and got 5 errors

You have to use scriptdev2_create_structure_mysql.sql if you have a MySQL database server.

But if you have a PostgreSQL database server, then you have to use scriptdev2_create_structure_pgsql.sql. But not both (create structure files) into the same database system.

Alright. I think I finally found what you are looking for...

C:\MangosZero\server\src\bindings\scripts\sql

I hope this finally helps.

Just to be clear on this. As already mentioned, the script library is now part of the core and is no longer in the bindings folder. See this commit: https://github.com/mangosone/server/commit/a7a1079200acf7147457247d3e61cf1073d41e99

[antz]

scriptdev2_create_structure_pgsql - is only if you are running a non-mysql database like postgres

[didi00704]

I, use this:

"C:\Program Files\MySQL\MySQL Server 5.6\bin\MySQL" -u root -p mangos < mangos_scriptname_clear.sql

"C:\Program Files\MySQL\MySQL Server 5.6\bin\MySQL" -u root -p mangos < mangos_scriptname_full.sql

"C:\Program Files\MySQL\MySQL Server 5.6\bin\MySQL" -u root -p scriptdev2 < scriptdev2_create_structure_mysql.sql

"C:\Program Files\MySQL\MySQL Server 5.6\bin\MySQL" -u root -p scriptdev2 < scriptdev2_script_full.sql

[antz]

Are you sorted and everything working now ?