[CDB] Youtube Videos Gallery

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Locked
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Re: [DEV] Youtube Videos Gallery

Post by noth »

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" 8-) it is great!!
CCRoiDanton
Registered User
Posts: 35
Joined: Thu Oct 18, 2012 11:17 pm

Re: [DEV] Youtube Videos Gallery

Post by CCRoiDanton »

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!
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Re: [DEV] Youtube Videos Gallery

Post by noth »

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? :x

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?
User avatar
_Vinny_
Style Customisations
Style Customisations
Posts: 8754
Joined: Tue Aug 11, 2009 12:45 am
Location: Brazil
Name: Marcus Vinicius
Contact:

Re: [DEV] Youtube Videos Gallery

Post by _Vinny_ »

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? :x
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.
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Re: [DEV] Youtube Videos Gallery

Post by noth »

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? 8-)
User avatar
_Vinny_
Style Customisations
Style Customisations
Posts: 8754
Joined: Tue Aug 11, 2009 12:45 am
Location: Brazil
Name: Marcus Vinicius
Contact:

Re: [DEV] Youtube Videos Gallery

Post by _Vinny_ »

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? 8-)
Honestly, I recommend not delete, you will lose the data.
ghost1313
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [DEV] Youtube Videos Gallery

Post by ghost1313 »

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 :(
User avatar
Galixte de EzCom
Registered User
Posts: 1091
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [DEV] Youtube Videos Gallery

Post by Galixte de EzCom »

Hi,

no it’s the opposite it’s for phpBB 3.1, see here: https://github.com/dmzx/youtubegallery.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
ghost1313
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [DEV] Youtube Videos Gallery

Post by ghost1313 »

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
User avatar
Galixte de EzCom
Registered User
Posts: 1091
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [DEV] Youtube Videos Gallery

Post by Galixte de EzCom »

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.*"
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
ghost1313
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [DEV] Youtube Videos Gallery

Post by ghost1313 »

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
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [DEV] Youtube Videos Gallery

Post by ghost1313 »

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!
User avatar
Galixte de EzCom
Registered User
Posts: 1091
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [DEV] Youtube Videos Gallery

Post by Galixte de EzCom »

No, a Googe API created espacially on developer console.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
ghost1313
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [DEV] Youtube Videos Gallery

Post by ghost1313 »

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.
User avatar
Galixte de EzCom
Registered User
Posts: 1091
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [DEV] Youtube Videos Gallery

Post by Galixte de EzCom »

Yes a Server key.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
Locked

Return to “Extensions in Development”