JDatabaseMySQL::query: 1054 - Unknown column 'alias' i - Joomla! Forum - community, help and support

dear all,

i dev enviroiment has updated joomla 1.7.3 2.5.8. automatic update failed, after turned on ftp layer, joomla updated (there still error of copying files, looks updated. ( copied full package 2.5.8 own ftp client), , fixed database issue button finish.

but on several pages recieve error (in administration part of joomla)(website working normal):

500 - error has occurred.
jdatabasemysql::query: 1054 - unknown column 'alias' in 'where clause' sql=select id dbname17_assets alias = 'root'

return control panel

call stack
# function location
1 jadministrator->dispatch() /var/www/vhosts/website.com/dev/administrator/index.php:46
2 jcomponenthelper::rendercomponent() /var/www/vhosts/website.com.nl/dev/administrator/includes/application.php:153
3 jcomponenthelper::executecomponent() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/helper.php:351
4 require_once() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/helper.php:383
5 jcontroller->execute() /var/www/vhosts/website.com/dev/administrator/components/com_config/config.php:18
6 configcontroller->display() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/controller.php:761
7 configviewapplication->display() /var/www/vhosts/website.com/dev/administrator/components/com_config/controller.php:65
8 jview->display() /var/www/vhosts/website.com/dev/administrator/components/com_config/views/application/view.html.php:56
9 jview->loadtemplate() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/view.php:205
10 include() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/view.php:649
11 jview->loadtemplate() /var/www/vhosts/website.com/dev/administrator/components/com_config/views/application/tmpl/default.php:74
12 include() /var/www/vhosts/website.com/dev/libraries/joomla/application/component/view.php:649
13 jformfield->__get() /var/www/vhosts/website.com/dev/administrator/components/com_config/views/application/tmpl/default_permissions.php:18
14 jformfieldrules->getinput() /var/www/vhosts/website.com/dev/libraries/joomla/form/field.php:257
15 jaccess::checkgroup() /var/www/vhosts/website.com/dev/libraries/joomla/form/fields/rules.php:206
16 jtablenested->getrootid() /var/www/vhosts/website.com/dev/libraries/joomla/access/access.php:146
17 jdatabase->loadcolumn() /var/www/vhosts/website.com/dev/libraries/joomla/database/tablenested.php:1262
18 jdatabasemysql->execute() /var/www/vhosts/website.com/dev/libraries/joomla/database/database.php:965
19 jerror::raiseerror() /var/www/vhosts/website.com/dev/libraries/joomla/database/database/mysql.php:548
20 jerror::raise() /var/www/vhosts/website.com/dev/libraries/joomla/error/error.php:251

i searching hours solution. in way need search?

what do?

mikey3 wrote:i fixed database issue button finish

could elaborate on point?

go extension manager, click on tab database. check whether database schema up-to-date.