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

Phoca Maps - displaying maps in Joomla! CMS
outsch
Phoca Member
Phoca Member
Posts: 12
Joined: 25 Jan 2014, 23:09

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

Post 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?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post 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
If you find Phoca extensions useful, please support the project
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

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 Member
Phoca Member
Posts: 12
Joined: 25 Jan 2014, 23:09

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

Post 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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
outsch
Phoca Member
Phoca Member
Posts: 12
Joined: 25 Jan 2014, 23:09

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

Post by outsch »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post 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
If you find Phoca extensions useful, please support the project
outsch
Phoca Member
Phoca Member
Posts: 12
Joined: 25 Jan 2014, 23:09

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

Post by outsch »

OK, practically no problem, but where do I get the table structure from in case I need to create it manually?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

Hi, you can find it here:

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

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