Phoenix 'connection dropped' error

R

Reestv

New Member
Jul 4, 2010
29
1
Hi,

I was wondering if anybody could help me with my (licensed) Phoenix Emulator error. When I try to access my hotel, I get the following error:

Code: 
>> Conection [0] from [xxx.xx.xxx.xxx]
Login error: User account not found - Make sure the users ip_last matches their current IP <xxx.xx.xxx.xxx>
>> Connection Dropped [0] from [xxx.xx.xxx.xxx]
I have already tried following several tutorials, such as changing the enable_securesessions from 1 to 0 but no luck.
I'm using PhoenixPHP as the CMS and the SWF's are set up correctly, they are all valid links.

If anyone could help me out with my error, I'd be really grateful.

Thanks much,
Reestv.
 
Sort by date Sort by votes
R

Reestv

New Member
Jul 4, 2010
29
1
Thanks for the reply. I managed to fix this error. Unfortunately, I now get:

Code: 
>> Connection [0] from [xxx.xx.xxx.xxx]
Exception has been saved
>> Connection Dropped [0] from [xxx.xx.xxx.xxx]
 
Upvote 0 Downvote
R

Reestv

New Member
Jul 4, 2010
29
1
Code: 
System.ArgumentException: Column 'mafiapoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
(it's the RP emulator from Phoenix) - there's also another error file called 'criticalexceptions'. Should I post that too?
 
Upvote 0 Downvote
BatDev

BatDev

Active Member
Apr 20, 2012
110
25
Reestv said:
Code: 
System.ArgumentException: Column 'mafiapoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
(it's the RP emulator from Phoenix) - there's also another error file called 'criticalexceptions'. Should I post that too?
Click to expand...

That error states that the 'mafiapoints' field should not be in the table... anyone correct me if i am wrong.
 
Upvote 0 Downvote
Sledmore

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,199
3,934
Rollo said:
That error states that the 'mafiapoints' field should not be in the table... anyone correct me if i am wrong.
Click to expand...

It should be there, add 'mafiapoints' column to the users table, also post the other exceptions you go too. (You suck for using PhxRP!!11:()
 
Upvote 0 Downvote
R

Reestv

New Member
Jul 4, 2010
29
1
Rollo said:
That error states that the 'mafiapoints' field should not be in the table... anyone correct me if i am wrong.
Click to expand...
I just looked through the SQL file I inserted, and I actually can't find a 'mafiapoints' field. Should I try to delete it from the database?

The critical exceptions were:
Code: 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
System.NullReferenceException: Object reference not set to an instance of an object.
  at Phoenix.xcf610c81231340bb.xebcd0e0bed32bc6a(String x7048fb0a9d14b44b, Boolean xe3d52c930b298d72)
  at Phoenix.x867eb3246b182488.xe9f31f392a654a01(x02a2047d05c29c5b x2f9ad81484440792)
 
Upvote 0 Downvote
R

Reestv

New Member
Jul 4, 2010
29
1
I executed the SQL and restarted the emulator. I got the same error when trying to get on the client, with the exception being this (again):

Code: 
System.ArgumentException: Column 'mafiapoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
 
Upvote 0 Downvote
BatDev

BatDev

Active Member
Apr 20, 2012
110
25
Reestv said:
I executed the SQL and restarted the emulator. I got the same error when trying to get on the client, with the exception being this (again):

Code: 
System.ArgumentException: Column 'mafiapoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
Click to expand...

Delete the mafiapoints field from users, try this query below

Code: 
ALTER TABLE `users_stats`
ADD `mafiapoints` int(11) NOT NULL DEFAULT '0';
 
Upvote 0 Downvote
R

Reestv

New Member
Jul 4, 2010
29
1
Okay, I executed these two SQL's:
Code: 
ALTER TABLE `users`
DROP COLUMN `mafiapoints`
and
Code: 
ALTER TABLE `user_stats`
ADD `mafiapoints` int(11) NOT NULL DEFAULT '0'
Restarted the emulator and went to enter the client. Got the same error, different exception:

Code: 
System.ArgumentException: Column 'colourpoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
I'm guessing I now have to run this? :
Code: 
ALTER TABLE `users_stats`
ADD `colourpoints` int(11) NOT NULL DEFAULT '0';
 
Upvote 0 Downvote
BatDev

BatDev

Active Member
Apr 20, 2012
110
25
Reestv said:
Okay, I executed these two SQL's:
Code: 
ALTER TABLE `users`
DROP COLUMN `mafiapoints`
and
Code: 
ALTER TABLE `user_stats`
ADD `mafiapoints` int(11) NOT NULL DEFAULT '0'
Restarted the emulator and went to enter the client. Got the same error, different exception:

Code: 
System.ArgumentException: Column 'colourpoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
I'm guessing I now have to run this? :
Code: 
ALTER TABLE `users_stats`
ADD `colourpoints` int(11) NOT NULL DEFAULT '0';
Click to expand...

Yes run that query.
 
Upvote 0 Downvote
Sledmore

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,199
3,934
Reestv said:
Okay, I executed these two SQL's:
Code: 
ALTER TABLE `users`
DROP COLUMN `mafiapoints`
and
Code: 
ALTER TABLE `user_stats`
ADD `mafiapoints` int(11) NOT NULL DEFAULT '0'
Restarted the emulator and went to enter the client. Got the same error, different exception:

Code: 
System.ArgumentException: Column 'colourpoints' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)
I'm guessing I now have to run this? :
Code: 
ALTER TABLE `users_stats`
ADD `colourpoints` int(11) NOT NULL DEFAULT '0';
Click to expand...

Yup!
 
Upvote 0 Downvote
R

Reestv

New Member
Jul 4, 2010
29
1
Okay, done that. Now I get:

Code: 
System.ArgumentException: Column 'aggression' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.x6c0e7b029a8d7571..ctor(UInt32 Id, String Username, String RealName, String AuthTicket, UInt32 Rank, String Motto, String Look, String Gender, Int32 Credits, Int32 ActivityPoints, Double LastActivityPointsUpdate, Boolean Muted, UInt32 HomeRoom, Int32 NewbieStatus, Boolean BlockNewFriends, Boolean HideinRoom, Boolean HideOnlineStatus, Boolean vip, Int32 volume, Int32 shells, xca0375af76c32b7d pClient, xf174b6b774db7993 UserData)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)

Do I add this to the table user_stats again?
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 3 (members: 0, guests: 3)
☀️  Switch to Light Theme

Latest posts

Top