We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Database Error during update from 1.0.5 to 1.0.6

    • 28173
    • 409 Posts
    Spheerys Reply #1, 11 years, 10 months ago
    Hi,

    For the first time, I have an error during a modx update !
    yeahh ! smiley

    Here the error :
    Install results

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `onnouscachetout`: OK!

Creating database tables: Database Alerts!

MODx setup couldn't install/alter some tables inside the selected database.

The following errors had occurred during installation

Duplicate entry '2-2' for key 2 during the execution of SQL statement ALTER TABLE `modx_web_groups` ADD UNIQUE INDEX `ix_group_user` (`webgroup`,`webuser`).

Some tables were not updated. This might be due to previous modifications.


    I can close, but I can't login myself. Modx tell me the installation is still in process.

    How can I resolve this ?
      • 38808
      • 4 Posts
      fnkst1 Reply #2, 11 years, 9 months ago
      Hi,

      I have the same problem ... does anyone have an idea?

      Install results
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `xxxxxxx`: OK!
Creating database tables: Database Alerts!
MODx setup couldn't install/alter some tables inside the selected database.
The following errors had occurred during installation
Duplicate entry '12-1' for key 'ix_group_user' during the execution of SQL statement ALTER TABLE `modx_web_groups` ADD UNIQUE INDEX `ix_group_user` (`webgroup`,`webuser`).
Some tables were not updated. This might be due to previous modifications.

      WAMP
      PHP 5.3.8
      MySQL 5.1.59


      Many thanks!

        • 38808
        • 4 Posts
        fnkst1 Reply #3, 11 years, 9 months ago
        Hi,

        I solved this problem with a manually check/update in the database table "modx_web_groups".
        There were some duplicate entries (regarding to webgroup, webuser) in this table and I removed the duplicate entries with the same value.

        But I don't know the reason why there were duplicate entries ... no manually operation before smiley