GlobeCom Jukebox / Discussion / Help: Ubuntu 12.04

john millard - 2013-10-20

Hi,
Have a problem importing mp3's on Ubuntu 12.04, have the following error(s)

DBD::mysql::st execute failed: Table 'music.genre' doesn't exist at ./import.pl line 555.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./import.pl line 556.
DBD::mysql::st execute failed: Table 'music.genre' doesn't exist at ./import.pl line 558.

Any suggestions?

Thanks

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Danny - 2013-10-21

It sounds like the genre table wasn't created during install.
It might be worth running the install script again and see if you get any errors.

How did you install gjukebox?
Did you use my scripts (http://danwood.me/gjuke_new.php)?

Best regards,
Danny

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- john millard - 2013-10-23
  
  Hi,
  Used your scripts to install, reran the scripts, tried on two other installations with same result.
  Works perfectly on 10.04.
  
  Regards
  John M
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

john millard - 2013-10-23

Dan,
Forgot to mention a couple of errors running the ./build script.
Looks like a MYSQL (and Perl) syntax problem.

Useless localization of scalar assignment at /usr/local/share/perl/5.14.2/DBI/Format.pm line 377.
Subroutine main::shell redefined at /usr/share/perl/5.14/Exporter.pm line 67.
at (eval 20) line 1

Setting up user web
ERROR 1062 (23000) at line 1: Duplicate entry 'localhost-music-web' for key 'PRIMARY'
Creating tables in music
ERROR 1064 (42000) at line 219: 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 5

Cheers
John M

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Danny - 2013-10-24

Hi John,

There are a couple of issues in the tables.sql file due to the later MySQL version on 12.04.

I actually rebuilt my jukebox using Debian Wheezy a couple of weeks ago and had to make these modifications then. I will upload the latest version to my site that has these and also contains a few modifications that makes the volume control work correctly (and possibly some other fixes).

I will post back here once this is done.

Best regards,
Danny

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

john millard - 2013-10-25

Thanks much appreciated.

Rgds
John M

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Danny - 2013-10-25

Hi John,

I just loaded up a virtual machine of Ubuntu 12.04 and the required package names are the same as on Wheezy.

Here is a link to the updated version with all the required script changes (I haven't updated my web pages yet):
http://danwood.me/files/gjuke_2.3.tar.gz

The new install script for 12.04 is called ubuntu-12.04-build with the original as ubuntu-10.04-build and the wheezy-build install script as well.

Best regards,
Danny

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- john millard - 2013-10-29
  
  Thanks Dan,
  I'll check those installs out.
  Your work very much appreciated.
  
  Thanks & Rgds
  John M
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - john millard - 2013-11-05
    
    Thanks Dan,
    12.04 working ok now, unfortunately there is no support for aumix so I'll stick to 10.04.
    Have it working on "wheezy" but have a heap of php errors (apache error log), any clues?
    
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Use of undefined co
    nstant double - assumed 'double' in /jukebox/www/connect.php on line 69
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable: VOLUME_x in /jukebox/www/left.php on line 260
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined index: RAW in /jukebox/www/left.php on line 104
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable: delurl in /jukebox/www/left.php on line 163
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable: priurl in /jukebox/www/left.php on line 165
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable: upurl in /jukebox/www/left.php on line 167
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined index: LASTPLAYED in /jukebox/www/left.php on line 182
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined index: CATEGORY in /jukebox/www/left.php on line 183
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable: delurl in /jukebox/www/left.php on line 208
    [Wed Nov 06 06:13:13 2013] [error] [client ::1] PHP Notice: Undefined variable::
    
    Rgds
    John M
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Danny - 2013-11-09
      
      I just had a quick look in the gjuke archive and it doesn't contain my rewritten setvol script that uses alsamixer instead of the custom mixer app.
      
      Are these errors occurring with the metal theme?
      
      You can usually ignore the undefined index warnings in PHP, basically they occur if an array index is tried that doesn't exist, they are usually un-harmful. I will take a look at them when I get a chance.
      
      Is the jukebox GUI functioning OK?
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - john millard - 2017-04-05
        
        Hi Dan, did you manage to rewrite the setvol script for alsamixer?
        
        Rgds
        John M
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

john millard - 2013-11-11

Confirming errors occuring with the metal theme.
If the errors are minor will turn error log off.
Jukebox GUI is functioning ok.

On the wheezy install had to replace first line of "connect.php" "import_request_variables("gpc");" with
"extract($_REQUEST, EXTR_PREFIX_ALL|EXTR_REFS, 'url');"
to make jukebox start.

My setup is an IBM X61 running off a usb(3) flash drive and a 1tb internal drive for music, had quite a few flash drive failures because excessive writes, have all logs on tmpfs now, runs quite well.

Is that setvol script (alsamixer) on your site?

Thanks
John M

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

john millard - 2013-11-15

Hi,
Have another error on wheezy, some imorted mp3s, have (Maybe you should just omit the defined()?) as file name in the gui, google says its a bug.
Ubuntu looks ok.

Rgds
John M

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Danny - 2013-11-16

Hi John,

I have just had a bit of a clean up in the jukebox code and fixed most of the warnings that you spotted. The connect.php file is generated at install time which is why the file needed modification when you installed soI have fixed that too.

The setvol script I wrote is OK but it doesn't function properly with Pulseaudio, which only shows one volume control to amixer. There is a pulseaudio perl module so I might write a new setvol script using that instead. The setvol script takes care of the normalization so loud and quiet MP3s come out the same level.

With the faulty MP3 import are you able to send me a sample file? It sounds like the perl ID3 module is spitting an error out and it might be caused by an odd tag. My email is danwood76 at gmail.com.

Best regards,
Danny

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

john millard - 2013-11-17

Thanks Dan,
Just wondering if we can do away with normalization completely without breaking anything, I run all my files through mp3gain before I load them onto the jukebox, setvol diffvol is not really required.

Solved the mp3 import problem, had quite a few songs with (path to)file names to long.
Wheezy picked up the errors but not Ubuntu.
The songs appeared on the gui, but were skipped.
Have a bit of editing to do!

Thanks & rgds
John M

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ubuntu 12.04

Forums

Help

Ubuntu 12.04 document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Ubuntu 12.04