Sitemap won't produce full xml file

[gwbyrd]

Hello,

I am running Joomla 1.0.15 upgraded via patch from 1.0.12 on GoDaddy.com shared hosting. I'm using MySQL 4.0.27 and PHP 5.2.5 and apache 1.3. I'm also using sh404SEF v1.3.4_288 component.

I've installed the XMap component, and it was working fine until I added a large number of records (over 4,000) to my jos_content table. I added the records via php script, but Joomla seems to have no problem displaying any of them on the front end.

I've been trying to submit a sitemap to Google and it is continually giving me error messages about the XML file. The exact error I'm getting (on Firefox) is:

"XML Parsing Error: no element found
Location: http://makeitgreatrealestate.com/component/option,com_xmap/no_html,1/sitemap,1/view,xml/
Line Number 3887, Column 1:"

Each time I run the sitemap, however, the Line Number changes. I actually have 4,500+ records in my jos_content table. When I run the sitemap in Internet Explorer, it displays part of the file and at the bottoms says "The XML page cannot be displayed. The following tags were not closed: urlset. Error processing resource: 'http://....."

Does anyone know what might be causing this problem or how to work around or fix it? My website is new and I'd really like to have a full sitemap submitted to Google, but this is proving quite difficult :(

UPDATE: I just disabled the sh404SEF component and it generated the sitemap very quickly without any problems. Anyone know why the two components may be having trouble working together with a large database? Any suggestions on how to fix? I definitely want Google to index my SEF links because my SEFs have keywords in them that the default Joomla SEFs don't.

Thanks!

George :)

[mulrich]

Hi
Verify what's happen, with the

Line Number 3887, Column 1:"

somebody (i don't remember, sorryyyy) in this forum, have found the work around to see the content of the line, try in your browser, "source code of the page".

Look in the SH404 admin panel, and/or with PHP MyAdmin in the xxx_redirection table,
Good luck
Michael

[gwbyrd]

Hi mulrich,

I opened the file in Internet Explorer and saved a copy to my hard drive and opened it with a text editor. The file looks fine, except after an unpredictable number of rows, the file suddenly stops. The error is "unclosed <URLSET>". Basically, the sitemap was being generated fine and then suddenly stopped. I'm having to assume either the script is crashing for some reason or it is timing out.

I'm trying to use external sitemap generators for the time being. I mean, if they work, anyway, why do I need one in Joomla? Still, I'd love to figure out this problem.

Thanks!

George :)

[mulrich]

take the last line and open with PHPMyAdmin the table jos_redirection in your database
the table description is

Code: Select all


id      int(11)                  
cpt    int(11)            
rank    int(11)            
oldurl    varchar(255)            
newurl    varchar(255)            
dateadd    date


oldurl is your SEF URL
newurl is the Joola URL

search for your "oldurl" and his 'newurl" and then look for all other sames "newurl".
some errors which I know now,
- strange caracters in the oldurl
- problems with a lot of sames newurls. Par exemple: When you rename a title of content or image SH404 remember the old SEF URL, and created a new SEF URL, (in some case?) i've found that XMap take the first record, in this case, the old SEF URL. When you delete this record it's work; But it's only a exemple, you must take a look in the data.

When you know the components which created the problem you have made another step forward.

Michael

[guilleva]

George, please try incrementing the max execution time in your php settings. Also, tell me if you see any error in your php error log.