[pimppa-users] Pleech broken?

[boz b. <bo...@po...>]

Hi


I've been jumping through hoops trying
to get pleech in 0.5.5a working to no avail.

I even thought my database might be corrupted
so I started from scratch.

I keep getting mysql errors when tryng to run it.

I edited common.c to include debug information comparing 0.5.4 and 0.5.5a.


Here is the output from 0.5.4

FROM p_groups, p_areas, p_servers
WHERE g_dest=3Darea_id AND g_server=3Ds_id
AND s_name like '%%'

AND NOT (g_flags & 1)
ORDER BY g_name



Here is the output from 0.5.5a

FROM p_groups, p_areas, p_servers
WHERE g_dest=3Darea_id AND g_server=3Ds_id
AND s_name like '%%'
=C2
AND NOT (g_flags & 1)
ORDER BY g_name


It appears that in this part of news.h ...

p_query(&dst_db, "SELECT g_name, g_last, area_path, area_id, s_name, s_id=
,
s_user, s_pass, area_name
FROM p_groups, p_areas, p_servers
WHERE g_dest=3Darea_id AND g_server=3Ds_id
AND s_name like '%s'
%s
AND NOT (g_flags & %ld)


... some crap is being assigned to the second %s
and fsking up the mysql string.

It seems that the problem lies somewhere in common.c
but I'll be darned if I can find it.




One other thing...

this line in sql/uninstall_db

mysql -u root -p <uninstall.sql

should be

mysql -u root -p <uninstall_db.sql


Boz





---
4.12.2001 V.I.P. Chat Live s
Terry Gilliamem - MONTY PYTHON=20
http://chat.volny.cz