[SOLVED] RSS/Comments feature in header does not work due to database upload problem

alfie · #1 Dec 1, 2010, 10:29 AM

I am using Atahualpa and my problem is the following. You may note in the header, you may see two icons, one for an RSS feed list and the other for a comment list. I am using both an off line implementation using xampplite and an on-line presentation using my website (www.mydomain.com) – both should be identical When I operate off line the feeds operate perfectly and display what would be expected for an RSS and comment list. When I click on the same icons on-line instead of the lists I see urls www.mydomain.com and localhost references (probably left over from the off line version). Apparently when exporting the database and then importing to the host not all references to http://localhost/wordpress were converted to www.mydomain.com.

Initially when I followed the procedure of uploading the database I exported using phpmyadmin and followed by running an editor remove and replace operation. This resulted in a mysql error (which I was unable to resolve). When I discussed problem with the host they suggested merely changing the wp-options and wp-options-table using phpmyadmin. I was now able to import the database and everything seemed to be working identically to off-line. …That is until I clicked on the two icons in question. Apparently all reference to localhost were not changed. I now went back into phpmyadmin to look for a table that might contain the rss and comment lists --- could not find any. The best solution would have been to run a remove and replace as suggested in tutorials on uploading but that does not work

If anyone can make any suggestions it would be appreciated.

alfie · #2 Dec 6, 2010, 04:49 PM

I have a feeling that i didn't do a good job in explaining the problem. The rss and comment history must have been placed in database files where there is a mixture of http://www.mydomain.com/?p= ......... and http://localhost/wordpress/?p= If I knew where thes files were in mysql I possibly could edit them using phpmytadmin. I looked in the files and could not find such data. That is my problem, where is the post and comment history which needs to be converted to rss.

alfie · #3 Dec 7, 2010, 04:22 PM

In my previous comments I believed that the rss feed was being stored in a database and could be modified by phpmyadmin, however after some further search using google I now believe that is not the case. Writeup below which I copied from wordpress discusses possibility of an xml file being automatically derived and saved in the root. I was not able to find it? I hope this additional info will help someone to fill in the voids.

RSS, how it works?
The RSS system to publish articles and news over the web is very simple:
1. There are web pages, one wants to be displayed by other websites.
This set of pages is defined in an xml file which defines the the RSS feed. This file also contains the URL, title and summary of each page to display.
Does Wordpress automatically create this rss file and where does it save it ? I would need to know if I have to edit it. I have searched for such an xml file without success ?
2. To read the feed the provider computer uses an RSS reader or its browser.
3. If another website wants to display the feed. It first has to load the RSS file from the provider, extract the URL of pages, display titles and summaries. This may be performed by a special PHP script.
4. When someone visits the website of the receiver, the php script is launched, to recall the RSS file from the provider's website and display a list of news from extracted data.
5. By a click on a individual lines of the list, visitors display a page from the provider.

How browsers know there is an RSS feed on a website and where it is

You have created an RSS feed and it is now stored in the root of your website. You must let browsers know the existence of this file and its location, when they enter and display the home page (or any other page if you want). Firefox will display the feed icon into the URL field, Internet Explorer on the bar of commands.
To activate them, insert the following line into the source code of the page, anywhere inside the <head> </head> section:
<link rel="alternate" type="application/rss+xml" href="http://www.xul.fr/rss.xml" title="Your title">
Replace the URL by your domain name with the path and filename of your RSS feed.

alfie · #4 Dec 9, 2010, 02:16 PM

I've tried posting this problem under another title that may have discouraged other viewers. I've done a lot of googling and I've learned a lot about rss but i still don't have the solution to my problem.
Please read on ----- any suggestions would be appreciated.

I am using Atahualpa and my problem is the following. You may note in the header, an rss and comments icon, one for an RSS feed and the other for a comment list. I am using both an off line implementation using xampplite and an on-line presentation using my website (www.mydomain.com) – both should be identical When I operate off line the default feed operates perfectly and displays what would be expected. When I click on the same icons on-line instead of the rss feed I see the following :

These are typical lines representing each post in the feeds

http://www.mydomain.com/?p=429
http://www.mydomain.com/?p=429#comments Thu, 02 Dec 2010 17:06:09 +0000 authors name http://www.mydomain.com/?p=429 http://www.fromoneseniortoanother.com/?feed=rss2&p=429 0

http://www.mydomain.com/?p=365
http://www.mydomain.com/?p=365#comments Wed, 11 Aug 2010 19:00:45 +0000 unknown http://localhost/wordpress/?p=365 http://www.mydomain.com/?feed=rss2&p=365 0

Note that the first post snippet was on-line on Dec 2 but the second took place while I was still off line on Aug 11. In addition while I was offline my host was localhost and somehow this history was not removed when I uploaded the off-line version to the on-line host. I believe that the appearance of localhost may be the cause of this problem.

So I thought this can be simply fixed by finding the file in which this exists and delete localhost references. But what is this file, I have searched through the databases using phpmyadmin and the source code (and files) using FTP; I have not found any such reference??

So what am I to think, the feeds are being generated dynamically and routed through the browser? If this was true there would be no rss feed file. However the post data must be somewhere, the only place that I can think of is the admin panel. I looked through the posts in the admin panel but it appeared that the references to local host had been changed to http://www.mydomain.com.

I hope I have explained the problem adequetly, If anybody has any suggestions it would be appreciated.

alfie · #5 Dec 20, 2010, 01:38 PM

STB

Somehow we seem to misunderstand eachother. If I'm at fault, please forgive me if I do not understand. My question is merely that there are leftover references to localhost from my offline version. I would like to find them and remove them (on line). Apparently they are not in the database. Where are they? How can I remove them?

I believe the rss control program sees localhost and instead of displaying the rss list outputs the data which I showed above.

I realize it must be confusing - if you re-read it I'm sure that you will understand.

juggledad · #6 Dec 20, 2010, 02:12 PM

rss feeds are stored in the database using the fully qualified url at the time they are entered. If you move a site to a new URL, you have to edit the SQL before import and do a global change of the old url to the new url.

juggledad · #7 Dec 21, 2010, 05:24 AM

Actually I was referring to the transient rss entries that are stored in the wp-options table.

alfie · #8 Dec 25, 2010, 01:01 PM

I want to thank you feelows for trying to help me. The comments on GUID by STB did help since I saw GUID in wp_posts in the database using phpmyadmin. I noted many references to localhost (which is in the off-line version) Of course i could not edit wp-posts but i did go ionto the database base after exporting and I performed a find and replace on localhost/wordpress and changed it to www.mydomain.com. In addition I found that the Host was partially involved and they made a fix taking me rfrom the free version to paid version which finally solved the rss problem as well as admin panel and plugin problems.

Hope this dialogue is able to help others,

Alfie