SQLSTATE[42S02]: Base table or view not found: 1146

[outsch]

Hi,

I have without success searched for the topic, but not sure wqhether it might have been discussed somewhere.

When trying to install the Phoca Maps component (after having installed the respective plugin with Joomla stating successfule installation) I do receive the following warning:

Code: Select all

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DBNAME.wkm2_phocamaps_map' doesn't exist

and the error message:

Code: Select all

Error installing component

I understand that a table in the DB is missing, but shouldn't it be setup by the installation itself? Is there any solution for this?

[Jan]

Hmmm, hard to say as Phoca Maps does not install itself but it is installed by Joomla! extension manager. When you enable debug mode when installing, do you get there more information about this problem?

Jan

[Jan]

Which vesion do you try to install? Did you install e.g. the plugin too?

Jan

[outsch]

I tried to install the most recent Version, but currently on mobile only unable to Check. I did install the plugin before with Joomla Reportinger success.

[Jan]

So which versions (component/plugin) do you run now?

Jan

[outsch]

The Phoca Maps Control panel shows version 3.0.5. which is as well true for component and plugin.

[Jan]

Hi, try to reinstall the component, because this seems like the table was not installed when the component was installed by extension manager (if this will not help then I think, manual installation of the table needs to be done )

Jan

[outsch]

OK, practically no problem, but where do I get the table structure from in case I need to create it manually?

[Jan]

Hi, you can find it here:

administrator/components/com_phocamaps/install/sql/mysql/install.utf8.sql

Jan