[BUGFIX] just one glitch :-) phpnuke 5.5-6.0 & postnuke

[sigi]

Hi

thanks for that release - i found all my errors fixed...

there just on glitch: in functions.inc.php you have one line reading

Code Select Expand

$result = $db->sql_query("SELECT user_timezone FROM " . $CONFIG['TABLE_USERS'] . " WHERE user_id=" . USER_ID);
   
this should be

Code Select Expand

$result = $db->sql_query("SELECT user_timezone FROM " . $CONFIG['TABLE_USERS'] . " WHERE ". $field_user_id."=" . USER_ID);
   
, and the global line in that function should include $field_user_id ...

that way it works in Nuke 5.5 !

[DJMaze]

thnx fixed for next release

[sigi]

uhh, ohh -
thanks, but theres another glitch now:  the catlist doesnt show the number of categories or albums - it say 0 (zero) ...
if you open a category, the number of albums and pictures is correct ...

ahh, and just this moment i get this:

Code Select Expand

error in sql-statement: mysql_query, err-no: 1054
qry: SELECT uname FROM nuke_users WHERE user_id='0'
description: Unknown column 'user_id' in 'where clause'

i stopped the slide show, and this error comes up. can be reproduced ...