search

e107inc / e107

e107 Bootstrap CMS (Content Management System) v2 with PHP, MySQL, HTML5, jQuery and Twitter Bootstrap. Issue Discussion Room: https://gitter.im/e107inc/e107
https://e107.org
GNU General Public License v3.0
318 stars 212 forks source link

[Feature request]: Change length of newsfeed_image field in db #5108

Closed Alex-e107nl closed 7 months ago

Alex-e107nl commented 7 months ago

Question

I was setting up the news feed plugin to show news from other websites on an e107 website. That worked fine, but it turned out that loading a logo was not possible because the input field for the image link was too small. Can that be adjusted?

Expected Source

I looked at e107_plugins/newsfeed/newsfeed_sql.php

CREATE TABLE newsfeed (
  newsfeed_id int(10) unsigned NOT NULL auto_increment,
  newsfeed_name varchar(150) NOT NULL default '',
  newsfeed_url varchar(250) NOT NULL default '',
  newsfeed_data longtext NOT NULL,
  newsfeed_timestamp int(10) unsigned NOT NULL default '0',
  newsfeed_description text NOT NULL,
  newsfeed_image varchar(100) NOT NULL default '',
  newsfeed_active tinyint(1) unsigned NOT NULL default '0',
  newsfeed_updateint int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (newsfeed_id)
) ENGINE=MyISAM;

If the newsfeed_image varchar(100) NOT NULL default '', is changed from 100 to 250, problem is solved...

Can that be changed without problems?

Additional Context

I prefer to use the logo of the feed providers website so that when it changes it is immediately visible or at least it is clear that something has changed. 100 characters turns out to be too few...