Rev 666

[trevius]

Many rules have been removed, so you can remove them from your rule_values table if you wish. But, those rule errors don't matter. What does matter is this error:

#1054: Unknown column 'augslot1visible' in 'field list'

It looks like you missed an SQL update from way back when the aug unknown was changed to the new augslot1visible field name.

See if this SQL helps:
/utils/sql/svn/292_augslots.sql

[Dodie]

I tried that one and it sais ERROR Check that column/key exists



and unknown column ' bla bla ' in items

[trevius]

If you sourced in items-0.6.0-DR2-0.6.1-DR1-convert.sql while trying to fix your other issues, that is probably the cause of your current problems. You need to revert back to before you sourced that in if possible.

[Dodie]

Ah, I probably did that. Hmm, I don't really have anything done on the DB, could I just reinstall in some quick way?



Thanks for assisting.

[trevius]

You should just need to download the latest PEQ DB update from their SVN and source it all in again to overwrite everything else you have in there now. Then, you will probably still need to run any SQL updates that came since the last PEQ DB version if it doesn't currently include the Heroic Resists and maybe some other stuff.

[Dodie]

Ok, i will try that.


Thanks

[cavedude]

No, I update the binaries with the DB so it is up to date. In the future, I also do not recommend manually updating the DB. Just wait for me to update it for you. Crossing the SVN update and the PEQ updates can sometimes create incompatibilities.

[WillowyLady]

Sounds a good idea CD!

May I thank you guys for the effort you put in to guiding techophobes like me.

You really put so called "professionals" to deep shame!

*sprinkles angel dust* ack, was bloody caltrops again~

[Dodie]

Ok ill just wait then!

[trevius]

Dodie, you don't have to wait, because the newest binaries are from R669 which means that since the PEQ DB matches that, you will be able to run as soon as you update to the latest PEQ DB release and resource everything.

Also, I wanted to mention that I am in the process of also adding 3 new tables for handling SoF AAs, so now that you guys are finally getting everything added for the items stuff and running again, you will be doing it all again soon for SoF AAs :P Seriously though, the new AA tables shouldn't be nearly as much trouble as the item table stuff though, so don't worry too much about it.

I think the addition of the items table changes as well as the upcoming SoF AA tables will mostly finalize the new table updates that will be required to finish off SoF. At least until new features available in SoF are coded in at all. Once the SoF AA tables go in, we should just need to code in the new item stats and then fill in the SoF AA tables to what they should be and SoF will be pretty-much caught up with Titanium. There will still be a couple minor issues here and there, but IMO, the AA issue is the biggest difference between the clients.

[Dodie]

Ahh, I just resourced everything and it works



Thanks for help.