Friday, 31 October 2014 11:32
beggarly

Sitemap won't produce full xml file

An open forum for opinions and general questions

Sitemap won't produce full xml file

Postby gwbyrd » Thu Jun 26, 2008 3:40 am

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 :)
Last edited by gwbyrd on Thu Jan 01, 1970 12:00 am, edited 65535 times in total.
Reason: 1
gwbyrd
Fresh Boarder
Fresh Boarder
 
Posts: 2
Joined: Thu Jun 26, 2008 4:25 am

Re:Sitemap won't produce full xml file

Postby mulrich » Thu Jun 26, 2008 3:43 pm

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
Last edited by mulrich on Thu Jan 01, 1970 12:00 am, edited 65535 times in total.
Reason: 1
mulrich
Junior Boarder
Junior Boarder
 
Posts: 23
Joined: Sun Nov 18, 2007 12:34 pm

Re:Sitemap won't produce full xml file

Postby gwbyrd » Thu Jun 26, 2008 3:54 pm

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 :)
gwbyrd
Fresh Boarder
Fresh Boarder
 
Posts: 2
Joined: Thu Jun 26, 2008 4:25 am

Re:Sitemap won't produce full xml file

Postby mulrich » Thu Jun 26, 2008 4:46 pm

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
mulrich
Junior Boarder
Junior Boarder
 
Posts: 23
Joined: Sun Nov 18, 2007 12:34 pm

Re:Sitemap won't produce full xml file

Postby guilleva » Thu Jun 26, 2008 6:37 pm

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.
User avatar
guilleva
Administrator
Administrator
 
Posts: 1527
Joined: Wed Sep 12, 2007 3:10 am
Location: San José, Costa Rica


Return to General



Who is online

Users browsing this forum: Bing [Bot], Google Adsense [Bot], Yahoo [Bot] and 1 guest