[KuraFire]

Originally Posted by CdaKnight

I don't have that column, although now I'm guessing I should... I used the installer... Is it possible to just drop 'hack' and 'hacklog' and run the installer to add them again (I'm assuming I wouldn't need the phrases, etc. again [including the file changes])

What you can do to solve this is this:

1) make sure you have the Hack_Tracking_Log.htl file in your htlfiles/ directory;
2) go to Manage Hacks -> Edit Hack Details for the Hack Tracking Log entry;
3) disable all steps for the Install Routine except Run Queries;
4) Save. Now go to Run Install Sequence (it's in the drop-down Controls menu) for the Hack Tracking Log;
5) Choose to run a Real Install, and click Proceed (or Continue?). You will now only encounter the Run Queries step. It will perform that step, which will clear out your hack and hacklog tables entirely!.
6) You will now have an empty HTL installation, which is baaaaad. So, we fix! Go to install hack, and choose the Hack Tracking Log that is listed there. Choose Import to Db only ! Hit proceed.
7) The HTL will now be imported to your system, but it will not appear as properly installed, but as Imported-only. To fix that, run this query on your database (manually):

UPDATE hack SET atstep=-1 WHERE hackid=1;

add a table prefix in front of "hack" if you have one.

Then your HTL installation should be fully operational again, and have the column changetype.
If not, your .htl file is corrupted somehow, outdated-beyond-all-outdatedness.


Natch: pretty much, yeah...