Icy Phoenix :: View topic - CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

xmenfile [ Thu 21 May, 2009 16:10 ]
Post subject: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

Hi,

I need some help to upgrade my CMS block table. I upgrade my site to new RC2 1.2.24.51 version and my CMS block table not upgrade correctly.

Spoiler: [ Show ]

Thank you and have a great day

DWho [ Thu 21 May, 2009 19:31 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

run the upgrade script again... mine did that some of the tables did not upgrade the first time...

let me know

xmenfile [ Thu 21 May, 2009 21:13 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

I re-ran database_update script but did not give any option beside these info and not clickable or process.

Spoiler: [ Show ]

DWho [ Thu 21 May, 2009 21:58 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

hmmm strange kinda stump at the moment...

Limun [ Thu 21 May, 2009 22:13 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

i think i know the reason
did you haved in past CMS ADV instaled ?

check this and tell me
in table cms_blocks do you have column border and titlebar or border_explain and titlebar_explain ?

EDIT :if yes try this

Code: [Hide] [Select]

ALTER TABLE `ip_cms_blocks` CHANGE `border_explain` `border` TINYINT( 1 ) NOT NULL DEFAULT '1'

ALTER TABLE `ip_cms_blocks` CHANGE `titlebar_explain` `titlebar` TINYINT( 1 ) NOT NULL DEFAULT '1'

xmenfile [ Thu 21 May, 2009 22:26 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

You're absolutely right, I had CMS advance before.

Spoiler: [ Show ]

Limun [ Thu 21 May, 2009 22:39 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

than try that from my post above ...i think it will help

if not change it manualy in phpmyadmin

DWho [ Thu 21 May, 2009 22:53 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

nice one thanks Limun..

xmenfile [ Thu 21 May, 2009 23:47 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

Thank you Linum. I changed it manually and come up with different error message:

Spoiler: [ Show ]

fyi: Just in case someone don't want to change it mannual.

Spoiler: [ Show ]

Limun [ Thu 21 May, 2009 23:55 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

i dont understand , did you solved ?

xmenfile [ Fri 22 May, 2009 00:13 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

sorry

i have't solved it yet. After changed the table that way you suggested, I have differrent error message (in last post). By any chance, do you have any other suggestion?

Thank you in advance,

Limun [ Fri 22 May, 2009 00:17 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

can i see your cms_blocks table

this one

xmenfile [ Fri 22 May, 2009 07:51 ]
Post subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

That's fixed it.

Thank you again

for those who have same problem, i did the following:

- add "block_bbcode_uid" field
- change "border_explain" to "border" and "titlebar_explain" to "titlebar" and make default "1"

Icy Phoenix

Old Support Topics - CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51