https://www.icyphoenix.com/viewtopic.php?f=35&t=6209
-----------------------------------
redrumm101
Sat 01 Aug, 2009 03:49

CMS GLOBAL BLOCKS LINKS ERROR
-----------------------------------
I am trying update my scrolling links on my site and evertime i hit the submit button i get this error. I upgraded from the previous version of IP 1.2 to 1.3.. After the upgrade everything else seems to be running fine except for this and my drop downs i get the same error. www.cisclan.com

Could not insert data into blocks table

DEBUG MODE

SQL Error : 1054 Unknown column 'border' in 'field list'

UPDATE ip_cms_blocks SET title = 'Links', bposition = 'hl', active = '1', type = '0', content = '', blockfile = 'blocks_imp_links', layout = '0', layout_special = '0', view = '0', border = '0', titlebar = '0', local = '1', background = '1', groups = '' WHERE bid = 45

Line : 704
File : cms.php

If anyone could help it would be greatly appreciated as always. Thank you..


-----------------------------------
spydie
Sat 01 Aug, 2009 12:23

Re: CMS GLOBAL BLOCKS LINKS ERROR
-----------------------------------
Question

Did you empty your cache folders ???


-----------------------------------
Limun
Sat 01 Aug, 2009 16:00

Re: CMS GLOBAL BLOCKS LINKS ERROR
-----------------------------------
i supose you are using new version of icy

so i supose you upgraded from 1.2.0.27 
i also supose that you used "CMS Advanced" instaled on your 1.2.0.27

[b]if yes[/b] try to check if you have this two columns in your database
border_explain
titlebar_explain

and try to rename them to
border
titlebar


-----------------------------------
redrumm101
Sat 01 Aug, 2009 18:20

Re: CMS GLOBAL BLOCKS LINKS ERROR
-----------------------------------
Yes thank you it worked perfectly.

For people out there having the same issue from the upgrade from 1.2 to 1.3. and are unsure where Limun is talking about.

Go to your ip_ database either thru your php admin or other mysql browser.
Back up your database before making any changes :mryellow: 

Go to ip_cms_blocks table and edit these field names
Change the name of border_explain to border
Change the name of titlebar_explain to titlebar 

Worked beautiful thank you Limun


