Database / trader issue

[redvine]

Having an issue with some items disappearing from traders. May add a few items today and a few from the other addition days earlier are removed. I have looked at what I thought was my hiveext.ini file but I cannot find scripts/commands/etc that run automatically that may effect something like this. The building supplies and toolbelt items for bash, stary, and klen are the only ones affected. Even my custom traders havent had an issue like this. Am I overlooking something? I queried "trader item database" , "trader database limit" , "trader items disappear". I read on a post somewhere that if your traders_data id # starts at a high number it may cause an issue, mine starts at 4995. An issue?

 

Thank you

 

Items:

ChainsawB

ChainsawG

ChainsawR

ChainsawP

ItemLockbox

ItemMixOil

ItemComboLock

ItemGPS

 

Map: Chernarus

Mod: Epoch 1.0.5.1

Version: 125548

Host: Vilayer

 

I use HeidiSQL for interaction with "database"

[ElDubya]

By disappearing, do you mean that after you add these items you can buy/sell them for a random amount of time THEN they vanish? Or after you add them to the traders they aren't available in-game at all?

[redvine]

Items in the toolbelt or building supplies disappear later on when I add those items. Then after a few auto restarts, 4 hrs, the list returns to default epoch mod items. Weapons, vehicles, ammo, skins I have added have not been affected. I may have just answered my own question but am unsure of where to look at what is affected on restart.

 

This only recently started happening in the trader. The only script that was added recently was Noxsicarious action menu which I don't believe affects the database in anyway, could be wrong.

[ElDubya]

Do you have any errors in either RPT? 

[redvine]

Only error or spam in arma2oaserver rpt is:

 

12:17:19 Strange convex component81 in zero_buildings\models\housev_3i3_i.p3d:geometryFire

12:17:28 Strange convex component288 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component289 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component290 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component291 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component292 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component293 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component294 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component295 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component296 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component297 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component298 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component299 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component300 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component301 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component302 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component303 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component304 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component305 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component306 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component307 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component308 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component309 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component310 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component311 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component312 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component313 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component314 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component315 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component316 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component317 in warehouse\models\warehouse.p3d:geometry

12:17:28 Strange convex component252 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component253 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component254 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component255 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component256 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component257 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component258 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component259 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component260 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component261 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component262 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component263 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component264 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component265 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component266 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component267 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component268 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component269 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component270 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component271 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component272 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component273 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component274 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component275 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component276 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component277 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component278 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component279 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component280 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component281 in warehouse\models\warehouse.p3d:geometryFire

12:17:28 Strange convex component249 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component250 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component251 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component252 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component253 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component254 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component255 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component256 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component257 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component258 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component259 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component260 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component261 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component262 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component263 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component264 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component265 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component266 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component267 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component268 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component269 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component270 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component271 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component272 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component273 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component274 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component275 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component276 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component277 in warehouse\models\warehouse.p3d:geometryView

12:17:28 Strange convex component278 in warehouse\models\warehouse.p3d:geometryView

 

Didn't have any errors on my pc. Is there another rpt file to open?

 

Hiveext.ini

 

;This is a comment 

;Comments above a certain setting will provide it's description 

 

;The format for a setting is 

;Variable = Value 

 

;If you see a commented line of that form, it means that the setting is optional, and the Value shows the default 

;To change from the default, simply uncomment the line and change the Value 

 

[Time]

Type = Custom

Offset = +8

 

[Database] 

;Currently, only MySQL is supported 

Type = MySQL 

;Hostname or IP of the server to connect to 

Host = 64.31.51.156 

;Port to connect to. The default is the default listening port of a server of the selected Type 

;Instead of specifying Port, you can specify Socket and set Value to the socket name 

Port = 

;Database name to connect to. 

Database = 

;Username to connect with 

Username = 

;Password to authenticate with (default is blank) 

Password = 

 

[Characters] 

;The field name that Player's IDs are stored in (unique per game license) 

;IDField = PlayerUID 

;The field name that Player's World Position and rotation is stored in 

;Enables you to run multiple different maps (different instances) off the same character table 

;WSField = Worldspace 

 

[Objects] 

;Flag indicating whether hiveext should detect vehicles out of map boundaries (X < 0, or Y > 15360) and reset their position to [] 

;Note: YOU MUST have a proper dayz_server.pbo that supports this feature, otherwise you will get script errors 

;You can find that file under the SQF directory for your server version 

;ResetOOBObjects = false 

 

;EPOCH SETTINGS 

;Which table should the objects be stored and fetched from  

;Table = Object_DATA 

 

;Negative values will disable this feature 

;0 means that ALL empty placed items will be deleted every server restart 

;A positive number is how old (in days) a placed empty item must be, in order for it to be deleted 

CleanupPlacedAfterDays = -1 

 

[ObjectDB] 

;Setting this to true separates the Object fetches from the Character fetches 

;That means that the Object Table must be on this other database 

;Use = false 

 

;The settings here have the same meaning as in [Database], and are only used if the setting above is set to true 

;Type = MySQL 

;Host = localhost 

;Port = 

;Database =  

;Username = 

;Password = 

 

HiveExt.log - No errors

 

Mysqlshutdown.log

 

 

MySQL Shutdown Cleanly

 

Do I need to look somewhere else for an error or configuration?

[ElDubya]

[Database] 
;Currently, only MySQL is supported 
Type = MySQL 
;Hostname or IP of the server to connect to 
Host = 64.31.51.156 
;Port to connect to. The default is the default listening port of a server of the selected Type 
;Instead of specifying Port, you can specify Socket and set Value to the socket name 
Port = <-----------
;Database name to connect to. 
Database = <----------
;Username to connect with 
Username = <------------
;Password to authenticate with (default is blank) 
Password = <-------------

Not sure if you omitted this information (which is smart) or you don't have these parts populated. If the latter, next time put ************ where the info should be so we know :)

 

Sounds like the action menu might have been installed (or modified) wrong. Have you tried removing the action menu? Regardless, I have come across a lot of errors but never this one, congratulations :)

[redvine]

The entries were removed, was there another rpt file or log to check out?

[ElDubya]

There are only two.

 

Server RPT : instance_24_Napf (for example)\arma2oaserver.RPT

Client RPT : C:\Users\yourcomputername\AppData\Local\ArmA 2 OA\arma2oa.RPT

 

Post both of those seperately to pastebin and put the links in here.

[Triage]

Are you on a dedicated machine or gameserver?