error while updating article basis information

[cmesser]

Hello

i have upgraded to version 08.06.04. after the upload i receive following
errormsg if i add a article.

error while updating article basis information:
UPDATE phpwcms_article SET article_cid=6,article_title='Erster Artikel', article_keyword='Geithain Sachsen', article_public=1, article_aktiv=1, article_begin='2004-06-09 19:05:53', article_end='2010-12-31 23:59:59', article_subtitle='', article_summary='Das ist der testartikel.', article_redirect='', article_username='Uwe Scheibner', article_notitle=0, article_hidesummary=1, article_image='a:13:{s:8:"tmpllist";s:7:"default";s:8:"tmplfull";s:7:"default";s:4:"name";s:10:"wappen.gif";s:2:"id";i:4;s:5:"width";i:71;s:6:"height";i:77;s:7:"caption";s:134:"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA";s:4:"zoom";i:0;s:4:"prev";s:18:"1_4_9BRGNac3iE.gif";s:9:"prev_info";a:7:{i:0;i:71;i:1;i:77;i:2;i:1;i:3;s:22:"width="71" height="77"";s:4:"bits";i:6;s:8:"channels";i:3;s:4:"mime";s:9:"image/gif";}s:9:"prev_make";i:1;s:3:"add";s:6:"-71x77";s:5:"cname";s:24:"1_4_9BRGNac3iE-71x77.gif";}' , article_uid=1 WHERE article_id=7;


if i go now to my website i can see the header of my article but the image and the caption and summary text is lost.

how can i solve this.

here is the link where you can see the result of the explained action.

http://web2.h7244.serverkompetenz.net/c ... hopfgarten

thx + rgds
Uwe

[Pappnase]

hello

please also load update file to the db! from version P2.



p.s.
thanks dexxus

[DeXXus]

There are -no- SQL update files in verion P1 patch (all -are- in version P2 patch though). However, whether you used both patches method -or- new "full archive" to get to version 08.06.04. you will have to execute the SQL files that came -after- date of your LAST version:

phpwcms_1.1-RC3_20-04-2004.sql
phpwcms_1.1-RC4_22-04-2004.sql
phpwcms_1.1-RC4_31-05-2004.sql <--Likely culprit
phpwcms_1.1-RC4_08-06-2004.sql

[cmesser]

thanx,

now ist works.

Rgds Uwe