SUNNY Here:
I tried several things. The good news is the Syndication is fixed.
The bad news is I couldnt upgrade as mentioned.
--------------------------
I got the autotags error Dirk was expecting in media gallery. (thats after i reinstalled media gallery)
Tue 04 Mar 2008 02:58:46 IST - 1054: Unknown column 'allow_autotags' in 'field list'. SQL in question: REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled,allow_autotags) VALUES (4,'polls_block','Poll','','phpblock','20','','all','','0000-00-00 00:00:00','0','phpblock_polls',1,2,1,3,3,2,2,1,0)
-----------------------------
I tried loading an older database version. The site went down with an AQL error. A database upgrade failed with an error 1060: duplicate..... (some entries)
------------------------------
So i loaded the current database again. Now i can shift the blocks up and down by editing the values in the database, but the admin panel on the site gives an SQL error whenever i try to edit a block. But the major concern of Syndication was resolved by creating a new group (in Groups Admin) which gave SpamX admin access to syndication edit and all the other fields ...
--------------------------------
I take this as a temporary solution. Atleast for the visitors the site is more or less error free. But my worries are far from over.
Can someone advise, if it would be a good idea to wait for Geeklog 1.4.2 and upgrade the database then? any more suggestion?
Thx