Icy Phoenix

Old Support Topics - A Few Questions About Icy Sitemap

Sarakin [ Fri 10 Apr, 2009 13:49 ]
Post subject: A Few Questions About Icy Sitemap

Well, now I'm trying to get some profit of the Icy automatic Sitemap feature, but have some doubts:

1 - It seems there's some issue with the album feature, which gives the following trouble

Code: [Hide] [Select]

Error getting pic information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY pic_id ASC LIMIT 1' at line 2

SELECT pic_id FROM foro_album WHERE pic_cat_id IN () ORDER BY pic_id ASC LIMIT 1

Line : 284

File : sitemap.php

I guess I remember something about this I did some time ago, but I can't remember what I did to solve this. Can anyone to refresh my memory?

2 - I've searched a bit and found a couple of Topics (here and here) where they say sitemap.php isn't read well by google, but it's also true those topics are so old, so I don't know if it's allright or not.

3 - As far as I understood, it seems the php file only generates the sitemap XML file, isn't it? So the only thing we've to do is upload it from time to time? Aren't there any way to make this automatic?

Greetings and thanks in advance!

Sarakin [ Wed 15 Apr, 2009 12:53 ]
Post subject: Re: A Few Questions About Icy Sitemap

Well, I'll answer to myself about the point 1 <- I had only to create a category on the Album menu of the ACP and worked fine.

But, concerning points 2 and 3, I'll leave this here as informative points:

2 - sitemap.php is read by google, it shows OK on the status and get the number of URL's submitted, what I don't know now is WHY it has indexed 0 URLs from it.
3 - I have another site working with a XML file Sitemap, which has got some URL's indexed (150 of 500) in the same time of the Icy one (about a week), so I'm beggining to wonder if generating a XML file manually from the php applications and upload it from time to time would be better...

Mighty Gorgon [ Sat 18 Apr, 2009 12:42 ]
Post subject: Re: A Few Questions About Icy Sitemap

It is really strange that Google couldn't read links from sitemap.php, it seems to work fine with my sites. :roll:

Sarakin [ Sat 18 Apr, 2009 15:17 ]
Post subject: Re: A Few Questions About Icy Sitemap

It reads it, because it shows an OK state and the number of URL's. What I can't understand is why it's indexing only 0 URL's :cry: Now I'm going to try to copy the xml on cache folder to my site's root and submit the XML file to see if the trouble is because of the php file :|

Nirose [ Mon 31 Aug, 2009 19:18 ]
Post subject: Re: A Few Questions About Icy Sitemap

you could just create a sitemap with online websites that offer to create a xml sitemaps. you just download and upload them. then the google will have no problem.

spydie [ Mon 31 Aug, 2009 20:18 ]
Post subject: Re: A Few Questions About Icy Sitemap

Sarakin wrote: [View Post]
It reads it, because it shows an OK state and the number of URL's. What I can't understand is why it's indexing only 0 URL's :cry: Now I'm going to try to copy the xml on cache folder to my site's root and submit the XML file to see if the trouble is because of the php file :|

Have you set the ACP SEO to give BOT´s reg access ??