I am getting a PgSQL error when deleting orphaned forums. It seems that the forum id is referenced incorrectly in forum_adm.inc. This is the result, notice the forum ID is missing from the table name in the DROP TABLE statement:
Warning: pg_query(): Query failed: ERROR: table "fud26_fl_" does not exist in /FUDforum/include/theme/default/db.inc on line 147
(/FUDforum/include/theme/default/db.inc:147
/FUDforum/include/forum_adm.inc:170
/www/adm/admdelfrm.php:48
) : ERROR: table "fud26_fl_" does not exist
Query: DROP TABLE fud26_fl_
_POST: S=4d8f363743f766b9023ffac4664035d4&SQ=96369f2b638fde9fd56d9c09eb9ef6cd&del=2&conf=Yes&
Server Version:
[Referring Page] http://forums.aoforge.net/adm/admdelfrm.php?del=2&rid=2&S=4d8f363743f766b9023ffac4664035d4&SQ=96369f2b638fde9fd56d9c09eb9ef6cd
I located what appears to be the error in forum_adm.inc, $id was referenced via an object instead of a local variable. Here is a patch that fixes this:
--- forum_adm.inc 2005-01-04 18:49:31.190025648 +0000
+++ forum_adm.inc.new 2005-01-04 18:48:14.683656384 +0000
@@ -167,7 +167,7 @@
q('DELETE FROM '.$tbl.'mlist WHERE forum_id='.$id);
q('DELETE FROM '.$tbl.'nntp WHERE forum_id='.$id);
$gid = q_singleval('SELECT id FROM '.$tbl.'groups WHERE forum_id='.$id);
- q("DROP TABLE ".$tbl."fl_".$this->id);
+ q("DROP TABLE ".$tbl."fl_".$id);
q('DELETE FROM '.$tbl.'forum WHERE id='.$id);
db_unlock();
Feel free to let me know if this is wrong/stupid (but hey it works) 
Calendar
Search
Help
Members
Register
Login
Home
]