Jump to content

World Database Error


N8boy

Recommended Posts

Hey guys

I just setting up my realm for testing but when I create the world database I get some errors. The used Database is "5.x.x Beta DB 1".

 

After that I updated the Database with the updates provided in the "sql/updates" folder. The file "sqlupdatesworld2014_02_03_00_world_creature_template.sql" created some errors and I got this SQL Error:

Query:
ALTER TABLE `character_glyphs`
DROP COLUMN `glyph7`,
DROP COLUMN `glyph8`,
DROP COLUMN `glyph9`

Error occured at:2014-03-04 22:54:20
Line no.:5
Error Code: 1091 - Can't DROP 'glyph7'; check that column/key exists



Query:
ALTER TABLE `character_glyphs`
DROP COLUMN `glyph7`,
DROP COLUMN `glyph8`,
DROP COLUMN `glyph9`

Error occured at:2014-03-04 22:54:27
Line no.:5
Error Code: 1091 - Can't DROP 'glyph7'; check that column/key exists

Did I something wrong or why is this happening?

Link to comment
Share on other sites

Finally found the real error:

2006 MySQL server has gone away

If someone gets this error as well here is a method to fix it:

(for xampp)

Go to xamppmysqlbin

Open my.ini

Change "max_allowed_packet" from "1m" to "16m"

Save my.ini

Now restart MySql through the XAMPP control panel.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.