Re-installed and now cant Create Article
Posted: Sat 24. Sep 2005, 21:10
I have had to rebuild a phpwcms site and a trying to get it to link to a database full of content. Whilst I can see articles I am getting errors like ERRORS WHEN CONNECTING TO DATABASE:
INSERT INTO amtlwcms__phpwcms_article (article_cid, article_uid, article_username, article_title, article_keyword, article_public, article_aktiv, article_begin, article_end, article_subtitle, article_redirect, article_sort, article_notitle, article_created, article_cache, article_nosearch, article_nositemap, article_aliasid, article_headerdata, article_morelink) VALUES ('0','1','AMTLwcms webmaster','kk','','1','1','2005-09-24 19:45:05','2010-12-31 23:59:59','','', 0,0, '1127587505', '', '', 1, 0, 0, 1);
Using phpmyadmin I can see that some fields, namely rticle_aliasid, article_headerdata, article_morelink are not defined in my database. My guess is that has happened because I have inadvertently installed slightly later version of phpwcms and the database has not been upgraded. The backend login screen reports that I am using v1.2.5-DEV.
1. Is there a way I can determine what version the database structure has been upgraded to?
2. are there any database upgrade scripts I can use to automatically create the fields that I need?
Many thanks,
James
INSERT INTO amtlwcms__phpwcms_article (article_cid, article_uid, article_username, article_title, article_keyword, article_public, article_aktiv, article_begin, article_end, article_subtitle, article_redirect, article_sort, article_notitle, article_created, article_cache, article_nosearch, article_nositemap, article_aliasid, article_headerdata, article_morelink) VALUES ('0','1','AMTLwcms webmaster','kk','','1','1','2005-09-24 19:45:05','2010-12-31 23:59:59','','', 0,0, '1127587505', '', '', 1, 0, 0, 1);
Using phpmyadmin I can see that some fields, namely rticle_aliasid, article_headerdata, article_morelink are not defined in my database. My guess is that has happened because I have inadvertently installed slightly later version of phpwcms and the database has not been upgraded. The backend login screen reports that I am using v1.2.5-DEV.
1. Is there a way I can determine what version the database structure has been upgraded to?
2. are there any database upgrade scripts I can use to automatically create the fields that I need?
Many thanks,
James