3.51 update error - Joomla! Forum - community, help and support

upgrading 3.5 , got database error 'fix' not resolve.


error
table 'xxx.#__banners' doesn't exist sql=show columns in `#__banners` field = 'created_by'
table 'xxx.#__banners' doesn't exist sql=show columns in `#__banners` field = 'created_by_alias'
table 'xxx.#__banners' doesn't exist sql=show columns in `#__banners` field = 'modified'
table 'xxx.#__banners' doesn't exist sql=show columns in `#__banners` field = 'modified_by'
table 'xxx.#__banners' doesn't exist sql=show columns in `#__banners` field = 'version'



leading to

1146 table 'xxxxxxxxx.#__banners' doesn't exist sql=alter table `#__banners` add column `created_by` int(10) unsigned not null default '0';


how worried should be?

i not use banner component.

bins_uk wrote:i not use banner component.

does mean uninstalled banner component?

if yes, above errors normal.

the reason banner component core component, i.e. has not been decoupled yet joomla! core. weblinks has been decoupled now.

such core components not protected, can uninstall them, when doing joomla! update, there sql scripts database schema changes applied, , banner component fail, , database checker cannot execute check queries because tables not exist.

see several meanwhile closed issues in joomla! cms issue tracker regarding diverse core components official maintainers explain this.

am sure here in forum several cases reported , discussed.

solution: extract joomla! 3.5.1 files joomla! folder, files uninstalled banner component come back, , go "extensions -> manage -> discover" , discover uninstalled presetn extensions. select core extensions (i.e. coming joomla! itself, there should @ least banner component found) , install it/them, , goto plugins manager , deactivate plugins belonging unwanted extensions if there some, not uninstall extensions.