EQEmulator Forums - Buffs dropping at zone

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - Buffs dropping at zone (https://www.eqemulator.org/forums/showthread.php?t=37917)

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:

Code:

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

Code:

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.

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

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!

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?

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?

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/

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