phpwcms Support Forum

When i try to update a article or add something i get a error

error while updating article basis information:
UPDATE phpwcms_article SET article_cid=2,article_title='About us', article_keyword='', article_public=1, article_aktiv=1, article_begin='2004-07-21 11:24:45', article_end='2010-12-31 23:59:59', article_subtitle='', article_summary='test', article_redirect='', article_username='phpwcms webmaster', article_notitle=1, article_hidesummary=0, article_image='a:8:{s:8:"tmpllist";s:7:"default";s:8:"tmplfull";s:7:"default";s:4:"name";s:0:"";s:2:"id";i:0;s:5:"width";i:538;s:6:"height";s:0:"";s:7:"caption";s:0:"";s:4:"zoom";i:0;}' , article_uid=2 WHERE article_id=3;


i would like to use phpwcms but i need a website soon and if i cant sort this then i cant use it =/

plz help

hello

please run the updgrade-php script in the setup folder!
from wich version did you update!?

i upgraded to the 6-22 version from the 3-26 version, and i'm getting this error. i ran the upgrade script selecting the 'older' option. i'm getting a similar error, any suggestions?

error while updating article basis information:
UPDATE phpwcms_article SET article_cid=52,article_title='Test2', article_keyword='', article_public=1, article_aktiv=1, article_begin='2004-07-23 09:46:46', article_end='2010-12-31 23:59:59', article_subtitle='', article_summary='', article_redirect='', article_username='Jared Hales', article_notitle=0, article_hidesummary=0, article_image='a:8:{s:8:"tmpllist";s:7:"default";s:8:"tmplfull";s:7:"default";s:4:"name";s:0:"";s:2:"id";i:0;s:5:"width";i:538;s:6:"height";s:0:"";s:7:"caption";s:0:"";s:4:"zoom";i:0;}' , article_uid=2 WHERE article_id=92;

Hello

Please run also the other sql updates!

thanks, that was a really easy fix.

i don't want to sound unappreciative, but maybe this should be documented better on the upgrade.php?

hello

yes you are right! that update procedure for older versions is not so good documented! but we are here to help!*smile*