vb.org Archive
Page 11 of 54 « First 910 11 121321 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vJukebox - Song and Video Management System (https://vborg.vbsupport.ru/showthread.php?t=102555)

markbolyard 12-20-2005 06:53 PM
Works Great. Install did not put tables into the database, so I opened the xml file up in a editor and manually added the table. Works like a charm now!

Clicks install.

MissKalunji 12-20-2005 08:13 PM
Quote:
Originally Posted by namesville.com
Works Great. Install did not put tables into the database, so I opened the xml file up in a editor and manually added the table. Works like a charm now!

Clicks install.

how did you? everytime i try to add the first table it keeps giving me errors

can you give me the right syntax for the tables plz?

RichieBoy67 12-20-2005 08:53 PM
Can someone take these querri out of the xml and create manual instructions?? I don't have time right now but this will work fine...

markbolyard 12-20-2005 10:08 PM
Quote:
Originally Posted by MissKalunji
how did you? everytime i try to add the first table it keeps giving me errors

can you give me the right syntax for the tables plz?
Ok, here is the sql to create the tables... I have discovered a couple problems, which I will work out and share my fixes here. In the meantime:

Code:
-- Table structure for table `jukebox_media`
--

CREATE TABLE `jukebox_media` (
  `mediaid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `plays` smallint(5) NOT NULL default '0',
  `active` int(2) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `username` varchar(225) NOT NULL default '',
  `totalrating` int(5) NOT NULL default '0',
  `announce` int(2) NOT NULL default '0',
  `genre` varchar(50) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `author` varchar(100) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  `whovoted` varchar(25) NOT NULL default '',
  `totalvotes` int(15) NOT NULL default '0',
  PRIMARY KEY  (`mediaid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
Code:
-- Table structure for table `jukebox_comments`
--

CREATE TABLE `jukebox_comments` (
  `mediaid` int(10) unsigned NOT NULL default '0',
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `date` int(10) unsigned NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `lasteditdate` int(10) default NULL,
  `lasteditusername` varchar(25) default NULL,
  `lastedituserid` int(10) default NULL,
  `ipaddress` varchar(15) default NULL,
  PRIMARY KEY  (`commentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Just copy and paste these these into your sql queries box in phpmyadmin.

The one problem I am facing is a error when administering media through the admincp, and the script is trying to locate a field in the table jukebox_media called album. I imagine if I remove this from the sql file, it will take care of it. I will keep you updated as I figure things out...

Additional Note: Phrases do not get added during product import / install.

MissKalunji 12-20-2005 10:36 PM
Quote:
Originally Posted by namesville.com
Ok, here is the sql to create the tables... I have discovered a couple problems, which I will work out and share my fixes here. In the meantime:

Code:
-- Table structure for table `jukebox_media`
--

CREATE TABLE `jukebox_media` (
  `mediaid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `plays` smallint(5) NOT NULL default '0',
  `active` int(2) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `username` varchar(225) NOT NULL default '',
  `totalrating` int(5) NOT NULL default '0',
  `announce` int(2) NOT NULL default '0',
  `genre` varchar(50) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `author` varchar(100) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  `whovoted` varchar(25) NOT NULL default '',
  `totalvotes` int(15) NOT NULL default '0',
  PRIMARY KEY  (`mediaid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
Code:
-- Table structure for table `jukebox_comments`
--

CREATE TABLE `jukebox_comments` (
  `mediaid` int(10) unsigned NOT NULL default '0',
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `date` int(10) unsigned NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `lasteditdate` int(10) default NULL,
  `lasteditusername` varchar(25) default NULL,
  `lastedituserid` int(10) default NULL,
  `ipaddress` varchar(15) default NULL,
  PRIMARY KEY  (`commentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Just copy and paste these these into your sql queries box in phpmyadmin.

The one problem I am facing is a error when administering media through the admincp, and the script is trying to locate a field in the table jukebox_media called album. I imagine if I remove this from the sql file, it will take care of it. I will keep you updated as I figure things out...

Additional Note: Phrases do not get added during product import / install.


Thanks! well my phrases were added let u know if i found anything before you ;)

markbolyard 12-20-2005 11:30 PM
Ok, need to add a additional field under jukebox_media. Go to phpmyadmin, browse to jukebox_media, view structure, and add field:

album varchar 100 (leave the rest untouched) and save... this will fix the error when you try to edit a media file through the admincp.

RichieBoy67 12-20-2005 11:44 PM
Great... Thanks.... I never looked at the xml file. I thought there were more than that...lol

Thanks much!!!

So the problem is that these are not being installed with older versions of mysql but as loing as you do them manualy your fine. Worked for me anyways... :)

markbolyard 12-20-2005 11:51 PM
Well, I am down to one last issue. Maybe one of you got through it and can help me now :)

I uploaded a video. If I click the link under "Highest Rated Media" the video opens in windows media player which is fine. Now the problem is when I click the link under "Most Accessed Media" or "List of Media", i get this message: There are no more entries to view.

It worked the very first time I tried this right after the install and additions to the database (when I clicked the media, I was taken to a template that displayed it, not right to my windows media player) Now, no go...

Thanks for any suggestions.

MissKalunji 12-20-2005 11:56 PM
Quote:
Originally Posted by namesville.com
Ok, need to add a additional field under jukebox_media. Go to phpmyadmin, browse to jukebox_media, view structure, and add field:

author varchar 100 (leave the rest untouched) and save... this will fix the error when you try to edit a media file through the admincp.
Quote:
Invalid SQL:

UPDATE jukebox_media SET
title = 'test',
author = 'test',
album = '',
url = 'http://dancehallareaz.com/forum/media/Lion king - Theme song.mp3',
genre = ''
WHERE mediaid = '6';

MySQL Error : Unknown column 'album' in 'field list'
Error Number : 1054
Date : Tuesday, December 20th 2005 @ 08:52:12 PM
Script : http://www.dancehallareaz.com/forum/...keboxadmin.php
Referrer : http://www.dancehallareaz.com/forum/...ditmedia&mid=6
thats whats happening still...and author still there

and i also get that error

uploaded_file(): Unable to move '/tmp/phpOeywfz' to '/xxxx/xxxx/xxxxx/forum/media/you are my sunshine.mp3' in /jukebox.php on line

silurius 12-21-2005 12:06 AM
I have a feeling that if imp can be accomodated, this extension could become quite powerful. Check out http://www.playimp.com.


All times are GMT. The time now is 03:55 AM.
Page 11 of 54 « First 910 11 121321 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.01442 seconds
  • Memory Usage 1,757KB
  • 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
  • (4)bbcode_code_printable
  • (5)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
  • (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