Error on Data Import of Cuepoints

[wheresmytissue]

Environment info

• Host: Linux
• xbvr docker container version: 0.4.24
• mariadb docker container version: 1:11.3.2+maria~ubu2204
• configured mariadb via the dockerfile in the xbvr wiki located here

Experienced behavior

• Downloaded cuepoints from timestamp.trade
• imported them into xbvr with MariaDB configured properly
• Logs presented the errors below

bvr3_1    | time="2024-04-21T20:33:58Z" level=info msg="Restoring scene cuepoints" task=scrape                                               
xbvr3_1    | time="2024-04-21T20:33:58Z" level=info msg="Processing cuepoints 1 of 69207" task=scrape                                         
xbvr3_1    | time="2024-04-21T20:33:58Z" level=info msg="Processing cuepoints 501 of 69207" task=scrape
xbvr3_1    | time="2024-04-21T20:33:59Z" level=info msg="Processing cuepoints 1001 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:33:59Z" level=info msg="Processing cuepoints 1501 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:33:59Z" level=info msg="Processing cuepoints 2001 of 69207" task=scrape
xbvr3_1    | time="2024-04-21T20:34:00Z" level=info msg="Processing cuepoints 2501 of 69207" task=scrape
xbvr3_1    | time="2024-04-21T20:34:00Z" level=info msg="Processing cuepoints 3001 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:34:00Z" level=info msg="Processing cuepoints 3501 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:34:00Z" level=info msg="Processing cuepoints 4001 of 69207" task=scrape
xbvr3_1    | time="2024-04-21T20:34:01Z" level=info msg="Processing cuepoints 4501 of 69207" task=scrape
xbvr3_1    | time="2024-04-21T20:34:01Z" level=info msg="Processing cuepoints 5001 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:34:01Z" level=info msg="Processing cuepoints 5501 of 69207" task=scrape                                      
xbvr3_1    | time="2024-04-21T20:34:02Z" level=info msg="Processing cuepoints 6001 of 69207" task=scrape     
xbvr3_1    | time="2024-04-21T20:34:21Z" level=info msg="Matching Scenes to known filenames (151/1009)" task=rescan
xbvr3_1    | time="2024-04-21T20:34:54Z" level=fatal msg="Failed to save All attempts fail:       
xbvr3_1    | #1: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #2: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #3: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #4: Error 1406: Data too long for column 'name' at row 1
xbvr3_1    | #5: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #6: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #7: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #8: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #9: Error 1406: Data too long for column 'name' at row 1                                                                         
xbvr3_1    | #10: Error 1406: Data too long for column 'name' at row 1"                                                                       
mariadb_1  | 2024-04-21 20:34:54 46850 [Warning] Aborted connection 46850 to db: 'xbvr' user: 'xbvr' host: '172.23.0.2' (Got an error reading 
communication packets)                                                 

I suspect there is a jav-vr scene with one of those ridiculously long and utf-8 formatted file names causing the issue. Any suggestions on how to identify the scene/file in question?

[tosh6072]

Assuming you haven't changed cuepoints since importing, you can find the most recent added cuepoints you can use the following query, then find the scene or scene near there in the json bundle
select * from scene_cuepoints sc
join scenes s on s.id=sc.scene_id
order by sc.id DESC

[wheresmytissue]

@tosh6072 ,

I appreciate you taking the time to respond. Per your instructions, I connected to the MariaDB and executed the appropriate query. Unfortunately the scene-id in the logs (wetvr-67972) was the very first file in the cue-point section of the json file.

output of query

| https://wetvr.com/video/pole-dancer                                                                                                                                                  | https://wetvr.com/members/video/pole-dancer                                                              |            0 |           4 |         0 |         1 |        0 |            0 |             0 |          1 |           0 | 2022-07-02 02:35:14 | 2024-03-07 00:54:39 |               0 |                1 |                 0 |            0 |             0 | scrape_html  | {"scene_url":"https://wetvr.com/video/pole-dancer","html_element":"deo-video source","extract_regex":"","content_base_url":"","record_path":"","content_path":"src","encoding_path":"","quality_path":"quality"}                                                                                                                    |                                                                                         |           0 |             0 |         0 |                         | 0000-00-00 00:00:00 |         0 |            0 |
|      6 | 2024-04-22 21:09:08 | 2024-04-22 21:09:08 |        4 |    568.572 |  906.501 |     0 | Blowjob                        |    3.5 |     4 | 2021-12-02 05:53:57 | 2024-04-22 21:09:08 | NULL       | wetvr-67972                   | Pole Dancer                                                                                                                                                     | VR         | wetvr                 | WetVR                 | WetVR                   | ["WetVR-GraceStoke-PoleDancer.mp4"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | [{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/019.jpg?imgw=970&imgh=545","type":"cover","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/006.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/009.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/012.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/003.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/006.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/009.jpg?imgw=475&imgh=268","type":"gallery","orientation":""},{"url":"https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/012.jpg?imgw=475&imgh=268","type":"gallery","orientation":""}] |       44 | Grae Stoke shows off what she learned in pole dancing class with a sexy strip tease.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 2019-09-11 00:00:00 | 2019-09-11        | https://cdn-images.r1.cdn.pornpros.com/content/videos/9/3/a/93adbacb-a5df-4931-a61e-2110364659bf/handtouched/019.jpg?imgw=970&imgh=545                                                                                            | https://wetvr.com/video/pole-dancer                                                                                                                                                  | https://wetvr.com/members/video/pole-dancer                                                              |            0 |           4 |         0 |         1 |        0 |            0 |             0 |          1 |           0 | 2022-07-02 02:35:14 | 2024-03-07 00:54:39 |               0 |                1 |                 0 |            0 |             0 | scrape_html  | {"scene_url":"https://wetvr.com/video/pole-dancer","html_element":"deo-video source","extract_regex":"","content_base_url":"","record_path":"","content_path":"src","encoding_path":"","quality_path":"quality"}                                                                                                                    |                                                                                         |           0 |             0 |         0 |                         | 0000-00-00 00:00:00 |         0 |            0 |

json file

 ],  
 "sceneCuepoints": [
  {  
   "scene_id": "wetvr-67993",
   "cuepoints": [
    {
     "time_start": 756.485,
     "time_end": 912.758,
     "track": 0,
     "name": "Blowjob",
     "rating": 0
    },
    {
     "time_start": 912.758,
     "time_end": 1198.664,
     "track": 0,
     "name": "Reverse Cowgirl",
     "rating": 5
    },
    {
     "time_start": 1198.664,
     "time_end": 1690.197,
     "track": 0,
     "name": "Cowgirl",
     "rating": 0
    },
    {
     "time_start": 1690.197,
     "time_end": 1861.679,
     "track": 0,
     "name": "Missionary",
     "rating": 4
    },
    {
     "time_start": 1861.679,
     "time_end": 2130.56,
     "track": 0,
     "name": "Doggystyle",
     "rating": 5
    }
   ] 
  }, 
  {  
   "scene_id": "wetvr-67972",
   "cuepoints": [
    {
     "time_start": 568.572,
     "time_end": 906.501,
     "track": 0,
     "name": "Blowjob",
     "rating": 3.5
    },
    {
     "time_start": 1018.39,
     "time_end": 1461.133,
     "track": 0,
     "name": "Cowgirl",
     "rating": 0
    },
    {
     "time_start": 1635.609,
     "time_end": 1920.833,
     "track": 0,
     "name": "Reverse Cowgirl",
     "rating": 0
    },
    {
     "time_start": 1920.833,
     "time_end": 2232.642,
     "track": 0,
     "rating": 0
    },
    {
     "time_start": 1920.833,
     "time_end": 2232.642,
     "track": 0,
     "name": "Missionary",
     "rating": 0
    },
    {
     "time_start": 2232.642,
     "time_end": 2650.133,
     "track": 0,
     "name": "Doggystyle",
     "rating": 4
    }
   ]
  },
  {
   "scene_id": "realjam-vr-2",
   "cuepoints": [
    {
     "time_start": 322,
     "time_end": 0,
     "track": null,
     "name": "Masturbation",
     "rating": 0
    },
    {
     "time_start": 366,
     "time_end": 0,
     "track": null,
     "name": "Toys",
     "rating": 0
    },
    {
     "time_start": 486,
     "time_end": 0,
     "track": null,
     "name": "Toys",
     "rating": 0
    },
    {
     "time_start": 598,
     "time_end": 0,
     "track": null,
     "name": "Toys",
     "rating": 0
    }
   ]

Solution

I was able to get a solution

• I added the stashdb api again
• i went into player settings > hero sphere and enabled the following settings

• restarted the containers
• configured the following settings on the import options
  

• worked. ¯_(ツ)_/¯ I'm currently adding custom scrapers 1 at a time, but should be ok now.