1
rogett
Upgrade error: 1054
  • 2009/12/14 21:37

  • rogett

  • Just popping in

  • Posts: 30

  • Since: 2005/5/5 1


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.

2
ghia
Re: Upgrade error: 1054
  • 2009/12/14 22:49

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


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?)

3
rogett
Re: Upgrade error: 1054
  • 2009/12/14 22:59

  • rogett

  • Just popping in

  • Posts: 30

  • Since: 2005/5/5 1


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)"

4
rogett
Re: Upgrade error: 1054
  • 2009/12/14 23:02

  • rogett

  • Just popping in

  • Posts: 30

  • Since: 2005/5/5 1


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?

Login

Who's Online

145 user(s) are online (95 user(s) are browsing Support Forums)


Members: 0


Guests: 145


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits