View Issue Details

IDProjectCategoryView StatusLast Update
0000386WackoWikiinstallerpublic2011-06-13 07:00
Reporterpascalvmf Assigned Toadministrator  
PriorityhighSeveritycrashReproducibilityalways
Status resolvedResolutionno change required 
PlatformsynologyOSlinuxOS VersionDSM 2.1-0844
Product Version5.0.beta 
Target Version5.0.rc 
Summary0000386: upgrade fails from R4.3 to R5.0beta - user not changed to user_name in user table
DescriptionI am currently in the following version :
"wakka_version" => "0.1.2",
"wacko_version" => "R4.3"

When upgrading to R5.0beta I'v got error during SQL upgrade like the following :

Unknown column 'user_name' in 'where clause'
Additional Informationsee attached report of the upgrade process, including sql error message I added to setup/database-install.php
TagsNo tags attached.
Attached Files
wacko_r43_to_r50beta_errors.txt (7,944 bytes)   
WackoWiki Installation
 : 
System Requirements

    Language Configuration
    >
    System Requirements
    >
    Site Configuration
    >
    Database Configuration
    >
    Database Installation
    >
    Write Config File

Your server must meet the requirements listed below.
PHP Version

Detected PHP 5.3.3
Apache Rewrite Extension (Optional)

Rewrite Extension (mod_rewrite) Installed?
Database

    MySQL
    MySQLi
    PDO

Permissions

    _cache/config
    _cache/feeds
    _cache/pages
    _cache/queries
    config/config.php
    files/global
    files/perpage
    xml
    sitemap.xml

Ready to Install?

Congratulations, it appears that your server is capable of running WackoWiki. The next few pages will take you through the configuration process.

This installer will try to write the configuration data to the file config.php, located in your WackoWiki directory. In order for this to work, you must make sure the web server has write access to that file. If you can't do this, you will have to edit the file manually (the installer will tell you how).

See WackoWiki:Doc/English/Installation for details.

WackoWiki Installation
 : 
Database Installation

    Language Configuration
    >
    System Requirements
    >
    Site Configuration
    >
    Database Configuration
    >
    Database Installation
    >
    Write Config File

Testing Configuration

    Testing database connection settings
    Checking if the database you specified exists


Wacko R4.3 to R5.0.beta

    Renaming acl Table
    Renaming link Table
    Renaming page Table
    Renaming referrer Table
    Renaming revision Table
    Renaming user Table
    Renaming watch Table
    Altering acl Table
    Altering cache Table
    Altering link Table
    Altering page Table
    Altering referrer Table
    Altering revision Table
    Altering upload Table
    Altering user Table
    Altering watch Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
        Error altering user table
        Can't DROP 'idx_name'; check that column/key exists
    Altering user Table
        Error altering user table
        Unknown column 'user_name' in 'wakka_user'
    Altering user Table
    Altering user Table
    Updating user Table
    Updating user Table
    Updating user Table
    Updating user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering user Table
    Altering acl Table
    Altering acl Table
    Updating acl Table
    Altering acl Table
    Altering acl Table
    Altering acl Table
    Altering acl Table
    Creating menu table
    Altering cache Table
    Altering cache Table
    Creating config table
    Creating group table
    Creating group_member table
    Creating category table
    Creating category_page table
    Altering link Table
    Altering link Table
    Altering link Table
    Updating link Table
    Updating link Table
    Altering link Table
    Altering link Table
    Altering link Table
    Creating log table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
        Error updating page table
        Unknown column 'user_name' in 'field list'
    Updating page Table
        Error updating page table
        Unknown column 'user_name' in 'field list'
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Altering page Table
    Updating page Table
    Updating page Table
    Updating page Table
    Creating poll table
    Altering watch Table
    Altering watch Table
    Altering watch Table
    Updating watch Table
        Error updating watch table
        Unknown column 'user_name' in 'field list'
    Updating watch Table
    Altering watch Table
    Altering watch Table
    Altering watch Table
    Altering watch Table
    Altering watch Table
    Creating rating table
    Altering referrer Table
    Altering referrer Table
    Altering referrer Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Updating revision Table
        Error updating revision table
        Unknown column 'user_name' in 'field list'
    Updating revision Table
        Error updating revision table
        Unknown column 'user_name' in 'field list'
    Updating revision Table
    Updating revision Table
    Updating revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Altering revision Table
    Updating revision Table
    Altering upload Table
    Updating upload Table
        Error updating upload table
        Unknown column 'user_name' in 'field list'
    Altering upload Table
    Altering upload Table
    Creating user_setting table
    Adding Config Values
    Adding System User
        The system account already exists
        Unknown column 'user_name' in 'field list'
    Adding Admin User Preferences
        The admin user settings already exists
        Unknown column 'user_name' in 'where clause'
    Adding Admins Group
        The admin group already exists
        Unknown column 'user_name' in 'where clause'
    Adding Admins Group Member
        The admin group member already exists
        Unknown column 'user_name' in 'where clause'
    Adding Everybody Group
        The everybody group already exists
        Unknown column 'user_name' in 'where clause'
    Adding Registered Group
        The registered group already exists
        Unknown column 'user_name' in 'where clause'
    Adding Moderator Group
        The moderator group already exists
        Unknown column 'user_name' in 'where clause'
    Adding Reviewer Group
        The reviewer group already exists
        Unknown column 'user_name' in 'where clause'


Adding Default Data

    Adding Default Pages
    Finished Adding Default Pages

In the next step, the installer will try to write the updated configuration file, config.php. Please make sure the web server has write access to the file, or you will have to edit it manually. Once again, see WackoWiki:Doc/English/Installation for details.

Activities

administrator

2011-06-08 09:31

administrator   ~0000791

Last edited: 2011-07-03 10:26

Error altering user table
        Can't DROP 'idx_name'; check that column/key exists

Guess this line fails
$alter_user_r4_3_11 = "ALTER TABLE {$pref}user CHANGE name user_name VARCHAR(80) NOT NULL DEFAULT '', DROP INDEX idx_name, ADD UNIQUE idx_user_name (user_name)";

and all the following errors were caused by the missing 'user_name' field

Can you check the 'user' table of your R4.3 wiki and try to add the index if missing.

KEY idx_name (name)

And then run the installer/upgrade again. If so the question is why the index was missing.

pascalvmf

2011-06-09 21:35

developer   ~0000793

In fact the user table has a primary index on "name" called "PRIMARY" :)

I'll add an idx_name unique index and restart the upgrade to see if it solves the error.

pascalvmf

2011-06-10 11:49

developer   ~0000794

Ok with the indicated modification, the upgrade was successfull.

(and btw I could at last be able to delete thousand of spam comments from my pages dated from the early wackowiki version :) )

Issue History

Date Modified Username Field Change
2011-06-03 16:24 pascalvmf New Issue
2011-06-03 16:24 pascalvmf File Added: wacko_r43_to_r50beta_errors.txt
2011-06-08 08:52 administrator Assigned To => administrator
2011-06-08 08:52 administrator Status new => acknowledged
2011-06-08 09:31 administrator Note Added: 0000791
2011-06-08 09:32 administrator Status acknowledged => feedback
2011-06-08 09:37 administrator Note Edited: 0000791
2011-06-08 09:41 administrator Product Version 4.3.rc => 5.0.beta
2011-06-08 09:41 administrator Target Version 5.0.beta => 5.0.rc
2011-06-09 21:35 pascalvmf Note Added: 0000793
2011-06-09 21:35 pascalvmf Status feedback => assigned
2011-06-10 11:49 pascalvmf Note Added: 0000794
2011-06-13 07:00 administrator Status assigned => resolved
2011-06-13 07:00 administrator Resolution open => no change required
2011-07-03 10:24 administrator Note Edited: 0000791
2011-07-03 10:26 administrator Note Edited: 0000791