Hi, Friends Block Fixed ( kind of ;) ) I changed the 'SELECT' back to 'SELECT_DISTINCT' Then changed 'ORDER_BY' => 'u.username_clean ASC', To 'ORDER_BY' => 'u.username ASC', This fixed the Friends block, the problem was that the SELECT_DISTINCT statement did not include the 'username_clean' column s...

Hi Nick, Thanks for the suggestion, however i changed the code in the friends block and recieved the below error...... General Error SQL ERROR [ mssql_odbc ] [Microsoft][ODBC SQL Server Driver][SQL Server]Column "phpbb_users.username_clean" is invalid in the ORDER BY clause because it is n...

Hi Kevin, Yes thats correct, I went through last night and turned all blocks on and off to see if any of the others cause errors too and everything else seems fine. So the problem blocks are ..... Birthday List Random Member Friends If i get chance at all tonight i will take a look at the code and s...

Hi, Thanks for the info, The install went through and i got the successful screen. Then went to portal index and got this......... General Error SQL ERROR [ mssql_odbc ] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'FROM'. [37000] SQL SELECT user_id, username, use...

Hi Kevin, Unfortunatley it comes up with the same error in SQL2K as in 2K5. I have taken a look at the schema, and it looked ok, so i imprted the code into SQL2005 Management Studio and the script executed OK. So that kind of stumps me at the minute, I will keep having a bash at it and see if i can ...

Hi Kevin, Thanks for the speedy response. I have just tried going for an install and i get 'Sorry, unsupported DBMS found'. I searched for that error in the code of portal.php and can see that it checks which DBMS system you are using and MSSQL is there. At present i am using a SQL2005 instance. Gim...

Hi All, Haven't tested your Portal yet, i have been using PHPBB3Portal for a while and relatively happy with it apart from some of the bugs which by the looks of things you guys have fixed! My issue now is that i need to run PHPBB3 on a MSSQL backend, as you will be aware PHPBB3 Portal does not work...