The R2 SQL Format about portalr2 HOT 11 CLOSED

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.

from portalr2.

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.
[email protected]
Thanks in advance.

from portalr2.

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.

from portalr2.

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

from portalr2.

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 ;)

from portalr2.

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.

from portalr2.

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

from portalr2.

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

from portalr2.

The info in the email should get you started

from portalr2.

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.

from portalr2.

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.

from portalr2.