rev. 5626 datenbankupdate ?

Thomas Baumann <[email protected]> Thu, 22 Sep 2005 21:48:59 +0200
Newsgroups gmane.comp.cms.bitflux.general.german
Message-ID <[email protected]>
Hallo Liste,

ich habe auf rev 5626 aktualisiert und jetzt sind auch meine blogs
nicht mehr erreichbar. Gibt es ein Skript, die Datenbank zu konvertieren =
?

http://tirili.zyklopaedie.de/blog/rss.xml

userInfo:
[Last query: SELECT blogposts.post_uri,blogposts.id, blogposts.post_title=
,
blogposts.post_uri, blogposts.post_content, blogposts.post_content_extend=
ed,
blogposts.post_info, blogposts.post_status, unix_timestamp(blogposts.chan=
ged) as
lastmodified, DATE_FORMAT(DATE_ADD(blogposts.post_date, INTERVAL 7200 SEC=
OND),
"%d.%m.%Y %H:%i") as post_date, unix_timestamp(blogposts.post_date) as un=
ixtime,
blogposts.post_comment_mode, DATE_FORMAT(blogposts.post_date,
"%Y-%m-%dT%H:%i:%SZ") as post_date_iso, blogposts.post_author,
count(blogcomments.id) as comment_count,
unix_timestamp(max(blogcomments.changed)) as comment_lastmodified from
tiri_blogposts as blogposts left join tiri_blogcomments as blogcomments o=
n
blogposts.id =3D blogcomments.comment_posts_id and blogcomments.comment_s=
tatus =3D 1
where blogposts.id =3D "55" group by blogposts.id ] [Native code: 1054] [=
Native
message: Unknown column 'blogposts.post_info' in 'field list']

Danke & Gruss

- tom

--=20
Thomas Baumann=20
Dipl.-Betriebswirt (BA)

tiri.li information technology
Postfach 11 01 15
D-64216 Darmstadt
fon +49 (0) 7000 - 66 464 66
fax +49 (0) 70000 - 329 329
http://www.tiri.li

This email and any attachments are confidential and are=20
intended only for the addressee. If you are not the=20
intended recipient of this email and have received it=20
in error, please notify the sender immediately by reply=20
email and then delete it from your system.=20



-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/