RSS url field is too short for my needs

[Pidea]

I'm trying to add a very long RSS URL from eBay. The current RSS_URL field is set to VARCHAR(255). It looks like my only option is to change this to a TEXT field in the database which isn't ideal but it's not possible to have a longer VARCHAR field in MySQL.

I've made the necessary changes to the templates but I've run into problems with the includes/tables.php file. Presumably to ensure that the right data type goes into the database I need to modify this file but I'm not sure how or what to change the RSS_URL value to.

Any ideas ?

[Dimitry]

Pidea

For this you need to do next things:

1. Alter field type in PLD_RSS_FEED table for RSS_URL field, set "TEXT" type (instead of "VARCHAR(255)").
2. Edit file "include/tables.php", find following line (~72 line):
Content visible to registered users only.
3. Replace it with next code:
Content visible to registered users only.
4. Edit file "templates/admin/rss_feeds_edit.tpl", find following line (~24 line):
Content visible to registered users only.
5. Replace it with next code:
Content visible to registered users only.

Its all, now you can use large URLs for RSS Feeds and use large textarea box for editing those URLs :)

[Pidea]

Thanks for your reply but the shorthand for TEXT can't be 'T', that's used in the tables.php file for the TIMESTAMP fields so I'm no further forward.

However, I had forgotten about the rss_feeds_edit.tpl file :)

[Dimitry]

Sorry Pidea, I was much tired yesterday. So i fixed my mistake in my previous message, now you can change tables.php ;)

[Pidea]

Thanks for that.

I'm still getting an error though 'An error occured while saving the RSS Feed'. Any ideas ?

[Dimitry]

Content visible to registered users only.

This message mean that you have problem with DB.
Maybe you forget to change the type of the field "RSS_URL" to "TEXT" (instead of VARCHAR(255)) in "PLD_RSS_URL" table?

If you changed it and still have like problem, i can provide you changed files from working phpLD 3.0.6.

[Pidea]

I definately changed it and I'm using NewsTopica not phpLD.

I'll re-install from the source and will try it all again. I'll post back if I get it to work.

[Pidea]

Melfel, just an update: I went back and re-installed from the original zip file and it still won't allow me to submit an RSS feed although I can submit a link so it looks there's some problem in the version that I downloaded.

The error message that I get is 'An error occured while saving the RSS Feed.' I took a quick look through the lang/en directory and couldn't find that error message anywhere. I can't see it in the submitrss.php file either . . .

I'm currently running NewsTopica on my laptop using the Sokkit PHP/Apache/MySQL bundle so that might be the cause. I can't check it on my main server because of a strange permissions problem (it won't run unless I delete or rename the .htaccess file).

I'll carry on plugging away at this and will maybe start a new thread if I get anything more.