[Ascent] Database Problem

[ipwn23]

I recently made my own server and all was well...HOWEVER, I cannot create a character because 'guild_data' was missing out of my DB. Well, I found something on the internet that looks like this

CREATE TABLE `guild_data` (
`guildid` int(30) NOT NULL,
`playerid` int(30) NOT NULL,
`guildRank` int(30) NOT NULL,
`publicNote` varchar(300) NOT NULL,
`officerNote` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Now an error happens that says

"column count does not match value count at row 1"

I have no Idea as to what is causing this but if it had anything to do with the addition i made to my DB I dont know how to fix it so please post a reply! :]

p.s.[how I added the 'guild_data' to the char DB was I found the abouve code and got a Sql file, copied it and deleted everything in the copy to replace it with the code I found. Then I went to SQLyog and added the new sql file to my character DB]

[MentaL]

[Shadei]

Reinstall your NCDB(if that's what you're using) with the newest revision. Make sure you run the sql updates! That should fix this problem.

[oneybm]

I'm having the same issue and have tried all that has been suggested. Currently the below error is what I get when attempting to import any of the needed sql updates.

Error occured at:2007-12-11 22:20:11
Line no.:1
Error Code: 1060 - Duplicate column name 'custom_faction'

If I'm doing anything wrong I'll gladly accept the criticism as long as ithelps.

Oneybm

[Shadei]

I'm having the same issue and have tried all that has been suggested. Currently the below error is what I get when attempting to import any of the needed sql updates.

Error occured at:2007-12-11 22:20:11
Line no.:1
Error Code: 1060 - Duplicate column name 'custom_faction'

If I'm doing anything wrong I'll gladly accept the criticism as long as ithelps.

Oneybm

That means those specific updates were already implemented. The only time I had this problem was when I upgraded to ascent 2527 and the sql updates fixed it for me. If you can't find a way you may need to downgrade below Revision 2527. Make sure you are using the newest Sql Updates also

[Paco44]

I have never encountered this error, but it should be mentioned in a SQL Query.

[iNs@nE]

http://forum.ragezone.com/f114/ascen...roblem-334812/

Discussed a method to get rid of this problem in that thread. Take a look. Else just use a different set of files. Simple.

[Vuldan]

use the (2521)_character_guilds.sql and (2525)_character_fix_account_data.sql updates (found on your SQL Updates Folder).

worked for me

[oneybm]

I updated to 2539 and that has gone away but now I have a whole new problem that I'm working on. *sigh* This time if a char is played and the acct logged out all of the inventory items are missing upon next login.

[Recklezz]

lol this is really getting anoyingxD. i updated it, with Characterguild.sql(2521). and now i cant even connect to the game xD. whilst i could this afternoon xD?

[computerhelper]

you happen to be an admin in any other servers