Buffs dropping at zone

[provocating]

Someone correct me here but I think even if you source in PEQ at a particular date, that does not guarantee you do not need to back date some of the SQL updates. I seem to have run into this before.

[demonstar55]

The issue described here is because they missed an SQL that affects a player table, which the PEQ update doe not over, since it would cause character deletion, so you need to run the right SQL from the updates.

[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.