A "new" install of midgard-data run correctly now. Thanks Piotras ;-)
Our second mission (if we accept that), is to dump an old Midgard base (from Midgard 1.2.6 !!), upgrade this and run with 1.4.x install (on a different server).
So, we found upgrade scripts in 1.4 data package, but no one seems to upgrade really our base : - database-upgrade - article-uniquename - GUIDSforOLDSITE.sql (is required ? for what is this ?)
nota : we have change user/pass/db in script before exec these, but no error appears and change.
Difference between 1.2.6 and 1.4.x base is 7 tables : - blobs - cache - event - eventmember - pagelink - record_extension - sitegroup
+ some columns (like "sitegroup) in tables...
informations : # ./database-upgrade Testing for nameless articles: 1299 found. Non-fatal but not recommended Testing for duplicate reply article names: 30 found. Run article-uniquename to fix it.
#mysql.log
030708 15:23:20 59 Connect [EMAIL PROTECTED] on test
60 Connect [EMAIL PROTECTED] on test
59 Query SELECT id FROM article WHERE name=''
59 Query SELECT DISTINCT a1.id FROM article a1, article a2 WHERE a1.name<>'' AND a1.name=a2.name and a1.id<>a2.id AND a1.topic=a2.topic AND a1.up=0 AND a2.up=0
59 Query SELECT DISTINCT a1.id FROM article a1, article a2 WHERE a1.name<>'' AND a1.name=a2.name and a1.id<>a2.id AND a1.up=a2.up
60 Quit
59 Quit
any idea ?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
