EQEmulator Forums

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)

nannite 03-02-2014 08:50 AM
Buffs dropping at zone
 
Hello all,
I have a linux eqemu server up and running. I pull the source from git master about 3 weeks ago and just updated the database from here; http://peqtgc.com/releases

We started playing on it a couple of days ago and quickly noticed that all our buffs drop when we zone. We also don't get full health with each ding, but we get full mana.

I've been searching around but haven't found anything yet.

Do I need to pull from a different source branch or do another pull?

Did I use the correct database version?

Anyone have any idea that would cause something like that?

demonstar55 03-02-2014 09:23 AM
You need to source this file https://github.com/EQEmu/Server/blob...uff_update.sql

nannite 03-02-2014 10:06 AM
Thanks for the reply but when I try that it get this:

ERROR 1054 (42S22): Unknown column 'death_save_chance' in 'character_buffs'
ERROR 1054 (42S22): Unknown column 'DeathSaveSuccessChance' in 'merc_buffs'
ERROR 1146 (42S02): Table 'eq.botbuffs' doesn't exist
ERROR 1054 (42S22): Unknown column 'death_save_aa_chance' in 'character_buffs'
ERROR 1054 (42S22): Unknown column 'CasterAARank' in 'merc_buffs'
ERROR 1146 (42S02): Table 'eq.botbuffs' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'caston_y'
ERROR 1060 (42S21): Duplicate column name 'caston_y'
ERROR 1146 (42S02): Table 'eq.botbuffs' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'caston_z'
ERROR 1060 (42S21): Duplicate column name 'caston_z'
ERROR 1146 (42S02): Table 'eq.botbuffs' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'ExtraDIChance'
ERROR 1060 (42S21): Duplicate column name 'ExtraDIChance'
ERROR 1146 (42S02): Table 'eq.botbuffs' doesn't exist
ERROR 1054 (42S22): Unknown column 'not_reflectable' in 'spells_new'

maybe there is another update that is missing?

sorvani 03-02-2014 10:15 AM
Yeah that query needs to be fixed to not attempt things on tables that don't exist such as bots, but that is not your problem. You have the changes in already per your errors there.

Likely your source is prior to the changes. You need to update the source and the DB.

nannite 03-02-2014 10:17 AM
Ahh ok, I'll pull down the latest source and rebuild then.

nannite 03-02-2014 10:34 AM
That did the trick! TYVM :)

nannite 03-02-2014 11:05 AM
ok well that fixed the zoning buff problem, but now I can't attack mobs and when I try to cast on them I get "Your spell would not have taken hold on your target". Buffs all work though.

nannite 03-02-2014 12:07 PM
Ok updated the source as of today and got todays database release, sourced the drop_system.sql and peqbeta_2014-03-02-02:01.sql but I still have the same issue, I can't attack any mobs with either autoattack or spells.

demonstar55 03-02-2014 12:39 PM
Im assuming you're in a revamped zone that has combat disabled in the database because they're not fully implemented yet

nannite 03-02-2014 12:44 PM
Actually I'm not sure, is North Ro a revamped zone?

nannite 03-02-2014 12:52 PM
Well looks like it is, as well as Common lands. Befallen seems to be working fine, so that must be the issue.

Thanks again!

sorvani 03-02-2014 06:13 PM
Quote:
Originally Posted by nannite (Post 228618)
Ok updated the source as of today and got todays database release, sourced the drop_system.sql and peqbeta_2014-03-02-02:01.sql but I still have the same issue, I can't attack any mobs with either autoattack or spells.
If you have a database dated after the SQL, you do not need the SQL.

Glad you figured it out.

jcarmony 06-16-2014 06:51 PM
I am having same problem, all buffs drop whenever I zone. Using windows emu , and PEQDB peqbeta_2014-06-16-02:01.tar.gz .. I got the latest source released (06/13/2014) and rebuilt it, fresh clean install and still no luck. Also the updates (source/utils/sql/git/required) are up to date (last one being 2014_05_04_SlowMitigationFix.sql) .. So I would assume the peqdb 6-16-14 would be fully updated.

Everything else seems to be working fine. Any help is highly appreciated.

provocating 06-17-2014 07:49 AM
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 06-17-2014 11:44 AM
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 06-17-2014 05:36 PM
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

demonstar55 06-17-2014 06:24 PM
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.

jcarmony 06-17-2014 06:36 PM
Yes, that is an exact match. 'll use git pull and check make sure I have latest code and rebuild.

jcarmony 06-19-2014 03:07 AM
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 07-17-2014 03:27 AM
Same problems.
 
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 07-17-2014 03:43 AM
https://github.com/EQEmu/Server/blob...uff_update.sql

rlie_0 07-19-2014 04:41 PM
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 07-20-2014 12:43 AM
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 07-20-2014 09:34 AM
And don't forget to delete the cache in cmake and rerun it before compiling.


All times are GMT -4. The time now is 10:21 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.