PhotoPost Community - View Single Post

HHMagz · July 12th, 2007, 09:23 PM

Threads has changed the schema and the table names and column names have changed. For example the file threads.php is looking for things like this...

if ( $userid != 0 ) $query = "SELECT U_Number,U_Username,U_Email,U_Password,U_Groups,U_TempPass,U_TimeOffset,U_SessionId, U_StyleSheet FROM {$Globals['dprefix']}Users WHERE U_Number=$userid";

There is no longer a table called 'dprefix' Users it is now ubbt_USERS and the column names are all upper case and have changed. It looks like there needs to be a new threads.php file that matches the ubbthreads schema. I don't know what other photopost files might be affected.

July 12th, 2007, 09:23 PM	#3 (permalink)
HHMagz Junior Member Verified Customer Join Date: Jan 2007 Posts: 20	There is a bigger problem Threads has changed the schema and the table names and column names have changed. For example the file threads.php is looking for things like this... if ( $userid != 0 ) $query = "SELECT U_Number,U_Username,U_Email,U_Password,U_Groups,U_TempPass,U_TimeOffset,U_SessionId, U_StyleSheet FROM {$Globals['dprefix']}Users WHERE U_Number=$userid"; There is no longer a table called 'dprefix' Users it is now ubbt_USERS and the column names are all upper case and have changed. It looks like there needs to be a new threads.php file that matches the ubbthreads schema. I don't know what other photopost files might be affected. Last edited by HHMagz; July 12th, 2007 at 09:28 PM.