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

02/08/2011 06:34 RumorUS#1
[Only registered and activated users can see links. Click Here To Register...]

Thanks for help
02/08/2011 06:41 Garuga#2
try to repair the table with the navicat function!
02/08/2011 08:15 RumorUS#3
[Only registered and activated users can see links. Click Here To Register...]

I'm using these files:
[Only registered and activated users can see links. Click Here To Register...]


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.
02/08/2011 10:41 RumorUS#4
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.
02/08/2011 10:49 Napaver#5
take another Database, would be the easiest way^^
02/08/2011 11:04 RumorUS#6
Quote:
Originally Posted by Napaver View Post
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
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...] (9030, 7230, 8090, 8080, 9010, 8040)

and...

02/08/2011 11:25 Napaver#7
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.
02/08/2011 11:52 RumorUS#8
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.
02/08/2011 17:04 RumorUS#9
I figured out on my own how to fix kay331's files.

you must do this:

Code:
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.
02/08/2011 17:22 Napaver#10
Code:
 chmod -R 777 /var/db/mysql
would have been easier^^
02/08/2011 18:51 RumorUS#11
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?