user.location not found when listing users in the admin control panel

[SD3]

I am getting this error when trying to list all my users in the admin control panel. I want to see all users and all newly registered users. When i run this below in MySQL, I can see that the user.location column does not exist. I did update to the latest 5.6.1 patch yesterday (vb_patch561_LK598E82FF). Could I have missed a file? Do I need to update my database to have the user location field?

Error Invalid SQL: SELECT user.userid, reputation, username, usergroupid, birthday_search, email, parentemail, (options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, skype, signature, usertitle, joindate, lastpost, posts, ipaddress, lastactivity, userfield.*, infractions, ipoints, warnings, user.location, user.privacyconsent, user.privacyconsentupdated FROM vb_user AS user LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid) ORDER BY username ASC LIMIT 0, 25 /** userFind**/;

Exception trace:
## /var/www/html/my_forums/core/vb/database.php(1208) Exception Thrown
#0 /var/www/html/my_forums/core/vb/database/mysqli.php(249): vB_Database->halt()
#1 /var/www/html/my_forums/core/vb/database.php(576): vB_Database_MySQLi->execute_query()
#2 /var/www/html/my_forums/core/vb/db/result.php(144): vB_Database->query_read()
#3 /var/www/html/my_forums/core/vb/db/result.php(68): vB_dB_Result->rewind()
#4 /var/www/html/my_forums/core/vb/db/querydefs.php(130): vB_dB_Result->__construct()
#5 /var/www/html/my_forums/core/vb/db/mysql/querydefs.php(3373): vB_dB_QueryDefs->getResultSet()
#6 /var/www/html/my_forums/core/vb/db/query/method.php(175): vB_dB_MYSQL_QueryDefs->userFind()
#7 /var/www/html/my_forums/core/vb/db/assertor.php(293): vB_dB_Query_Method->execSQL()
#8 /var/www/html/my_forums/core/vb/db/assertor.php(641): vB_dB_Assertor->assertQuery()
#9 /var/www/html/my_forums/core/vb/api/user.php(1030): vB_dB_Assertor->getRows()
#10 /var/www/html/my_forums/core/vb/api/wrapper.php(201): vB_Api_User->find()
#11 /var/www/html/my_forums/core/admincp/user.php(101): vB_Api_Wrapper->__call()
#12 /var/www/html/my_forums/includes/api/interface/collapsed.php(144): require_once('/var/www/html/s...')
#13 /var/www/html/my_forums/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#14 /var/www/html/my_forums/index.php(74): vB5_Frontend_Controller_Relay->admincp()
#15 {main}

If I modify /core/vb/db/mysql/querydefs.php, lines 3364 to remove user.location, my errors go away, but I also see user.location referenced in this file three more times. This makes me think I need to update my database.

Thanks for any help.

[Wayne Luke]

This is a field that is new to vBulletin 5.6.1. If you're encountering this error the most likely cause is that you have uploaded vBulletin 5.6.1 files to your server and have not run /core/includes/upgrade.php.

You will need to run upgrade.php in order for the database to be updated to use the new location tables and fields expected by the files. Upgrades are always a two-step process. 1) Upload the files. 2) Run upgrade.php. Without both steps, the system will always fail.

[SD3]

I am on version 5.6.0.
I did the patch update first.
I just did the upgrade.php now.
My site now says this in the admin cp, Powered by vBulletin® Version 5.6.1 Patch Level 1 Copyright © 2020 MH Sub I, LLC dba vBulletin. All rights reserved..
My vb_user table does not have a location column in it. I feel like scripts were updated, but I am not sure my DB was updated. I do not recall seeing any errors during the upgrade.

Is a patch different than an upgrade? For example, should I have upgraded from 5.6.0 to become 5.6.1, or does applying a patch to 5.6.0 make it become 5.6.1? Because I did not do this... https://forum.vbulletin.com/forum/vb...e-for-download before applying the patch for 5.6.1. Maybe that's my problem with the vb_user table?

This is what my upgrade progress looks like.

[LIST][*][B]Processing XML[/B][*]Step 1 - Import latest options[*]Importing vbulletin-settings.xml[*]Import Done[*]Step 2 - Import latest admin help[*]Importing vbulletin-adminhelp.xml[*]Import Done[*]Step 3 - Import latest language[*]Importing vbulletin-language.xml[*]Import Done[*]Step 4 - Import latest widgets[*]Importing vbulletin-widgets.xml[*]Import Done[*]Step 5 - Importing vbulletin-screenlayouts.xml[*]Import Done[*]Step 6 - Importing vbulletin-pagetemplates.xml[*]Import Done[*]Step 7 - Importing vbulletin-pages.xml[*]Import Done[*]Step 8 - Importing vbulletin-channels.xml[*]Import Done[*]Step 9 - Importing vbulletin-routes.xml[*]Import Done[*]Step 10 - Skipping step, not needed[*]Step 11 - Updating vb_node table[*]Step 12 - Updating vb_node table[*]Step 13 - Updating product nativo[*]Product nativo has been updated but remains disabled[*]Updating product viglink[*]Product viglink has been updated but remains disabled[*]Updating product twitterlogin[*]Updating product googlelogin[*]Updating product vbfilescan[*]Step 13 - Process done[*]Step 14 - Verifying Product Dependencies[*]Step 15 - Importing vbulletin-style.xml[*]Template Group: Admin[*]Template Group: Article[*]Template Group: BB Code[*]Template Group: Blog[*]Template Group: Blog Admin[*]Template Group: Color[*]Template Group: Content Entry[*]Template Group: Conversation[*]Template Group: CSS[*]Template Group: Dialog[*]Template Group: Display[*]Template Group: Editor[*]Template Group: Error[*]Template Group: Group[*]Template Group: Human Verification[*]Template Group: Inline Moderation[*]Template Group: Link[*]Template Group: Login[*]Template Group: Media[*]Template Group: Member List[*]Template Group: Pagenav[*]Template Group: Photo[*]Template Group: vB Messenger[*]Template Group: Private Message[*]Template Group: Profile[*]Template Group: Screen Layout[*]Template Group: Search[*]Template Group: Group Admin[*]Template Group: Sprite[*]Template Group: Paid Subscription[*]Template Group: Subscription[*]Template Group: Tag[*]Template Group: Top Menu[*]Template Group: User Profile Field[*]Template Group: User Setting[*]Template Group: Video[*]Template Group: Module[*]Template Group: Ungrouped Templates 1[*]Template Group: Ungrouped Templates 2[*]Template Group: Ungrouped Templates 3[*]Template Group: Ungrouped Templates 4[*]Step 15 - Import Done[*]Step 16 - Import Styles[*]Template Group: CSS[*]Finished importing style 'Black Red'.[*]Template Group: CSS[*]Finished importing style 'Blue Green'.[*]Template Group: CSS[*]Finished importing style 'Blue Yellow'.[*]Template Group: CSS[*]Finished importing style 'Cool Blue'.[*]Template Group: CSS[*]Finished importing style 'Dark'.[*]Template Group: CSS[*]Finished importing style 'Denim'.[*]Template Group: CSS[*]Finished importing style 'Gradient'.[*]Template Group: CSS[*]Finished importing style 'Grey Stripes'.[*]Template Group: CSS[*]Finished importing style 'Grunge'.[*]Template Group: CSS[*]Finished importing style 'Light Blue'.[*]Template Group: CSS[*]Finished importing style 'Old School'.[*]Template Group: CSS[*]Finished importing style 'Orange Purple'.[*]Template Group: CSS[*]Finished importing style 'Pink'.[*]Template Group: CSS[*]Finished importing style 'Red'.[*]Template Group: CSS[*]Finished importing style 'Stripes'.[*]Template Group: CSS[*]Finished importing style 'Wood'.[*]Step 16 - Import Done[*]Step 17 - Resetting cache[*]Step 18 - Skipping step, not needed[*]Step 19 - Import the password schemes[*]Step 20 - Adding default notification category & type data.[*]Step 21 - Check for updated phrases.[*]Merge template changes[*]Processed 0 records starting at 0[*]Template merges complete. Rebuilding style information. This could take a while...[*]Step 22 - Merge template changes[*]Processing Complete[/LIST]

Status: Done

Thanks for any help.

[Wayne Luke]

Yes... If you are running 5.6.0, the patch for 5.6.1 will not work.

A Patch is very different from an upgrade. Patches are made for very specific versions and only works for the version they are made for. Patches only include code changes and are limited to usually fixing one specific issue. Generally only PHP code is updated and no changes are made to the database except in very dire circumstances.

Upgrades include hundreds of code (PHP, HTML, CSS, and Javascript) changes throughout the product. Code files are generally not interchangeable across versions. Upgrades will include new features, improvements and bug fixes. They often include database changes which is a primary reason that we have upgrade scripts. These upgrade scripts make sure the changes are applied to the database so the fields the code expects to find are actually found.

You will need to download the complete 5.6.1 PL1 package. Upload all 3,000+ files. Then run upgrade.php.

[SD3]

I got it all working now. I had to apply more than just a patch and now I am on 5.6.1 that includes patch level 1. Thanks for your help.