[Ascent] Database Problem

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]

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.

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.

Code:

---

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

Quote:

---

Originally Posted by 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.

Code:

---

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

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

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.

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

worked for me

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.

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?

you happen to be an admin in any other servers