The R2 SQL Format

[ECEstal]

Alright, so I've pulled your R2 Core. Compiled and I'm trying to start the server. When I start the server I get

2012-07-01 18:55:22 Loading Creature templates... 2012-07-01 18:55:22 ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql).

I'm not sure if this is an issue by me or in the MaNgos SQL you have provided, but I thought it was worth mentioning. By the way. This is a fresh compile not an attempt to add. Thanks

[blueboy]

Hi

The error your getting suggests that your world database is not up-to-date or corrupt. I have checked the creature_template table in my world database and there are indeed 90 fields. Easy way to check, is to examine the db_version table. It should say 'required_12012_01_mangos_spell_template'. If this checks out, I would suggest you re-install the database (I believe ytdb is the preferred world database for the R2 core).

Let me know if you get it resolved, it's been two months since I ran my R2 server and I'm having to re-extract the maps etc.. as you know this can take many hours, but I will check your issue out shortly.

P.S. If your interested in the latest features that include arena & LFG interaction, you must get your source from the R2new-ai branch, https://github.com/blueboy/portalR2/tree/R2new-ai

@EDIT Sorry I just checked and the file I thought you meant (mangos_botguy.sql) and this alters the 'gossip_menu_option' table and not the 'creature_template' table. Shouldn't be too many more hour until the map extraction finishes ;)

Thanks for your interest in playerbot.

[ECEstal]

Any way I could bother you for a SQL Mangos dump of your database? I'm trying to get a proper YTDB database in and it dies everytime during the execution. admin@doxramos.org Thanks in advance.

[blueboy]

Yes, I can let you have a copy of my active database, but I might have a quicker solution for you. Check that you creature_template table has the following fields

PowerType Spell5 Spell6 Spell7 Spell8

If not you will need to apply 'custom_mangos_tables.sql' from the 'sql_mr' directory in your R2 source root. This will add these additional fields to the table and hopefully allow your server to load.

[ECEstal]

I have them in them in my database. I think the YTDB that I have is corrupted. (Possibly) I've tried setting my max allowed packet size higher and I think it's my primary issue. Sorry for asking for all the support just having more issues then I've ever had. Hoping it's cause it's worth that much more :P

[blueboy]

I have backup my mangos database and I going to install it again. The backup is large and full of junk, so I think it would be better if I post instructions on how to get a fresh ytdb installed. Give me a few minutes ;)

[ECEstal]

Sounds like a plan. At this time I currently have an issue going of max packet allowed size, but that's a SQL Server issue I think, so I'm trying to find a fix too. Downloading your R2 with the new AI in the mean time.

Alright Blues. I was able to change the max packet size and then install your updates. Afterwards I now have a minor issue. No NPCs seem to be in game or tele locations. I have items going. This is with a fresh compile and a fresh ytdb database with your updates installed.

[blueboy]

I've just spent an email to you with instructions. ------------ ^ (Sorry for the typo, I know I'm spent it's nearly 5 in the morning here)

@Edit: If you're not getting any NPCs are you sure your using the FULL ytdbase and not the mangos.sql from the R2 sql directory. This contains no data like NPCs teleport locs etc..

Hope this helps

[ECEstal]

Yeah; pushed in the mangos sql afterwards, so maybe it's deleting everything.

[blueboy]

The info in the email should get you started

[ECEstal]

Alright, so the vmaps for the master repo don't work with the new-ai repo and the new-ai repo doesn't seem to work. Fairly sure it's a problem I did, so since I have one working I will figure this second one out. Thanks much for the help.

[blueboy]

I had exactly the same problem, that's why I had to create new (maps, vmaps, dbc, mmaps).. You will need to do the same. On a reasonably fast pc it should take about 12 hours. You will find the necessary binaries to do the extraction in the directory 'contrb' in your R2 source root. Copy ExtractResources.sh and the contents of either win32 or win64 to your WOW client root. Then use GitBash to run the script and extract the resources. I believe the R2 team are doing their own thing with the map system, so the files can not be used with both R2 & MaNGOS. You will probably need two sets.

I know the code on both portalR2 (master & R2new-ai) branches work, as I have tested them and I'm currently using the code on R2new-ai. It concerns me that you refer to the code on the new-ai repo. I thought you were using R2. The code in the portal (new-ai) branch will only run on MaNGOS (WotLK) and is not transferable.