Case

[JacksonTeller]

Click the link beneath for my tutorial on how i fixed it
http://forum.ragezone.com/f335/fix-connect-disconnect-black-screen-1038579

Errors fixed; Client still loads to hotelview, shows welcome message, then disconnects
Any suggestions? Have checked vars, banner.php, rs4.php, client.php, emu configuration, cms configuration, if ports are open etc.

Emulator shows connection with no errorlogs
Everything in external_variables is checked, and it is linked properly
Firewall is turned off and allowed programs (just in case)
Tried to run it locally, same shit happens

SWF's used is KyleVonnie's upload
Same with emulator and database.

What is really shit about this is that the same set-up worked yesterday, but then i have tried other emu's and swf's and after that something went wrong. Because it worked perfectly

i dont see any other option than reinstalling the server and start from scratch again

edit; This thread is completely updated and the reply's doesnt rely to this.

[MentaL]

[Terrum]

Data too long for column 'last_online' at row 1

Whichever query you're trying to add, it's too long for the record you're trying to add.

[FatalLulz]

Run this SQL into your database,

ALTER TABLE users CHANGE last_online last_online int(32);

Make a back up of your users table just in case.

[JacksonTeller]

Run this SQL into your database,

ALTER TABLE users CHANGE last_online last_online int(32);

Make a back up of your users table just in case.

This is what happened;


Im not sure its a database fail, even if it looks like it.
Because this is a clean database which i have used some days ago and it worked perfectly with the same swf's and emulator.

Currently waiting for my host to reinstall the server.

- - - Updated - - -

Okay, i managed to load without any errors

My problem now is it connects, loading the hotelview and welcome message then disconnects.

[Terrum]

My problem now is it connects, loading the hotelview and welcome message then disconnects.

Does it show any exceptions/errors on the emulator when it disconnects?

[JacksonTeller]

Emulator shows connection with no errorlogs

Nope.

Please read PM

[Terrum]

I'm only willing to provide support on threads, sorry. So provide the information you gave here.