1
Ventrix
problem in blocks after updating
  • 2005/12/11 13:30

  • Ventrix

  • Just popping in

  • Posts: 58

  • Since: 2004/8/31


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)
Resized Image

http://ventrix.nsdc.gr

2
Ventrix
Re: problem in blocks after updating
  • 2005/12/12 0:30

  • Ventrix

  • Just popping in

  • Posts: 58

  • Since: 2004/8/31


hello?!
Resized Image

http://ventrix.nsdc.gr

3
Ventrix
Re: problem in blocks after updating
  • 2005/12/13 13:15

  • Ventrix

  • Just popping in

  • Posts: 58

  • Since: 2004/8/31


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 (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.072622)

After installing again and updating. Can't do nothing!
Resized Image

http://ventrix.nsdc.gr

4
Ventrix
Re: problem in blocks after updating
  • 2005/12/14 20:26

  • Ventrix

  • Just popping in

  • Posts: 58

  • Since: 2004/8/31


so difficault?
Resized Image

http://ventrix.nsdc.gr

5
peterr
Re: problem in blocks after updating
  • 2006/4/19 23:24

  • peterr

  • Just can't stay away

  • Posts: 518

  • Since: 2004/8/5 9


In the XOOPS table "xoops_block_instance", there is no column named "instanceid"
NO to the Microsoft Office format as an ISO standard.
Sign the petition

Login

Who's Online

281 user(s) are online (166 user(s) are browsing Support Forums)


Members: 0


Guests: 281


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits