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

outsch
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 25 Jan 2014, 23:09

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

Post by outsch » 12 Oct 2018, 14:23

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?


User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 12 Oct 2018, 18:22

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
If you find Phoca extensions useful, please support the project

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 12 Oct 2018, 20:47

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

Jan
If you find Phoca extensions useful, please support the project

outsch
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 25 Jan 2014, 23:09

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

Post by outsch » 12 Oct 2018, 21:41

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.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 15 Oct 2018, 12:22

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

Jan
If you find Phoca extensions useful, please support the project

outsch
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 25 Jan 2014, 23:09

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

Post by outsch » 15 Oct 2018, 13:33

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 15 Oct 2018, 17:36

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
If you find Phoca extensions useful, please support the project

outsch
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 25 Jan 2014, 23:09

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

Post by outsch » 15 Oct 2018, 18:08

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

Post Reply