I come back on my 1.2.6 database upgrade.

my operations :

1) ./database-upgrade (pointing on my 1.2.6 database)
response : "run first ./article-uniquename..."

2) ./article-uniquename (configured)
returns "would have ran: UPDATE..."
cause $opt_U & $opt_P had no value.
I add in article-uniquename
"$root = $opt_U ? $opt_U : 'root';
$rootpw = $opt_P ? $opt_P : 'pass';"
and run again article-uniquename : "Not fixing empty names (if any)"

3) /database-upgrade
and U can see the result :

--- begin ----

Testing for nameless articles: 1299 found. Non-fatal but not recommended

>> BLOBS
   ++ Blobs table created

>> CACHE
   ++ Cache table created

>> PARAMETERS
   ++ Params table created

>> REPLIGARD
   Repligard table present

>> SNIPPET
   Snippet table present

>> SNIPPETDIR
   SnippetDir table present

>> EVENT
   ++ Event table created

>> EVENT MEMBER
   ++ EventMember table created

>> SITEGROUPS
   ++ Sitegroup table created
      sitegroup field added to article
      blobs has the sitegroup field
      cache has the sitegroup field
      sitegroup field added to element
      sitegroup field added to event
      sitegroup field added to eventmember
      sitegroup field added to file
      sitegroup field added to grp
      sitegroup field added to host
      sitegroup field added to image
      sitegroup field added to member
      sitegroup field added to page
      sitegroup field added to pageelement
DBD::mysql::st execute failed: Table 'test.pagelink' doesn't exist at 
./database-upgrade line 523.
DBD::mysql::db do failed: Table 'test.pagelink' doesn't exist at ./database-upgrade 
line 216.
      !! Failed to add sitegroup field to pagelink
      sitegroup field added to person
      sitegroup field added to preference
      record_extension has the sitegroup field
      sitegroup field added to repligard
      sitegroup field added to snippet
      sitegroup field added to snippetdir
      sitegroup field added to style
      sitegroup field added to topic

>> TABLES
   !! 'pagelink' table expected but not present

>> GUIDS
   ++ Testing 'article'...
   !! 'article' has 440 entries without a repligard GUID
   ++ Testing 'blobs'...
   ++ Testing 'cache'...
   ++ Testing 'element'...
   !! 'element' has 17 entries without a repligard GUID
   ++ Testing 'event'...
   ++ Testing 'eventmember'...
   ++ Testing 'file'...
   ++ Testing 'grp'...
   ++ Testing 'host'...
   ++ Testing 'image'...
   ++ Testing 'member'...
   !! 'member' has 192 entries without a repligard GUID
   ++ Testing 'page'...
   !! 'page' has 15 entries without a repligard GUID
   ++ Testing 'pageelement'...
   !! 'pageelement' has 17 entries without a repligard GUID
   ++ Testing 'pagelink'...
DBD::mysql::st execute failed: Table 'test.pagelink' doesn't exist at 
./database-upgrade line 523.
   !! Table 'pagelink' is missing the 'id' field.
   ++ Testing 'person'...
   !! 'person' has 28 entries without a repligard GUID
   ++ Testing 'preference'...
   ++ Testing 'record_extension'...
   ++ Testing 'sitegroup'...
   ++ Testing 'snippet'...
   ++ Testing 'snippetdir'...
   ++ Testing 'style'...
   ++ Testing 'topic'...
   !! 'topic' has 5 entries without a repligard GUID
There are 714 GUIDS missing! You will need to run 'repligard -m'.


--- end ----



my question now : how can fix problem of "pagelink" table creation ?


I will run also "repligard -m" (or GUIDSforOLDSITE.sql is better ?)


thanks for your precious help!



Benoit.



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to