This is the error message I receive when I try to log in to begin the upgrade. Going from 2.0.17.1 to 2.4.2

Queries
0.000084 - SET SQL_BIG_SELECTS = 1
0.000159 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000140 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '7') ORDER BY conf_order ASC
0.000273 - SELECT * FROM `users` WHERE (uname = 'roger' AND pass = '123456789abcdefghi')
0.000085 - SELECT * FROM `users` WHERE (loginname = 'roger' AND pass = '123456789abcdefghi')
Error number: 1054
Error message: Unknown column 'loginname' in 'where clause'
Total: 5
Blocks
Total: 0
Extra
Included files: 48 files
Memory usage: 3626296 bytes
Timers
XOOPS took 0.033 seconds to load.
XOOPS Boot took 0.033 seconds to load.

Edit by ghia: don't publicize real passwords.

Humm, that query is normally not part of the 2.4.2 distribution.
What procedure and steps did you follow?

(You are not mistaken by trying upgrade to 2.2.4?)

I was following the directions in the "release_notes.txt" under the section "Upgrading from XOOPS 2.0.* above 2.0.14 and 2.2.* (using the full package)"

I also followed the direction:
4. For security considerations, you are encouraged to move directories xoops_lib (for XOOPS libraries) and xoops_data (for XOOPS data) out of Document Root, and change the folder names.

I moved the files to a different folder on the root drive and renamed them. Based on the instructions I assumed I was to do this BEFORE running the upgrade process.

Does anyone have any idea what I should do at this point?