COMPLETE PUBLIC SERVER SETUP - Jan-2011

[Aeryn]

You already have a URL associated with that folder

To check or change it
go into the tortoise options and choose "Relocate"
that will show the url currently associated with the folder, change it there if it's wrong

[Lazzeraith]

Did that and got a TortoiseSVN error box.

The repository at 'http://projecteqquests.googlecode.com/svn/trunk/quests' has uuid '858f6fc0-2484-11de-a087-198e6c7179d9', but the WC has 1db01234-8a6e-11dd-8937-b3a0fbe'

[Lazzeraith]

Also when I opened the relocate option it had this URL http://projecteqemu.googlecode.com/s...efaults/quests, I replaced it with the one from the guide http://projecteqquests.googlecode.com/svn/trunk/quests and got the error from the above post. Is it possible to manually download these files and put them in the folder or is there a needed purpose for using SVN?

[Lazzeraith]

Ok I cheated, made same named folders on different drive pasted links then copied them to server directory.

[Lazzeraith]

You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

Hello,

I am using rev_2022.sql, when I did the above set I get the following error.


[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Err] 1060 - Duplicate column name 'time_creation'
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
-------------------------------------------------

Also in using rev_2022, this means I will have execute all the files higher than 1711 ?