Search shoppers - SQL error / VirtueMart 3.8.4 10335

Started by vmfyelloq19, July 03, 2020, 13:38:37 PM

Previous topic - Next topic

vmfyelloq19

Hi folks,

when I use the search field on
.../administrator/index.php?option=com_virtuemart&view=user

1054 Unknown column 'ui.name' in 'field list'
/htdocs/libraries/joomla/database/driver/mysqli.php:665
Call stack
#   Function   Location
1   ()   JROOT/libraries/joomla/database/driver/mysqli.php:665
2   JDatabaseDriverMysqli->execute()   JROOT/libraries/joomla/database/driver.php:1701
3   JDatabaseDriver->loadObjectList()   JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868
4   VmModel->exeSortSearchListQuery()   JROOT/administrator/components/com_virtuemart/models/user.php:1649
5   VirtueMartModelUser->getUserList()   JROOT/administrator/components/com_virtuemart/views/user/view.html.php:232
6   VirtuemartViewUser->display()   JROOT/administrator/components/com_virtuemart/helpers/vmcontroller.php:121
7   VmController->display()   JROOT/libraries/src/MVC/Controller/BaseController.php:710
8   Joomla\CMS\MVC\Controller\BaseController->execute()   JROOT/administrator/components/com_virtuemart/virtuemart.php:76
9   require_once()   JROOT/libraries/src/Component/ComponentHelper.php:402
10   Joomla\CMS\Component\ComponentHelper::executeComponent()   JROOT/libraries/src/Component/ComponentHelper.php:377
11   Joomla\CMS\Component\ComponentHelper::renderComponent()   JROOT/libraries/src/Application/AdministratorApplication.php:101
12   Joomla\CMS\Application\AdministratorApplication->dispatch()   JROOT/libraries/src/Application/AdministratorApplication.php:159
13   Joomla\CMS\Application\AdministratorApplication->doExecute()   JROOT/libraries/src/Application/CMSApplication.php:196
14   Joomla\CMS\Application\CMSApplication->execute()

Latest VirtueMart 3.8.4 10335

Same happens when I try to sort customers.

Anything I can do about this?

TIA

AH

Yes you could change


if($this->searchTable!='juser'){
$select .= ' , ui.name as uiname ';
}


to


if($this->searchTable!='juser'){
$select .= ' , ui.* ';
}




Regards
A

Joomla 3.10.11
php 8.0

vmfyelloq19

Hello AH,

happen to have at hand where that change needs to go?
And wouldn't that (I suppose) be a core change that would overwritten with the next update?

TIA

AH

QuoteHello AH,

happen to have at hand where that change needs to go?
And wouldn't that (I suppose) be a core change that would overwritten with the next update?

TIA

It goes in the user model:

administrator/components/com_virtuemart/models/user.php

Yes - it will get overwritten - but I will report to the team!
Regards
A

Joomla 3.10.11
php 8.0


Milbo

Quote from: AH on July 03, 2020, 14:26:59 PM
Yes you could change


if($this->searchTable!='juser'){
$select .= ' , ui.name as uiname ';
}


to


if($this->searchTable!='juser'){
$select .= ' , ui.* ';
}



I doubt that will work, just remove it.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

AH

It works :-)

The reason seems to be that the name field is not created in the vm_userinfos table

I have no idea why it is not there or how to fix it (other than a manual intervention)

The ui.*  will function fine
Regards
A

Joomla 3.10.11
php 8.0