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
Re-installed and now cant Create Article
Hi
you have to upgrade your Database also - goto http://www.yourdomain.tld/setup/upgrade.php and do the SQL-Database upgrades Step-By-Step starting at your 'old' Version.
you have to upgrade your Database also - goto http://www.yourdomain.tld/setup/upgrade.php and do the SQL-Database upgrades Step-By-Step starting at your 'old' Version.