Dirty Bill

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 110 total)
  • Thread Starter Dirty Bill

    (@dirty-bill)

    The missing transcript entries apparently were a false leader. For whatever reason, the double quotes are an issue with mysql 8.0. Downloading and trying again. Thanks for your help btw. Even with this issue I still recommend FV Player to anyone looking for flexible (.m3u8 files!) video functionality in WordPress.

    Thread Starter Dirty Bill

    (@dirty-bill)

    Hi Martin. Unfortunately that gives the same result – there are no TRANSCRIPT entries in the videometa table. I modified your code to count the meta_keys per video:

    select p.id, player_name, date_created, videos, author, status, count(fvpm.meta_key) as mkeyCount FROM edn_fv_player_players AS p JOIN edn_fv_player_videos AS v on FIND_IN_SET(v.id,p.videos) LEFT JOIN edn_fv_player_videometa AS fvpm ON v.id=fvpm.id_video WHERE 1=1 GROUP BY p.id ORDER BY date_created desc LIMIT 0,25;

    But as long as “Transcript” is a required entry in the videometa table these queries are going to fail – there is NO TRANSCRIPT key ever entered into the table.

    +----+-------------+---------------------+--------+--------+-----------+-----------+
| id | player_name | date_created        | videos | author | status    | mkeyCount |
+----+-------------+---------------------+--------+--------+-----------+-----------+
|  9 |             | 2022-05-24 20:13:20 | 9      |      1 | published |         0 |
|  5 |             | 2022-05-09 19:55:01 | 5      |      1 | published |         3 |
|  4 |             | 2022-05-09 19:40:52 | 4      |      1 | published |         2 |
|  3 |             | 2022-05-08 22:28:35 | 3      |      1 | published |         0 |
|  2 |             | 2022-05-08 22:06:17 | 2      |      1 | published |         0 |
|  1 |             | 2022-05-07 15:43:05 | 1      |      1 | published |         0 |
+----+-------------+---------------------+--------+--------+-----------+-----------+
6 rows in set (0.00 sec)

    select p.id, player_name, date_created, videos, author, status, count(fvpm.id) as idCount 
FROM edn_fv_player_players AS p 
JOIN edn_fv_player_videos AS v on FIND_IN_SET(v.id,p.videos) 
LEFT JOIN edn_fv_player_videometa AS fvpm ON v.id=fvpm.id_video AND fvpm.meta_key = 'transcript' 
WHERE 1=1 GROUP BY p.id ORDER BY date_created desc LIMIT 0,25;
+----+-------------+---------------------+--------+--------+-----------+---------+
| id | player_name | date_created        | videos | author | status    | idCount |
+----+-------------+---------------------+--------+--------+-----------+---------+
|  9 |             | 2022-05-24 20:13:20 | 9      |      1 | published |       0 |
|  5 |             | 2022-05-09 19:55:01 | 5      |      1 | published |       0 |
|  4 |             | 2022-05-09 19:40:52 | 4      |      1 | published |       0 |
|  3 |             | 2022-05-08 22:28:35 | 3      |      1 | published |       0 |
|  2 |             | 2022-05-08 22:06:17 | 2      |      1 | published |       0 |
|  1 |             | 2022-05-07 15:43:05 | 1      |      1 | published |       0 |
+----+-------------+---------------------+--------+--------+-----------+---------+
6 rows in set (0.01 sec)

    The Double Quotes ” ” where giving the missing column error. Using single quotes gives the Count 0 you were expecting.

    • This reply was modified 2 years, 9 months ago by Dirty Bill.
    • This reply was modified 2 years, 9 months ago by Dirty Bill.
    • This reply was modified 2 years, 9 months ago by Dirty Bill.
    Thread Starter Dirty Bill

    (@dirty-bill)

    I have not posted any transcripts.

    mysql> SELECT
    -> p.id,player_name, date_created, videos, author, status,
    -> count(transcript.id) as transcript_count
    -> FROM edn_fv_player_players AS p
    -> JOIN edn_fv_player_videos AS v on FIND_IN_SET(v.id, p.videos)
    -> LEFT JOIN edn_fv_player_videometa AS fvplayertranscript ON v.id = fvplayertranscript.id_video AND transcript.meta_key = "transcript"
    -> WHERE 1=1 GROUP BY p.id ORDER BY date_created desc LIMIT 0, 25;
ERROR 1054 (42S22): Unknown column 'transcript.id' in 'field list'

    Here are the contents of the individual tables in your query.

    mysql> select id, player_name, videos, status from edn_fv_player_players;
+----+-------------+--------+-----------+
| id | player_name | videos | status    |
+----+-------------+--------+-----------+
|  1 |             | 1      | published |
|  2 |             | 2      | published |
|  3 |             | 3      | published |
|  4 |             | 4      | published |
|  5 |             | 5      | published |
+----+-------------+--------+-----------+
5 rows in set (0.00 sec)
    mysql> select id, src, caption from edn_fv_player_videos;
+----+----------------------------------------------------------------------------------------------------------+------------------+
| id | src                                                                                                      | caption          |
+----+----------------------------------------------------------------------------------------------------------+------------------+
|  1 | https://youtu.be/ZWYFHxjjfqA                                                                             |                  |
|  2 | https://youtu.be/YU1R-m4cLhg                                                                             |                  |
|  3 | https://youtu.be/YU1R-m4cLhg                                                                             |                  |
|  4 | https://vsn.lifeforceglobal.network/GNNLocal-NewGuinea/CasparD/playlist_dvr_range-1651280915-334480.m3u8 | Papua New Guinea |
|  5 | https://s3-eu-west-1.amazonaws.com/s3.dataton.com/_video/Dataton_Explainer_short.mp4                     | DATATON          |
+----+----------------------------------------------------------------------------------------------------------+------------------+
5 rows in set (0.00 sec)
    mysql> select * from edn_fv_player_videometa;
+----+----------+-----------------------+--------------------+
| id | id_video | meta_key              | meta_value         |
+----+----------+-----------------------+--------------------+
|  1 |        4 | last_video_meta_check | 1652125259         |
|  2 |        4 | duration              | 1070.0420000000013 |
|  4 |        5 | last_video_meta_check | 1652723478         |
|  5 |        5 | duration              | 133.73866666666666 |
|  7 |        5 | stats_play            | 1                  |
+----+----------+-----------------------+--------------------+
5 rows in set (0.00 sec)

    It does consistently look like the data is not being written to the videometa table.

    Error log:
    WordPress database error Unknown column 'transcript' in 'on clause' for query SELECT\np.id,player_name, date_created, videos, author, status,\ncount(subtitles.id) as subtitles_count,\ncount(cues.id) as cues_count,\ncount(chapters.id) as chapters_count,\ncount(transcript.id) as transcript_count\nFROMedn_fv_player_playersAS p\nJOINedn_fv_player_videosAS v on FIND_IN_SET(v.id, p.videos)\nLEFT JOINedn_fv_player_videometaAS subtitles ON v.id = subtitles.id_video AND subtitles.meta_key like "subtitles%"\nLEFT JOINedn_fv_player_videometaAS cues ON v.id = cues.id_video AND cues.meta_key like "cues%"\nLEFT JOINedn_fv_player_videometaAS chapters ON v.id = chapters.id_video AND chapters.meta_key = "chapters"\nLEFT JOINedn_fv_player_videometaAS transcript ON v.id = transcript.id_video AND transcript.meta_key = "transcript"\n WHERE 1=1 GROUP BY p.id ORDER BY date_created desc LIMIT 0, 25 made by do_action('toplevel_page_fv_player'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_List_Table_View->tools_panel, FV_Player_List_Table->prepare_items, FV_Player_List_Table->get_data, FV_Player_Db->getListPageData, FV_Player_Db->query_players, QM_DB->query, referer: https://eugenedailynews.com/wp-admin/

    Thread Starter Dirty Bill

    (@dirty-bill)

    The new query returned the same results. If you look at the listing from the videometa table – only those 5 entries, there is nothing else in the videometa table:

    ----------+-----------------------+
| id_video | meta_key              |
+----------+-----------------------+
|        4 | last_video_meta_check |
|        4 | duration              |
|        5 | last_video_meta_check |
|        5 | duration              |
|        5 | stats_play            |
+----------+-----------------------+

    In the player_videos table All 5 videos that I had put into the FV Player are listed:

    +----+----------------------------------------------------------------------------------------------------------+
| id | src                                                                                                      |
+----+----------------------------------------------------------------------------------------------------------+
|  1 | https://youtu.be/ZWYFHxjjfqA                                                                             |
|  2 | https://youtu.be/YU1R-m4cLhg                                                                             |
|  3 | https://youtu.be/YU1R-m4cLhg                                                                             |
|  4 | https://vsn.lifeforceglobal.network/GNNLocal-NewGuinea/CasparD/playlist_dvr_range-1651280915-334480.m3u8 |
|  5 | https://vsn.lifeforceglobal.network/GNNLocal-NewGuinea/CasparD/playlist_dvr_range-1651280915-334480.m3u8 |
+----+----------------------------------------------------------------------------------------------------------+

    This indicates that the “write” to the videometa table is either not happening or fails. I cannot find an entry in the logs showing a failure on write. It only logs a failure when I attempt to see the FV Players list.

    • This reply was modified 2 years, 9 months ago by Dirty Bill.
    Thread Starter Dirty Bill

    (@dirty-bill)

    Yes, reported the same error. Doing a select all from videometa it shows that the entries are incomplete:

    ----------+-----------------------+
| id_video | meta_key              |
+----------+-----------------------+
|        4 | last_video_meta_check |
|        4 | duration              |
|        5 | last_video_meta_check |
|        5 | duration              |
|        5 | stats_play            |
+----------+-----------------------+

    Player_Videos shows the 5 tests I’ve put in:

    +----+----------------------------------------------------------------------------------------------------------+
| id | src                                                                                                      |
+----+----------------------------------------------------------------------------------------------------------+
|  1 | https://youtu.be/ZWYFHxjjfqA                                                                             |
|  2 | https://youtu.be/YU1R-m4cLhg                                                                             |
|  3 | https://youtu.be/YU1R-m4cLhg                                                                             |
|  4 | https://vsn.lifeforceglobal.network/GNNLocal-NewGuinea/CasparD/playlist_dvr_range-1651280915-334480.m3u8 |
|  5 | https://vsn.lifeforceglobal.network/GNNLocal-NewGuinea/CasparD/playlist_dvr_range-1651280915-334480.m3u8 |
+----+----------------------------------------------------------------------------------------------------------+
    • This reply was modified 2 years, 9 months ago by Dirty Bill.
    Thread Starter Dirty Bill

    (@dirty-bill)

    Here’s the file:

    ### Begin System Info ###

## Please include this information when posting support requests ##

Multisite:                No

SITE_URL:                 https://eugenedailynews.com
HOME_URL:                 https://eugenedailynews.com
Plugin URL:               https://eugenedailynews.com/wp-content/plugins/fv-wordpress-flowplayer

FV Player version:        7.5.22.728
FV Player core version:   7.2.8
FV Player license:        

WordPress Version:        5.9.3
Permalink Structure:      /%postname%/
Active Theme:             Divi Child 1.0.0

Browser:                  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36
PHP Version:              7.4.3
MySQL Version:            8.0.27
Web Server Info:          Apache/2.4.41 (Ubuntu)

WordPress Memory Limit:   40M
PHP Memory Limit:         256M
PHP Upload Max Size:      128M
PHP Post Max Size:        128M
PHP Upload Max Filesize:  128M
PHP Time Limit:           30
PHP Max Input Vars:       1000
PHP Arg Separator:        &
PHP Allow URL File Open:  Yes
PHP Extensions Installed: Array
(
    [0] => Core
    [1] => date
    [2] => libxml
    [3] => openssl
    [4] => pcre
    [5] => zlib
    [6] => filter
    [7] => hash
    [8] => Reflection
    [9] => SPL
    [10] => session
    [11] => standard
    [12] => sodium
    [13] => apache2handler
    [14] => mysqlnd
    [15] => PDO
    [16] => xml
    [17] => calendar
    [18] => ctype
    [19] => curl
    [20] => dom
    [21] => mbstring
    [22] => FFI
    [23] => fileinfo
    [24] => ftp
    [25] => gd
    [26] => gettext
    [27] => iconv
    [28] => imagick
    [29] => intl
    [30] => json
    [31] => exif
    [32] => mysqli
    [33] => pdo_mysql
    [34] => Phar
    [35] => posix
    [36] => readline
    [37] => shmop
    [38] => SimpleXML
    [39] => soap
    [40] => sockets
    [41] => sysvmsg
    [42] => sysvsem
    [43] => sysvshm
    [44] => tokenizer
    [45] => xmlreader
    [46] => xmlrpc
    [47] => xmlwriter
    [48] => xsl
    [49] => zip
    [50] => Zend OPcache
)
PHP MBString:             MB String extension is installed on server.

WP_DEBUG:                 Disabled

DISPLAY ERRORS:           N/A
cURL:                     Your server supports cURL.

ACTIVE PLUGINS:

Auto Affiliate Links: 6.1.8
DiviTorque: 3.5.0
FeedWordPress: 2022.0222
FluentCRM - Marketing Automation For WordPress: 2.5.8
Fluent Forms: 4.3.5
Fluent Forms PDF Generator: 1.1.2
Fluent Forms Pro Add On Pack: 4.3.5
FPW Category Thumbnails: 1.9.4
FV Player: 7.5.22.728
Gmail SMTP: 1.2.3.1
Invitation Based Registrations: 2.2.83
Matomo Analytics - Ethical Stats. Powerful Insights.: 4.6.0
OWM Weather: 5.2.0
PressForward: 5.2.8
User Role Editor: 4.62
User Switching: 1.5.8
Videopack (formerly Video Embed & Thumbnail Generator): 4.7.4
Wordfence Security: 7.5.9

SETTINGS

Array
(
    [nag_fv_player_7] => 1
    [notice_7_5] => 1
    [notice_new_lightbox] => 1
    [notice_db] => 1
    [notice_xml_sitemap_iframes] => 1
    [js-optimize] => true
    [autoplay] => false
    [googleanalytics] => 
    [chromecast] => 1
    [key] => 
    [logo] => 
    [rtmp] => 
    [auto_buffering] => false
    [disableembedding] => false
    [disablesharing] => false
    [disable_video_hash_links] => false
    [popupbox] => false
    [allowfullscreen] => true
    [allowuploads] => true
    [postthumbnail] => false
    [tgt] => backgroundcolor
    [backgroundColor] => #333333
    [canvas] => #000000
    [sliderColor] => #ffffff
    [durationColor] => #eeeeee
    [timeColor] => #eeeeee
    [progressColor] => #bb0000
    [bufferColor] => #eeeeee
    [timelineColor] => #666666
    [borderColor] => #666666
    [hasBorder] => false
    [adTextColor] => #888888
    [adLinksColor] => #ff3333
    [subtitleBgColor] => rgba(0,0,0,0.50)
    [subtitleSize] => 16
    [playlistBgColor] => #808080
    [playlistFontColor] => #
    [playlistSelectedColor] => #bb0000
    [logoPosition] => bottom-left
    [parse_commas] => false
    [width] => 640
    [height] => 360
    [engine] => false
    [font-face] => Tahoma, Geneva, sans-serif
    [ad] => 
    [ad_width] => 0
    [ad_height] => 0
    [ad_css] => .wpfp_custom_ad { position: absolute; bottom: 10%; z-index: 20; width: 100%; }
.wpfp_custom_ad_content { background: white; margin: 0 auto; position: relative }
    [ad_show_after] => 0
    [disable_videochecker] => true
    [interface] => Array
        (
            [ads] => true
            [align] => false
            [autoplay] => false
            [controlbar] => true
            [embed] => true
            [mobile] => true
            [playlist_advance] => false
            [playlist] => false
            [playlist_captions] => true
            [share] => false
            [speed] => false
            [splash_text] => false
            [sticky] => false
            [synopsis] => false
            [end_actions] => true
            [lightbox] => false
            [popup] => true
        )

    [amazon_bucket] => Array
        (
            [0] => 
        )

    [amazon_key] => (redacted, 1)
    [amazon_secret] => (redacted, 1)
    [amazon_region] => Array
        (
            [0] => 
        )

    [amazon_expire] => 5
    [amazon_expire_force] => false
    [fixed_size] => false
    [js-everywhere] => false
    [marginBottom] => 28
    [volume] => 0.7
    [player-position] => 
    [playlist_advance] => false
    [sharing_email_text] => Check out the amazing video here
    [liststyle] => season
    [ui_speed_increment] => 0.25
    [popups_default] => 1
    [email_lists] => Array
        (
            [#fv_list_dummy_key#] => Array
                (
                    [title] => 
                    [description] => 
                    [first_name] => 0
                    [last_name] => 0
                    [disabled] => 0
                )

            [0] => Array
                (
                    [title] => 
                    [description] => 
                    [first_name] => 0
                    [last_name] => 0
                    [disabled] => 0
                )

            [1] => Array
                (
                    [title] => Subscribe to list one
                    [description] => Two good reasons to subscribe right now
                    [first_name] => 1
                    [last_name] => 0
                    [disabled] => 0
                )

        )

    [sticky_video] => false
    [sticky_place] => right-bottom
    [sticky_width] => 380
    [playlist-design] => 2017 visible-captions
    [skin-slim] => Array
        (
            [progressColor] => #bb0000
        )

    [skin-youtuby] => Array
        (
            [progressColor] => #bb0000
        )

    [skin-custom] => Array
        (
            [hasBorder] => false
            [bottom-fs] => false
            [borderColor] => #666666
            [marginBottom] => 
            [bufferColor] => #eeeeee
            [canvas] => #000000
            [backgroundColor] => rgba(51,51,51,1.00)
            [font-face] => Tahoma, Geneva, sans-serif
            [player-position] => 
            [progressColor] => #bb0000
            [timeColor] => #eeeeee
            [durationColor] => #eeeeee
            [design-timeline] =>  
            [design-icons] =>  
        )

    [skin] => slim
    [lightbox_images] => false
    [lightbox_improve_galleries] => false
    [mailchimp_api] => 
    [mailchimp_list] => 
    [mailchimp_label] => Subscribe for updates
    [version] => 7.5.22.728
    [css_writeout-http-165-232-139-52] => 1651871686
    [video_checker_agreement] => true
    [video_model_db_checked] => 7.5.22.728
    [player_model_db_checked] => 7.5.22.728
    [video_meta_model_db_checked] => 7.5.22.728
    [player_meta_model_db_checked] => 7.5.22.728
    [pro] => Array
        (
        )

    [show_controlbar] => true
    [hd_streaming] => false
    [matomo_domain] => 
    [matomo_site_id] => 
    [multiple_playback] => false
    [ui_no_picture_button] => false
    [ui_repeat_button] => false
    [ui_rewind_button] => true
    [ui_speed] => true
    [splash] => 
    [subtitleOn] => false
    [video_position_save_enable] => false
    [video_stats_enable] => true
    [integrations] => Array
        (
            [featured_img] => true
            [wp_core_video] => true
            [facebook_sharing] => false
            [schema_org] => false
        )

    [css_disable] => false
    [profile_videos_enable_bio] => false
    [parse_comments] => true
    [db_duration] => false
    [lightbox_force] => false
    [mobile_native_fullscreen] => false
    [mobile_force_fullscreen] => true
    [mobile_alternative_fullscreen] => false
    [mobile_landscape_fullscreen] => true
    [video_sitemap] => true
    [video_sitemap_meta] => 
    [disable_localstorage] => false
    [playlistFontColor-proxy] => #
    [fv-wp-flowplayer-submit] => SaveAllChanges
    [customCSS] => 
    [subtitleFontFace] => inherit
    [s3_browser] => false
    [digitalocean_spaces] => Array
        (
            [space] => 
            [endpoint] => 
            [key] => 
            [secret] => 
        )

    [linode_object_storage] => Array
        (
            [space] => 
            [endpoint] => 
            [key] => 
            [secret] => 
        )

    [remove_all_data] => false
    [vi_login] => 
    [vi_pass] => 
    [css_writeout-https-eugenedailynews-com] => 1652306751
)

DATABASE

CREATE TABLE "edn_fv_player_players" (
  "id" bigint unsigned NOT NULL AUTO_INCREMENT,
  "player_name" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "player_slug" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "videos" text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "ab" varchar(3) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "ad" text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "ad_height" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "ad_width" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "ad_skip" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "align" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "author" bigint unsigned NOT NULL DEFAULT '0',
  "autoplay" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "controlbar" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "copy_text" varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "changed_by" bigint unsigned NOT NULL DEFAULT '0',
  "date_created" datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  "date_modified" datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  "embed" varchar(12) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "end_actions" varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "end_action_value" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "height" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "hflip" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "lightbox" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "lightbox_caption" varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "lightbox_height" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "lightbox_width" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "playlist" varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "playlist_advance" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "qsel" varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "share" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "share_title" varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "share_url" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "speed" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "sticky" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "video_ads" varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "video_ads_post" varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "width" varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "status" varchar(9) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'published',
  PRIMARY KEY ("id")
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

CREATE TABLE "edn_fv_player_playermeta" (
  "id" bigint unsigned NOT NULL AUTO_INCREMENT,
  "id_player" bigint unsigned NOT NULL DEFAULT '0',
  "meta_key" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "meta_value" longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY ("id"),
  KEY "id_player" ("id_player"),
  KEY "meta_key" ("meta_key"(191))
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

CREATE TABLE "edn_fv_player_videos" (
  "id" bigint unsigned NOT NULL AUTO_INCREMENT,
  "src" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "src1" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "src2" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "splash" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "splash_text" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "caption" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "end" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "mobile" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "rtmp" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "rtmp_path" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "start" varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY ("id"),
  KEY "src" ("src"(191)),
  KEY "caption" ("caption"(191))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

CREATE TABLE "edn_fv_player_videometa" (
  "id" bigint unsigned NOT NULL AUTO_INCREMENT,
  "id_video" bigint unsigned NOT NULL DEFAULT '0',
  "meta_key" varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  "meta_value" longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY ("id"),
  KEY "id_video" ("id_video"),
  KEY "meta_key" ("meta_key"(191))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

### End System Info ###
    Thread Starter Dirty Bill

    (@dirty-bill)

    deleted and reinstalled 3 times, 3rd time (as usual) was the charm. Looking forward to testing it out and upgrading.

    Thread Starter Dirty Bill

    (@dirty-bill)

    Ok, tracked activation issues down to the auto-update initialization:

    # Cron-less auto-update. Hooray!
    // $autoUpdateHook = $feedwordpress->automatic_update_hook();
    // if (!is_null($autoUpdateHook)) :
    // add_action($autoUpdateHook, array($feedwordpress, ‘auto_update’));
    // endif;

    I commented it out and feedwordpress now activates. Has something to do with not finding the MyPHP::val function when it initializes. Testing to see if it works or if the val() call is still an issue further into the program.

    I have a suspicion that whatever info is in the meta storage (or tables, no idea where the settings/params are stored for FWP). Once activated all of my feeds from 2 years ago are there…guessing the old settings for the previous version are too.

    Update: Ok, deleted FWP, Went into mysql and deleted all FWP entries and reinstalled. This time, it installs and activates just fine, BUT, this error when trying to add a feed, update a feed, etc.: Fatal error: Uncaught Error: Call to undefined method MyPHP::val()

    • This reply was modified 7 years, 1 month ago by Dirty Bill.
    • This reply was modified 7 years, 1 month ago by Dirty Bill.
    Thread Starter Dirty Bill

    (@dirty-bill)

    Here’s the actual error reported on activation attempt:
    Fatal error: Uncaught Error: Call to undefined method MyPHP::val() in /<mypath>/wp-content/plugins/feedwordpress/feedwordpress.php:2526 Stack trace: #0 /<mypath>/wp-content/plugins/feedwordpress/feedwordpress.php(1451): FeedWordPress::val('shutdown') #1 /<mypath>/wp-content/plugins/feedwordpress/feedwordpress.php(265): FeedWordPress->automatic_update_hook() #2 /<mypath>/wp-admin/includes/plugin.php(1897): include('/<mypath>...') #3 /<mypath>/wp-admin/plugins.php(172): plugin_sandbox_scrape('feedwordpress/f...') #4 {main} thrown in /<mypath>/wp-content/plugins/feedwordpress/feedwordpress.php on line 2526

    Any help would be appreciated, would love to be using this again.

    Thread Starter Dirty Bill

    (@dirty-bill)

    Sorry, meant “Edit Flow”

    Thread Starter Dirty Bill

    (@dirty-bill)

    Yes, that is the plugin – we have 15 custom statuses we use for managing our writers and our curation process (sports feeds vs news feeds for example). Currently Pipes doesn’t recognize custom statuses and actually doesn’t seem to recognize using standard wordpress statuses like “pending”. I do love the layout and design of your plugin, it’s very clean and easy to use.

    I have the same issue – can one by one update plugins from the plugins page, but full updates don’t work.

    Thread Starter Dirty Bill

    (@dirty-bill)

    I removed and re-installed Pipes (and it deleted all the feeds!) and it got rid of the database error until I tried to save a pipe that didn’t have all the fields complete – this appears that it could be the source of the database error. I (reluctantly) removed and re-installed and it is working again, just have to be careful not to overlook a required field when I save.

    Thread Starter Dirty Bill

    (@dirty-bill)

    Actually I’m looking at sequential CF7 forms: fill out Form1, submit takes you to Form 2. Want to use data from Form1 in Form2. Ideally carry forward pertinent info, but populating a dropdown with choices is just as good.

    Dirty Bill

    (@dirty-bill)

    *removed – didn’t notice the RESOLVED tag.

Viewing 15 replies - 1 through 15 (of 110 total)