https://www.icyphoenix.com/viewtopic.php?f=1&t=7214&p=51295#p51295
-----------------------------------
spydie
Sun 23 Jan, 2011 11:51

Re: Icy Phoenix 1.3.11.64
-----------------------------------
Error in update to 255.

looks like theres something missing in update script, or not getting executed well.

i get this after update:
[spoiler]SQL ERROR [ mysql4 ]

Unknown column 'b.bs_id' in 'where clause' [1054]

SQL

SELECT b.*, s.* FROM ip_cms_blocks AS b, ip_cms_block_settings AS s WHERE b.layout = 0 AND b.active = 1 AND b.block_cms_id = '0' AND s.view IN (0, 1) AND b.bposition IN ('gh','gf','gt','gb','gl','gr','hh','hl','hc','fc','fr','ff') AND b.bs_id = s.bs_id ORDER BY b.bposition ASC, b.layout ASC, b.layout_special ASC, b.weight ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 289
CALL: sql_db->sql_error()

FILE: includes/class_cache_extends.php
LINE: 111
CALL: sql_db->sql_query()

FILE: includes/new_page_common.php
LINE: 33
CALL: ip_cache->obtain_cms_global_blocks_config()

FILE: index.php
LINE: 17
CALL: include('includes/new_page_common.php')
[/spoiler]

I fixed this, changing the name of column IP_BLOCKS - BLOCKS_SETTINGS_ID to BS_ID direktly in the database


@MG: Your missing to rename this table in update script


