FUDforum: FUDforum Installation Issues » I am afraid i have a problem

Home » FUDforum » FUDforum Installation Issues » I am afraid i have a problem (I get this error when i want to change the forum display order)

Show: Today's Messages :: Polls :: Message Navigator

I am afraid i have a problem [message #166457]

Tue, 13 December 2011 15:37

hbmmafia
Messages: 11
Registered: December 2011

Karma: 0

Junior Member

it seems i have a problem.....
Fatal error: Uncaught exception 'Exception' with message '(/home/admin/fudforum1/include/theme/default/db.inc:104 /home/admin/xxxxxxxx.org/test/adm/admforum.php:127 ) 1054: Unknown column 'nameDESC' in 'order clause' Query: SELECT id FROM fud30_forum WHERE cat_id=1 ORDER BY nameDESC _GET: array ( 'o' => '0', 'ot' => 'name', 'cat_id' => '1', 'SQ' => '5d09020aa09d702b71abbc03f5e9d505', ) Database version: 5.0.92 [Referring Page] http://xxxxxxxx.org/test/adm/admforum.php?&SQ=5d09020aa09d702b71abbc03f5e9d505 ' in /home/admin/fudforum1/include/core.inc:256 Stack trace: #0 /home/admin/fudforum1/include/theme/default/db.inc(104): fud_sql_error_handler() #1 /home/admin/xxxxxxx.org/test/adm/admforum.php(127): q('SELECT id FROM ...', 'Unknown column ...', 1054, '5.0.92') #2 {main} thrown in /home/admin/fudforum1/include/core.inc on line 256

Any ideas? ty

Report message to a moderator

Re: I am afraid i have a problem [message #166462 is a reply to message #166457]

Thu, 15 December 2011 00:38

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma: 3

Senior Member

To clarify their having an issue with the Forum Management System for reordering the forums briefly discussed here: http://fudforum.org/forum/index.php?t=msg&th=120274&goto=166444& ;#msg_166444

I tried it myself and had the same error.

"I'm a Witcher, I solve human problems; not always using a sword!"

Report message to a moderator

Re: I am afraid i have a problem [message #166463 is a reply to message #166457]

Thu, 15 December 2011 11:33

hbmmafia
Messages: 11
Registered: December 2011

Karma: 0

Junior Member

does any one have a idea ??? is there a sql querry we have to do or create something in the database to fix this?

Report message to a moderator

Re: I am afraid i have a problem [message #166464 is a reply to message #166463]

Thu, 15 December 2011 13:32

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Fix @ http://fudforum.svn.sourceforge.net/fudforum/?rev=5410&view=rev

EDIT: The diff doesn't show the spaces added on line 127. The patch is:

--- admforum.php	(revision 5350)
+++ admforum.php	(revision 5410)
@@ -124,7 +124,7 @@
 	if (isset($_GET['o'], $_GET['ot'])) {
 		if (in_array($_GET['ot'], array('name', 'descr', 'date_created'))) {
 			$i = 0;
-			$r = q('SELECT id FROM '. $tbl .'forum WHERE cat_id='. $cat_id .' ORDER BY '. $_GET['ot'] . ((int)$_GET['o'] ? 'ASC' : 'DESC'));
+			$r = q('SELECT id FROM '. $tbl .'forum WHERE cat_id='. $cat_id .' ORDER BY '. $_GET['ot'] . ((int)$_GET['o'] ? ' ASC' : ' DESC'));
 			while ($o = db_rowarr($r)) {
 				q('UPDATE '. $tbl .'forum SET view_order='. ++$i .' WHERE id='. $o[0]);
 			}

Report message to a moderator

Re: I am afraid i have a problem [message #166465 is a reply to message #166464]

Thu, 15 December 2011 13:49

hbmmafia
Messages: 11
Registered: December 2011

Karma: 0

Junior Member

i downloaded the admforum.php but Where is that file located ? please and thank you

Report message to a moderator

Re: I am afraid i have a problem [message #166466 is a reply to message #166465]

Thu, 15 December 2011 13:51

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

In your forum's 'adm' directroy. Search for it.

Report message to a moderator

Re: I am afraid i have a problem [message #166468 is a reply to message #166466]

Thu, 15 December 2011 13:53

hbmmafia
Messages: 11
Registered: December 2011

Karma: 0

Junior Member

ok i found it lol for some reason my ftp program cant read the folder but filemanager of my control panel can for some reason apache is the owner and not me thanks

Report message to a moderator