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/