Error while updating article

aran384 · Post by **aran384** » Wed 21. Jul 2004, 12:37

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

Pappnase · Post by **Pappnase** » Wed 21. Jul 2004, 13:04

hello

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

jaredhales · Post by **jaredhales** » Fri 23. Jul 2004, 15:54

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;

Pappnase · Post by **Pappnase** » Fri 23. Jul 2004, 16:00

Hello

Please run also the other sql updates!

jaredhales · Post by **jaredhales** » Fri 23. Jul 2004, 23:10

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?

Pappnase · Post by **Pappnase** » Fri 23. Jul 2004, 23:16

hello

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