On Fri, 22 Oct 2004, Pablo Martinez wrote:

> syntax. Check the manual that corresponds to your MySQL server
> version for the right syntax to use near ''10'' at line 9
> at /www/tvdinner/format/list_table.comp line 104.

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 numeric. Hence the problem with limit = '10'. SO, to
temporarily correct it on your system until I come up with the param to
force numeric, use this code in link_table.comp:

   $list_sql = "select d.id, d.artist, d.album, d.title, p.comment
                from directory d, playlists p, playlist_idx pi
                where (d.id = p.dir_id)
                  and (pi.id = p.list_id)
                  and (pi.listname = ?)
                  and ((pi.username='$session{tvd_u}->{username}') or
                      (pi.flag_private = 0))
                order by p.create_dt DESC
                limit $limit";
   $list_sth = $gdbh->prepare($list_sql);
   $list_sth->bind_param(1,$listname);

Note that I removed the second bind_param.

> i tried to add/remove users as well, and that works right up until (i
> think) its about to do a table update or insert or delete. and then i
> get the following error (from deleting)
>
> error:  DBD::mysql::st execute failed: Table 'mp3.user_prefs' doesn't
> exist at /www/tvdinner/system/rmuser.html line 69.

Whoops. More legacy code -- just remove that block that deletes
"user_prefs. I'm also making the change for version 0.4.3. Thanks for
catching that. (I love having testers!)

> if i may put a plug in for the new webmail-gmail.  its really sleek
> interface, very streamline, and is a great replacement address for
> hotmail accounts.  right now (im pretty sure) its still in beta mode,
> so in order to get an account you have to know someone who has an
> account.  i have 6 invites that are just sitting there, so if anyone
> would like to take advantage of them just drop me an email
> valmasj@... and ill send you an invite.  its neat for forum's
> like these because it combines messages as conversations.  oh yah and
> they give you 1000mb of space *gasp*.

I agree -- I also have a GMail account and the threaded message view
feature is very nice. The only thing I can't seem to get used to is the
lack of folders -- you can make "labels", but it still doesn't feel the
same.

I have 3 invites if anyone is interested.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin AT one DOT net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

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 the previous error:

error:  DBD::mysql::st execute failed: 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 ''10'' at line 9
at /www/tvdinner/format/list_table.comp line 104.

context:  ...
100:  limit ?";
101:  $list_sth = $gdbh->prepare($list_sql);
102:  $list_sth->bind_param(1,$listname);
103:  $list_sth->bind_param(2,$limit);
104:  $res = $list_sth->execute;
105:  </%init>
106:
107:  <%args>
108:  $listname
...

code stack:  /www/tvdinner/format/list_table.comp:104
/www/tvdinner/index.html:17
/www/tvdinner/autohandler:23

i tried to add/remove users as well, and that works right up until (i
think) its about to do a table update or insert or delete. and then i
get the following error (from deleting)

error:  DBD::mysql::st execute failed: Table 'mp3.user_prefs' doesn't
exist at /www/tvdinner/system/rmuser.html line 69.

context:  ...
65:  # cascade delete preferences
66:  $del_sql = "delete from user_prefs where username = ?";
67:  $del_sth = $gdbh->prepare($del_sql);
68:  $del_sth->bind_param(1,$ARGS{username});
69:  $res = $del_sth->execute;
70:
71:  # cascade delete prefs
72:  $del_sql = "delete from prefs where user_id = ?";
73:  $del_sth = $gdbh->prepare($del_sql);
...

code stack:  /www/tvdinner/system/rmuser.html:69
/www/tvdinner/system/autohandler:2
/www/tvdinner/autohandler:23

i noticed that it actually does delete/update/add the information,
but blows up in the process.  im sorry if this is repetative
information for you, just trying to give you as much as possible to
go on.

if i may put a plug in for the new webmail-gmail.  its really sleek
interface, very streamline, and is a great replacement address for
hotmail accounts.  right now (im pretty sure) its still in beta mode,
so in order to get an account you have to know someone who has an
account.  i have 6 invites that are just sitting there, so if anyone
would like to take advantage of them just drop me an email
valmasj@... and ill send you an invite.  its neat for forum's
like these because it combines messages as conversations.  oh yah and
they give you 1000mb of space *gasp*.

anyways thanks for the help....again =)

On Thu, 21 Oct 2004, Pablo Martinez wrote:

> let me know if you have any other ideas, or need anymore info from my end.

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 server>/tvdinner/dbstats.html

That page should come up if authentication went OK. There's a problem with
the playlists on the first page. I'll put some more thought into it today.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin AT one DOT net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

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 system's created (2 recommends, 1 favorite), and
1 guest favorite created by the database scripts.  i tried making it
even between guest and system, and even tried changign "Recommend"
to "recommend", but no dice.  its still really ticked about
something.  I probably should have left the version in there that i
was running, but i saw "new", got a twinkle in my eye, and started
deleting and recreating.  let me know if you have any other ideas, or
need anymore info from my end.

thanks=

On Thu, 21 Oct 2004, Pablo Martinez wrote:

> 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 neglected to run the
> create_prefs_tbl.sql script, so i just ran everythign manually and go
> that all done and set.

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 user accounts..."
   mysql -u root mysql <create_user_accounts.sql

Good catch!

> i actually popped open Lib.pm, and had to enter the "my" in:
>  my $btable = <<BTABLE;
> located on line 116.  it was only after i made that change that i
> could get those error msg's to go away.  and now im stuck.  i thought
> i had everything in place, but when i try to open up the site, i get:

Guh...I need to get rid of some of this legacy crap and update my Lib.pm.
I'm not even sure if I still use that stuff anymore. I will make a note to
look into it.

> error:  DBD::mysql::st execute failed: 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 ''10'' at line 9
> at /www/tvdinner/format/list_table.comp line 104.

Sounds like a problem with a record not being created in the 'recommended'
or 'favorites' playlists.

Make sure that the 'add_default_playlists.sql' was executed. Otherwise,
you can check the playlist_idx table and make sure that there is a record
for the 'favorites' and 'recommended' for that user. I believe I fixed
this with 0.4.3 but I'll check just to be sure.

> seems like it would be pretty simple, i may just have to sleep on it.
> Let me know if there is a more stable version out there that i can
> install. im eager to get this baby back up and in regular use. thanks

I'm (slowly) working on 0.4.3 which has improved playlists and graphics as
well as artist/album listing improvements.

Let me know if that works out for you!


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin AT one DOT net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

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 neglected to run the
create_prefs_tbl.sql script, so i just ran everythign manually and go
that all done and set.  when i did a make test, i kept getting:

[root@here tvdinner]# perl test.pl
1..4  configuration
2..4  database library
3..4  general library
Global symbol "$btable" requires explicit package name
at /usr/lib/perl5/site_perl/5.6.1/App/TVDinner/Lib.pm line 116.
Global symbol "$btable" requires explicit package name
at /usr/lib/perl5/site_perl/5.6.1/App/TVDinner/Lib.pm line 128.
Global symbol "$btable" requires explicit package name
at /usr/lib/perl5/site_perl/5.6.1/App/TVDinner/Lib.pm line 130.
Global symbol "$btable" requires explicit package name
at /usr/lib/perl5/site_perl/5.6.1/App/TVDinner/Lib.pm line 139.
Compilation failed in require at test.pl line 23.
BEGIN failed--compilation aborted at test.pl line 23.
[root@her tvdinner]#

i actually popped open Lib.pm, and had to enter the "my" in:
  my $btable = <<BTABLE;
located on line 116.  it was only after i made that change that i
could get those error msg's to go away.  and now im stuck.  i thought
i had everything in place, but when i try to open up the site, i get:

error:  DBD::mysql::st execute failed: 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 ''10'' at line 9
at /www/tvdinner/format/list_table.comp line 104.

context:  ...
100:  limit ?";
101:  $list_sth = $gdbh->prepare($list_sql);
102:  $list_sth->bind_param(1,$listname);
103:  $list_sth->bind_param(2,$limit);
104:  $res = $list_sth->execute;
105:  </%init>
106:
107:  <%args>
108:  $listname
...

code stack:  /www/tvdinner/format/list_table.comp:104
/www/tvdinner/index.html:17
/www/tvdinner/autohandler:23

seems like it would be pretty simple, i may just have to sleep on
it.  Let me know if there is a more stable version out there that i
can install. im eager to get this baby back up and in regular use.
thanks

On Fri, 9 Apr 2004, Andreas Haehnel wrote:

> these days I updated my mp3-collection and the tvdinner-stats show me
> some potential duplicates, but when i follow the link, the
> duplicates-list stays emtpy. I use version 0.4.1, does anyone have the
> same problem?

This feature is incomplete. Though it will tell you how many duplicates
there are, it doesn't current list *which* are duplicates. I will try to
finish this and post it here on this list.

Alternatively, there is a program in the "tools" directory called
"dups.pl" that will list duplicate filenames. It is also incomplete.

Older versions used to have the duplicate functionality, but it didn't
work quite the way I wanted it so I started to rewrite
it...and...well..didn't finish.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

Hello,

these days I updated my mp3-collection and the tvdinner-stats show me some
potential duplicates, but when i follow the link, the duplicates-list stays
emtpy.
I use version 0.4.1, does anyone have the same problem?

Andreas

On Sat, 3 Apr 2004, Pablo Martinez wrote:

> I seem to do this a lot.  turns out my previous post was just a bunch
> of hog wash.  after i was just looking at how tables were configured
> in the database and stuff, i went back and low and behold the artist
> that i was complaining about appeared.  Im pretty sure i didnt change
> anything at all, and am guessing it was just a cached page that
> needed to be refreshed.

For future reference: the "bad characters" pattern is in the "collect"
script. I have a TODO written down to move that into the
App::TVDinner::Lib module, but haven't had time to do it yet.

> gosh i love this software-def the best one out there to me
> thanks a bunch

Good to know people are still using it. I have a new version that is a lot
cleaner (better utilizes CSS), does some neat Javascript tricks, and has a
new and improved playlist feature. I will be putting that out there as
soon as I find the time.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

im not sure if its something im doing, but this is a bit weird.  the
usage of my box has jumped from not being used at all to being used a
couple times a day.  since then im getting these errors when i do
anything database related (just about everything)

error:  DBD::mysql::st execute failed: MySQL server has gone away
at /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Lock/MySQL.pm line
54.

context:  ...
50:  #MySQL requires a timeout on the lock operation. There is no
option
51:  #to simply wait forever. So we'll wait for a hour.
52:
53:  my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?,
3600)}, {}, 1);
54:  $sth->execute($self->{lockid});
55:
56:  $self->{lock} = 1;
57:  }
58:
...

code
stack:  /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Lock/MySQL.pm:54
g /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Lock/MySQL.pm:60
g /usr/lib/perl5/site_perl/5.6.1/Apache/Session.pm:569
g /usr/lib/perl5/site_perl/5.6.1/Apache/Session.pm:497
g /usr/lib/perl5/site_perl/5.6.1/Apache/Session.pm:462
g /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm:1078


let me know if im doing something wrong here, or a good idea to try
to make it go away. useually clicking back and then trying what ever
link caused this will work, its just annoying to have to try a couple
times.

thanks
josh

I seem to do this a lot.  turns out my previous post was just a bunch
of hog wash.  after i was just looking at how tables were configured
in the database and stuff, i went back and low and behold the artist
that i was complaining about appeared.  Im pretty sure i didnt change
anything at all, and am guessing it was just a cached page that
needed to be refreshed.

gosh i love this software-def the best one out there to me
thanks a bunch
josh


--- In tvdinner@yahoogroups.com, "Pablo Martinez" <valmasj@h...>
wrote:
> long time no chat everyone.  ive got a bit of a problem.  i a bunch
> of mp3's that have an ! mark in the artist name-and due to that it
> will not show up in the interface for some reason.  is there a way
> that i can get it to allow ! marks?
>
> thanks
> josh

long time no chat everyone.  ive got a bit of a problem.  i a bunch
of mp3's that have an ! mark in the artist name-and due to that it
will not show up in the interface for some reason.  is there a way
that i can get it to allow ! marks?

thanks
josh

On Fri, 12 Dec 2003, Pablo Martinez wrote:

> while im sorting all my issues out, ive got a quick question
> regarding the random tune section.  i think it looks pretty nifty all
> expanded when you boot into tvdinner.  is there a way to leave it
> always expanded for everyone when the log on?  in my opinion i think
> its a feature that should always show its face =).

Over the last week, I changed the way preferences work. Now, all of those
boxes will be sticky depending on your setting. I will put the new version
online next week. There is only one new database table, so you wont have
to completely rebuild it.

Thanks again to everyone helping to debug TVDinner.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

On Sat, 13 Dec 2003, [ISO-8859-1] Andreas Hähnel wrote:

> The fixbadfilenames doesn't do anything until you remove the '#' on line 59.

I was having problems with it not actually moving files on different
machines, so I had it just print the move commands out into a shells
script and then I would run that. There is also "fix" functionality built
into the collect script with the "-f" switch.

For fixbadfilenames, I would do something like this:

   ./fixbadfilenames.pl > fix.sh
   ./fix.sh

For collect, you can do this:

   ./collectunderpants.pl -vab -f


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

The fixbadfilenames doesn't do anything until you remove the '#' on line 59.

Andi

while im sorting all my issues out, ive got a quick question
regarding the random tune section.  i think it looks pretty nifty all
expanded when you boot into tvdinner.  is there a way to leave it
always expanded for everyone when the log on?  in my opinion i think
its a feature that should always show its face =).

thanks
josh

On Wed, 10 Dec 2003, Pablo Martinez wrote:

> yah that works fine.  i think its not the sql statement, cause that
> does work exactly as it appears.  but i think its something after
> that statement, like maybe the prepare or something.  because if i
> comment out (i think your line 25):
>
> $list_sth->bind_param(1,$limit);
>
> and then replace the ? with a number, than it works fine. but i
> havent been able to discover any differences.  is that variable used
> in a previous page that would carry over stale info?

Then it has to be the way DBI or DBD::mysql works. The ? and bind_param
functionality is built into DBI.

> email me at josh@... with a user name and password and ill
> set you up with an account on the server/tvdinner.

Will do.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

> Attached is a Perl program that attempts to read the MP3 tag off of
the
> file using the same module that TVDinner uses. Let me know if it
works for
> you. Run is as follows:
>
>   ./mp3tag mp3filename.mp3

yup works great.  im beginning to think that tvdinner just doesnt
like my linux box. here is the output from the proggie:

title = A tu Vera
artist = The Gipsy Kings
duration = 3m 22s
genre = Latin
album = The Best of The Gipsy Kings
comment =
min = 3
sec = 22
seconds = 202
track = 17
year = 1995
bitrate = 128
samplerate = 44.1

and just a fyi: that is a song that i ripped with a ID3v2 tag, the
ID3v1 worked as well.  let me know if you need anything else from me.
thanks
josh

On Thu, 11 Dec 2003, Pablo Martinez wrote:

> yes they do, i have the latest cDEx version of that ripper you talked
> about it.  And it has the option to select what kinda tag to pop in
> there.  orginially i was justing just ID3-V2, and then when you asked
> me this question, i thought i read some place that Apache::MP3 or
> Mason or something to that effect only permits ID3-V1.  so i changed
> the option on the ripper to ID3-V1 & ID3-V2, and it made no
> difference. i could still not see any genre, album, or artist.  so
> then i tried just setting it to straight ID3-V1, and i got the same
> results.  So something is squirlly and i cant even begin to find it.
> hopefully this will help your trouble shooting angle.

Attached is a Perl program that attempts to read the MP3 tag off of the
file using the same module that TVDinner uses. Let me know if it works for
you. Run is as follows:

   ./mp3tag mp3filename.mp3


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

#!/usr/bin/perl

use strict;
use MP3::Info;

# **************************************************************************
# mp3tag.pl
#
# by:            Sean Keplinger
# start date:    11.30.2000

my $application = 'mp3tag';
my $version     = '0.3';
my $verdate     = '01.24.2001';

# purpose:      return ID3v1 tag for specified file
#
# version history
#
# 01.24.2001   0.3   added duration,bitrate and samplerate to output
#
# **************************************************************************

my $file = shift;

my $tag  = get_mp3tag($file);
my $info = get_mp3info($file);

my ($title,$artist,$album,$year,$comment,$genre,$track) =
    @{$tag}{qw(TITLE ARTIST ALBUM YEAR COMMENT GENRE TRACKNUM)} if $tag;
my $duration = sprintf "%dm %2.2ds", $info->{MM}, $info->{SS};
my $seconds  = ($info->{MM} * 60) + $info->{SS};

my %data =(title        => $title,
            artist       => $artist,
            duration     => $duration,
            genre        => $genre,
            album        => $album,
            comment      => $comment,
            min          => $info->{MM},
            sec          => $info->{SS},
            seconds      => $seconds,
            track        => $track || '',
            year         => $year,
            bitrate      => $info->{BITRATE},
            samplerate   => $info->{FREQUENCY},
        );

print <<INFO;

    title      =  $data{title}
    artist     =  $data{artist}
    duration   =  $data{duration}
    genre      =  $data{genre}
    album      =  $data{album}
    comment    =  $data{comment}
    min        =  $data{min}
    sec        =  $data{sec}
    seconds    =  $data{seconds}
    track      =  $data{track}
    year       =  $data{year}
    bitrate    =  $data{bitrate}
    samplerate =  $data{samplerate}

INFO

> Hmmm...do the MP3's have ID3 tags?

yes they do, i have the latest cDEx version of that ripper you talked
about it.  And it has the option to select what kinda tag to pop in
there.  orginially i was justing just ID3-V2, and then when you asked
me this question, i thought i read some place that Apache::MP3 or
Mason or something to that effect only permits ID3-V1.  so i changed
the option on the ripper to ID3-V1 & ID3-V2, and it made no
difference. i could still not see any genre, album, or artist.  so
then i tried just setting it to straight ID3-V1, and i got the same
results.  So something is squirlly and i cant even begin to find it.
hopefully this will help your trouble shooting angle.

thanks
josh

> Maybe it's the "limit" statement. Try this: jump into mysql and try
the
> following query:
>
>   select * from directory limit 10;
>

yah that works fine.  i think its not the sql statement, cause that
does work exactly as it appears.  but i think its something after
that statement, like maybe the prepare or something.  because if i
comment out (i think your line 25):

$list_sth->bind_param(1,$limit);

and then replace the ? with a number, than it works fine. but i
havent been able to discover any differences.  is that variable used
in a previous page that would carry over stale info?

email me at josh@... with a user name and password and ill
set you up with an account on the server/tvdinner.
thanks so much
josh

On Tue, 9 Dec 2003, Pablo Martinez wrote:

> found one tiny tiny error that could prevent some confusion with
> users in the future.  in dbstats.html, url is missing a "/" so i
> change this:
[snip]

Noted and fixed. Thanks!

> also, i added and organized a bunch of mp3's that i uploaded.  i see
> some of them in the newly added section of main menu.  but i dont see
> anything when i cycle through artists artists, albums, genres.  this
> could be cause i cobbed it to work from my previous error.  instead
> of having a question mark, i just substituted a 5 and commented out
> the bind_param line so that i could get past it.  not sure if that
> adjustment is whats causing this problem as well.

Hmmm...do the MP3's have ID3 tags?


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

On Tue, 9 Dec 2003, Pablo Martinez wrote:

> thus were just running into the same problem.  what i thought
> interesting, and i dont know if they are really created equal or not,
> is that the $idx_sth variable compiled and executed fine from the
> looks of it. and that has a ? in it-way different syntax, but similar.

Maybe it's the "limit" statement. Try this: jump into mysql and try the
following query:

   select * from directory limit 10;

If that doesn't work, then try this query:

   select * from directory;

If that works, it's the limit statement.


Worst comes to worse, if you want, I can jump on your box and check it
out.


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

hey just remembered something that might and might not help this
project.  at work we write our service order system in php, and one
of the resources that we have utilized to enhance some features is

http://www.hotscripts.com

you may already know about it, but there are billions of little apps
that ppl have created in different languages to accomplish their
tasks. some are pay-for's and some are free.  you may be able to find
a script in there that you could modify to add upload functionality
or perhaps adding php to your server so that you can run a php based
forum on tvdinner. or whatever.

just thought id share that site, just because of the amount of useful
tools weve come across in just browsing around.

thanks
josh

found one tiny tiny error that could prevent some confusion with
users in the future.  in dbstats.html, url is missing a "/" so i
change this:

<!-- TOTAL FILES -->
<tr><td class="rowhead" width="50%">Total files listed:</td>
<td class="rowdata"><a href="<%$gConf->{interfaceroot}%>/display"><%
$mp3filecount%></a></td></tr>

to look like this:

<!-- TOTAL FILES -->
<tr><td class="rowhead" width="50%">Total files listed:</td>
<td class="rowdata"><a href="<%$gConf->{interfaceroot}%>/display/"><%
$mp3filecount%></a></td></tr>

also, i added and organized a bunch of mp3's that i uploaded.  i see
some of them in the newly added section of main menu.  but i dont see
anything when i cycle through artists artists, albums, genres.  this
could be cause i cobbed it to work from my previous error.  instead
of having a question mark, i just substituted a 5 and commented out
the bind_param line so that i could get past it.  not sure if that
adjustment is whats causing this problem as well.

thanks
josh

> The "?" should be replaced by a number -- looks like it replaced it
with a
> string for some reason. Replace line 25 (below) with the following:
>
>   $list_sth->bind_param(1,$limit,$DBD::mysql::SQL_INTEGER);
>

that didnt seem to help any.  it just switched the error:

error in file:   /www/mason/obj/tvdinner/format/newadd.html
   line 26:  DBD::mysql::st execute failed: 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 ''18'' at line 5

context:   ...
22:  limit ?";
23:
24:  $list_sth = $gdbh->prepare($list_sql);
25:  $list_sth->bind_param(1,$limit,$DBD::mysql::SQL_INTEGER);
26:  $res = $list_sth->execute;
27:
28:  $new = "<!-- NEW TABLE -->\n";
29:  $new .= qq(<table border="0" cellpadding="2" cellspacing="0">);
30:
...

component stack:   /tvdinner/format/newadd.html
/tvdinner/index.html
/tvdinner/autohandler

code stack:   /www/mason/obj/tvdinner/format/newadd.html:26
/www/mason/obj/tvdinner/index.html:92
/www/mason/obj/tvdinner/autohandler:186

not quite sure why the number isnt getting to that point.  but if i
replace the question mark with a five, and comment out that
bind_param line, then it moves onto this error:

error in file:   /www/mason/obj/tvdinner/format/list_table.comp
   line 47:  DBD::mysql::st execute failed: 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 ''22'' at line 9

context:   ...
43:
44:  $list_sth = $gdbh->prepare($list_sql);
45:  $list_sth->bind_param(1,$listname);
46:  $list_sth->bind_param(2,$limit);
47:  $list_sth->execute;
48:
49:  $list = "<!-- LIST TABLE -->\n";
50:  $list .= qq(<table border="0" cellpadding="2" cellspacing="0">);
51:
...

component stack:   /tvdinner/format/list_table.comp
/tvdinner/index.html
/tvdinner/autohandler

code stack:   /www/mason/obj/tvdinner/format/list_table.comp:47
/www/mason/obj/tvdinner/index.html:98
/www/mason/obj/tvdinner/autohandler:186

thus were just running into the same problem.  what i thought
interesting, and i dont know if they are really created equal or not,
is that the $idx_sth variable compiled and executed fine from the
looks of it. and that has a ? in it-way different syntax, but similar.

> btw: Did you start from scratch, rebuilding the databases and
everything?

yah, i didnt have anything in there yet, because i was running into
that moving/directory creating problem.  so i just used webmin to
drop the databases and let your script rebuild them again.  i had to
tweak some passwords and stuff like that because the defualt ones for
the database had changed.  not a big deal at all.

thanks again
josh

On Tue, 9 Dec 2003, Pablo Martinez wrote:

> turns out that you actually have to zip into CPAN and install
> Apache::MP3, and then the test completed successfully.

The App::TVDinner::MP3 module is the Apache::MP3 module with the interface
and a few other things taken out. Eventually, I'll isolate it down to the
streamer, but it's low on the priority list.

I'll update the documentation to remind people to install Apache::MP3.

> this one seems to be stumping me. not sure what it doesnt like about
> that syntax, i tried punching that sql statement into mysql from the
> command line, but with a 5 instead of a ? at the end, and it didnt
> blow up.

The "?" should be replaced by a number -- looks like it replaced it with a
string for some reason. Replace line 25 (below) with the following:

   $list_sth->bind_param(1,$limit,$DBD::mysql::SQL_INTEGER);

Not sure why it works on my OBSD box and not on your Linux box.

I appreciate the help with testing. I suppose I should be a clean box for
installation testing.

btw: Did you start from scratch, rebuilding the databases and everything?


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------

it maybe common knowledge, but in the new version, during the make
test....i got the following error:

[root@lakehouse tvdinner]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -
I/usr/lib/perl5/5.6.1/i386-linux -I/usr/lib/perl5/5.6.1 test.pl
1..4  configuration
2..4  database library
3..4  general library
4..4  mp3 package
Can't locate Apache/MP3/L10N.pm in @INC (@INC contains: blib/arch
blib/lib /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1/i386-
linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/5.6.1/i386-
linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-
linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib
/perl5/vendor_perl/5.6.1/i386-
linux /usr/lib/perl5/vendor_perl/5.6.1 /usr/lib/perl5/vendor_perl .)
at blib/lib/App/TVDinner/MP3.pm line 10.
BEGIN failed--compilation aborted at blib/lib/App/TVDinner/MP3.pm
line 10.
Compilation failed in require at test.pl line 29.
BEGIN failed--compilation aborted at test.pl line 29.
make: *** [test_dynamic] Error 2


turns out that you actually have to zip into CPAN and install
Apache::MP3, and then the test completed successfully.


next major problem i ran into was the following Mason error message:

error in file:   /www/mason/obj/tvdinner/format/newadd.html
   line 26:  DBD::mysql::st execute failed: 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 ''18'' at line 5

context:   ...
22:  limit ?";
23:
24:  $list_sth = $gdbh->prepare($list_sql);
25:  $list_sth->bind_param(1,$limit);
26:  $res = $list_sth->execute;
27:
28:  $new = "<!-- NEW TABLE -->\n";
29:  $new .= qq(<table border="0" cellpadding="2" cellspacing="0">);
30:
...

component stack:   /tvdinner/format/newadd.html
/tvdinner/index.html
/tvdinner/autohandler

code stack:   /www/mason/obj/tvdinner/format/newadd.html:26
/www/mason/obj/tvdinner/index.html:92
/www/mason/obj/tvdinner/autohandler:186


this one seems to be stumping me. not sure what it doesnt like about
that syntax, i tried punching that sql statement into mysql from the
command line, but with a 5 instead of a ? at the end, and it didnt
blow up.
thanks
josh

> Looks like it's not getting your settings from the Config. Try this
script
> and let me know what the result looks like:
>
>   #!/usr/bin/perl
>   use App::TVDinner::Conf;
>   my $conf = $App::TVDinner::Conf::conf;
>   foreach $key (keys %$conf) {
>     print "conf->{$key} = $conf->{$key}\n";
>   }
>
> The above should return a list of all of your config values. If it
> doesn't, something went wrong with the "make install".


ok this is what i got running that script:

[root@lakehouse tools]# ./testconfig.pl
conf->{interfaceroot} = /tvdinner
conf->{defaultorder} = artist,album,track,title
conf->{mp3hardpath} = /www/mp3
conf->{iconized} = 1
conf->{webroot} = /www
conf->{allowstream} = 1
conf->{mp3webroot} = /www/mp3
conf->{defaultdispcol} = artist,album,track,title,duration,comment
conf->{allowdownload} = 1
conf->{tvdinnerver} = 0.4 (blue canary)
conf->{webhardpath} = /www
[root@lakehouse tools]#

looks like everything is pointed in the right direction. the
interface root is the only one i believe that follows the directory
root in apache.  all the other ones are absolute paths if im not
mistaken.  let me know if you eyeball something.
thanks

I coulnd't wait until the first of the year -- I wanted to get this out as
soon as possible because it has so many bug fixes and is all around better
than 0.3.

You can download the new version from the TVDinner project page:

   http://spookyworld.dnsalias.com/projects/tvdinner

Warning:  I haven't designed a "backwards-compatibility" script. If you
want, you can keep your existing database, but you'll have to determine
what's different. I believe the playlist tables are the only difference
database-wise, but don't quote me on that. :^)

Enjoy the new release -- as always, send me bug reports.

Good Luck!


Sean
--
    \___/  Sean Keplinger
    |o,o|  skeplin at one dot net
  \/    )  http://spookyworld.dnsalias.com
----mm-----------------------------------