I got it thanks to this thread:
http://www.eqemulator.org/forums/sho...d.php?p=194732
Here's what I did:
- In the folder I unzipped "EQEmu-Rev1741-Bots" there is a folder called "sql_updates"
- The first file in there is 1711_account_restricted_aa.sql which did not run correctly as I previously noted.
- I commented out the first line which was the culprit so the rest of the script could run, which adds the missing column in the account table so that accounts can be created.
Viola everything works. Thanks Huppy (in the other thread) for the info.