Page 1 of 1

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

Posted: 12 Oct 2018, 14:23
by 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?

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

Posted: 12 Oct 2018, 18:22
by 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

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

Posted: 12 Oct 2018, 20:47
by Jan
Which vesion do you try to install? Did you install e.g. the plugin too?

Jan

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

Posted: 12 Oct 2018, 21:41
by 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.

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

Posted: 15 Oct 2018, 12:22
by Jan
So which versions (component/plugin) do you run now?

Jan

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

Posted: 15 Oct 2018, 13:33
by outsch
The Phoca Maps Control panel shows version 3.0.5. which is as well true for component and plugin.

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

Posted: 15 Oct 2018, 17:36
by 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 :idea: )

Jan

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

Posted: 15 Oct 2018, 18:08
by outsch
OK, practically no problem, but where do I get the table structure from in case I need to create it manually?

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

Posted: 24 Oct 2018, 13:48
by Jan
Hi, you can find it here:

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

Jan