Hi !
Can't find info how to upgrade mysql database from 2.x to 3.x .
Can this be done ?
How ?
/GB
Upgrading database from 2.x to 3.x possible?
Moderator: Forum Moderator
-
ghostbuster
- Peon
- Posts: 6
- Joined: Wed Aug 31, 2005 6:53 am
- Location: Sweden
- Contact:
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
Re: Upgrading database from 2.x to 3.x possible?
It is built in to the plugin
No support via PM or Email
-
ghostbuster
- Peon
- Posts: 6
- Joined: Wed Aug 31, 2005 6:53 am
- Location: Sweden
- Contact:
Re: Upgrading database from 2.x to 3.x possible?
Hi !
Found out what was going wrong.
1. Had to add plaierip varchar(30) to old table !
2. Modified upgrade script
changed
"INSERT INTO wc3_player select '', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",
to
"INSERT INTO wc3_player select '0', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",
in "db_mysqlx.inl" and compiled war3ft again. Then it worked
/GB
Found out what was going wrong.
1. Had to add plaierip varchar(30) to old table !
2. Modified upgrade script
changed
"INSERT INTO wc3_player select '', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",
to
"INSERT INTO wc3_player select '0', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",
in "db_mysqlx.inl" and compiled war3ft again. Then it worked
/GB
