vb.org Archive
Page 2 of 312 1 2 341252102 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - 8WayRun.Com - Media Library (https://vborg.vbsupport.ru/showthread.php?t=240677)

Jaxel 04-17-2010 09:20 PM
Use & instead of &

The string is treated as raw unparsed text, for security reasons.

rule0 04-17-2010 09:29 PM
When I click a user link in media.php it gives the following sql error:
Code:
Invalid SQL:

                SELECT user.*, media.userID, COUNT(media.mediaID) AS count
                FROM vb_user AS user
                LEFT JOIN vb_media AS media ON(media.userID = user.userid)
                WHERE user.userid = '1';

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140
vb 4.0.3

ps: thanks, we've been waiting for this, was keeping 3.x plugin since 4.x upgrade. nominated and appreciated :)

kho91 04-17-2010 09:38 PM
that work fine for me, but i have too small problem, : the yahoo video and google video don't work

Jaxel 04-17-2010 09:42 PM
Quote:
Originally Posted by rule0 (Post 2022877)
When I click a user link in media.php it gives the following sql error:

vb 4.0.3

ps: thanks, we've been waiting for this, was keeping 3.x plugin since 4.x upgrade. nominated and appreciated :)
Okay, its odd that you are getting this error on user pages, but NOT tag or category pages; since NONE of those pages have the implicit GROUP BY clause either. In my version of MySQL, GROUP BY is not required. Do you get this error on any other pages? Most importantly, do you also get it on a SEARCH page?

Anyway, I uploaded a new version just for you... try it now.

Quote:
Originally Posted by kho91 (Post 2022884)
that work fine for me, but i have too small problem, : the yahoo video and google video don't work
Thats because there is no import function for Yahoo or Google yet.

rule0 04-17-2010 10:03 PM
Quote:
Originally Posted by Jaxel (Post 2022887)
Okay, its odd that you are getting this error on user pages, but NOT tag or category pages; since NONE of those pages have the implicit GROUP BY clause either. In my version of MySQL, GROUP BY is not required. Do you get this error on any other pages? Most importantly, do you also get it on a SEARCH page?
i checked now and it gives the same error in category links.
also when i search smtg it gives this error:
Code:
Parse error: syntax error, unexpected ';' in ..\media\media_search.php  on line 76
mysql: 5.0.51b
os: windows 2k3
php 5.2.6
vb: 4.0.3

note: upgraded from VDR

edit: ok trying new version, ty for quick response :)

rule0 04-17-2010 10:08 PM
Quote:
Originally Posted by Jaxel (Post 2022887)
..
Anyway, I uploaded a new version just for you... try it now.
..
user and category links are ok now! problem fixed. thanks.

but search still gives the following error:
Code:
Parse error: syntax error, unexpected ';' in ...\media\media_search.php  on line 73

Jaxel 04-17-2010 10:10 PM
I'm an idiot... new version... fixed.

How you guys like the new thumbnail format?

kho91 04-17-2010 10:16 PM
i can't edit TAG a have this error

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT media_tag_content.*, media_tag.tagText, user.username
FROM vbmedia_tag_content AS media_tag_content
LEFT JOIN vbmedia_tag ON(media_tag.tagID = media_tag_content.tagID)
LEFT JOIN vbuser AS user ON (user.userid = media_tag_content.userid)
WHERE media_tag_content.mediaID = '186';

MySQL Error : Unknown column 'media_tag.tagText' in 'field list'
Error Number : 1054
Request Date : Sunday, April 18th 2010 @ 01:14:55 AM
Error Date : Sunday, April 18th 2010 @ 01:14:56 AM
Script : http://www.mysite.com/media.php?do=tags_edit&mid=186
Referrer : http://www.mysite.com/media.php?do=details&mid=186
IP Address :
Username : Aroot
Classname : vB_Database
MySQL Version : 5.0.67-log

Jaxel 04-17-2010 10:23 PM
Dammit... its always some random TABLE PREFIX error that I miss... fixed.

rule0 04-17-2010 10:26 PM
Quote:
Originally Posted by Jaxel (Post 2022898)
I'm an idiot... new version... fixed.

How you guys like the new thumbnail format?
ok, search is working good now. 449 media imported from vdr and all is working perfect! ty!

new thumbnail format is much better. this is a perfect mod. :up:


All times are GMT. The time now is 04:34 PM.
Page 2 of 312 1 2 341252102 Last »
Show 40 post(s) from this thread on one page

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.02235 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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