Page 1 of 1

problem with install the phocamaps

Posted: 08 Jun 2011, 08:17
by Peguschwein
hello
i have install the com_phocamaps_v2.0.0.zip
I miss the database entries ? I find the Tread viewtopic.php?f=38&t=13487
and create manual the database-Table

then install the language file de-DE.com_phocamaps-j16.zip
with the error JInstaller: :Install: Cannot find XML setup file

i have copy the File with ftp

when i open the komponent phocamaps


500 - Es ist ein Fehler aufgetreten

Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

plase help my

Joomla 1.6.3

Best Regards Rene

Re: problem with install the phocamaps

Posted: 08 Jun 2011, 20:48
by liopardo
Same problem here, it's up to mysql errore syntax. Any advise?
Thanks
Fabio

Re: problem with install the phocamaps

Posted: 09 Jun 2011, 17:02
by Peguschwein
Hello
There is no problem of Phoca
by a migration I have general problems with the installation (database) :x

Best rgeards Pegu

Re: problem with install the phocamaps

Posted: 09 Jun 2011, 18:59
by liopardo
I got the same error that occours to Peguschwein, as I follewed his same step on install. Following a normal procedure, It installs the component regulary, but id doesn't create the 2 tables in mysql. It happens to me in a fresh 1.6.3 Joomla installation.
regards
Fabio

Re: problem with install the phocamaps

Posted: 26 Jul 2011, 20:24
by Jan
Hi, if the tables are not installed, they must be added manually, see the guide for Phoca Gallery, it is the same for all other extensions:

https://www.phoca.cz/documents/2-phoca-g ... em-solving
Jan