[pimppa-users] Pleech broken?
Brought to you by:
iwronsky
|
From: boz b. <bo...@po...> - 2001-12-20 21:44:11
|
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 |