[Ascent]Character problem

[Juhoman]

Alright, I've got my server running as well, and database is just great..
but I have one problem...

When I login, character is naked.
No items.
If I add an item, .save and .saveall and all kind of saves, no dice.
It will disappear within logon.

Here is a screenshot what is happening on my Ascent.

It gives some player_item error.
I think it is about playeritems- table.
but I am not sure.
I don't either know how to fix, I've tried alot of other repacks, ascents, databases, dbc:s, and all.
Always.
Same problem.
I've also ran all possible SQL Updates, I think.
I've tried googling with every different word which with I could find, no.

Is this about My computer, or my database?

 

[vozisce]

Something is wrong with your database, in your character database, the playeritems, does not match what Ascent expected. The amount of Colums is wrong to be specific

What Revs. do you use?

 

[Juhoman]

Ascent, 3,5 stable.
I tried the newest ones somewhen.
same problem.
So, please, tell me how can I fix my playeritems- database. ;<

EDIT: Solved
If anybody with the same problem is browsing this topic. I want to help em.
Okay, here is it.
When you have SQLYog on, you click your main connection, then to Playeritems
open it, and then, search for 'columns' inside it.
Right click, press "manage columns"
You should see Empty column on there. Remove it.

It should work by then.
Atleast worked for me ^_^

 

[nanouniko]

hi, please, can you explain me .. i dont understand good. when i click right in columns i cant look "manage columns". can you help me please, what file i need delete..

 

[Juhoman]

The empty one..
but It keeps popping up ;<
Any ideas?

EDIT: That should fix it.
I don't know how or why, did my items disappear when I made new character.
Also the starting items are not on you.
Any suggestions?

 

[Kameleon20]

use the chardb maybe of my topic? it's correct updated with the newest updates

 

[Juhoman]

use the chardb maybe of my topic? it's correct updated with the newest updates

Well, It's working now `_^
the thing I said above, worked.
It haven't wipe up, but the starting gear does not appear.
Not a problem while running friend sided gm server ^_^

EDIT: It worked a while.
Then It blewt.
Ideas?
I also tried your char db. nope , did not work.
I also updated fully my db.
No, not working.

 

[Juhoman]

Sorry for double posting. But now I fixed it. Even the starting gear appeared (atleast I hope.)
I hope this works for you.
Uninstall every MySQL - Program, not Navicat or SQLYog or such. just MySQL stuff.
Install MySQL 5.0 , as MySQL5 on the configuration.
Re-install your databases.


Test it out, worked for me atleast.
(I don't know if the bug appears again, I posted this almost immediately after I did see some kind of gear on my server.)

 

[rr2739]

Sorry for double posting. But now I fixed it. Even the starting gear appeared (atleast I hope.)
I hope this works for you.
Uninstall every MySQL - Program, not Navicat or SQLYog or such. just MySQL stuff.
Install MySQL 5.0 , as MySQL5 on the configuration.
Re-install your databases.


Test it out, worked for me atleast.
(I don't know if the bug appears again, I posted this almost immediately after I did see some kind of gear on my server.)

the worst solution is to delete your files and reinstall,Why would you do all that>

whern you are simply missing your playercreate_info table. and if it is not missing then simply delete the table and execute new one?

 

[Juhoman]

the worst solution is to delete your files and reinstall,Why would you do all that>

whern you are simply missing your playercreate_info table. and if it is not missing then simply delete the table and execute new one?

'


Well, then it is YOUR database.
since I downloaded that Cosa Nostra thing.
and it works fine, when I re-installed mySQL Program.
Not navicat or sqlyog.

 

[mclarkey08]

Jesus, how annoying when people post these kind of things. Why cant you just try different Rev.s and Database's Check EVERYTHING FIRST then post.