View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000386 | WackoWiki | installer | public | 2011-06-03 16:24 | 2011-06-13 07:00 |
| Reporter | pascalvmf | Assigned To | administrator | ||
| Priority | high | Severity | crash | Reproducibility | always |
| Status | resolved | Resolution | no change required | ||
| Platform | synology | OS | linux | OS Version | DSM 2.1-0844 |
| Product Version | 5.0.beta | ||||
| Target Version | 5.0.rc | ||||
| Summary | 0000386: upgrade fails from R4.3 to R5.0beta - user not changed to user_name in user table | ||||
| Description | I 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 Information | see attached report of the upgrade process, including sql error message I added to setup/database-install.php | ||||
| Tags | No 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.
| ||||
|
|
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. |
|
|
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. |
|
|
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 :) ) |
| 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 |
