SELECT 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 (21,47,18,17,46,12,11,10,9,8,7,6,5,4,3,25,24,1,22,50,54,49,27,52,23,51,2,48,53) 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: 1146
Error message: Table 'sawloser_xoop2.xoops_block_instance' doesn't exist
( 0.000439)

RealyRoten wrote:
yes updated them several time all the modules.
Also cleard the caches server times.
Its the blocks with not display in admin or frontend.I try to add them again maually and it dispalys thathttp://www.boneshakerchoppers.co.uk/bsc/error.jp2

Could download some folders from one of my other site and upload em to this site with the fualt,my other site work fine.

SQL query:

CREATE TABLE xoops_block_instance(

instanceid int( 12 ) unsigned NOT NULL AUTO_INCREMENT ,
bid int( 12 ) unsigned NOT NULL default '0',
options text NOT NULL ,
title varchar( 255 ) NOT NULL default '',
side tinyint( 1 ) unsigned NOT NULL default '0',
weight smallint( 5 ) unsigned NOT NULL default '0',
visible tinyint( 1 ) unsigned NOT NULL default '0',
bcachetime int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( instanceid ) ,
KEY JOIN ( instanceid, visible, weight )
) TYPE = MYISAM

All sorted now thanks jdseymour
and is LIVE HELP support over at his site.
http://www.warpigw2.com/index.php
Very excellent system he got in place.
I would highly recommend that every one books mark his site and even subscribe to is Live Support systems.