Page 1 of 2
Upgrade 1.1-RC4 -> 1.2.6: uncomplete update-sql-file
Posted: Thu 2. Feb 2006, 01:22
by harrybo
Hello,
I upgraded from version 1.1-RC4 27-08-2004 to 1.2.6 and realized that the according update SQL file "07__27-08-2004_to_1.2.6-DEV.sql" seems not to be complete. There's missing the line
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_anchor` INT( 1 ) NOT NULL ;
, that is part of file "13_..." Without adding this field, saving or creating articles is not possible.
Could this be the reason, why after the db-update all my graphics have not been switched properly (hundreds of them - grrrmpf)?
Regards
Harry
Posted: Thu 2. Feb 2006, 04:00
by Pappnase
hello
from where did you download!?
Posted: Thu 2. Feb 2006, 07:01
by DeXXus
Doesn't your database show that field already there?
It's always created *here* in "
phpwcms_init.sql":
CREATE TABLE `phpwcms_articlecontent` (
`acontent_id` int(11) NOT NULL auto_increment,
`acontent_aid` int(11) NOT NULL default '0',
`acontent_uid` int(11) NOT NULL default '0',
`acontent_tstamp` timestamp(14) NOT NULL,
`acontent_title` text NOT NULL,
`acontent_text` text NOT NULL,
`acontent_type` int(10) NOT NULL default '0',
`acontent_sorting` int(11) NOT NULL default '0',
`acontent_image` text NOT NULL,
`acontent_files` text NOT NULL,
`acontent_visible` int(1) NOT NULL default '0',
`acontent_subtitle` text NOT NULL,
`acontent_before` varchar(10) NOT NULL default '',
`acontent_after` varchar(10) NOT NULL default '',
`acontent_top` int(1) NOT NULL default '0',
`acontent_redirect` text NOT NULL,
`acontent_html` text NOT NULL,
`acontent_trash` int(1) NOT NULL default '0',
`acontent_alink` text NOT NULL,
`acontent_media` text NOT NULL,
`acontent_form` mediumtext NOT NULL,
`acontent_newsletter` mediumtext NOT NULL,
`acontent_block` varchar(200) NOT NULL default '0',
`acontent_anchor` int(1) NOT NULL default '0',
PRIMARY KEY (`acontent_id`)
) TYPE=MyISAM;
All it does is this:
Code: Select all
// each content part will get an anchor
if($crow["acontent_anchor"]) {
$CNT_TMP .= '<a name="cpid'.$crow["acontent_id"].'" id="cpid'.$crow["acontent_id"].'" class="cpidClass"></a>';
}
Posted: Thu 2. Feb 2006, 09:03
by harrybo
Hello Pappnase,
I downloaded from the docu page. Does your question mean, the 1.2.6 differs depending from the download location? Arrrrrgh. Anyway, I looked at phpwcms and sourceforge where there's only a 1.2.5. ??!!
@DeXXus: I'm not shure if I understand you right. How could this init query be successful in a given database, where most tables already exist?
Fact is: I exactly followed the advices in the docu, but couldn't save any record afterwards. More than 700 pictures, their sizes and their caption are now lost. Why is the phpwcms update procedure so confusing, whereas the system itself is so clearly arranged?
Regards
Harry
Posted: Thu 2. Feb 2006, 09:13
by pico
Hi
did you also do the 3 Steps at the Top of the upgrade-Script
1) UPGRADE FILESTORAGE (all files will be moved and renamed)
2) UPGRADE ARTICLE CONTENT IMAGE (copy and paste using phpMyAdmin)
3) UPGRADE ARTICLE CONTENT IMAGELIST (copy and paste using phpMyAdmin)
Posted: Thu 2. Feb 2006, 15:50
by harrybo
Hi pico,
yes I did proceed the three mentioned steps - after having upgraded the database. The graphics where moved from the folder 1 - 10, so all seemed to be ok. From the backend, the graphics are available in the filemanager and they do have the correct names, but within all content parts, the graphics are lost. The graphic name is still remaining but the graphic itself is missing. Also the size is reset to small values like 4 or 6 and all captions are changed to strings like "׿zôFßR¢â]wãé".
Do you have any idea how I could reassign the graphics without opening every content part to do it manually?
Regards
Harry
Posted: Fri 3. Feb 2006, 04:09
by Pappnase
harrybo wrote:Hello Pappnase,
I downloaded from the docu page. Does your question mean, the 1.2.6 differs depending from the download location? Arrrrrgh. Anyway, I looked at phpwcms and sourceforge where there's only a 1.2.5. ??!!
Hello
please tell me wicht version esp. wich file you download from the docu page! i checked the last few files! but all have your missing row included
Posted: Fri 3. Feb 2006, 09:58
by harrybo
Hello Pappnase,
from the docu site
http://www.phpwcms-docu.de/index.php?cvs_info_de I downloaded the phpwcms_dev_1.2.6_14.12.2005.zip. So this seems to be the actual version.
Regards
Harry
Posted: Sat 4. Feb 2006, 04:46
by Pappnase
helli
i checked now all! and the file 13__1.2.5-DEV_to_1.2.6-DEV contains what you looking for.
Code: Select all
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_anchor` INT( 1 ) NOT NULL ;
i also add this row to the big sql update file! it seems like over g. forget this line.
Posted: Sat 4. Feb 2006, 05:33
by DeXXus
Pappnase wrote:it seems like over g. forget this line.
BTW, -=Pappnase=-
There should be a change to the following file in latest archives of
Version phpwcms_dev_1.2.6:
"setup/setup.func.inc.php"
FROM:
Code: Select all
//setup functions
$phpwcms_version = "1.2.5-DEV";
TO:
Code: Select all
//setup functions
$phpwcms_version = "1.2.6-DEV";
Posted: Sat 4. Feb 2006, 05:36
by Pappnase
DeXXus wrote:Pappnase wrote:it seems like over g. forget this line.
BTW, -=Pappnase=-
There should be a change to the following file in latest archives of
Version phpwcms_dev_1.2.6:
"setup/setup.func.inc.php"
FROM:
Code: Select all
//setup functions
$phpwcms_version = "1.2.5-DEV";
TO:
Code: Select all
//setup functions
$phpwcms_version = "1.2.6-DEV";
hello dex
also changed
Posted: Sat 4. Feb 2006, 05:38
by DeXXus
Pappnase wrote:hello dex
also changed
I knew you would be right on it
You constantly -=amaze=- me
Posted: Sat 4. Feb 2006, 05:43
by Pappnase
DeXXus wrote:Pappnase wrote:hello dex
also changed
I knew you would be right on it
You constantly -=amaze=- me
hello dex
thanks!
but i need also say that it makes me happy to see you back again in the forum. after a few months absence.
Posted: Sat 4. Feb 2006, 05:47
by DeXXus
Yes, been back a -little- while (after my dear mother's passing -and- job change, too). Thanks for saying so.
I still see that folks
recognize how flexible and powerful phpWCMS can be!
Note: OliverG even needs to update his copyright dates, LOL.
Posted: Sat 4. Feb 2006, 05:50
by Pappnase
DeXXus wrote:Yes, been back a -little- while (after my dear mother's passing -and- job change, too).
I still see that folks
recognize how flexible and powerful phpWCMS can be!
Note: OliverG even needs to udate his copyright dates, LOL.
hello
yes but they wanna have all in one day!
but now stop our offtopic talk!