Search the web
Sign In
New User? Sign Up
tvdinner
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
having some trouble with lastest version   Message List  
Reply | Forward Message #95 of 121 |
Re: having some trouble with lastest version


> # stream/download/playlist MP3 handler
> Alias /mp3 /mp3
>
> <Location /mp3>
> SetHandler perl-script
> PerlHandler Apache::MP3
> </Location>

that was it. apache::mp3 was installed, but this file was using
App::TVDinner::MP3, and the alias was incorrect for me. once i
adjusted those, streaming and downloading works great.

it seems i have some duplicate entries in places, and the potential
duplicate count = 39. however if i click that number it flips me to
the screen but doesnt list anything. by duplicates im referring to 2
duplicate (in name, track, time, etc) entries under the album. one
works, the other goes to "page cannot be displayed". wondering how i
could fix this.

now that its working, i have been adding in some users. i keep
getting this error:

System error

error: DBD::mysql::st execute failed: Unknown column 'username'
in 'field list' at /www/tvdinner/system/adduser.html line 169.

context: ...
165: # nice to have right about now!)
166: $insert_sql = "insert into prefs (username) values (?)";
167: $insert_sth = $gdbh->prepare($insert_sql);
168: $insert_sth->bind_param(1,$ARGS{username});
169: $res = $insert_sth->execute;
170: }
171:
172: $sql = "select id, username, password, fullname, perm_access,
perm_stream,
173: perm_download, perm_edit, perm_upload, perm_system,
...

code stack: /www/tvdinner/system/adduser.html:169
/www/tvdinner/system/autohandler:2
/www/tvdinner/autohandler:23

if i restart apache, and then go back to the users list, the user has
been added. it also seems i can delete, and edit users without
seeing an error.

thanks for all the help,
i really like this thing






Wed Oct 27, 2004 3:43 am

valmasj
Offline Offline
Send Email Send Email

Forward
Message #95 of 121 |
Expand Messages Author Sort by Date

for starters the install_database.sh script didnt work for me. i had to tell it to use the mysql database when running create_user_accounts.sql. Then it...
Pablo Martinez
valmasj
Offline Send Email
Oct 21, 2004
6:44 am

... Thanks for catching that -- I fixed it in the current version. You're right, the install_database.sh script needs the following: echo "generating default...
Sean Keplinger
keane_skeplin
Offline Send Email
Oct 21, 2004
5:22 pm

ok i spent a bit more time, made sure i ran all the database configs that were in there, and then double checked the playlist_idx and by default there were 3...
Pablo Martinez
valmasj
Offline Send Email
Oct 21, 2004
7:52 pm

... The error is happening right after you login? After you recieve the error, try going to a different page by typing in the URL. For example: http://<your...
Sean Keplinger
keane_skeplin
Offline Send Email
Oct 22, 2004
12:09 pm

i entered dbstats.html in manually and it came up. it seems like i can navigate just about everywheres except main_menu. when i try to go to main_menu i get...
Pablo Martinez
valmasj
Offline Send Email
Oct 22, 2004
1:22 pm

... Ok. Looks like there's something wrong with the way the $limit variable coming in is handled. It's passing it to the query as a string when it should be a...
Sean Keplinger
keane_skeplin
Offline Send Email
Oct 22, 2004
4:35 pm

that took care of me for the login side of things. however i still have one remaining problem, and thats downloading/playing songs. im sure its a permission...
Pablo Martinez
valmasj
Offline Send Email
Oct 23, 2004
2:43 am

... Check the permissions on your /mp3 diretory -- make sure that Apache has permissions to read the files. Also, make sure you have the following in your...
Sean Keplinger
keane_skeplin
Offline Send Email
Oct 26, 2004
3:01 pm

... that was it. apache::mp3 was installed, but this file was using App::TVDinner::MP3, and the alias was incorrect for me. once i adjusted those, streaming...
Pablo Martinez
valmasj
Offline Send Email
Oct 27, 2004
3:44 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help