Buffs dropping at zone

[jcarmony]

Yes, I went back and applied all the sql updates, it actually fixed a problem with items disappearing turning into coins I had with the lastest source. It did not however fix the buffs dropping. I applied all updates (SVN/GIT, Optional & Required) and still does not resolve the issue. I did find alot of updates PEQ did not apply. I am thinking now it must reside in one of the updates that could not be completed because it was a duplicate? Is it possible to get a blank DB? Or could someone tell me what is supposed to be in 'character_buffs" tables? Or better yet what are the tables? Or perhaps a SQL export of working 'charater_buffs' table. Currently I have in this order:

character_id, slot_id, spell_id, caster_level, caster_name, ticsremaining, counters, numhits, melee_rune, magic_rune, persistent, dot_rune, caston_x, caston_y, caston_z, ExtraDIChance

if it helps, when I check DB after buffs are casted, the 'character_buffs' is not populated at all.. I have also tried to enter valid data into the fields with no luck, (deleted upon zone, login)

Much thanks for any help

[demonstar55]

mysql> DESCRIBE `character_buffs`;
+---------------+-----------------------+------+-----+---------+-------+
| Field         | Type                  | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------+-------+
| character_id  | int(10) unsigned      | NO   | PRI | NULL    |       |
| slot_id       | tinyint(3) unsigned   | NO   | PRI | NULL    |       |
| spell_id      | smallint(10) unsigned | NO   |     | NULL    |       |
| caster_level  | tinyint(3) unsigned   | NO   |     | NULL    |       |
| caster_name   | varchar(64)           | NO   |     | NULL    |       |
| ticsremaining | int(10) unsigned      | NO   |     | NULL    |       |
| counters      | int(10) unsigned      | NO   |     | NULL    |       |
| numhits       | int(10) unsigned      | NO   |     | NULL    |       |
| melee_rune    | int(10) unsigned      | NO   |     | NULL    |       |
| magic_rune    | int(10) unsigned      | NO   |     | NULL    |       |
| persistent    | tinyint(3) unsigned   | NO   |     | NULL    |       |
| dot_rune      | int(10)               | NO   |     | 0       |       |
| caston_x      | int(10)               | NO   |     | 0       |       |
| caston_y      | int(10)               | NO   |     | 0       |       |
| caston_z      | int(10)               | NO   |     | 0       |       |
| ExtraDIChance | int(10)               | NO   |     | 0       |       |
+---------------+-----------------------+------+-----+---------+-------+

If it matches that, it could be possible you're not using current code.

[jcarmony]

Yes, that is an exact match. 'll use git pull and check make sure I have latest code and rebuild.

[jcarmony]

Well I finally got it working correctly. After unsuccessfully dropping SQL tables adding SQL tables, building and rebuilding I decided to start from scratch, I uninstalled everything completely (mySQL, perl, windows vs 2013 express). Recompiled and it works. Not sure where the demon lay, but it is resolved, much thanks for your help!

[rlie_0]

Im having much of the same problem, I dont use bots or mercs but the PCs themselfs are losing buffs upon zoning. I attempted to you use the links provided here to see what I could do and buffs are still not holding, keeps giving me errors like

SQL Error: 1054, Unkown Colum 'death_save_chance' in character_buffs'

Any ideas on what to do to get buffs working again?

[Akkadius]

https://github.com/EQEmu/Server/blob...uff_update.sql

[rlie_0]

When I attempt to recompile it gives me an error,

Error in configuration process project files may be invalid


CMake Error at C:/Program Files (x86)/CMake 2/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:108 (message):
Could NOT find ZLIB (missing: ZLIB_LIBRARY ZLIB_INCLUDE_DIR)
Call Stack (most recent call first):
C:/Program Files (x86)/CMake 2/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:315 (_FPHSA_FAILURE_MESSAGE)
C:/Program Files (x86)/CMake 2/share/cmake-2.8/Modules/FindZLIB.cmake:85 (FIND_PACKAGE_HANDLE_STANDARD_ARGS)
CMakeLists.txt:300 (FIND_PACKAGE)

Any one know whats causing this?

[lerxst2112]

I'm going to go out on a limb and say it can't find zlib. Make sure you have all the proper dependencies.

http://eqemu.github.io/

[Scorpious2k]

And don't forget to delete the cache in cmake and rerun it before compiling.