Adventure Game Studio | Forums

AGS Development => Site & Forum Reports => Topic started by: Slasher on Thu 22/06/2017 13:05:57

Title: Database error when adding Youtube video
Post by: Slasher on Thu 22/06/2017 13:05:57
Adding Youtube video to game database page.

it seems this does not work on database page:

https://www.youtube.com/watch?v=-psgUB-aypk

also there is a very large gap between adding photos an adding game name.


Title: Re: Database error when adding Youtube video
Post by: AGA on Fri 23/06/2017 11:11:34
Would help if you mentioned the name of the game you're talking about...
Title: Re: Database error when adding Youtube video
Post by: arj0n on Fri 23/06/2017 11:27:35
Splinter: http://www.adventuregamestudio.co.uk/site/games/game/216
Title: Re: Database error when adding Youtube video
Post by: Slasher on Fri 23/06/2017 20:14:58
It's actually

Splinter:

http://www.adventuregamestudio.co.uk/site/games/game/2167/

Using

H T T P S://www.youtube.com/watch?v=-psgUB-aypk   (H T T P S intended so can show url)

Title: Re: Database error when adding Youtube video
Post by: AGA on Sat 24/06/2017 09:31:33
QuoteYouTube ID (e.g. https://www.youtube.com/watch?v=1Ml_DR76Cl4):

I've edited it to actually follow that rule, and it works now.

Quote from: Slasher on Thu 22/06/2017 13:05:57
also there is a very large gap between adding photos an adding game name.

Not sure what you mean by this?  I don't see any large gap on the edit game form?
Title: Re: Database error when adding Youtube video
Post by: Slasher on Sat 24/06/2017 10:38:48
Thanks for doing the video AGA
Quote
Not sure what you mean by this?  I don't see any large gap on the edit game form?
Whenever I click to EDIT game information there is a large vertical space between add photos and add game name..

http://www.adventuregamestudio.co.uk/site/games/game/2167/

Title: Re: Database error when adding Youtube video
Post by: Cassiebsg on Sat 24/06/2017 10:57:44
Slasher, maybe a screenshot would help?
Title: Re: Database error when adding Youtube video
Post by: Slasher on Sat 24/06/2017 12:44:19
(pt) Screenshot of gap

(http://i1181.photobucket.com/albums/x423/qikfire/AGS%20GAMEDATABASE_zpsufehxoxf.png)

I don't think this happen with just one game of mine...
Title: Re: Database error when adding Youtube video
Post by: Slasher on Mon 10/07/2017 11:32:27
My image has lost hosting..

I see the long vertical space in the game database edit has still not be addressed.
Title: Re: Database error when adding Youtube video
Post by: AGA on Wed 12/07/2017 05:52:09
I still don't see a large gap on the edit form myself, so I don't know what to tell you.  There's no obvious reason in the code why this might be happening.
Title: Re: Database error when adding Youtube video
Post by: Slasher on Wed 12/07/2017 12:26:58
Hi AGA.

Let me try it again..

I'll be back (laugh)

[EDIT]

This is also happening to other people....

Look at the vertical space gap (nod)

(http://i.imgur.com/kJ6sjl0.png)

This is for all my games on the edit page...

Title: Re: Database error when adding Youtube video
Post by: Slasher on Wed 12/07/2017 12:48:10
Hi

Could you check your game's edit page and let me know if it appears ok...that is there is no large vertical space..

cheers

slasher
Title: Re: Database error when adding Youtube video
Post by: Stupot on Wed 12/07/2017 13:06:26
Yep, same.
This is on Safari on iOS
(http://i.imgur.com/YGyxBSk.jpg)
Title: Re: Database error when adding Youtube video
Post by: CaesarCub on Wed 12/07/2017 13:46:37
I'm having the same issue on Chrome on a 1920x1080 resolution.
Title: Re: Database error when adding Youtube video
Post by: AGA on Wed 12/07/2017 18:07:55
I get what you're saying, but also:
(http://www.adventuregamestudio.co.uk/images/temp/slasher.png)

And as I say, there doesn't seem to be anything in the HTML that would cause what you're seeing...  Can somebody web design savvy have a look and see if they can work out what might be causing the gap?
Title: Re: Database error when adding Youtube video
Post by: Cassiebsg on Wed 12/07/2017 18:19:25
Looks good (no GAP) on my Firefox(s) (28 & 54)
Title: Re: Database error when adding Youtube video
Post by: cat on Wed 12/07/2017 19:24:43
Looks fine for me as well with Firefox.
But I noticed another weird issue when checking the game page: The most recent comments seem to date all from 2017-07-10 17:15:24 but they have been added a long time ago ???
Title: Re: Database error when adding Youtube video
Post by: Khris on Wed 12/07/2017 19:37:10
If the space is too narrow for the table, the browser moves it below the floating white box. Firefox and Chrome simply have different cutoff points; Firefox will show the table if the gap is at least 670 pixels wide, but Chrome wants at least ~800 pixels.

The problem is of course easily solved: hide the entire white box on the edit page, since it's not really needed there anyway.

Also, this post should probably go into http://www.adventuregamestudio.co.uk/forums/index.php?topic=47530.0
Title: Re: Database error when adding Youtube video
Post by: Slasher on Wed 12/07/2017 19:40:54
Hi Khris,

it had already been reported to AGA...

cheers
Title: Re: Database error when adding Youtube video
Post by: Khris on Wed 12/07/2017 22:17:08
1. Get Chrome's Stylish extension
2. Create a new style:
Code (CSS) Select
#main { width: 1090px }

3. Set "Applies to" to "URLs matching the regexp" and enter this in the box: https?://www.adventuregamestudio.co.uk/site/games/game/\d+/edit/
4. Enter a name for the rule at the top left and click "Save".
Title: Re: Database error when adding Youtube video
Post by: Gurok on Thu 13/07/2017 02:16:23
Khris listed a good workaround in the other thread (http://www.adventuregamestudio.co.uk/forums/index.php?topic=55015.msg636565800#msg636565800), but fixing the design properly is a bit involved.

Remove all size=75 declarations from <input> elements in the code. These, combined with the width of the YouTube URL in the left column of the table, are what is pushing the width of the table out.
Add a class to each of the affected <input> elements, something like class="fullWidth".
Add a rule to the stylesheet:
.fullWidth { width: 100% }

If you don't fancy messing with the textboxes, you could fix it with just:
input[type=text][size=75] { width: 100% }
However, this is overriding the bad markup and may negatively affect other pages. It would be better to clean up the markup and apply styles in a modern fashion (as above).

Note: I tested these solutions in Chrome (which exhibited the problem for me) and they worked for me.
Title: Re: Database error when adding Youtube video
Post by: AGA on Thu 13/07/2017 17:19:06
Seems to be fixed now in Chrome for me.  Thanks, Khris and Gurok for your ideas.

I'm currently working on cleaning up the site's backend code.  I'll try to abstract as much of the styling to CSS as I can while I'm at it.
Title: FIXED: Database error when adding Youtube video
Post by: Slasher on Thu 13/07/2017 17:56:23
Good man AGA (nod)

Now fixed for me in Chrome.

Cheers