About my server environment:
PHP Version: 4.1.2
SQL Version: 3.23.56
Apache Version: Apache/1.3.27 (Unix) (Red-Hat/Linux)
Xoops Version: 2.0.9.2
OS: Linux sme60build 2.4.20-18.7

I have a database with correct name and pass.

The Problem

I did a clean install of XOOPS 2.0.9.2. I transfered the users table over from XOOPS 1.3 to XOOPS 2 MySQL database using phpmyadmin. I noticed there's a few new field entries in XOOPS 2.0.9.2 so I added the new fields to XOOPS 1.3 before I exported the information.

Everything transfered into the new database okay. For some reason new users can't register though and I'm uncertain if it's related to my tranfering the existing user data from the existing database. An example of the registration process and error that is produced is displayed below using the default theme:

I'm not sure where to begin trying to troubleshoot the registration error. I've tried every debugging mode in XOOPS but there wasn't any helpful information displayed.

Example of The Problem

The XOOPS 2.0.x *installer* script has a built-in migration script, but it actively changes the tables for a number of modules and parts, including the user tables. So you should do it in the following order:

dump 1.3 database
upload 2.0.9.2
run installer
it will detect the 1.3.x tables and upgrade them to 2.0.x

and you're set to go.

Herko

When I upload 2.0.9.2 do I just overwrite the existing 1.3.10 installation?

My first attempt I removed the files from 1.3.10 before uploading 2.0.9.2 files, & I got the following database error message re: users during the database upgrade process: