Upgrade 1.1-RC4 -> 1.2.6: uncomplete update-sql-file

harrybo · Post by **harrybo** » Thu 2. Feb 2006, 01:22

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

Pappnase · Post by **Pappnase** » Thu 2. Feb 2006, 04:00

hello

from where did you download!?

DeXXus · Post by **DeXXus** » Thu 2. Feb 2006, 07:01

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>';
				}

harrybo · Post by **harrybo** » Thu 2. Feb 2006, 09:03

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

pico · Post by **pico** » Thu 2. Feb 2006, 09:13

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)

harrybo · Post by **harrybo** » Thu 2. Feb 2006, 15:50

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

Pappnase · Post by **Pappnase** » Fri 3. Feb 2006, 04:09

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

harrybo · Post by **harrybo** » Fri 3. Feb 2006, 09:58

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

Pappnase · Post by **Pappnase** » Sat 4. Feb 2006, 04:46

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.

DeXXus · Post by **DeXXus** » Sat 4. Feb 2006, 05:33

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";

Pappnase · Post by **Pappnase** » Sat 4. Feb 2006, 05:36

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

DeXXus · Post by **DeXXus** » Sat 4. Feb 2006, 05:38

Pappnase wrote:hello dex

also changed

I knew you would be right on it

You constantly -=amaze=- me

Pappnase · Post by **Pappnase** » Sat 4. Feb 2006, 05:43

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.

DeXXus · Post by **DeXXus** » Sat 4. Feb 2006, 05:47

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.

Pappnase · Post by **Pappnase** » Sat 4. Feb 2006, 05:50

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!