On 12/8/05, Dave Johnson <[EMAIL PROTECTED]> wrote: > I've tested the upgrade scripts and code with MySQL and PostgreSQL and > I've given a copy of the build to the fellow who reported the problem > so that he can verify the fix. > > Additional testing would be very nice.
Well, I got various errors still, but I'm still taking a 0.99 database and trying to run every script to get it to 2.0. It'll take me a while to deploy each and every Roller release as I go, but I'll give that a shot if time permits. I'm building from http://svn.apache.org/repos/asf/incubator/roller/branches/roller_2.0/. I get three types of error. 1) Some null value errors, which are probably because I've not been turning on Roller. An example is: ERROR: column "timezone" contains null values 2) ERROR: constraint "att_entryid_fk" for relation "entryattribute" already exists and most worringly: 3) Lots of syntax errors. ie: ERROR: syntax error at or near "pt" at character 19 ERROR: syntax error at or near "foreign" at character 26 (more below) -- Also I'm worried about http://svn.apache.org/repos/asf/incubator/roller/branches/roller_2.0/trunk/ We seem to have files both in the trunk directory and in the directory around it. Nothing wrong per se, but it seems likely to have been a mistake. Hen [Syntax error list is: ERROR: syntax error at or near "pt" at character 19 ERROR: syntax error at or near "foreign" at character 26 ERROR: syntax error at or near "foreign" at character 27 ERROR: syntax error at or near "foreign" at character 26 ERROR: syntax error at or near "foreign" at character 30 ERROR: syntax error at or near "foreign" at character 30 ERROR: syntax error at or near "foreign" at character 33 ERROR: syntax error at or near "foreign" at character 26 ERROR: syntax error at or near "foreign" at character 33 ERROR: syntax error at or near "foreign" at character 26 ERROR: syntax error at or near "foreign" at character 26 ERROR: syntax error at or near "foreign" at character 25 ERROR: syntax error at or near "foreign" at character 27 ERROR: syntax error at or near "foreign" at character 27 ERROR: syntax error at or near "foreign" at character 29 ERROR: syntax error at or near "foreign" at character 27 ERROR: syntax error at or near "foreign" at character 27 ERROR: syntax error at or near "foreign" at character 31 ERROR: syntax error at or near "foreign" at character 31 ERROR: syntax error at or near "userrole_userid_index" at character 33 ERROR: syntax error at or near "userrole_username_index" at character 33 ERROR: syntax error at or near "usercookie_username_index" at character 35 ERROR: syntax error at or near "usercookie_cookieid_index" at character 35 ERROR: syntax error at or near "webpage_name_index" at character 32 ERROR: syntax error at or near "webpage_link_index" at character 32 ERROR: syntax error at or near "webpage_id_index" at character 32 ERROR: syntax error at or near "website_id_index" at character 32 ERROR: syntax error at or near "website_userid_index" at character 32 ERROR: syntax error at or near "website_isenabled_index" at character 32 ERROR: syntax error at or near "folder_websiteid_index" at character 31 ERROR: syntax error at or near "folderassoc_folderid_index" at character 36 ERROR: syntax error at or near "folderassoc_ancestorid_index" at character 36 ERROR: syntax error at or near "folderassoc_relation_index" at character 36 ERROR: syntax error at or near "bookmark_folderid_index" at character 33 ERROR: syntax error at or near "weblogcategory_websiteid_index" at character 39 ERROR: syntax error at or near "weblogcategoryassoc_categoryid_index" at character 44 ERROR: syntax error at or near "weblogcategoryassoc_ancestorid_index" at character 44 ERROR: syntax error at or near "weblogcategoryassoc_relation_index" at character 44 ERROR: syntax error at or near "weblogentry_websiteid_index" at character 36 ERROR: syntax error at or near "weblogentry_categoryid_index" at character 36 ERROR: syntax error at or near "weblogentry_pubtime_index" at character 36 ERROR: syntax error at or near "weblogentry_pinnedtomain_index" at character 36 ERROR: syntax error at or near "weblogentry_publishentry_index" at character 36 ERROR: syntax error at or near "newsfeed_websiteid_index" at character 33 ERROR: syntax error at or near "comment_entryid_index" at character 32 ERROR: syntax error at or near "pingtarget_websiteid_index" at character 35 ERROR: syntax error at or near "autoping_websiteid_index" at character 33 ERROR: syntax error at or near "autoping_pingtargetid_index" at character 33 ERROR: syntax error at or near "pingcategory_autopingid_index" at character 37 ERROR: syntax error at or near "pingcategory_categoryid_index" at character 37 ERROR: syntax error at or near "pingqueueentry_entrytime_index" at character 39 ERROR: syntax error at or near "pingqueueentry_pingtargetid_index" at character 39 ERROR: syntax error at or near "pingqueueentry_websiteid_index" at character 39 ERROR: syntax error at or near "referer_websiteid_index" at character 32 ERROR: syntax error at or near "referer_entryid_index" at character 32 ERROR: syntax error at or near "referer_refurl_index" at character 32 ERROR: syntax error at or near "referer_requrl_index" at character 32 ERROR: syntax error at or near "referer_datestr_index" at character 32 ERROR: syntax error at or near "referer_refpermalink_index" at character 32 ERROR: syntax error at or near "referer_duplicate_index" at character 32 ERROR: syntax error at or near "entryattribute_entryid_index" at character 39 ERROR: syntax error at or near "rag_group_subscription_gid" at character 47 ERROR: syntax error at or near "rag_group_subscription_sid" at character 47 ERROR: syntax error at or near "rag_group_handle" at character 34 ERROR: syntax error at or near "rag_subscription_feed_url" at character 41 ERROR: syntax error at or near "rag_entry_sid" at character 34
