how do i update my dayz epoch server from 1.0.2.4 to 1.0.2.5?

[jachosta]

how do i update from .2.4 to .2.5 because when i put the sql file in the database it fail. could i get some sort of instruction on how to update thx.

[MatthewK]

how does it fail ? error message ? how are you adding the file to your database, are you using the import sql feature or cutting and pasting directly into the sql query box ? 

[jachosta]

i drag the add_lastupdated_to_existing_object_data.sql to the dayz_epoch database and get this

 

 

[Err] 1060 - Duplicate column name 'LastUpdated'

[Err] ALTER TABLE `Object_DATA`  ADD `LastUpdated` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `Datestamp`;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[jachosta]

can i get instruction what to download and how to instal the update

[MatthewK]

I'm probably being dumb here , but that tells me you've already got a last_udpdated column ? 

[MatthewK]

http://dayzepoch.com/forum/index.php?/topic/126-patch-1025-download/

[jachosta]

http://img96.imageshack.us/img96/5066/h1nc.png

this is what i have

[jachosta]

when i join he server it says its 1.0.2.4 

[MatthewK]

Why are you showing us that? The instructions are on that link I posted for you.  If you follow the installation steps it clearly tells you how to update from 1.0.2.4 to 1.0.2.5 .. I know I sound like a grumpy old b***** here, but you need to go back read through those links again .. The error you're getting is because you already have that column .... Unless I'm missing something too :p

[MatthewK]

when i join he server it says its 1.0.2.4 

 

Actually, i read somewhere that this was a bug... Do a quick search on the forum..

[Axe Cop]

young padawan, you still have much to learn :P

 

Not that easy to just upgrade the version, unless your have no custom scripts and nothing you can replace the files and the database.. but don't just run the sql file if you don't know what it is doing and do a backup before !

Only run the "epoch.sql" and not the other ones, thats just for other version upgrades!

 

I would just drop the 3 trader tables and use the new entries from the epoch.sql, unless you changed some trader items..

[jachosta]

i followed all the instruction and still dont know what im doing wrong

[jachosta]

server worked fine before but it was at 1.0.2.4 not .2.5

[Axe Cop]

i followed all the instruction and still dont know what im doing wrong

what instructions did u follow exactely? There are no official instructions on how to upgrade to a new version as far as i know?

[jachosta]

i followed instructions on how to instal the server and just need to find out how to update to .2.5 because when i add the epoch sql and start the server it still says its 1.0.2.4

[jachosta]

when i join the server it says im running incorrect version of dayzcode and the server is running 1.0.2.4

[MatthewK]

what instructions did u follow exactely? There are no official instructions on how to upgrade to a new version as far as i know?

 

This tells me how to update (upgrade, same meaning) ? 

http://dayzepoch.com/wiki/index.php/Server_Installation_Instructions#SQL_to_update_from_1.0.2.4.2B

[jachosta]

i added that code to the server database and still it thinks its .2.4

 

UPDATE `object_data` SET `Classname`='CH_47F_EP1_DZE' WHERE `Classname`='CH_47F_EP1_DZ'; 

UPDATE `object_data` SET `Classname`='UH1Y_DZE' WHERE `Classname`='UH1Y_DZ'; 

UPDATE `object_data` SET `Classname`='UH1H_DZE' WHERE `Classname`='UH1H_DZ'; 

UPDATE `object_data` SET `Classname`='Mi17_DZE' WHERE `Classname`='Mi17_DZ'; 

UPDATE `object_data` SET `Classname`='UH60M_EP1_DZE' WHERE `Classname`='UH60M_EP1_DZ'; 

UPDATE `object_data` SET `Classname`='HMMWV_M998A2_SOV_DES_EP1_DZE' WHERE `Classname`='HMMWV_M998A2_SOV_DES_EP1'; 

UPDATE `object_data` SET `Classname`='HMMWV_M1151_M2_CZ_DES_EP1_DZE' WHERE `Classname`='HMMWV_M1151_M2_CZ_DES_EP1'; 

UPDATE `object_data` SET `Classname`='LandRover_Special_CZ_EP1_DZE' WHERE `Classname`='LandRover_Special_CZ_EP1'; 

UPDATE `object_data` SET `Classname`='LandRover_MG_TK_EP1_DZE' WHERE `Classname`='LandRover_MG_TK_EP1'; 

UPDATE `object_data` SET `Classname`='UAZ_MG_TK_EP1_DZE' WHERE `Classname`='UAZ_MG_TK_EP1'; 

UPDATE `object_data` SET `Classname`='GAZ_Vodnik_DZE' WHERE `Classname`='GAZ_Vodnik'; 

UPDATE `object_data` SET `Classname`='ArmoredSUV_PMC_DZE' WHERE `Classname`='ArmoredSUV_PMC_DZ'; 

UPDATE `object_data` SET `Classname`='Pickup_PK_TK_GUE_EP1_DZE' WHERE `Classname`='Pickup_PK_TK_GUE_EP1'; 

UPDATE `object_data` SET `Classname`='Offroad_DSHKM_Gue_DZE' WHERE `Classname`='Offroad_DSHKM_Gue'; 

UPDATE `object_data` SET `Classname`='Pickup_PK_GUE_DZE' WHERE `Classname`='Pickup_PK_GUE'; 

UPDATE `object_data` SET `Classname`='Pickup_PK_INS_DZE' WHERE `Classname`='Pickup_PK_INS';

[jachosta]

Actually, i read somewhere that this was a bug... Do a quick search on the forum..

can you try to find this bug

[MatthewK]

Can you ? 

[jachosta]

i cant find it i looked for a while now

[MatthewK]

All I remember reading is that they forgot to change the version number and they would fix it in the next release.. So I couldn't worry about it. 

[jachosta]

i might just be an dumb ass but i think i fixed it

[jachosta]

yup i forgot to update the @dayz_epoch in the server files