Icy Phoenix

Old Support Topics - CMS GLOBAL BLOCKS LINKS ERROR

redrumm101 [ Sat 01 Aug, 2009 03:49 ]
Post subject: 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 ]
Post subject: Re: CMS GLOBAL BLOCKS LINKS ERROR

Question

Did you empty your cache folders ???

Limun [ Sat 01 Aug, 2009 16:00 ]
Post subject: 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

if yes 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 ]
Post subject: 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

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