Quote:
|
Last time I did this I did that AC fix talked about at pqe that I talked about above, but it still didn't work. For right now I have done nothing but source in the above database. Of course I did the create database eq2; and use eq2; before sourceing.
|
That didn't work b/c the AC fix inserts a missing AC column in the npc_types table. Your problem is a missing charges column in the items db. I think you ought to brush up on some SQL. You'll need it to make any real db tweaks unless you like grinding along with EQAdmin.
Why don't you try manually inserting that column into the db, and giving it a default value of 0? That should at least let you get your server up and running and let you begin to play, even though items with charges won't be accurate.
I recommend you get govtcheez's loots update after you add that column, and source it. Then you'll have accurate charges for items that have charges.
I also think this 'one error' you keep getting when sourcing files is that you are missing the column, and the .sql file just assumes it's there. You have to know that .sql files are nothing more than a batch of SQL commands to run.