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.
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
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.
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:
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.
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 ]
|
|
|