Need Help Upgrading my Bliss

[Zod]

damn this is what i get now when i try to migrate reality main

 

[Zod]

and this is when i choose migration from bliss

 

[Zod]

cant i just download a newer version of bliss server that will work when i try to upgrade to reality?
If possible, link me download section because i find many different bliss files to download and dont know what is the latest, ty.

 

[Zod]

this is my migration schema log after i used the command you provided above



1 Reality 2012-09-09 16:09:31 0.000000 0.010000
2 Reality 2012-09-09 16:09:32 0.010000 0.020000
3 Reality 2012-09-09 16:09:32 0.020000 0.030000
4 Reality 2012-09-09 16:09:32 0.030000 0.040000
5 Reality 2012-09-09 16:09:32 0.040000 0.050000
6 Reality 2012-09-09 16:09:33 0.050000 0.060000
7 Reality 2012-09-09 16:09:33 0.060000 0.070000
8 Reality 2012-09-09 16:09:34 0.070000 0.080000
9 Reality 2012-09-09 16:09:34 0.080000 0.090000
10 Reality 2012-09-09 16:09:34 0.090000 0.100000
11 Reality 2012-09-09 16:09:34 0.100000 0.110000
12 Reality 2012-09-09 16:09:34 0.110000 0.120000
13 Reality 2012-09-09 16:09:35 0.120000 0.130000
14 RealityMigrate 2013-02-13 18:24:47 0.000000 0.010000



migration schema version
Reality 0.130000
RealityMigrate 0.010000

 

[Zod]

Nvm Forums is just fine

Plz help me i am desperate and i am stuck

 

[Zod]

I will just try to download esi download thats the latest bliss files i assume install those and then try to upgrade those into reality.

Wish me luck

 

[Zod]

ok the same happends with the other bliss files i downloaded.

Where you guys download your bliss files from?

Just need a version of bliss database that is able to upgrade to reality database.

 

[wriley]

The migration or Reality schema didn't update from 0.13 so I think it is dying on the first migration step, executing the SQL files in schema/Reality/mysql/0.13-0.14.

Do you have full rights granted to your database user? Run this in your SQL program.

SHOW GRANTS FOR 'USER'@'HOST';

Where USER and HOST match your database connection information.

That should show something similar to this:

mysql> SHOW GRANTS FOR [email protected];
+----------------------------------------------------------------------------------------------------------------+
| Grants for [email protected]                                                                                   |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dayz'@'zombie.local' IDENTIFIED BY PASSWORD 'XXXXXXXXXXX' |
| GRANT ALL PRIVILEGES ON `reality_1`.* TO 'dayz'@'zombie.local'                                                 |
+----------------------------------------------------------------------------------------------------------------+

 

[Zod]

+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set

 

[wriley]

I understand this is frustrating. To find why the migration is failing you can run the migration SQL code manually. db_migrate.pl looks in schema/Reality/mysql and runs the SQL files in order that it finds.

Let's try manually updating from 0.13 to 0.14.

10_spawns_heli.sql

insert ignore into spawns (otype, pos, uuid) values ('UH1H_DZ', '[310,[6365.74,7795.35,-0.0487671]]', '989539');
insert ignore into spawns (otype, pos, uuid) values ('UH1H_DZ', '[14,[13308.510780334473, 3227.0215606689453, 0]]', '625402');
insert ignore into spawns (otype, pos, uuid) values ('UH1H_DZ', '[265,[7695.035457611084, 3991.2055587768555, 0]]', '339267');
insert ignore into spawns (otype, pos, uuid) values ('UH1H_DZ', '[22,[12035, 12368.4, -0.0491638]]', '6791014');
 
update spawns set pos = '[153,[11251.7728805542, 4274.1740798950195, 0]]' where uuid = 35;
update spawns set pos = '[133,[4211.878776550293, 10735.167846679688, 0]]' where uuid = 36;
update spawns set pos = '[52,[6879.14, 11439.9, -0.0406189]]' where uuid = 37;
update spawns set pos = '[359,[6377.88, 2757.89, -0.0487671]]' where uuid = 39;

20_proc_fix.sql

drop procedure if exists `proc_loginSurvivor`;
create procedure `proc_loginSurvivor`(in `p_uniqueId` varchar(128), in `p_playerName` varchar(128))begin
  update profile set name = p_playerName where unique_id = p_uniqueId; --
  update survivor
  set state = '["","aidlpercmstpsnonwnondnon_player_idlesteady04",36]'
  where
    unique_id = p_uniqueId and is_dead = 0 and state rlike '.*_(driver|pilot)'; --
  select
    id, inventory, backpack, floor(time_to_sec(timediff(now(), start_time)) / 60), model, last_ate, last_drank
  from survivor
  where
    survivor.unique_id = p_uniqueId
    and is_dead = 0; --
end;

 

[Zod]

sorry i didnt understand what i have to do

nvm i got it i think

i create 2 files inside schema/reality/mysql that are

10_spawn_heli.sqf and the other one

This is correct?

 

[wriley]

I was showing you the 2 SQL files that need to be ran. Copy and paste each of the 2 code sections above (1 at a time) into your SQL program and see what errors you get. I want to see which of those 2 sections doesn't work.

 

[Zod]

inside schema/reality/mysql is has more folders inside and in them it has the sql files

 

[Zod]

i found 10_spawns_heli.sql

[Err] 1146 - Table 'dayz.spawns' doesn't exist
[Err] insert ignore into spawns (otype, pos, uuid) values ('UH1H_DZ', '[310,[6365.74,7795.35,-0.0487671]]', '989539');
[Msg] Finished - Unsuccessfully

 

[Zod]

20_proc_fix.sql

[Msg] Finished - 7 queries executed successfully

 

[wriley]

[Err] 1146 - Table 'dayz.spawns' doesn't exist

There's your problem, the database is missing a table.

I'm at a loss as to how your database got in this state, or how it ever worked with Bliss. I think you will have to start over with a new database as getting your current database into a working state needs more help than I can provide via the forum. Best of luck.

 

[Zod]

Ty but plz i still need your help.

Where can i get a fresh bliss install that will work for the upgrade process ?

Also i never recall my bliss database ever to have a table that was called spawns.

Last time i saw a table called spawn in a database was when i was using sanctuary build.

So plz a little more help and i will be on my way
Sent me a link if possible where i can download a fresh bliss that most ppl used to upgrade to reality.
Because the bliss i download from tunngle (conan's, or ESI downloader) both gave me same error meaning their database is exactly the same.
So the question is where you guys got your bliss from???

 

[Zod]

Sorry i am unable to find a bliss installation that will create a database that is including dayz.spawns table.

I already tried Conan installation and ESI download (not sure if those are exactly the same).
But both create the same stracture database and none of them had included dayz.spawns table.

So the questions remains the same where you guys downloaded your bliss server from?

Share plz so i download fresh install then use the control panel to upgrade to reality nice and easy.

Or sent me skype or TS so we can talk with voice and get done with this as fast as possible, plz i beg you.

 

[Zod]

Nvm i got my server fixed thanks to dayzCC.

Ty all for your time and for the assistance provided.

 

[wriley]

Sorry, I was out of town for several days. I'm glad you got it to work!