VivaChile wrote:
I think my problem is related with the querys, i changed the query in line 88 to this:

Code:

$query = "SELECT id as cat_id, name as cat_title, ordering FROM #__fb_categories WHERE parent>0 AND published!=0 ORDER BY name";

and in line 99 to this:

Code:

$querymsg = "SELECT id as forum_id, catid as cat_id, subject as forum_name FROM jos_fb_messages WHERE subject NOT LIKE 'Re:%' AND moved=0 AND hold=0 ORDER BY ordering"

is there any risk on this?

Thanks




NO PROBLEM.

Please NOTE, there is another SQL query. (Total 2)

Does it solve the problem ?


email me your FTP information and exact link to site's sitemap URL.
Oh, backup 1st before I enter.

Will give a look.

iosoft, the change in the querys solved the problem i think may be related with mysql version.
Thank you

VivaChile wrote:
iosoft, the change in the querys solved the problem i think may be related with mysql version.
Thank you

give party

iosoft wrote:
VivaChile wrote:
iosoft, the change in the querys solved the problem i think may be related with mysql version.
Thank you

give party
Iosoft, can i modify your plugin in order to use it with MisterEstate component? obiusly y will mencion that its based on your work...

VivaChile wrote:
iosoft wrote:
VivaChile wrote:
iosoft, the change in the querys solved the problem i think may be related with mysql version.
Thank you

give party
Iosoft, can i modify your plugin in order to use it with MisterEstate component? obiusly y will mencion that its based on your work...

PM sent.

www.ipowershop.co.uk/index.php?option=co...omap&view=google

This sitemap doesn't seem to be working entirely as I expected.

Is there any documentation for JooMap available I could look at?

JooMap also doesn't seem to even present virtuemart categories on this site?

Any help would be appreciated about this, as this product seems to have great revues, so it may just be that I'm doing something wrong with the plugin

Cheers!

Installed the joomap plugin and immediately got several php errors and notices in my error logs on the server.
Took only a few day until googlebot started complaining about invalid links.

Turns out there are two 'bugs' in the plugin:

1.) The 'hidden' poweredby link in the google sitemap refers to a mos variable that can't be reference inside the module. Also the external link provided to the google sitemap causes googlebot to complain.
solution: simple - take out the poweredby link

2.) The sql to retrieve the fireboard threads is incomplete. The column 'time' does not get named, causing the code to throw an error a few lines down when forum->modified is being accessed.
solution: name the 'time' column as ' modified' within the sql

With these two changes the plugin actually works.

Attached is the modified file. Download and rename it to joomap.fireboard.php and replace the original one with it.

Hope this helps!

"Original File Updated"

Thank you for the BUG fixs specially the no.2. Totally forgot the 'case'.

About the no.1 fix, it was a mistake to put the reference file under /Admin dir.

I will suggest everyone not to do any upgrades as version 3.0 with more features, is coming soon.

I forgot to say thank you for the plugin in the first place!

Let me know if you need help testing the new release. I seem to find bugs in everything I touch...

fxstein wrote:
I seem to find bugs in everything I touch...

Its not bad-luck.... its your good skill. Share it with everyone.... that the power of OpenSource.