RompR
RompR copied to clipboard
fatg3erman
OPML import fails
I import an OPML file, the process goes fine with some errors about some channels not being available however at the end of the process, no podcasts are imported and the actual tables are all empty. This OPML has alot of podcasts, I know it works because I exported from AntennaPod which I use daily.
1.58 Php 7.4.14 Apache 2.4.46 MariaDB 15.1
* **PHP INFO**
* **Version** 7.4.15
* **mbstring** 7.4.15
* **PDO** 7.4.15
* **pdo_mysql** 7.4.15
* **pdo_sqlite** 7.4.15
* **curl** 7.4.15
* **date** 7.4.15
* **fileinfo** 7.4.15
* **json** 7.4.15
* **SimpleXML** 7.4.15
* **GD** 7.4.15
* **GD Info** GD Version=2.3.0, FreeType Support=1, FreeType Linkage=with freetype, GIF Read Support=1, GIF Create Support=1, JPEG Support=1, PNG Support=1, WBMP Support=1, XPM Support=1, XBM Support=1, WebP Support=1, BMP Support=1, TGA Read Support=1, JIS-mapped Japanese Font Support=
* **ImageMagick** Installed
* **date.timezone** global_value=, local_value=, access=7
* **default_charset** global_value=UTF-8, local_value=UTF-8, access=7
* **default_socket_timeout** global_value=60, local_value=60, access=7
* **display_errors** global_value=, local_value=, access=7
* **error_log** global_value=, local_value=, access=7
* **error_reporting** global_value=22527, local_value=22527, access=7
* **file_uploads** global_value=1, local_value=1, access=4
* **log_errors** global_value=1, local_value=1, access=7
* **max_execution_time** global_value=3600, local_value=3600, access=7
* **mbstring.language** global_value=neutral, local_value=neutral, access=7
* **memory_limit** global_value=1024M, local_value=128M, access=4
* **pdo_mysql.default_socket** global_value=/var/run/mysqld/mysqld.sock, local_value=/var/run/mysqld/mysqld.sock, access=4
* **session.use_cookies** global_value=1, local_value=1, access=7
* **upload_tmp_dir** global_value=/var/www/html/rompr/prefs/temp, local_value=/var/www/html/rompr/prefs/temp, access=4
1:56:03 [136487] MARK : PODCASTS : Getting podcast https://afteron.libsyn.com/rss
21:56:03 [136487] MARK : PARSE_RSS : Parsing Feed https://afteron.libsyn.com/rss
21:56:03 [136487] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://afteron.libsyn.com/rss
21:56:03 [136487] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:04 [136487] MARK : PODCASTS : Adding New Podcast The After On Podcast
21:56:04 [136487] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:04 [133871] MARK : PODCASTS : Getting podcast http://chandra.harvard.edu/resources/podcasts/hd/podcasts.xml
21:56:04 [133871] MARK : PARSE_RSS : Parsing Feed http://chandra.harvard.edu/resources/podcasts/hd/podcasts.xml
21:56:04 [133871] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading http://chandra.harvard.edu/resources/podcasts/hd/podcasts.xml
21:56:04 [133871] WARN : PODCASTS : Could not parse RSS feed!
21:56:04 [133871] ERROR : PODCASTS : Error 8 Trying to access array offset on value of type bool in /var/www/rompr.git/backends/sql/podatabase.class.php at line 313
21:56:04 [133870] MARK : PODCASTS : Getting podcast https://thecommandline.net/cmdln
21:56:04 [133870] MARK : PARSE_RSS : Parsing Feed https://thecommandline.net/cmdln
21:56:04 [133870] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://thecommandline.net/cmdln
21:56:04 [133870] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:04 [133870] MARK : PODCASTS : Adding New Podcast The Command Line Podcast
21:56:04 [133870] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:04 [134144] MARK : PODCASTS : Getting podcast https://ajc-cwt-001.podomatic.com/rss2.xml
21:56:04 [134144] MARK : PARSE_RSS : Parsing Feed https://ajc-cwt-001.podomatic.com/rss2.xml
21:56:04 [134144] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://ajc-cwt-001.podomatic.com/rss2.xml
21:56:05 [134144] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:05 [134144] MARK : PODCASTS : Adding New Podcast The Creative Writer's Toolbelt
21:56:05 [134144] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:05 [135806] MARK : PODCASTS : Getting podcast https://podcasts.files.bbci.co.uk/p02nq0lx.rss
21:56:05 [135806] MARK : PARSE_RSS : Parsing Feed https://podcasts.files.bbci.co.uk/p02nq0lx.rss
21:56:05 [135806] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://podcasts.files.bbci.co.uk/p02nq0lx.rss
21:56:05 [135806] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:05 [135806] MARK : PODCASTS : Adding New Podcast The Documentary Podcast
21:56:05 [135806] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:05 [134856] MARK : PODCASTS : Getting podcast https://thedrunkenodyssey.libsyn.com/rss
21:56:05 [134856] MARK : PARSE_RSS : Parsing Feed https://thedrunkenodyssey.libsyn.com/rss
21:56:05 [134856] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://thedrunkenodyssey.libsyn.com/rss
21:56:05 [134856] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:05 [134856] MARK : PODCASTS : Adding New Podcast The Drunken Odyssey with John King: A Podcast About the Writing Life
21:56:05 [134856] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:06 [136368] MARK : PODCASTS : Getting podcast https://thefutureandyou.libsyn.com/rss
21:56:06 [136368] MARK : PARSE_RSS : Parsing Feed https://thefutureandyou.libsyn.com/rss
21:56:06 [136368] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://thefutureandyou.libsyn.com/rss
21:56:06 [136368] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:06 [136368] MARK : PODCASTS : Adding New Podcast The Future And You
21:56:06 [136368] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:06 [136487] MARK : PODCASTS : Getting podcast https://futurologypodcast.podbean.com/feed.xml
21:56:06 [136487] MARK : PARSE_RSS : Parsing Feed https://futurologypodcast.podbean.com/feed.xml
21:56:06 [136487] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://futurologypodcast.podbean.com/feed.xml
21:56:06 [136487] WARN : URL_DOWNLOADER : .. Download Failed With Status Code 404
21:56:06 [136487] WARN : PARSE_RSS : Failed to Download https://futurologypodcast.podbean.com/feed.xml
21:56:06 [136487] ERROR : PODCASTS : Error 8 Trying to access array offset on value of type bool in /var/www/rompr.git/backends/sql/podatabase.class.php at line 313
21:56:06 [133871] MARK : PODCASTS : Getting podcast https://rss.acast.com/thehistoryofbyzantium
21:56:06 [133871] MARK : PARSE_RSS : Parsing Feed https://rss.acast.com/thehistoryofbyzantium
21:56:06 [133871] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading https://rss.acast.com/thehistoryofbyzantium
21:56:06 [133871] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
21:56:06 [133871] MARK : PODCASTS : Adding New Podcast The History of Byzantium
21:56:06 [133871] ERROR : PODCASTS : Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
21:56:06 [133870] MARK : PODCASTS : Getting podcast http://feeds.feedburner.com/TheKingdomsOfEvilPodcast
21:56:06 [133870] MARK : PARSE_RSS : Parsing Feed http://feeds.feedburner.com/TheKingdomsOfEvilPodcast
21:56:06 [133870] LOG : URL_DOWNLOADER (get_data_to_string) : Downloading http://feeds.feedburner.com/TheKingdomsOfEvilPodcast
21:56:06 [133870] LOG : PARSE_RSS (parse_rss_feed) : Found a new episode
Good spot. That's one that slipped through when I refactored the code. The bug looks to be
Error 8 Undefined variable: mysqlc in /var/www/rompr.git/backends/sql/podatabase.class.php at line 346
The fix for that is on the develop branch now, or you can edit that line of that file to read
$newpodid = $this->mysqlc->lastInsertId();
The 404 errors are nothing to do with rompr, those are feeds it can no longer find. But I've also separately pushed a fix for
Error 8 Trying to access array offset on value of type bool in /var/www/rompr.git/backends/sql/podatabase.class.php at line 313
which shouldn't be a fatal error but did need tidying up.
Hi
Thanks for the fix, however this does not seem to solve the import issue after git pull. The podcast tables are still mepty after the import.
Please try with version 1.59. It's possible something got messed up your database when it failed the first time. If it still doesn't work send me another debug log.