SOLVED CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

The time now is Tue 16 Apr, 2024 06:53 • All times are UTC + 1 Hour [DST enabled]

SOLVED CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

Article
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 ] Spoiler: [ Hide ] Could not insert data into blocks table DEBUG MODE SQL Error : 1054 Unknown column 'border' in 'field list' UPDATE phpbb_cms_blocks SET title = 'Fujitsu', bposition = 'c', active = '1', type = '0', content = '', blockfile = 'blocks_imp_recent_topics', layout = '1', layout_special = '0', view = '', border = '0', titlebar = '0', local = '0', background = '0', groups = '' WHERE bid = 28 Line : 704 File : cms.php Thank you and have a great day
xmenfile [ Thu 21 May, 2009 16:10 ]

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

SOLVED CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51

Comments
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
DWho [ Thu 21 May, 2009 19:31 ]

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 ] Spoiler: [ Hide ] Installed phpBB version :: 2.0.23 » Latest release :: 2.0.23 Installed Icy Phoenix version :: 1.2.24.51 » Latest release :: 1.2.24.51 Database Type :: mysql4 File Writing :: Your server seems to support files creation and editing. Files & Folders Permissions: Spoiler: [ Show ] Spoiler: [ Hide ] CHMOD 777 ../backup ../cache ../cache/forums ../cache/posts ../cache/sql ../cache/topics ../cache/users ../ctracker/logfiles/logfile_attempt_counter.txt ../ctracker/logfiles/logfile_blocklist.txt ../ctracker/logfiles/logfile_debug_mode.txt ../ctracker/logfiles/logfile_malformed_logins.txt ../ctracker/logfiles/logfile_spammer.txt ../ctracker/logfiles/logfile_worms.txt ../downloads ../files ../files/album ../files/album/cache ../files/album/med_cache ../files/album/users ../files/album/wm_cache ../files/posted_images ../files/screenshots ../files/thumbs ../images/avatars ../logs
xmenfile [ Thu 21 May, 2009 21:13 ]

Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
hmmm strange kinda stump at the moment...
DWho [ Thu 21 May, 2009 21:58 ]

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] Code: [Download] [Show] 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'
Limun [ Thu 21 May, 2009 22:13 ]

Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
You're absolutely right, I had CMS advance before. Spoiler: [ Show ] Spoiler: [ Hide ] Field Type Collation Attributes Null Default Extra Action bid int(10) No auto_increment layout int(10) No 0 layout_special int(10) No 0 title varchar(60) latin1_swedish_ci No content text latin1_swedish_ci No bposition char(2) latin1_swedish_ci No weight int(10) No 1 active tinyint(1) No 1 blockfile varchar(255) latin1_swedish_ci No view tinyint(1) No 0 type tinyint(1) No 1 border_explain tinytext latin1_swedish_ci No titlebar_explain tinytext latin1_swedish_ci No background tinyint(1) No 1 local tinyint(1) No 0 edit_auth tinyint(1) No 5 groups
xmenfile [ Thu 21 May, 2009 22:26 ]

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
Limun [ Thu 21 May, 2009 22:39 ]

Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
nice one thanks Limun..
DWho [ Thu 21 May, 2009 22:53 ]

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 ] Spoiler: [ Hide ] Could not insert data into blocks table DEBUG MODE SQL Error : 1054 Unknown column 'border' in 'field list' INSERT INTO phpbb_cms_blocks (bid, title, content, bposition, weight, active, type, blockfile, view, layout, layout_special, border, titlebar, background, local, groups) VALUES ('36', 'Welcome', '', 'c', '1', '1', '0', 'blocks_imp_recent_topics_wide', '', '1', '0', '0', '0', '0', '0', '') Line : 798 File : cms.php FYI: Just in case someone don't want to change it mannual. Spoiler: [ Show ] Spoiler: [ Hide ] ALTER TABLE `ip_cms_blocks` CHANGE `border_explain` `border_explain` TINYINT NOT NULL DEFAULT '1' ALTER TABLE `ip_cms_blocks` CHANGE `titlebar_explain` `titlebar_explain` TINYINT NOT NULL DEFAULT '1'
xmenfile [ Thu 21 May, 2009 23:47 ]

Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
i dont understand , did you solved ?
Limun [ Thu 21 May, 2009 23:55 ]

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,
xmenfile [ Fri 22 May, 2009 00:13 ]

Re: CMS Table Not Upgrade After Upgrade To RC2 1.2.24.51
can i see your cms_blocks table this one
Limun [ Fri 22 May, 2009 00:17 ]

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"
xmenfile [ Fri 22 May, 2009 07:51 ]

Display posts from previous: