I've got two issues at the moment.

Error Description: Uploading the wowroster.lua parses in 0.03 seconds, the roster then still insists that the guild needs to be loaded and will not display any members.
Page: index.php?p=update&a=g:1
Error Info: No errors are listed, the parsing information is listed below
Other: The guild and character upload rules have been set to match the release guild website, I have tried the upload from the control panel and uniuploader. I did check the _guild table and have noticed an entry has been created for Guildless-A. I did try changing this manually to the name of the guild and this stopped the roster from asking me to upload the guild, but will still not show a member list.

Parse information:
Parsing files

Parsed wowroster in 0.03 seconds


Processing Files
Updating Character Data for [Tomofinland@EU-Arathor]

About to update player
Updating Equipment ..................
No Inventory Data
Updating Bank : Bag5 : Bag4 : Bag0 : Bag1 : Bag2 : Bag7 : Bag3 : Bag6
No New Mail
Updating Skills .....
Updating Professions : Cooking : First Aid : Alchemy
Updating Spellbook : Beast Mastery : General : Survival : Marksmanship : All - Guild Perks
Updating Glyphs .........
Updating Talents : 0-Marksmanship : 0-Beast Mastery : 0-Survival
Updating Reputation ..................................................................
Updating Currency ........
Updating Quests: 3
Updating Buffs: 3
No Companions

Error Description: When trying to register another user the system crashes.
Page: ?p=user-user-chars&a=g:1
Error Info:
There was a DB error while creating your user.
MySQL Said

1048: Column 'fname' cannot be null

Array
(
[username] => Expectations
[rank] =>
[email] => rayven@blueyonder.co.uk
[password1] => gh0stwh33l
[password2] => gh0stwh33l
[op] => register
[active] => 1
[submit] => Register
)

Other: The Check Me button is picking up the class and level of the character, but not the guild rank.

Note that all this has been done from a clean install of the roster and database from the latest files.

make sure you have set the access levels you what for uploading data in Main Settings -> Upload Access for guild and character..
And that you have configured Upload Rules the character name in here needs to match exactly what is shown in game for guild name

Code: Select all

 Column 'fname' cannot be null


this is a result of the table having a not null setting for this value i will update this asap.
in the mean time you can do this in php myadmin..

Code: Select all

ALTER TABLE `roster_user_members`
CHANGE `pass` `pass` varchar(32) NOT NULL DEFAULT '',
         CHANGE `email` `email` varchar(255) DEFAULT NULL,
         CHANGE `regIP` `regIP` varchar(15) DEFAULT NULL,
         CHANGE `access` `access` varchar(25) DEFAULT NULL,
         CHANGE `fname` `fname` varchar(30) DEFAULT NULL,
         CHANGE `lname` `lname` varchar(30) DEFAULT NULL,
         CHANGE `age` `age` varchar(32) DEFAULT NULL,
         CHANGE `city` `city` varchar(32) DEFAULT NULL,
         CHANGE `state` `state` varchar(32) DEFAULT NULL,
         CHANGE `country` `country` varchar(32) DEFAULT NULL,
         CHANGE `zone` `zone` varchar(32) DEFAULT NULL,
         CHANGE `homepage` `homepage` varchar(64) DEFAULT NULL,
         CHANGE `other_guilds` `other_guilds` varchar(64) DEFAULT NULL,
         CHANGE `why` `why` varchar(64) DEFAULT NULL,
         CHANGE `about` `about` varchar(64) DEFAULT NULL,
         CHANGE `notes` `notes` varchar(64) DEFAULT NULL,
         CHANGE `last_login` `last_login` varchar(64) DEFAULT NULL,
         CHANGE `date_joined` `date_joined` varchar(64) DEFAULT NULL;


make sure you change roster_ to what you used as a pre fix in your database

Thanks for the info.

I'll reset the roster and check the upload rules and settings again. I'll make the changes to the database structure at the same time.

I know I have set the "allowed" guild and character upload rules correctly, they work fine on the current guild site. I even copied and pasted the guild name from the wowroster.lua file just in case I got the spelling and/or case wrong, but I'll go back and check in a bit and let you know what is happening.

Took some getting my head around, but I'm a lot closer than before.
Took me a while to spot that the guild name had one character wrong in that it had an upper case letter instead of a lower case.
I've updated most of the settings and now have access to the guild members list and the APIsync (which is moaning about authorisation at the moment, so i'm going to give it a rest).

I'm still having some issues, so i'll spend some time with it, compile a full list and pop it on here when I'm done if that's okay.

Thanks for the assistance so far