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-----------------------------------