vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Video-Directory Remixed (https://vborg.vbsupport.ru/showthread.php?t=200819)

ArnyVee 01-06-2009 06:45 PM

Quote:

Originally Posted by WarLion (Post 1703416)
i find a way arny go to admincp - avatars - storage -and change customavatar to customavatar/thumbs
i saw that the code for the avatar $comment[avatarurl] is diferent
and the you have to rebuilt the custom avatars

Wait, so you changed the name of the directory (from customavatar to customavatar/thumbs) or added a sub-directory named thumbs?

TCB 01-06-2009 07:10 PM

Quote:

Originally Posted by Pehchaan (Post 1703474)
Uninstalling it seems unsuccessful, getting this:
  • Dropping Table community_video ... Done!
  • Dropping Table community_videocategory ... Done!
  • Altering Table session ...Done!
  • Altering Table usergroup ...Done!
  • Dropping Table community_videotag ... Done!
  • Dropping Table community_videotagvideo ... Done!
  • Dropping Table community_videocomment ... Done!
  • Altering Table video ...vB_Database_Alter: fetch_table_info() has not been called successfully.
    Table 'website_forum.community_video' doesn't exist
also geeting this error on forum home:

I had the same error... I disabled it, installed the survivor version, tried to uninstall that one, upload old files, installed another old version, and so on. Now I finally had it deleted. Don't know how exactly, but it is.

THis weekend I'll try to install a better version. But it looks great so far (y)

TCB 01-06-2009 07:20 PM

djeezz.... I finally thought I had everything working, had a good install, was able to change all settings, but the went to the actual page:

Code:

Database error in vBulletin 3.7.0:

Invalid SQL:

                SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
                        FROM vb3_videotagvideo
                        INNER JOIN vb3_videotag ON (videotag.tagid = videotagvideo.tagid)
                        WHERE videotagvideo.dateline > 1199740698
                        GROUP BY videotag.tagid, videotag.tagtext
                        ORDER BY quantity DESC
                        LIMIT 50;

MySQL Error  : Unknown table 'videotag'
Error Number  : 1051
Request Date  : Tuesday, January 6th 2009 @ 02:18:18 PM
Error Date    : Tuesday, January 6th 2009 @ 02:18:18 PM
Script        : http://www.mysite/video.php
Referrer      :
IP Address    : 195.xxx.xxx.xx
Username      : TCB
Classname    : vB_Database
MySQL Version : 5.0.67-community-log


Veer 01-06-2009 07:22 PM

Quote:

Originally Posted by Jaxel (Post 1703490)
Hmm... Pehchaan... lets try it this way... In:
Manage Products > Video-Directory > EDIT > Version

Change it to 1.0.0... Then try to re-install. (used attached file)

If that doesn't work.. Delete all "Existing Install/Uninstall Code" (there are checkboxes on the right to delete them)... then uninstall, and then re-install with the attached file... But try the other way first.

okay I installed with attached xml using first way.
Forum home is fine now, but getting database error when browing /video.php

Quote:

Database error in vBulletin 3.8.0 Release Candidate 1:

Invalid SQL:

SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
FROM community_videotagvideo
INNER JOIN community_videotag ON (videotag.tagid = videotagvideo.tagid)
WHERE videotagvideo.dateline > 1199740602
GROUP BY videotag.tagid, videotag.tagtext
ORDER BY quantity DESC
LIMIT 50;

MySQL Error : Unknown table 'videotag'
Error Number : 1051
Request Date : Tuesday, January 6th 2009 @ 04:16:42 PM
Error Date : Tuesday, January 6th 2009 @ 04:16:42 PM
Script : http://www.domain.com/video.php
MySQL Version : 5.0.67-community

WarLion 01-06-2009 07:23 PM

Quote:

Originally Posted by ArnyVee (Post 1703520)
Wait, so you changed the name of the directory (from customavatar to customavatar/thumbs) or added a sub-directory named thumbs?

i chage the past from customavatar to customavatar/thumbs and now is working fine

Jaxel 01-06-2009 07:54 PM

Well at least we're making progress to weeding out all these problems... Penchaan or TCB, do you mind contacting me on aim so I can look at your forums and your database? AIM: BadBreath911

ArnyVee 01-06-2009 08:43 PM

Quote:

Originally Posted by WarLion (Post 1703555)
i chage the past from customavatar to customavatar/thumbs and now is working fine

I'm sorry, I don't understand your response to my question. Did you change the name of the directory or add a sub-directory?

Jaxel 01-06-2009 08:49 PM

ArnyVee... all he's saying is change your avatar storing options from Database to File System.

The file system will AUTOMATICALLY create a directory called /thumbs... chmod that to 777. THATS IT.

WarLion 01-06-2009 08:58 PM

sorry my englsh is not so good
what i did was change the path from my admincp-avatar-storage and change customavatars to customavatars/thumbs

and you need to have your folder forum-root/customavatars/thumbs (chmd 777) then you need to go
Maintenance > Update Counters > Rebuild Custom Avatar Thumbnails

that will move all your avatars from your db to a folder forum-root/customavatars/thumbs

that work for me not sure if will work for you
http://www.rctitis.com/foro/videos/t...te-301-15.html

Jaxel 01-06-2009 09:09 PM

No... dont change your storage to customavatars/thumbs, leave it as the default customavatars... else it will end up being customavatars/thumbs/thumbs. vBulletin AUTOMATICALLY handles the thumbs directory and pulls from it if available. Dont forget to CHMOD both customavatars and customavatars/thumbs to 777. Then run the update counter.

As long as you have both directories, vBulletin handles the rest:
/customavatars/avatar1_7.gif
/customavatars/thumbs/avatar1_7.gif

The /customavatars DIR keeps normal avatars for the forum...
The /customavatars/thumbs DIR keeps thumbnailed avatars at 60x60 for commenting sections of the forums.

WarLion 01-06-2009 09:14 PM

Quote:

Originally Posted by Jaxel (Post 1703636)
No... dont change your storage to customavatars/thumbs, leave it as the default customavatars... else it will end up being customavatars/thumbs/thumbs. vBulletin AUTOMATICALLY handles the thumbs directory and pulls from it if available. Dont forget to CHMOD both customavatars and customavatars/thumbs to 777. Then run the update counter.

As long as you have both directories, vBulletin handles the rest:
/customavatars/avatar1_7.gif
/customavatars/thumbs/avatar1_7.gif

The /customavatars DIR keeps normal avatars for the forum...
The /customavatars/thumbs DIR keeps thumbnailed avatars at 60x60 for commenting sections of the forums.

sorry thats rigt i forgot that even when that happen to me

Morrus 01-06-2009 09:15 PM

There's a problem with the tag cloud - it uses every word as a separate tag, rather than each term separated by a comma.

Thus: matt smith, david tennant becomes: matt, smith, david, tennant.

ArnyVee 01-06-2009 09:49 PM

Quote:

Originally Posted by Jaxel (Post 1703617)
ArnyVee... all he's saying is change your avatar storing options from Database to File System.

The file system will AUTOMATICALLY create a directory called /thumbs... chmod that to 777. THATS IT.

Gotcha. That worked. Thanks to both of you! :up:

So, looks like you have to move them from database to file system for them to show. Cool. :D

Jaxel 01-06-2009 09:50 PM

Morrus... there is an option in the settings for:

Tag Separators
This option allows you to specify additional tag separators. Regardless of the value here, a comma will always be used as a separator.

The default value is: { } ,

Which tells it to use spaces and commas as seperators. If you dont want to use spaces, remove the { } (there is a help icon for this setting so you can understand how it works.

DoB Rhapsody 01-06-2009 09:53 PM

I'm getting this notice when trying to import the xml:

HTML Code:

A required field called level is missing or has an invalid value.

WarLion 01-06-2009 09:57 PM

Quote:

Originally Posted by DoB Rhapsody (Post 1703667)
I'm getting this notice when trying to import the xml:

HTML Code:

A required field called level is missing or has an invalid value.

the way i solve this is installing first the original mod https://vborg.vbsupport.ru/showthread.php?t=192241 andd then upload this one overwriting that will solve your problem until jexel figure out the problem ( is really extrange)
but you can fix fast doing this

Lionsloser07 01-06-2009 10:07 PM

Hm. It is coming up blank?
http://motownsc.com/video.php

Jaxel 01-06-2009 10:26 PM

1 Attachment(s)
Okay... I've just said SCREW IT... and I rewrote the install script to correctly use the db->alter function for handing the "level" field and such... If you're having trouble installing, please uninstall, and retry with the attached file.

If it still doesnt work at this point, then I dunno. Cause I just ran through the entire code line by line, looking for errors, and I dont see any.

inciarco 01-06-2009 10:48 PM

Quote:

Originally Posted by inciarco (Post 1703404)
Hello.

Will this Mod Overwrite the Video Directory Mod's Files, Codes, Application (Product), Plugins, and Tables on the vBulletin Forum Board and Data Base? :confused:

I can see the video.php File is the same, so do the other Files and also the Installed Code will Overwrite the Video Directoy Application? :confused:

Or can Both Applications Run at the Same Time?

(I've seen the Demo and the Improvements Look Great, Congratulations and Thank You For Sharing This Great Mod). :up:

My Best Regards.

:)

I'm sorry to Bump my Question. but I think is Important to Know the Answer to it before deciding on Installing this Mod on a Forum that is already using the Video Directory Mod. :confused:

My Best Regards.

:)

ArnyVee 01-06-2009 10:55 PM

Jaxel, I noticed you aren't using the landing page announcement box on the demo. Was it "hdef" instead of "http" for the HighDef videos from YouTube? I'm almost sure it was, but just checking :)

Jaxel 01-06-2009 11:18 PM

@inciaro... this mod will overwrite Survivor's version.

@arnyvee... its HDEF for HD, HTTP for SD.

Going to sleep now... got Jury Duty tommorow.

ArnyVee 01-06-2009 11:28 PM

Oh man...hopefully you don't get picked for jury duty! :D

Thanks for the support. :up:

Jaxel 01-06-2009 11:31 PM

I WANT to get picked... I show up at 8AM... if I dont get picked, then I sit around till 5PM before I can go home... If I get picked, then the trial could be over within a few hours and I could go home earlier.

ArnyVee 01-06-2009 11:39 PM

Okay, so I hope you get picked early! :up:

By the way, I just tested a HD video (http://www.youtube.com/watch?v=nvYAfiUiycs) and changed the "http" to "hdef" and it still came through at the normal size. So, maybe tomorrow you can take a look and see if I did something wrong (probably my fault ;) ) ... here's the link to my posted video http://www.waltdisneyboards.com/vide...world-107.html


Can someone post the RSS Feed url ? I had it written down and can't find it. :(

Jaxel 01-06-2009 11:54 PM

Did you install the NEW versions of the YouTube XMLs? You must re-install them manually to get the updates.

ArnyVee 01-07-2009 12:14 AM

AHA! :D

I knew I forgot something ;)

I uploaded them, but forgot to import them again through "Manage Hoster"! Works now! :D

http://www.waltdisneyboards.com/vide...world-108.html

DoB Rhapsody 01-07-2009 01:04 AM

I tried the new xml that you attached, that worked. Installed fine. When navigating to video.php i get this error:

HTML Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
                        FROM VB_videotagvideo
                        INNER JOIN VB_videotag ON (videotag.tagid = videotagvideo.tagid)
                        WHERE videotagvideo.dateline > 1199761312
                        GROUP BY videotag.tagid, videotag.tagtext
                        ORDER BY quantity DESC
                        LIMIT 50;

MySQL Error  : Unknown table 'videotag'
Error Number  : 1051
Request Date  : Tuesday, January 6th 2009 @ 09:01:52 PM
Error Date    : Tuesday, January 6th 2009 @ 09:01:52 PM

P.S. Could vBSEO be causing this?

TCB 01-07-2009 07:55 AM

Quote:

Originally Posted by DoB Rhapsody (Post 1703775)
I tried the new xml that you attached, that worked. Installed fine. When navigating to video.php i get this error:

HTML Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
                        FROM VB_videotagvideo
                        INNER JOIN VB_videotag ON (videotag.tagid = videotagvideo.tagid)
                        WHERE videotagvideo.dateline > 1199761312
                        GROUP BY videotag.tagid, videotag.tagtext
                        ORDER BY quantity DESC
                        LIMIT 50;

MySQL Error  : Unknown table 'videotag'
Error Number  : 1051
Request Date  : Tuesday, January 6th 2009 @ 09:01:52 PM
Error Date    : Tuesday, January 6th 2009 @ 09:01:52 PM

P.S. Could vBSEO be causing this?

No, I don't have vseo and also have this error. I don't understand how others can have this mod up and running, while I (and others) are receiving this error (after an install that seemd allright).

@Arnvee: It seems your install is working. Didn't you get this error? And what did you do to fix it? (btw, great site you got there)

indie2industry 01-07-2009 08:12 AM

Jaxel. This is by far my favorate mod. Be expecting a donation soon.

Lionel 01-07-2009 09:58 AM

Actually I had to fix a couple of lines. One of them

Quote:

SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
FROM VB_videotagvideo videotagvideo
INNER JOIN VB_videotag AS videotag
you do that and the database errors will disappear

Jaxel 01-07-2009 10:24 AM

1 Attachment(s)
Yes... Lionel, that could be it... I forgot to put the AS in on the tag cloud...

Try this file if you are still getting the videotag error... NO NEED TO INSTALL.

TCB 01-07-2009 10:41 AM

Quote:

Originally Posted by Jaxel (Post 1704055)
Yes... Lionel, that could be it... I forgot to put the AS in on the tag cloud...

Try this file if you are still getting the videotag error... NO NEED TO INSTALL.

yes, that did the trick. Excellent :D

One minor question: is there a way to retrieve the name of the original youtube uploader? It does seem fair to mention this name (now the forum member who just adds it to the website gets 'the credit' as uploader

;)

TCB 01-07-2009 10:43 AM

featurerequest: let the mod check if youtube link has been already added

Veer 01-07-2009 11:47 AM

Quote:

Originally Posted by Jaxel (Post 1704055)
Yes... Lionel, that could be it... I forgot to put the AS in on the tag cloud...

Try this file if you are still getting the videotag error... NO NEED TO INSTALL.

Yes, that file works.

Another problem, getting database error when adding tag via admincp:

Quote:

Database error in vBulletin 3.8.0 Release Candidate 1:

Invalid SQL:

SELECT videotagvideo.*
FROM community_videotagvideo AS videotagvideo
WHERE videotagvideo.videoid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Request Date : Wednesday, January 7th 2009 @ 08:43:17 AM
Error Date : Wednesday, January 7th 2009 @ 08:43:17 AM
Script : http://www.forum.com/admincp/video.php?do=taginsert
Referrer : http://www.forum.com/admincp/video.php?do=tags
MySQL Version : 5.0.67-community

Lionsloser07 01-07-2009 11:59 AM

Hm. I installed everything, and I got a blank page. Then I looked at the Page Source and saw this:
<!-- SHTML Wrapper - 500 Server Error -->
Please help. http://motownsc.com/video.php

Veer 01-07-2009 12:11 PM

Found error when editing video tag:

Quote:

Database error in vBulletin 3.8.0 Release Candidate 1:

Invalid SQL:

SELECT videocategory.*
FROM community_videocategory
WHERE videocategoryid = 3;

MySQL Error : Unknown table 'videocategory'
Error Number : 1051
Request Date : Wednesday, January 7th 2009 @ 09:30:44 AM
Error Date : Wednesday, January 7th 2009 @ 09:30:44 AM
Script : http://www.forum.com/videotag.php?videoid=2
Referrer : http://www.forum.com/video.php?do=vi...nnat-full-song
MySQL Version : 5.0.67-community
Editing tag doesn't work.

ArnyVee 01-07-2009 12:42 PM

Quote:

Originally Posted by TCB (Post 1703974)
@Arnvee: It seems your install is working. Didn't you get this error? And what did you do to fix it? (btw, great site you got there)

I have to check if that was the error I got and let you know what I did to fix it. Edited: Looks like you got it working, right?

Thanks for the nice comments about the site....I've got an Elvis one in the plans too! ;)

Katelynn 01-07-2009 12:50 PM

Quote:

Originally Posted by Pehchaan (Post 1704123)
Found error when editing video tag:



Editing tag doesn't work.

Got the same error ...

Also, all my videos already posted by Members, is coming up as ??? in the lower right corner of the thumbnail?

Great Mod!

One more quick question ... should I go ahead and install the module-vbadvanced.xml? What is the deal with this?

Thanks!

Katelynn 01-07-2009 12:55 PM

One more question ...

Can we move the video tag cloud to the bottom?? How would we do that?? It is cool, but takes away from the videos on first glance at the video page. Thanks!

ArnyVee 01-07-2009 12:58 PM

Quote:

Originally Posted by Katelynn (Post 1704149)
Got the same error ...

Also, all my videos already posted by Members, is coming up as ??? in the lower right corner of the thumbnail?

Great Mod!

One more quick question ... should I go ahead and install the module-vbadvanced.xml? What is the deal with this?

Thanks!

The question marks are those for videos that were previously there and don't have the 'length of time' entered. So, just click on the video...click on 'edit' and then add the time in minutes and seconds and it'll display. :)

I'm doing that with about 100 videos now on www.WaltDisneyBoards.com/videos ...it's gonna take awhile, but it's worth it.

It's up to you whether you want the vBadvanced module on your page. I have one on mine (www.WaltDisneyBoards.com) and you can take a peek to see if it's worth it for you.

Quote:

Originally Posted by Katelynn (Post 1704153)
One more question ...

Can we move the video tag cloud to the bottom?? How would we do that?? It is cool, but takes away from the videos on first glance at the video page. Thanks!

I believe that the move can be done by going to video_home template and moving the table, but I haven't looked yet, so I'm not sure.

Good luck with everything! :D


All times are GMT. The time now is 03:05 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05690 seconds
  • Memory Usage 1,859KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_html_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete