On Fri, 17 Dec 2004, Pablo Martinez wrote:

> error: DBD::mysql::st execute failed: Table 'mp3.user_prefs' doesn't
> exist at /www/tvdinner/system/adduser.html line 169.
>
> context: ...
> 166: $insert_sql = "insert into user_prefs (username) values (?)";
> 167: $insert_sth = $gdbh->prepare($insert_sql);
> 168: $insert_sth->bind_param(1,$ARGS{username});
> 169: $res = $insert_sth->execute;
> 170: }

To fix that (temporarily), comment out lines 166-169:

#$insert_sql = "insert into user_prefs (username) values (?)";
#$insert_sth = $gdbh->prepare($insert_sql);
#$insert_sth->bind_param(1,$ARGS{username});
#$res = $insert_sth->execute;

I made a change to the way preferences worked and forgot to change the
adduser function. Whoops! I will note it as a bug and fix it.

> the other problem i was having with only the new version, is that when i
> click on the albums tab it switches to that page, but the all function
> seems to be broken. if i look at them catagorized by letter/number it
> works fine. but as soon as i click the all option, screen goes blank.
> i think the interface is very very snazy, and love the new layout for
> browsing albums.

Uh...ahem...I, uh...left an extra character in the URL:

/tvdinner/display/album/list_all_albumes.html
^

DOH! Line 43 in /display/album/index.html needs to be fixed. It should
read:

$alphalinks = qq(<a
href="$gConf->{interfaceroot}/display/album/list_all_albums.html"
target="albums">All</a> | );

My mistake!


Sean
--
Sean Keplinger / Visit my Hiking/Backpacking and Projects
skeplin AT gmail DOT com / blog at: http://spookyworld.dnsalias.com/