Errors on upgrade RC2 -> PL

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #1, 16 years, 2 months ago

I’ve yet to find out if it’s causing anything odd, but thought I’d post anyway.

To me, it seems like it wants to create tables that already exist (hence the upgrade).

Edit
Besides the tree being empty when first logging in (which was fixed with a refresh, after which I cleared the cache and flushed permissions to remove traces of the old version), I’m not seeing any problems.

    *

      Successfully created table for class modAccessCategory
    *

      Successfully created table for class modCategoryClosure
    *

      Error updating table for class
      Array
      (
      [0] => 42S22
      [1] => 1054
      [2] => Unknown column 'evtid' in 'revo_site_plugin_events'
      )
    *

      Successfully upgraded table for class modResource
      Changed `context_key web` field to `context_key web` on table ``revo_site_content``.
    *

      Error updating table for class modEvent
      Array
      (
      [0] => 42000
      [1] => 1091
      [2] => Can't DROP 'id'; check that column/key exists
      )
    *

      Successfully upgraded table for class modEvent
      Dropped column `name` on table ``revo_system_eventnames``.
    *

      Error updating table for class modUser
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'remote_key'
      )
    *

      Error updating table for class modUser
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'remote_data'
      )
    *

      Error updating table for class modUser
      Array
      (
      [0] => 42000
      [1] => 1061
      [2] => Duplicate key name 'remote_key'
      )
    *

      Error updating table for class modUserProfile
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'extended'
      )
    *

      Error updating table for class modUserProfile
      Array
      (
      [0] => 42000
      [1] => 1061
      [2] => Duplicate key name 'extended'
      )
    *

      Error updating table for class modAccessPolicy
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'lexicon'
      )
    *

      Error updating table for class modLexiconEntry
      Array
      (
      [0] => 00000
      [1] => 1060
      [2] => Duplicate column name 'lexicon'
      )
    *

      Error updating table for class transport.modTransportProvider
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'api_key'
      )
    *

      Error updating table for class transport.modTransportProvider
      Array
      (
      [0] => 42000
      [1] => 1061
      [2] => Duplicate key name 'api_key'
      )
    *

      Error updating table for class modCategoryClosure
      Array
      (
      [0] => 00000
      [1] => 1061
      [2] => Duplicate key name 'api_key'
      )
    *

      Error updating table for class modActionDom
      Array
      (
      [0] => 42S21
      [1] => 1060
      [2] => Duplicate column name 'active'
      )
    *

      Error updating table for class modActionDom
      Array
      (
      [0] => 42000
      [1] => 1061
      [2] => Duplicate key name 'active'
      )
    *

      Error updating table for class modLexiconEntry
      Array
      (
      [0] => 00000
      [1] => 1061
      [2] => Duplicate key name 'active'
      )
    *

      Config file successfully written.
    *

      Config file permissions were not updated. You may want to change the permissions on your config file to secure the file from tampering.

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.

- ☆ A M B ☆
- 1,056 Posts
pixelchutes Reply #2, 16 years, 2 months ago

I’ve had a test build of Revo, starting with RC-1 > RC-2 > RC-3, and now to PL.

RC-2 > RC-3 had many more warnings (much like yours), however my RC-3 > PL only had one warning:

Quote from: "Revo

Error updating table for class modLexiconEntry
Array
(
[ 0 ] => 00000
[ 1 ] =>
[ 2 ] =>
)

Not sure if this is a cause for concern? I am tempted to ditch everything and start fresh just to be safe
Mike Reid - www.pixelchutes.com
MODx Ambassador / Contributor
[Module] MultiMedia Manager / [Module] SiteSearch / [Snippet] DocPassword / [Plugin] EditArea / We support FoxyCart
________________________________
Where every pixel matters.