Ubercms 2 Client loading problem

[Diddy]

When you load the client all the bars load and you are presented with the hotel view that stays on and then you are dced. In the mean time the phoenix emu is not recieving any connections.
Any idea on this issue?

 

[Brad]

what ports are you using?

 

[Diddy]

what ports are you using?

trying to use 1232 as the emu says

 

[Brad]

u need to use 1232 for game port and 1233 For Mus Port

 

[Diddy]

u need to use 1232 for game port and 1233 For Mus Port

I have done

 

[Brad]

ok What Connection ip you using?

 

[Diddy]

ok What Connection ip you using?

127.0.0.1 in phoenix config and ubercms_config

 

[Brad]

use your ip if your portforward it or if on VPS use the VPS ip

 

[Diddy]

use your ip if your portforward it or if on VPS use the VPS ip

Changed the ip in ubercm_config and phoenix config i now get this error on the emu

You must be registered for see links

 

[Brad]

is this the Right IP?

 

[Diddy]

yeah my vps ip

You must be registered for see links

 

[Brad]

Ok make sure the Mysql host is 127.0.0.1 or localhost and not ur IP

 

[Diddy]

A connection is made now but droped

with this Exception

4/4/2013 9:43:50 AM: System.ArgumentException: Column 'hide_inroom' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at (Object , String )
  at A.
.
(Object 
, String )
  at A.    .
(DataRow 
, String ,  , 
)
  at A.    .
(String 
,  , 
, 
)
  at A..
(String 
)

You must be registered for see links

 

[Brad]

Run All Theses in your database

ALTER TABLE `users` ADD COLUMN `hide_inroom` enum('0','1') NOT NULL DEFAULT '0';

ALTER TABLE `users` ADD COLUMN `hide_room` enum('0','1') NOT NULL DEFAULT '0';

ALTER TABLE `users` ADD COLUMN `hide_online` enum('0','1') NOT NULL DEFAULT '0';


ALTER TABLE `users` ADD COLUMN `vip` enum('0','1') NOT NULL DEFAULT '0';


ALTER TABLE `users` ADD COLUMN `vip` enum('0','1') NOT NULL DEFAULT '0';

ALTER TABLE `users` ADD COLUMN `volume` int(3) NOT NULL DEFAULT 100;

 

[Diddy]

Thanks Alot mate worked!

 

[Brad]

welcome