Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

SOLVED CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

Reply to topic

 

xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Thu 21 May, 2009 16:10
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 :)

Profile PM  
DWho
Quote
Posts: 1307 Location: hampshire
Thu 21 May, 2009 19:31
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

:mrgreen: :mrgreen:

Profile PM   Website MSN
xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Thu 21 May, 2009 21:13
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 ]

Profile PM  
DWho
Quote
Posts: 1307 Location: hampshire
Thu 21 May, 2009 21:58
Subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
hmmm strange kinda stump at the moment...

Profile PM   Website MSN
Limun
Quote
Posts: 1334 Location: [Censor]
Thu 21 May, 2009 22:13
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: [Download] [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'

Profile PM   Website
xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Thu 21 May, 2009 22:26
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 ]

Profile PM  
Limun
Quote
Posts: 1334 Location: [Censor]
Thu 21 May, 2009 22:39
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

Profile PM   Website
DWho
Quote
Posts: 1307 Location: hampshire
Thu 21 May, 2009 22:53
Subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
nice one thanks Limun..

:mrgreen: :mrgreen:

Profile PM   Website MSN
xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Thu 21 May, 2009 23:47
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 ]

Profile PM  
Limun
Quote
Posts: 1334 Location: [Censor]
Thu 21 May, 2009 23:55
Subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
i dont understand , did you solved ?

Profile PM   Website
xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Fri 22 May, 2009 00:13
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,

Profile PM  
Limun
Quote
Posts: 1334 Location: [Censor]
Fri 22 May, 2009 00:17
Subject: Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
can i see your cms_blocks table

this one

ooo

Profile PM   Website
xmenfile
Quote
Posts: 482 Location: Right in front of my computer
Fri 22 May, 2009 07:51
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"

Profile PM  
Reply to topic
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.1052s (PHP: 19% SQL: 81%)
SQL queries: 10 - Debug Off - GZIP Enabled