3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Youtube Videos Gallery

[martin]

ACP / Video titles
Clicking on the "Sync" function:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 330: Trying to access array offset on null
[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 331: Trying to access array offset on null

Code: Select all

SQL ERROR [ mysqli ]

Column 'video_duration' cannot be null [1048]

SQL

UPDATE phpbb_video SET video_description = '<t></t>', video_duration = NULL WHERE video_id = 8

BACKTRACE

Enter a description the ext was tested and found to be working.

[SpIdErPiGgY]

ACP / Video titles
Clicking on the "Sync" function:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 330: Trying to access array offset on null
[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 331: Trying to access array offset on null

Code: Select all

SQL ERROR [ mysqli ]

Column 'video_duration' cannot be null [1048]

SQL

UPDATE phpbb_video SET video_description = '<t></t>', video_duration = NULL WHERE video_id = 8

BACKTRACE

Enter a description the ext was tested and found to be working.

I did... 😁 but the desctiotion field is empty in acp

[martin]

Screenshot from 2025-03-03 00-40-57.png

Does not matter if a description is filled out or not see image above.

Check your api is working enable posting in chat if the name posts then your api key is good if not go make a new api key.

[SpIdErPiGgY]

Okay I had to disable the ext, and remove data.
After a new install, everything is working.

When just updating to the new version, It did not show the duration time of the videos. That was the SQL error.

[Sniper_E]

In the template/video_body.html template that starting first • made the titles look off.

Maybe you could add an if statement around that on the next release so my face cheek want twitch when looking at it.

Code: Select all

<p>{% for videocat in loops.videocat %}{% if not videocat.S_FIRST_ROW %} &bull; {% endif %}<a href="{{ videocat.U_CAT }}" id="cat{{ videocat.VIDEO_CAT_ID }}">{{ videocat.VIDEO_CAT_TITLE }}</a>{% endfor %}</p>

Video Categories

[dmzx]

First post updated.

[nou nou]

When trying to enable the extension (v1.1.1)

[martin]

Purge the boards cache then enable it and then purge after.

[nou nou]

Thanks - doesn't work, I still get the same error.

The extension is in the disabled extensions list and there is data, and when I try "delete data" I get this:

Screenshot 2025-03-05 122554.png

this seems to be the added data:

Screenshot 2025-03-05 122722.png

What would be the best way to go about this now?

[Xxxbennyxxx]

ACP / Video titles
Clicking on the "Sync" function:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 330: Trying to access array offset on null
[phpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/youtubegallery/controller/admin_controller.php on line 331: Trying to access array offset on null

Code: Select all

SQL ERROR [ mysqli ]

Column 'video_duration' cannot be null [1048]

SQL

UPDATE phpbb_video SET video_description = '<t></t>', video_duration = NULL WHERE video_id = 8

BACKTRACE

Enter a description the ext was tested and found to be working.

I did... 😁 but the desctiotion field is empty in acp

Same problem with version 1.1.1, only a complete reinstallation solves this problem

[Xxxbennyxxx]

Just a quick question: I think the font size of the description/content of the video is very large. Looks like it's just copying this from YouTube. Can i hardcode this font size in the CSS ?

[nou nou]

Screenshot 2025-03-13 213532.png

Screenshot 2025-03-13 213542.png

Leftover database tables from a previous restore - did a fresh one, and tadaaa!

All good!

(but I'd be happy to learn how to troubleshoot/fix this without starting over... I removed any phpbb_video tables and reference to the extension in phpbb_ext but it still didn't work, some migration error I couldn't get rid of)

Thanks!

[dmzx]

Screenshot 2025-03-13 213532.png

Screenshot 2025-03-13 213542.png



Leftover database tables from a previous restore - did a fresh one, and tadaaa!

All good!

(but I'd be happy to learn how to troubleshoot/fix this without starting over... I removed any phpbb_video tables and reference to the extension in phpbb_ext but it still didn't work, some migration error I couldn't get rid of)

Thanks!

on holiday now back the 21th, will explain then

[d3ath2435]

Thanks for the EXT, but I've some issues with it



is not showing the stats from youtube

Also I cannot edit Titles, descriptions etc?


Also when I push the button Resync

[nou nou]

Working great so far! Will have to do some CSS changes for my style but that was to be expected.

I have a couple of requests if I may...

- Subcategories or the ability to assign multiple categories to a video. I can see libraries grow to where they really will need more specific ways of sorting/searching.

- The ability to change the order of categories in the ACP (exactly like how you can move the order of forums, for example)

- The order displayed in the videos page is the inverse of the order in the drop-down list when adding videos - could they both follow the ACP order?

Please and thank you, enjoy your holiday!