RSS Error [Archive]

View Full Version : RSS Error

brabago

01-23-2007, 01:20 PM

Hello I'AM getting this error when I Click on the subscribe rss button

Fatal error: Cannot access empty property in /home/xxxxx/xxxxx/xxxxx.com/xxxxx/components/com_fabrik/fabrik_table.class.php on line 2673

any ideas how to fix it

echologic

01-24-2007, 01:26 PM

brabago,

Are you still getting this error with the upgraded version?

-Graylan

brabago

01-24-2007, 01:31 PM

yes just tested still getting error

echologic

01-24-2007, 01:34 PM

Ok, we will look into it

-Graylan

brabago

01-24-2007, 01:40 PM

Great thanks !!

echologic

01-24-2007, 01:51 PM

brabago,

Can you please give us the details of the process you are going through to get this error? For example: what button are you selecting - is it on your site or the Fabrik site? If it's on your site - what have you selected to RSS?

Thanks,
-Graylan

rob

01-24-2007, 06:00 PM

Hi

Also an example url would be great, I think it must be something specific to your set up, as the RSS link on this site's blog seems to work ok.
Could you try, in turn, editing all of your table's elements and turning off their "show in RSS feed" setting (under the publishing tab). Each time you edit an element re-check the rss feed to see if you still get the error. This should narrow down whether there is one specific element's data which is causing the problem

Cheers
Rob

brabago

01-24-2007, 06:25 PM

Well I selected the rss feed in the form in the back-end of through fabrik so if you do not mind me sending you the url via e-mail becuase it is password protected that way you can see what is going on so if this is okay let me know what e-mail to send it to thanks in advance.

Regards,
Brabago

rob

01-24-2007, 06:36 PM

please - could you send me a personal message on the forum?
Also a screen shot of the page where you are clicking on the rss feed link would be great, as I'm unsure that the rss feed link should be showing in the admin form

Cheers
Rob

brabago

01-26-2007, 01:02 PM

Hello Rob just checking to see if you had time to check into the RSS Error thanks in advance.

Regards,
brabago

rob

01-26-2007, 05:03 PM

Hi brabago

Just taken a look, I think the issue is that you don't have a primary key defined for the table. Primary keys are unique references for each record in your table.

To fix this (presuming that you created everything from within Fabrik):

edit the table an under the data tab select "fabrik_internal_id" from the "Primary Key" drop down
Also check that "Auto Incrementing Key" is checked

Let me know if that works
Rob

brabago

01-27-2007, 01:35 PM

That did the trick ;D thanks for the help know when I click on subcribe to rss I get an xml file to downlaod or I right click on it to copy link location I tried feeding into my rss reader but would not read it I'am I missing a step? also I see that there are two options for selecting

Column to use for feed title
Column to use for feed dates

are these the only options we need whcih I have picked or can we add more options? once again thanks for the great support :)

rob

01-27-2007, 02:39 PM

For each element you want to show in the feed you need to edit the element

Then under the publishing tab, in the "rss options" section you need to turn on "Show in RSS feed"

Cheers
Rob

brabago

01-27-2007, 05:19 PM

Okay I almost there when I right click to save link location I get this url

http://www.xxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48

which does not work in an rss reader how do I get a url that is readable by a rss reader thanks in advance

Regards,
brabago

rob

01-27-2007, 05:52 PM

any chance you can post the source code of that page?

brabago

01-27-2007, 05:57 PM

Hmm you got me on that one do not quite understand were would I grab the source code for that page you mean the page that has the rss button?

brabago

01-27-2007, 06:13 PM

hmm I don't quite understand that were can I find the code for that page ?

rob

01-29-2007, 08:30 AM

Hi

I meant, that when you click on http://www.xxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48
and a page is rendered what html source code is rendering on this page. e.g in Firefox press ctrl+u to see the source, and in IE select "view->source code" from the top menu

Cheers
Rob

brabago

01-29-2007, 11:17 AM

This is what I got thanks in advance.

</script>

<h1>Rentals</h1>
<p></p>
<form action="index.php" method="post" id="fabriktable" name="fabriktable">

<span class="pagenav">

<a href="http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&tableid=1&rowid=">Add Listing</a>
</span>

<span class="pagenav">
<a href="index2.php?option=com_fabrik&no_html=1&task=tableF eed&tableid=1&Itemid=48">Subscribe RSS</a>
</span>

<table class="filtertable" style="float:right;width:200px;border:1px solid #cccccc;" cellpadding="5" cellspacing="0">
<tr style="background-color:#cccccc;font-weight:bold;">
<th colspan="2" style="text-align:left">Search:</th>
</tr>

<tr>
<td>locationjob</td>
<td style="text-align:right;">

<select name="locationjob[value]" class="inputbox" size="1" onchange="submitfabrikTable('filter');">
<option value="" selected="selected">Please Select</option>
<option value="585">585</option>
<option value="686">686</option>
</select>

<input type='hidden' name='locationjob[type]' value='dropdown' />

<input type='hidden' name='locationjob[match]' value='0' />

<input type='hidden' name='locationjob[full_words_only]' value='0' />

</td>
</tr>

<tr>
<td colspan="2" style="text-align:right;">

</td>
</tr>
</table>

<br style="clear:both;" />
<br />





<h1></h1>
<table width="100%" style="width:100%;border:1px solid #cccccc;" cellpadding="5" cellspacing="0" class="mfDataTable">
<tr style="background-color:#cccccc;font-weight:bold;">

<th style="text-align:left">equipment</th>

<th style="text-align:left">year</th>

<th style="text-align:left">description</th>

<th style="text-align:left">dateonsite</th>

<th style="text-align:left">datedueback</th>

<th style="text-align:left">companyrentedfrom</th>

<th style="text-align:left"><a href='javascript:fabrikNavOrder("addrental.locationjob", "asc")'>locationjob</a></th>

<th style="text-align:left">Edit</th>

</tr>


<tr class="oddrow1">

<td>test55</td>

<td>2005</td>

<td>test55 wide</td>

<td>2007-01-27</td>

<td>2007-01-31</td>

<td>hertz</td>

<td>585</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=test55&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow0">

<td>Rental</td>

<td>2006</td>

<td>Rental 555</td>

<td>2007-01-24</td>

<td>2007-01-31</td>

<td>HERTZ</td>

<td>686</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=Rental&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow1">

<td>Yellow</td>

<td>2005</td>

<td>YELLOW TRUCK</td>

<td>2007-01-24</td>

<td>2007-01-26</td>

<td>HERTZ</td>

<td>585</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=Yellow&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow0">

<td>What</td>

<td>2005</td>

<td>what about</td>

<td>2007-01-24</td>

<td>2007-01-26</td>

<td>UNITED</td>

<td>686</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=What&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow1">

<td>Roller</td>

<td>2007</td>

<td>Blue Roller</td>

<td>2007-01-22</td>

<td>2007-01-26</td>

<td>HERTZ</td>

<td>585</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=Roller&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow0">

<td>EXCAVATOR2</td>

<td>2006</td>

<td>Big excavator</td>

<td>2006-12-05</td>

<td>2007-01-16</td>

<td>HERTZ</td>

<td>585</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=EXCAVATOR2&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow1">

<td>early55</td>

<td>2007</td>

<td>early 55 pick up</td>

<td>2007-01-28</td>

<td>2007-01-31</td>

<td>hertz</td>

<td>585</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=early55&tableid=1'>edit</a></td>

</tr>


<tr class="oddrow0">

<td>big25</td>

<td>2007</td>

<td>big27 roller</td>

<td>2007-01-27</td>

<td>2007-01-31</td>

<td>united</td>

<td>686</td>

<td><a href='http://www.marshgo.com/online/index.php?option=com_fabrik&task=viewForm&Itemid=4 8&fabrik=1&rowid=big25&tableid=1'>edit</a></td>

</tr>


<tr>

<td><strong></strong></td>

<td><strong></strong></td>

<td><strong></strong></td>

<td><strong></strong></td>

<td><strong></strong></td>

<td><strong></strong></td>

<td><strong></strong></td>

</tr>
</table>

<div style="text-align:center;margin:auto;">

<table class="adminlist"><tr><th>
<span class="pagenav">
<<Start </span>

<span class="pagenav">
<Previous </span>

<span class="pagenav">1</span> <span class="pagenav">
Next> </span>
<span class="pagenav">
Last>></span>
</th</tr><tr><td style="text-align:center;">Display #
<select name="limit" class="inputbox" size="1" onchange="fabrikNavLimit(this.options[this.selectedIndex].value);">
<option value="5">5</option>

<option value="10" selected="selected">10</option>
<option value="15">15</option>
<option value="20">20</option>
<option value="25">25</option>
<option value="30">30</option>
<option value="50">50</option>

</select>
Results 0 to 8 of 8</td></tr></table>
</div>

<input type="hidden" name="option" value="com_fabrik" id="option" />

<input type="hidden" name="orderdir" value="" id="orderdir" />

<input type="hidden" name="orderby" value="" id="orderby" />

<input type="hidden" name="tableid" value="1" id="tableid" />

<input type="hidden" name="Itemid" value="48" id="Itemid" />

<input type="hidden" name="pagelimit" value="10" id="pagelimit" />

<input type="hidden" name="limitstart" value="0" id="limitstart" />

<input type="hidden" name="task" value="viewTable" id="task" />

<input type="hidden" name="pageURL" value="option=com_fabrik&task=viewTable&tableid=1&Itemid= 48" id="pageURL" />

</form>

</td>
</tr>
</table>

</td>

</tr>
</table>
</div>

</div>
</td>
</tr>
</table>
</div>
<div align="center">
© 2007 Inc.</div>

<div align="center">

</div></body>
</html>

rob

01-29-2007, 11:50 AM

Ah I think I know what it is, your feed reader hasnt logged into the website so you're getting redirected to the "your not authorised to view this" page.
Could you try allowing access to the table page without having to login and then try the feed?

Cheers
Rob

brabago

01-29-2007, 12:45 PM

I allowed acces to that page but what is confusing me is when I click on the subscribe to rss button that fabrik produces in table view
I get this link http://www.xxxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48

shouldn't I get a link with rss at the end or xml so that the reader can consume it thanks in advance.

Regards,
brabago

rob

01-29-2007, 01:46 PM

that link will generate a rss feed for you. The link calls a fabrik page which queries the database and returns an xml file

Cheers
Rob

brabago

01-31-2007, 11:11 AM

Hello well it does produce an xml file which I able to download but shouldn't it work like the joomla syndication on the front page were you click on the say 2.0 button up pops the xml scema then you grab the url from the browser pump that into the reader and wala you have your live feed. But I get this http://www.xxxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48
and when I download the xml page it produces there is no url I can put in a reader so I guess what I'am looking for is a valid url I can put in a rss reader thanks for your time appreciate it.

Regards,
brabago

rob

01-31-2007, 12:16 PM

you can put that url in as the url for the feed

Cheers
Rob

brabago

01-31-2007, 01:17 PM

Hello Rob thanks for putting up with all these question when I download the xml it produces this is the name it gives it addrental.xml
but when I have it open up in a browser I get this url

http://www.xxxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48 and when I put that url in the reader I get no rss url feed found error so I 'am missing something ?

rob

01-31-2007, 01:51 PM

what reader are you using? I use firefox & newsgator and both accept these types of urls
Could you post a link to your feed so I can see if your reader is the problem.
For me I click on the "rss feed link" - (ie http://www.xxxxxxx.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48 ) it shows me an xml page with the feed details and I then use a bookmarklet to post that page to newsgator.

brabago

01-31-2007, 04:19 PM

I tested it out in google reader and newsgator online and I get this Error: Subscription could not be added. Please check the URL and try again. So I'am going a bit crazy here what the heck I'am I doing wrong? here is the url http://www.marshgo.com/online/index2.php?option=com_fabrik&no_html=1&task=tableFeed&tableid=1&Itemid=48

rob

01-31-2007, 04:28 PM

I get

You are not authorized to view this resource.
You need to login.

when i click on the link, thats probably your problem - the rss reader deosnt have access rights to the feed

brabago

01-31-2007, 05:53 PM

well logged in and still get error that it is not a valid feed hmmmmmmmmm :-\ what can I try next

rob

02-01-2007, 07:15 AM

can you pm me a login to the site?

rob

02-02-2007, 12:33 PM

Hi
The link pointing to the feed was set to be visible to registered users only, so when the reader tries to access it it couldnt. I changed the link to be public and i can now read the feed in google reader & newsgator

brabago

02-02-2007, 12:56 PM

thank you thank you thank you ;D sweet really appreciate it know on to my next project all I can say this is great customer service becuase I must of asked about hundred questions and you guys didn't run away and hide sweet have a good one and you probalby be hearing from me again as I tackle my next project ;D

rob

02-02-2007, 01:13 PM

hehe - quick where's the kitchen table! :D

brabago

02-03-2007, 01:05 PM

Yupp me again well everything is working but after the update to 1.02 my rss feed is inserting dates from 1969 take a look at this but in the database dates are correct and I can see you behind the kitchen table ;D thanks in advance appreciate it

5:57 AM (seconds ago)

equipment
another test
description
another test
dateonsite
1969-12-31------this is what I'am talking about
datedueback
1969-12-31----------these dates
companyrentedfrom
united
locationjob

brabago

02-05-2007, 04:05 PM

Any luck Rob on the date issue ;D An whats this I hear about plug-ins :o thanks in advance

equipment
another test
description
another test
dateonsite
1969-12-31------this is what I'am talking about
datedueback
1969-12-31----------these dates
companyrentedfrom
united
locationjob

echologic

02-05-2007, 04:15 PM

Hi branago,

While I'm not sure of this, I think you may have installed version 1.0.2 when it was first posted. We had to take it down and fix some errors and then repost it. You may want to re-install 1.0.2.

Cheers,
-Graylan King

brabago

02-05-2007, 04:50 PM

okay will give it a go thanks in advance

brabago

02-06-2007, 01:10 AM

Well Downloaded again and updated but still get the rss feed with the 1969 year .any Ideas what is causing this?Thanks in advance

equipment
night test
description
night test
dateonsite
1969-12-31 ----------same results
datedueback
1969-12-31 ----------

rob

02-08-2007, 10:13 AM

Hi

OK this is a bug in the code, please download the patch from

http://www.fabrikar.com/patches/com_fabrik_1.0.2-patch-d-rssdateformat.zip

Plugins are going to be part of Fabrik 2.0a. The idea is that you can install / uninstall extra element types for use in your forms. (Think sliders, capatchas, country lists, state lists etc).
Its taking up quite a bit of my time at the moment decoupling the logic from fabrik into the plugins but I would say that I'm 80% there. Hoping to release something in the next couple of days

Cheers
Rob

brabago

02-09-2007, 11:14 AM

Loaded the patch and all is working ;D thanks a bunch keep up the good work !!!!!!!