GM ticket

[damar]

Hello! I'm using whydb 226, i can't see the tickets, from my admin or GM account. Any idea to rezolve that?
Thanks!

[damar]

Nobody can help me to fix Gmtickets, on Arcemu trunk r1547??? I need something to fix it, please!

[stoneharry]

Update your core to a higher revision and it should be fixed for something that major (or look in commit log for when they fixed).

[damar]

I need only a sql file, because i tried to update it, but don't work, if you have a sql file to execute her, you'll help me so much

[stoneharry]

Your ticket table might have the wrong structure, in your core go to the SQL folder --> utilities and run the bat (might be exe) file in there, enter your details and apply the updates.

[damar]

Yes, i have a problem un update file, look the error!

[Err] 1060 - Duplicate column name 'playerGuid'
[Err] ALTER TABLE `gm_tickets` CHANGE COLUMN `guid` `playerGuid` INTEGER NOT NULL;
[Msg] Finished - Unsuccessfully

[Err] 1054 - Unknown column 'type' in 'gm_tickets'
[Err] ALTER TABLE `gm_tickets` CHANGE COLUMN `type` `map` INTEGER NOT NULL;
[Msg] Finished - Unsuccessfully

2 files to erros, but i don't know what's mean, because it's first time when i saw that at a sql file....

[stoneharry]

Sounds like the database you are useing is hopelessly out of date with the one you have - Get a better one I read somewhere ArcEmu were supporting UDB (which is the best database by far) or if there not theres still other databases that support ArcEmu (look on there forums).

[damar]

I can't find a good UDB, but, offf, this is a big problem with tickets. i hope i can rezolve it!