1
After updating to xoops-2.2.3a-Final, and update the system module, running xoops-hotfix20051030 still cant see any blocks or adding them successfully...
This is the error i get:
ELECT DISTINCT i.instanceid, b.*, i.* FROM xoops_block_instance i, xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (15,25,26,12,3,16,40,37,11,41,32,7,5,2,1,58,57,56,55,54,53,52,51,50,49,48,34,47,14,46,45,44,8,43,42,39,33,13,22,21,20,19,17,10,9,4,59) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND m.module_id=0 AND m.pageid IN (0, 1) ORDER BY i.weight,i.instanceid
Error number: 1054
Error message: Unknown column 'i.instanceid' in 'field list'
( 0.001293)