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)

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

  • Ventrix

  • Just popping in

  • Posts: 58

  • Since: 2004/8/31


hello?!

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!

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?

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

293 user(s) are online (198 user(s) are browsing Support Forums)


Members: 0


Guests: 293


more...

Donat-O-Meter

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

Latest GitHub Commits