everytime i click the load from database i get this in the cmd box
17:04:04.375 - [ INFO ] > [RedBox] Internal event received: serverReady
17:04:04.375 - [ INFO ] > [RedBox] Internal event received: serverReady
17:04:04.375 - [ INFO ] > [RedBox] Internal event received: serverReady
[dbExtension.as]: Event received: userJoin
[simpleExt.as]: Event received: userJoin
17:05:04.103 - [ WARNING ] > it.gotoandplay.smartfoxserver.exceptions.MissingExt
ensionException: Unrecognized extension name: [ dbTest ]! Zone: dbZone, Room: 21
pro db extention example problem
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
Please make sure that the dbExtension.as extension is loaded correctly. You can check this by checking the server logs
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
i keep seeing
01:12:20.185 - [ SEVERE ] > DbManager error during command execution: INSERT INT
O contacts (id, name, location, email) VALUES ('1323997940183', 's', 's', 's')
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' i
n 'field list'
EDIT
Foxed the problem, just having isues with the avatar not showing and room list not being updated
01:12:20.185 - [ SEVERE ] > DbManager error during command execution: INSERT INT
O contacts (id, name, location, email) VALUES ('1323997940183', 's', 's', 's')
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' i
n 'field list'
EDIT
Foxed the problem, just having isues with the avatar not showing and room list not being updated
-ZG1
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
UPDATE
Got it working. just having trouble with making regester acounts and having problems with chat bouble not showing but in chat log the text come up
also Rjgtav can i please have a source file of the Database register please? because im having big problems making it work on my game. I'm using smartfox server pro
Got it working. just having trouble with making regester acounts and having problems with chat bouble not showing but in chat log the text come up
also Rjgtav can i please have a source file of the Database register please? because im having big problems making it work on my game. I'm using smartfox server pro
-ZG1
Hi. Well, the whole source of the extension is on the post. The only bug there is in the line:
function handleInternalEvent(evt){ //not used }
And the fix is:
function handleInternalEvent(evt){};//not used
function handleInternalEvent(evt){ //not used }
And the fix is:
function handleInternalEvent(evt){};//not used
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
That doesn't have nothing to do with the extension... Sorry but i lost my hdd and no longer have the source...
But is the example at least connecting to the server?
But is the example at least connecting to the server?
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
Ok but i can't check the example now as i no longer have it. Can you please debug it by yourself? Add some traces in the connect event, turn on the smartfox.debug flag, etc.
Probably the application isn't connecting... if so, there is some probem reaching the server... Is the server running on the same pc as the example? And has the server started correctly with no errors?
Probably the application isn't connecting... if so, there is some probem reaching the server... Is the server running on the same pc as the example? And has the server started correctly with no errors?
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
- zachofthegolden1
- Posts: 89
- Joined: 05 Sep 2011, 19:31
The docs say nothing about creating new accounts because that's out of the scope of the Server's core. Registering accounts in SFS is the same as registering accounts in MySQL (the SQL code is the same), so you may probably want to look for SQL codes regarding registering accounts.
Then, to execute those SQL codes, you can check the DB related examples, as they run various queries and updates to a database
Then, to execute those SQL codes, you can check the DB related examples, as they run various queries and updates to a database
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Return to “SmartFoxServer 1.x Discussions and Help”
Who is online
Users browsing this forum: Google [Bot] and 60 guests