sql problem with Phoca Maps

[arkoudaki]

I keep getting this msg when i'm in the Markers area:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/abcde/public_html/abcde.gr/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/abcde/public_html/abcde.gr/libraries/joomla/database/database/mysql.php on line 344

Warning: array_unshift() [function.array-unshift]: The first argument should be an array in /home/abcde/public_html/abcde.gr/administrator/components/com_phocamaps/views/phocamapsmarkers/view.html.php on line 57

Warning: Invalid argument supplied for foreach() in /home/abcde/public_html/abcde.gr/libraries/joomla/html/html/select.php on line 68



and i get the following message when i'm in the maps area:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/abcde/public_html/abcde.gr/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/abcde/public_html/abcde.gr/libraries/joomla/database/database/mysql.php on line 344


Any idea what i could do to get rid of them?


Also... i cannot get the markers to show up in the map unless i do a search for the street road .. and then i get one marker alone.


COUld you please help me out?

Thank you in advance

Samantha

[Jan]

Hi, see your database, it seems like the tables were not installed. If you don't find the tables for Phoca Maps, see install.bak file in ZIP installation file and try to add them manually (as SQL queries, e.g. via phpMyAdmin)

Jan

[morten44]

Hi
THis is how i solved it:
1. open my folder \administrator\components\com_phocamaps
2. Local "install.back" and open in notepad
3. All tables name will be like- #__phocamaps_map
4. In notepad i did a "edit --> Replace"
I replaced #__ with jos_ (jos is my default pre name in mysql)
Be aware that the # has 2 underscore so replace that with jos with one underscore

5. I then saved it the file on my desktop as "install.sql". type the "" as well when saving so it change the extention from .bak to .sql

6. Now open your sql editor /phpmyadmin. Highlight the database for your joomla site.
7. Locate the script on your desktop and execute it
It should say "Import has been successfully finished, 4 queries executed."

8 It now works for me

My big problem was that I did not see that in the file name there where 2 underscore after # so my first search and replace i just wrote "find # and replate with jos". Correct is "find #__ and replace with jos_"

Regards
Morten

[Benno]

Well done Morten!
Kind regards,
Benno