[OUTDATED] Ginnungagap DB - 1.2

[PlanarChaosRvrtwo]

We set up the next step here not fully done couse we work currently as duo on the basics to solve the very outdated 1.87 db/code but we gonna fix it dirty on cl skills and appeal the code issues in order to have an smooth fix in order with dol (couse we dont want run away from dol). But in order of that we gonna charge through alot of code/db crap and everyone who want help push dol forward is welcome:


http://www.dolserver.net/viewtopic.php?f=70&t=23113

[tranksen76]

hello everyone,

I am very new to DAoC ome servers and I apologize if my following question is dumb bit i could not find a solution in this forum or in google.

I am trying to import the below SQL file in a brand new data base with UniServer Zero XIII but i am getting a nasty error.
http://sourceforge.net/projects/ginnungagap-dol-db

the error I am getting is:
Error
Static analysis:
1 errors were found during analysis.
Missing expression. (near "ON" at position 25)
SQL query: Edit Edit
SET FOREIGN_KEY_CHECKS = ON;
MySQL said: Documentation
#2006 - MySQL server has gone away

The box below starst with:
Warning in .\libraries\dbi\DBIMysqli.php#262
mysqli_query(): MySQL server has gone away

Backtrace
.\libraries\dbi\DBIMysqli.php#262: mysqli_query(

I have no problem with:
dolpubdb_alpha_V3.1
dolpubdbV3.0

Any idea would be most welcome.
Many thanks
Tranksen

[ontheDOL]

i recently had issue trying to import this DB. This is how i fixed it.

close Uniserver
Goto uniserver directory /core/mysql
double click my.ini
scroll down until you find

Code: Select all

[mysqldump] quick max_allowed_packet = 100M

yours will say max_allowed_packet = 16M , change it to 100M like above ( NOTE: max_allowed_packet appears several times in this file! change the value under the heading [mysqldump] ), save file
now double click the folder "bin"
copy the database sql file to here. Rename the file to something easy to type, like "gin.sql"

Load uniserver, click "start mysql"
connect to mysql inside you database manager (heidiSQL or whatever you use), create a new database called "dol"

now go back to Uniserver, click "mysql console"
type : use dol
it should say "database changed"
now type : source gin.sql;
hit enter and it should start importing all the data

let me know if this works

[tranksen76]

Hi ontheDOL,

I changed the my.ini file exactly as you recommended but that failed again with the same error.
I paste below the content of the INI file.

I did not have any problem with dolpubdb_alpha_V3.1.sql which is 70.4 Mb. No problem either with dolpubdbV3.0.sql which is 51.8 Mb.

With the gin.sql file the import still crashes and the last item I can see it has imported is the "craftedxitem" branch.

#######################################################################
# File name: my.ini
# Created By: The Uniform Server Development Team
# Edited Last By: Mike Gleaves (ric)
# V 1.0 24-7-2016
########################################################################

[mysql]
default-character-set=utf8

# SERVER SECTION The following options will be read by the MySQL Server.
[mysqld]
#Do not delete next line. Used for setting port when run as service
#{service_port}
bind-address=127.0.0.1
# server-id = 1 Comment Prevents error Cannot open table mysql/slave_master_info
server-id = 0
pid-file=mysql.pid
explicit_defaults_for_timestamp
#default-storage-engine=MYISAM


skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

character-set-server=utf8

# federated
skip-federated


# Uncomment the following if you are using InnoDB tables
innodb_file_per_table = 1
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 32M
innodb_log_file_size = 8M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


[mysqldump]
quick
max_allowed_packet = 100M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

------------------------------
Thank you very much again for your help.
Tranksen

[tranksen76]

Hi again,

the error in the console is:
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'

This is way beyond me
regards
Tranksen

[ontheDOL]

i am not good with MySQl either
all i saw was "mysqli_query(): MySQL server has gone away" which is common error with larger files and small packet memory

last thing i can suggest is
inside MYSQL console type:
set global max_allowed_packet=524288000;
use dol;
source gin.sql;


if that doesnt work ... then someone with better sql knowledge will need to help

[tranksen76]

Hi ontheDOL,

Many thanks again for helping me.

Unfortunately that did not work either but still i appreciate your taking the time to try and help.
Really cool of you

Take care.

[ontheDOL]

set global max_allowed_packet=1073741824;
press enter, should say something like "Query OK, 0 rows affected (0.00 sec)"
if nothing shows, then command didnt work( you need to include the ; at end of command)

[tranksen76]

Hi again,

I forgot the ; on my very first attempt earlier but had nothing going on so I realized i had to include the ;

I tried again with a bigger value:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global max_allowed_packet=1073741824;
Query OK, 0 rows affected (0.00 sec)

mysql> use dol;
Database changed
mysql> source gin.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
processes data for a little while and then :

Query OK, 3 rows affected (0.01 sec)
Rows matched: 3 Changed: 3 Warnings: 0

ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'
mysql>

I guess I will have to use another DB

Thanks again for your time and effort.

Regards
Tranksen.

[Graveen]

Please install MariaDB, and use HeidiSQL for import.

Error you are listing is a matter of version.

[tranksen76]

Hi Graveen and ontheDOL,

that worked smoothly with MariaDb and HeidiSQL.
Many thanks to both of you for your help.

It looks like I am going to spend a few hours having fun. How can i thank the community or support it? I cannot code or run databases.
Can i make a (small) donation ? To whom ?

Take care
Tranksen

[ontheDOL]

Glad you go it fixed. I cant comment on the donation part, that would be Graveen's department. Just enjoy and have fun! You never know, you might be able to contribute some code or database sometime in future

[HunabKu]

Hi,
this error are not related max_allowed_packet but max_allowed_packet seems t be changed like 200M.
This errors are database type related.
Nice to see your fixed with MariaDB.

[Graveen]

You can donate Project->Donate, but rather buy yourself a DOL mug on Zazzle Project->Merchandise https://www.zazzle.com/dolserver

Donations are expected to:
- host Storm game server
- hire domain
- host website/forum
- renew DAoC account we own for tests

But with help we have not need of them, so many thanks to:
- Tolakram for Storm hosting
- Sourceforge for website
- Graveen for domain renew
- legacy money for periodic DAoC renew (used by dol devs to record datas.... feel free to ask ^^)

bah, i have very small use of donation (roughly less than 5USD per year).

[Sumy]

Some minor Bugs I've found:

Minstrels are missing Instru skill.
Prevent Flight has an Icon, it should not.

Also there is a warning because shields have no ability value for level 0.