| Language: |  |  |  |  |  |  |  |
| Language: | | | | | | | |
07-20-2004, 12:08 AM
|
|||
|
|||
2.1 and MySQL Login Problems
Hi;
I am running version 2.1 and MySQL v4.0.17. All works well when I auto-login using the username and password fields, except.... If the users are added to MySQL today, the login stops in flashchat with "The username does not exist!". By tomorrow, they will all work fine, with no changes to your code or mine. How come? |
|
07-20-2004, 06:32 AM
|
|||
|
|||
|
Re:2.1 and MySQL Login Problems
It's seems strange. never happed to me before.
was that your mysql running in "auto commit" mode or not? if the new data wasn't been commited after inserting, then the chat server won't get the new data. |
|
07-20-2004, 05:14 PM
|
|||
|
|||
|
Re:2.1 and MySQL Login Problems
Hi;
Thanks for your prompt response. Don't think that is it, because; 1. After they register on to my site, they are taken back to login 2. They can, in fact, login. 3. Then, we try chat, and it fails. Yesterday's new members are still not working, but all older ones are, and I am not looking at any variables, except username and password. Included is my Cold Fusion code. ============================================= <!--- Chat.cfm ---> <html> <!--- Check LogIn Status ---> <cfinclude template="../logtest.cfm"> <head> <title><cfoutput>#application.namelong#: Meet Beautiful Russian Women For Love And Marriage!</cfoutput></title> <cfinclude template="../metatags.cfm"> <cfinclude template="../ru_charset.cfm"> <!--- Frame Dropper ---> <script language="javascript"> if (self.location != top.location) { top.location = self.location; } </script> <cfinclude template="../rightclick.cfm"> </head> <cfinclude template="../body.cfm"> <!--- Build The Table ---> <table align="center" valign="top" width="100%" cellspacing="0" cellpadding="0" border="0"> <tr> <!--- BEGIN - Main Window Goes In The Next Cell ---> <td valign="top" align="left"> <center> <br> <table bgcolor="<cfoutput>#TBL_BG_Color#</cfoutput>" align="center" cellspacing="0" cellpadding="0" border="1"> <tr> <td align="left"> <table width="650" align="center" cellspacing="3" cellpadding="5" border="0"> <tr> <td align="left" bgcolor="<cfoutput>#heading#</cfoutput>"> <font face="Arial" size="+1" color="<cfoutput>#subheading#</cfoutput>"><b> Member Chat Rooms </b></font> </td> <tr> <td align="center"> <cfparam name="lang" default="en"> <cfparam name="init_room" default=""> <!--- Get User Info ---> <cfquery name="GetDetails" datasource="#application.datasource#" username="#application.username#" password="#application.password#"> select username,pass from userinfo where user_id = #session.user_id# </cfquery> <cfif #getdetails.recordcount# eq 1> <cfset username = #getdetails.username#> <cfset password = #getdetails.pass#> <cfelse> <font size="+2" color="White">Oops, Error!</font> <cfabort> </cfif> <cfoutput> <!--- <font size="+2" color="White"> |#username#|#password#| </font> <cfabort> ---> <p align=center> <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/s...rsion=6,0,0,0" WIDTH="100%" HEIGHT="476"> <PARAM NAME=movie VALUE="123flashchat.swf?init_user=#username#&init_ password=#password#&init_skin=angel&init_lang=#lan g#&init_room=#init_room#"> <PARAM NAME=quality VALUE="high"> <PARAM NAME="menu" value="false"> <param name="bgcolor" value="##000000"> <param name="scale" value="noscale"> <EMBED src="123flashchat.swf?init_user=#username#&init_pa ssword=#password#&init_skin=angel&init_lang=#lang# &init_room=#init_room#" quality=high menu=false WIDTH="100%" HEIGHT="476" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer" scale="noscale"></EMBED> </OBJECT> </p> </cfoutput> </td> </table> <center> <input type="Button" value="Close This Window" onclick="parent.close();"> <br><br> </center> </td> </table> </td> <!--- END - Main Window Goes In The Previous Cell ---> </tr> </table> <br> </body> </html> |
 |
Was this information helpful? Yes No
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
