Phpfox Logout problem

[stev35555]

Hi guys.

I use the latest version of phpfox (1.6 build 20) and have just had the latest version of VB integrated. Everything works fine apart from members can not logout. It just goes to a blank page.

I have posted this problem on the phpfox forums and have has some response on how to fix this error, how ever i do not fully understand as i am not that familar with phpmyadmin. this is the conversation so far:

-----------------------------------------------------------------------------------------------------------------

Me:
When i go to logout, it doesnt complete and goes to a blank white page. I have checked the link and it is not that. I have a customed template, does anyone no a fix or has had this problem?

Response:
Do you get any error message when you turn on debug mode?

Me: (my debug errors)
User Notice: Mysql Query:SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user
Mysql Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

1 /home/ourlscom/public_html/include/classes/database/mysql/Database.class.php : 105 trigger_error("Mysql Query:SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user
Mysql Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='")
2 /home/ourlscom/public_html/include/classes/database/mysql/Database.class.php : 124 database->databaseerror("SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user ", "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='")
3 /home/ourlscom/public_html/include/classes/database/mysql/Database.class.php : 247 database->query(" SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user ")
4 /home/ourlscom/public_html/include/classes/database/mysql/Database.class.php : 279 database->getrow(" SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user ", FALSE)
5 /home/ourlscom/public_html/plugins/vbulletin/phpfox_functions.php : 87 database->getfield(" SELECT vb.userid FROM vbulletin_user AS vb JOIN phpfox_user AS u ON u.id = "1" WHERE vb.username = u.user ")
6 /home/ourlscom/public_html/plugins/vbulletin/phpfox_functions.php : 198 vbulletin_uid()
7 /home/ourlscom/public_html/include/classes/Plugins.class.php : 334 vbulletin_logout_user({Phpfox_mod_account_itemacco unt})
8 /home/ourlscom/public_html/include/classes/Plugins.class.php : 414 phpfoxplugins->call_phpfox_function("logout_user", {Phpfox_mod_account_itemaccount})
9 /home/ourlscom/public_html/include/classes/App.class.php : 1539 phpfoxplugins->phpfoxlogout({Phpfox_mod_account_itemaccount})
10 /home/ourlscom/public_html/include/modules/Account/classes/PhpFox_ServiceSecurity.class.php : 378 app:lugin_logoutuser({Phpfox_mod_account_itemacc ount})
11 /home/ourlscom/public_html/site/public/logout.php : 66 phpfox_mod_account_servicesecurity->logout()
12 /home/ourlscom/public_html/include/classes/App.class.php : 900 require_once("/home/ourlscom/public_html/site/public/logout.php")
13 /home/ourlscom/public_html/include/classes/App.class.php : 920 app::_processlevel(1, "public/")
14 /home/ourlscom/public_html/include/classes/App.class.php : 843 app::_processlevel(0, "")
15 /home/ourlscom/public_html/index.php : 79 app::run()

Response:
I think you're using two different character sets -latin1_swedish, latin1_general. Which version of phpFox / vBulletin are you using?

You'll have to use the same connection set for both 'databases', stick with the phpFox one and change the vBulletin one. You can change the sets in phpMyAdmin, or follow vBulletin instructions here:
http://www.vbulletin.com/forum/proje...?issueid=11531

---------------------------------------------------------------------------------------------------------------

What i am unsure on is the what needs editing in phpmyadmin. Does anyone know? It has been 2 days now and members are starting to moan lol

thanks in advanced.

steve

--------------- Added [DATE]1222680322[/DATE] at [TIME]1222680322[/TIME] ---------------

issue fixed thanks

--------------- Added [DATE]1222723133[/DATE] at [TIME]1222723133[/TIME] ---------------

problem solved