[CDB] Youtube Videos Gallery

noth · Post by **noth** » Sat Jul 16, 2016 8:44 am

yes the index page display of the "Last 6 videos" does look amazing but if its not responsive ....

a lot of people will be effected as they tune in from mobile

good comments Austeyr

and remember he said "Great Ext"

it is great!!

CCRoiDanton · Post by **CCRoiDanton** » Tue Jul 19, 2016 7:24 am

CCRoiDanton wrote:I just upgraded to the latest version 1.0.2 (from 1.0.0) and got errors after re-enabling the extension. I run the latest phpBB 3.1 (3.1.9). I cannot enable the extension anymore. Also downgrading to 1.0.0 does not work anymore with a different error when enabling.

Can you help me?

Code: Select all

SQL ERROR [ mysqli ]

Duplicate entry '1' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_video_cat (video_cat_id, video_cat_title) VALUES (1, 'Uncategorized')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 650
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 377
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/ext/dmzx/youtubegallery/migrations/youtubegallery_install.php
LINE: 155
CALL: phpbb\db\driver\factory->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\youtubegallery\migrations\youtubegallery_install->insert_sample_data()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 550
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 496
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 322
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 202
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 185
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 80
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 177
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Ok, I manually delete the row with ID 1 from the table phpbb_video_cat and then I was able to activate 1.0.2 (after upgrading from 1.0.0).

Works now!

noth · Post by **noth** » Sat Jul 23, 2016 6:09 am

so if we want to update from a previous version we have to get onto phpmyadmin and start deleting a row manually? what could possibly go wrong?

the only other answer is to DELETE DATA each time you upgrade to the next version, which of course means you lose all your members videos, that have been "collected so far", actually I'm wrong, if you do that you get this

Code: Select all

SQL ERROR [ mysql4 ]

Table 'blackfoot.w2phpbb_video' doesn't exist [1146]

SQL

SELECT COUNT(video_id) AS total_videos FROM w2phpbb_video

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/ext/dmzx/youtubegallery/event/listener.php
LINE: 144
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\youtubegallery\event\listener->index_modify_page_title()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 158
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 231
CALL: phpbb\event\dispatcher->trigger_event()

this whole updating from one version to another is a REAL MESS

big problem - any support?

Post by **_Vinny_** » Sat Jul 23, 2016 6:20 am

noth wrote:so if we want to update from a previous version we have to get onto phpmyadmin and start deleting a row manually? what could possibly go wrong?

For future updates, the following procedure is not necessary, you will be able to update your extension normally.

Step 1 - on phpmyadmin, backup all data from tables [i]yourprefix[/i]_video_cat and [i]yourprefix[/i]_video.

Step 2 - uninstalled extension and delete files from ext folder

Step 3 - upload the new updated version and install the extension

Step 4 - Restore data to tables [i]yourprefix[/i]_video_cat and [i]yourprefix[/i]_video.

Just to remind, this is a development version, unforeseen can happen.

noth · Post by **noth** » Sat Jul 23, 2016 6:54 am

Vinny there is another way apparently

Ok, I manually delete the row with ID 1 from the table phpbb_video_cat and then I was able to activate 1.0.2 (after upgrading from 1.0.0).

one user manually deleted the problem row

so do you agree that would also succeed? if so what would be the SQL QUERY to effect that manual delete please?

Post by **_Vinny_** » Sat Jul 23, 2016 8:33 am

noth wrote:Vinny there is another way apparently

Ok, I manually delete the row with ID 1 from the table phpbb_video_cat and then I was able to activate 1.0.2 (after upgrading from 1.0.0).
one user manually deleted the problem row

so do you agree that would also succeed? if so what would be the SQL QUERY to effect that manual delete please?

Honestly, I recommend not delete, you will lose the data.

ghost1313 · Post by **ghost1313** » Wed Aug 31, 2016 11:18 pm

Wow this looks incredible!

Is there a way to make this work in 3.1.9? I loaded it up and realized its for v3.2

Galixte de EzCom · Post by **Galixte de EzCom** » Thu Sep 01, 2016 1:09 am

Hi,

no it’s the opposite it’s for phpBB 3.1, see here: https://github.com/dmzx/youtubegallery.

ghost1313 · Post by **ghost1313** » Thu Sep 01, 2016 1:35 am

Galixte de EzCom wrote:Hi,

no it’s the opposite it’s for phpBB 3.1, see here: https://github.com/dmzx/youtubegallery.

I have 3.1.9 and it will not let me activate it because its for 3.2

from details pulled from customize tab

Extension Details
Display Name:
Youtube Videos Gallery
Clean Name:
dmzx/youtubegallery
Description:
This extension adds a new page to your phpBB3, on this page is possible add YouTube videos simply by submitting the video URL and watch the videos directly on your phpBB3.
Version:
1.0.2
Homepage:
http://www.dmzx-web.net
Release Time:
2016-04-17
Licence:
GPL-2.0
Requirements
phpBB Version:
3.2.0
PHP Version:
>=5.3.3

Galixte de EzCom · Post by **Galixte de EzCom** » Thu Sep 01, 2016 1:44 am

Your archive was downloaded from the website of the author, if you download from Github repository is it the same case ? https://github.com/dmzx/youtubegallery/ ... master.zip

EDIT: it’s strange i have edited the both archives and it’s the same information in the composer.json file:

Code: Select all

		"display-name": "Youtube Videos Gallery",
		"soft-require": {
			"phpbb/phpbb": "3.1.*"

ghost1313 · Post by **ghost1313** » Thu Sep 01, 2016 1:58 am

Galixte de EzCom wrote:Your archive was downloaded from the website of the author, if you download from Github repository is it the same case ? https://github.com/dmzx/youtubegallery/ ... master.zip

EDIT: it’s strange i have edited the both archives and it’s the same information in the composer.json file:
Code: Select all
		"display-name": "Youtube Videos Gallery",
		"soft-require": {
			"phpbb/phpbb": "3.1.*"

you rock! yep from his site its 3.2, thanks!!!

ghost1313 · Post by **ghost1313** » Thu Sep 01, 2016 2:05 am

Well shoot, I need an API key, I'm assuming its a youtube API key that's needed?

OK so I got the Youtube api key added and verified my domain through them. Did I get the correct API key needed or does that even matter as long as you get one.

This process is a log bigger then I thought but I want to make sure to do it correctly. After this can anyone who is using this feature let me know what else I will need to do or what to expect from here. are the videos just the ones that get loaded to my board that get added to the video library or do I manually add them somehow?

Thanks for spending time helping me with this, its very much appreciated!

Galixte de EzCom · Post by **Galixte de EzCom** » Thu Sep 01, 2016 2:46 am

No, a Googe API created espacially on developer console.

ghost1313 · Post by **ghost1313** » Thu Sep 01, 2016 3:06 am

thats what I set up, I have an API manager dashboard and added a api key that was tied to youtube - ther eis no API key called google public api key, Im assuming he meant any google api key that links to my website.
Is there a tutorial for this extension / process somewhere? What API kets are others using for this extension?
Google has 8 API categories
Google Cloud APIs
Google Maps APIs
Google Apps APIs
Mobile APIs
Social APIs
YouTube APIs
Advertising APIs
Other popular APIs

each category has several options, my assumption was any would work as there was no definition as to which specific one was needed. What is the specific API key needed? There are many "developer" keys.

I have no problem workng through the process for getting another one, just need to know which one if there is a specific one to get.

Thanks again!

ETA : Is it a Server Key that I need? sorry Im still digging through options.

Galixte de EzCom · Post by **Galixte de EzCom** » Thu Sep 01, 2016 3:39 am

Yes a Server key.

advertisements