vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - vBTube LE 2.1.1 Media Library UPDATE vBulletin 4.2.x (https://vborg.vbsupport.ru/showthread.php?t=279864)

andyv72 07-16-2012 11:45 PM

hi..

Cant install XML

Error:
Code:

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbtube_tubes` (
  `tubeid` int(20) unsigned NOT NULL auto_increment,
  `categoryid` int(3) unsigned NOT NULL default '0',
  `forumid` int(10) unsigned NOT NULL default '0',
  `userid` int(20) unsigned NOT NULL default '0',
  `username` varchar(70) NOT NULL default '',
  `email` varchar(70) NOT NULL default '',
  `title` mediumtext,
  `vidlang` varchar(50) NOT NULL default '',
  `link` varchar(170) NOT NULL default '',
  `link1` longtext NOT NULL,
  `link2` longtext NOT NULL,
  `link3` longtext NOT NULL,
  `link1img` varchar(250) NOT NULL default '',
  `thumb_type` int(1) unsigned NOT NULL default '0',
  `filename` varchar(30) NOT NULL default '',
  `mext` varchar(6) NOT NULL default '',
  `msize` int(20) unsigned NOT NULL, 
  `filename_mp4` varchar(30) NOT NULL default '',
  `filename_img` varchar(30) NOT NULL default '',
  `filename_img2` varchar(30) NOT NULL default '',
  `photo_mp3` varchar(30) NOT NULL default '',
  `url_flv` varchar(150) NOT NULL default '',
  `ofilename` varchar(20) NOT NULL default '',
  `oext` varchar(6) NOT NULL default '',
  `osize` int(20) unsigned NOT NULL, 
  `mediatype` varchar(50) NOT NULL default '',
  `site` varchar(50) NOT NULL default '',
  `aboutme` longtext,
  `active` varchar(1) NOT NULL default '0',
  `tube` varchar(50) NOT NULL default '',
  `views` int(30) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rates` int(10) unsigned NOT NULL default '0',
  `rating` double(5,2) unsigned NOT NULL default '0.00',
  `duration` varchar(15) NOT NULL default '', 
  `keywords` varchar(250) NOT NULL default '',
  `joindate` int(10) unsigned NOT NULL default '0',
  `reviewid` int(10) unsigned NOT NULL default '0',
  `positive` int(10) unsigned NOT NULL default '0',
  `negative` int(10) unsigned NOT NULL default '0',
  `reported` varchar(1) NOT NULL default '0',
  `reporteruser` varchar(50) NOT NULL default '',
  `reportreason` mediumtext,
  `reportcategory` varchar(50) NOT NULL default '',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `lastposter` int(10) unsigned NOT NULL default '0',
  `totalcom` int(8) unsigned NOT NULL default '0', 
  `deleted` int(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tubeid`)
) TYPE=MyISAM;

MySQL-Fehler  : Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'TYPE=MyISAM' in Zeile 51
Fehler-Nr.    : 1064
Fehler-Zeit  : Tuesday, 17.07.2012 @ 02:42:52
Datum        : Tuesday, 17.07.2012 @ 02:42:52
Skript        : admincp/plugin.php?do=productimport
Referrer      : admincp/plugin.php?do=productadd
IP-Adresse    : xx.xx.xx.xx
Benutzername  : Andy-V72
Klassenname  : vB_Database
MySQL-Version : 5.5.25-1~dotdeb.0

Can anyone Help ??

Toorak Times 08-04-2012 04:40 PM

Hi, Loving this mod! Added a track to a slideshow. May have done it wrong, added track to first pic. Got this anyway.

a. http://www.tooraktimes.com.au/media/...ng-Dong-Lounge

Cheers

Mick

edit: Can anyone help?

Elenna 08-08-2012 07:58 PM

I just installed on 4.2, and had the same issue with the overlapping menus.

I disabled the Menu plugin, but it still did it on my manually-created button.

So I went into vBTube Option, turns OFF "Tabs Menu" and turned ON "Usermenu". Then I could delete my manually-created button (do NOT disable the Menu plugin).

All is well. :)

Elenna 08-08-2012 08:19 PM

I'm getting the following errors when trying to view a video:
Code:

Deprecated: Assigning the return value of new by reference is deprecated in /home/content/76/9471276/html/uat/vbtube_show.php on line 360

Deprecated: Assigning the return value of new by reference is deprecated in /home/content/76/9471276/html/uat/vbtube_show.php on line 642

Deprecated: Assigning the return value of new by reference is deprecated in /home/content/76/9471276/html/uat/vbtube_show.php on line 1042

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at [path]/vbtube_show.php:360) in [path]/includes/facebook/facebook.php on line 37

Warning: Cannot modify header information - headers already sent by (output started at [path]/vbtube_show.php:360) in [path]/vbtube_show.php on line 659

I am also having the same issue. Video uploads just fine, plays just fine, etc.

The template edit to headinclude didn't fix it:
Change
<vb:if condition="$show['fb_opengraph']">
to
<vb:if condition="$show['fb_opengraph'] AND THIS_SCRIPT != 'vbtube'">

Elenna 08-09-2012 12:43 AM

Strange, I enabled .htaccess re-write mode and then disabled it, and the error messages went away. :)

Fongool 08-10-2012 11:11 PM

I'm getting the same error as Andy:
(I removed my Dbname and My IP from the error)
Can anyone help with this? I get this after uploading the files, chmodding the 2 folders to 777...then when I try to import the .xml file in the admin panel, I get the following error:

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbtube_tubes` (
`tubeid` int(20) unsigned NOT NULL auto_increment,
`categoryid` int(3) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`userid` int(20) unsigned NOT NULL default '0',
`username` varchar(70) NOT NULL default '',
`email` varchar(70) NOT NULL default '',
`title` mediumtext,
`vidlang` varchar(50) NOT NULL default '',
`link` varchar(170) NOT NULL default '',
`link1` longtext NOT NULL,
`link2` longtext NOT NULL,
`link3` longtext NOT NULL,
`link1img` varchar(250) NOT NULL default '',
`thumb_type` int(1) unsigned NOT NULL default '0',
`filename` varchar(30) NOT NULL default '',
`mext` varchar(6) NOT NULL default '',
`msize` int(20) unsigned NOT NULL,
`filename_mp4` varchar(30) NOT NULL default '',
`filename_img` varchar(30) NOT NULL default '',
`filename_img2` varchar(30) NOT NULL default '',
`photo_mp3` varchar(30) NOT NULL default '',
`url_flv` varchar(150) NOT NULL default '',
`ofilename` varchar(20) NOT NULL default '',
`oext` varchar(6) NOT NULL default '',
`osize` int(20) unsigned NOT NULL,
`mediatype` varchar(50) NOT NULL default '',
`site` varchar(50) NOT NULL default '',
`aboutme` longtext,
`active` varchar(1) NOT NULL default '0',
`tube` varchar(50) NOT NULL default '',
`views` int(30) unsigned NOT NULL default '0',
`votes` int(10) unsigned NOT NULL default '0',
`rates` int(10) unsigned NOT NULL default '0',
`rating` double(5,2) unsigned NOT NULL default '0.00',
`duration` varchar(15) NOT NULL default '',
`keywords` varchar(250) NOT NULL default '',
`joindate` int(10) unsigned NOT NULL default '0',
`reviewid` int(10) unsigned NOT NULL default '0',
`positive` int(10) unsigned NOT NULL default '0',
`negative` int(10) unsigned NOT NULL default '0',
`reported` varchar(1) NOT NULL default '0',
`reporteruser` varchar(50) NOT NULL default '',
`reportreason` mediumtext,
`reportcategory` varchar(50) NOT NULL default '',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` int(10) unsigned NOT NULL default '0',
`totalcom` int(8) unsigned NOT NULL default '0',
`deleted` int(1) unsigned NOT NULL default '0',
PRIMARY KEY (`tubeid`)
) TYPE=MyISAM;

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 'TYPE=MyISAM' at line 51
Error Number : 1064
Request Date : Friday, August 10th 2012 @ 07:08:27 PM
Error Date : Friday, August 10th 2012 @ 07:08:28 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.23-55

Elenna 08-11-2012 08:12 PM

From a different thread, I found this that might solve the issue?
https://vborg.vbsupport.ru/showpost....postcount=1912

In the install XML file:

Find
Code:

TYPE=MyISAM
Replace With
Code:

ENGINE=MyISAM

extremeseo 08-12-2012 07:59 AM

How to buy pro version ?

Fongool 08-12-2012 12:55 PM

I was having the same trouble with Spam-O-Matic also...I tried what you posted and it worked perfectly!...Thank you so much...
(Edit)...I think I spoke too soon...LOL...It does work, and shows up as the "Media" tab on the forum...BUT, when I click on the Media tab, it gives me this:

you do not have permission to access this page. This could be due to one of several reasons:

1) Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2) If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

and I am the Administrator...I went through all the permissions, and there are no permissions for this....I'm going to keep looking...LOL...


F

Quote:

Originally Posted by Elenna (Post 2356284)
From a different thread, I found this that might solve the issue?
https://vborg.vbsupport.ru/showpost....postcount=1912

In the install XML file:

Find
Code:

TYPE=MyISAM
Replace With
Code:

ENGINE=MyISAM


Elenna 08-12-2012 01:47 PM

There are permissions for this on the Usergroups, for me it's the last item in the list. Make sure you give yourself (or your Admin usergroup) FULL permissions (YES to everything in the vB Tube section). I missed one, and it gave me the same error message. :(


All times are GMT. The time now is 03:58 PM.

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.01621 seconds
  • Memory Usage 1,763KB
  • 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
  • (6)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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