# Thread: Problems with updating World

1. Originally Posted by mariow
Hello 125125 I download SqLOG and i'm try Excuite my Merge-sql.sql And He give me errors "There was an error while executing a query.
The query and the error message has been logged at:
C:\Users\Mario\AppData\Roaming\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file."

But to my SqLOG.err says that "Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 11:59:55
Line no.:15
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 12:00:06
Line no.:15
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 12:00:29
Line no.:16
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 12:02:12
Line no.:16
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 12:02:20
Line no.:16
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

Query:
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0)

Error occured at:2014-08-27 12:02:29
Line no.:16
Error Code: 1054 - Unknown column 'VerifiedBuild' in 'field list'

"
Rename your WDBVerified column to VerifiedBuild.
You can use this query
Code:
`ALTER TABLE gameobject CHANGE WDBVerified VerifiedBuild smallint(5);`
Run this query in world DB :)

2. Originally Posted by 125125
Rename your WDBVerified column to VerifiedBuild.
You can use this query
Code:
`ALTER TABLE gameobject CHANGE WDBVerified VerifiedBuild smallint(5);`
Run this query in world DB :)
I use but He give me error
Code:
`/* SQL Error (1054): Unknown column 'WDBVerified' in 'gameobject' */`

3. Originally Posted by mariow
I use but He give me error
Code:
`/* SQL Error (1054): Unknown column 'WDBVerified' in 'gameobject' */`
Well, You told me on skype that your last column in gameobject table was state. Last column should be VerifiedBuild. That means that you have to add another column to the table. So add a column and name it VerifiedBuild and set it to SmallINT and set the length to 5. So smallint(5)
I guess you have even more errors but this will solve the error for gameobject table atleast

I'm not sure if you know how to add columns to a table so you can use this query
Code:
```ALTER TABLE gameobject
ADD VerifiedBuild SmallINT(5) NULL DEFAULT 0;```

4. Ok now i will test it and i tell you work/no work