Upgrading Obliquid from 0.9.1 to 0.9.2

Overwrite all the common files with the new ones. You can do it with ftp, with a file manager or with the shell cp -r obliquid-0.9.2/common/ obliquid-0.9.1/

Copy common/scripts/index.php over the main index.php, copy favicon.ico too if you want.

Execute the following queries -- If your prefix is not sl_, adjust accordingly

ALTER TABLE sl_person CHANGE provincia provincia VARCHAR(32) DEFAULT NULL;

INSERT INTO sl_country (name, code) VALUES ('Guyana', 'GY');

INSERT INTO sl_slot (id_slot, id_module, slot, comment) VALUES (225,'3','addnote','Add or modify a Note entry');

UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 10;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 61;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 56;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 64;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 69;
UPDATE sl_slotfield SET intype = 'PASSWORD' WHERE id_slotfield = 71;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 107;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 112;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 115;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 120;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 157;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 162;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 165;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 170;
UPDATE sl_slotfield SET intype = 'PASSWORD' WHERE id_slotfield = 172;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 211;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 257;
DELETE FROM sl_slotfield WHERE id_slotfield = 258;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 356;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 412;
UPDATE sl_slotfield SET enable = 'Y' WHERE id_slotfield = 606;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 706;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 714;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 719;
UPDATE sl_slotfield SET intype = 'TITLE' WHERE id_slotfield = 726;

UPDATE sl_tabledesc SET length = 32 WHERE id_tabledesc = 318;

Go to developers' tools, select 'Reset table with default data' from the left side menu and choose msg_text table and 'Empty and reload table completely', press OK. If you've customized your email messages, the changed message is doc_appr, both in English and Italian. Beware that also now you enable or disable a message, not a message/language combination as it was happening before. The language sent will depend on the language of the sender (if there is interest, it could be in the language of who receives).

Bid Chief, Bid quality and Statistics roles has been modified, reload them. The change is the addition of the slots prj/phasehours and prj/hourconf

Lastly, go to developers' tools, choose 'Load PO translation files' on the left menu and press OK to reload traslations