joomla-extensions / weblinks

This repo is meant to hold the decoupled com_weblinks component and related code.
GNU General Public License v2.0
45 stars 88 forks source link

JInstaller: :Install: Error SQL Table 'foo_weblinks' doesn't exist #501

Closed grantiago closed 2 years ago

grantiago commented 2 years ago

error Table 'foo_weblinks' doesn't exist

JInstaller: :Install: Error SQL Table 'xxx_weblinks' doesn't exist

after updating from joomla 3 to joomla 4. all running as expected.

notification to upgrade weblinks through the joomla updater. error

I also tried a fresh install from the zip file pkg-weblinks-4.0.1.zip

same error

Weblinks Extension Package Joomla! installed 3.9.0 -- available 4.0.1 the foo_extensions table; name | type| element

mod_weblinks | module | mod_weblinks

plg_search_weblinks | plugin | weblinks

plg_finder_weblinks | plugin | weblinks

pkg_weblinks | package | pkg_weblinks

plg_system_weblinks | plugin | weblinks

plg_editors-xtd_weblink | plugin | weblink

Expected result - update success

Actual result JInstaller: :Install: Error SQL Table 'xxx_weblinks' doesn't exist

Extension installation aborted. Package Update: There was an error installing an extension: com_weblinks.zip

System information (as much as possible)

in the database maintenance: Table 'foo.gja12_weblinks' doesn't exist × Warning There are tables not up to date! com_weblinksCOM_WEBLINKS_XML_DESCRIPTION | Administrator | Component | One Problem

Database Type | mysql Database Version 5.7.38-0ubuntu0.18.04.1-log collation utf8_general_ci utf8mb4_general_ci php version: 7.4.30 Joomla! 4.1.5 Stable [ Kuamini ] 21-June-2022 14:00 GMT Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36

Additional comments.

just updated from j3 to j4. I didn't, don't remember, removing those tables. shouldn't there be an if doesn't exist create in the sql statement?

grantiago commented 2 years ago

Never mind. I fixed it by copying the table from another joomla install.