SQL problem (gold_expire, autoloot_expire, etc...)

[RumorUS]

Thanks for help

[Garuga]

try to repair the table with the navicat function!

[RumorUS]

I'm using these files:



And now when I try to access the account table it says it is marked as crashed and the last extended repair failed. To fix that I ran a quick repair. This allowed me to open the table but I still can't design that table.

[RumorUS]

I changed an npc name in mob_proto@player and the server would not start. I backed up what I needed and now I can't dump my sql files into the database because it won't allow me to delete the old databases.

[Napaver]

take another Database, would be the easiest way^^

[RumorUS]

Originally Posted by Napaver

take another Database, would be the easiest way^^

I have another database I can add with tar -xvf, (2010 us db), but then the server won't start. I also tried a friend's database (soulboundmt2) and the server also won't start.. :@

Look, this is all I want:

English item_proto
item_attr from Z8Games
lv 120 or 127 Game File

(9030, 7230, 8090, 8080, 9010, 8040)

and...

[Napaver]

u got a 2010er DB, but in the Server the Database is from 2007/2008 afaik.
So the Server cant start, because your Files cant handle the DB.

[RumorUS]

mmmh ok, so I need to get some 2010 files but I want level 127 max or 120.. 125... not 250, 254, 255. Is that possible to do ^^?

And can you please suggest me some 2010 files? pm me the link if you can.

[RumorUS]

I figured out on my own how to fix kay331's files.

you must do this:

chmod 777 /var/db/mysql/account/
chmod 777 /var/db/mysql/common/
chmod 777 /var/db/mysql/player/

And so on.. to which ever database table you have issues with.

[Napaver]

 chmod -R 777 /var/db/mysql

would have been easier^^

[RumorUS]

oh yeah haven't done this in a while, thx..
but I still would like some new files because I have so much trouble with these ones, whenever I change names of items in item_proto. Do you know any good 2010 files?