| 
        
          | 
              
                | Author |  Topic  |  |  
                | jeepgenNew Member
 
  
 
                Italy73 Posts
 | 
                    
                      |  Posted - 04 January 2003 :  10:45:56     
 |  
                      | hi. I have a problem (it happens often when i modify some asp file.. ) 
 Microsoft JET Database Engine error '80040e37'
 
 The Microsoft Jet database engine cannot find the input table or query 'FORUM_SMILES'. Make sure it exists and that its name is spelled correctly.
 
 /forum/inc_functions.asp, line 363
 
 
 when i try to login in admin_home.asp
 The line seems to be where i modify Smile Manager 3.3 but i cant find the mistake:
 
 
 ............			fString= replace(fString, "<img src=icon_smile_kisses.gif border=0 align=middle>", "
  ", 1, -1, 1) '############# Stimmy's SMile Mod ################
 strsql = "SELECT S_URL, S_CODE, S_ENABLED FROM " & strTablePrefix & "SMILES"
 set smilers = my_conn.execute(strsql)
 if smilers.eof then
 '## Do nothing
 else
 do until smilers.eof
 if not(smilers("S_ENABLED") = "no") then
 fString= replace(fString, "<img src=" & smilers("S_URL") & " border=0 align=middle>", smilers("S_CODE"), 1, -1, 1)
 else
 '## Do nothing
 end if
 smilers.movenext
 loop
 end if
 set smilers = nothing
 '############# End Stimmy's Smile Mod #################
 end if
 ...........
 
 
 ............		fString = replace(fString, "
  ", "<img src=icon_smile_kisses.gif border=0 align=middle>") fString = replace(fString, "
  ", "<img src=icon_smile_kisses.gif border=0 align=middle>") '############# Stimmy's SMile Mod ################
 strsql = "SELECT S_URL, S_CODE, S_ENABLED FROM " & strTablePrefix & "SMILES"
 set smilers = my_conn.execute(strsql)
 if smilers.eof then
 '## Do nothing
 else
 do until smilers.eof
 if not(smilers("S_ENABLED") = "no") then
 fString = replace(fString, smilers("S_CODE"), "<img src=" & smilers("S_URL") & " border=0 align=middle>")
 else
 '## Do nothing
 end if
 smilers.movenext
 loop
 end if
 set smilers = nothing
 '############## End Stimmy's Smile Mod ###########
 Smile = fString
 end function
 
 ..........
 
 please, i have the admin_home frozen! Thanks.
 
 ps i have a 3.3.05 installed at www.jeeptepevision.com/forum
 |  
                      | 
  |  
                      | Edited by - jeepgen on 04 January 2003  11:01:32
 |  |  
                | RascoAdvanced Member
 
      
 
                Germany3192 Posts
 | 
                    
                      |  Posted - 04 January 2003 :  19:10:44   
 |  
                      | You have run the Mod Setup when you installed that Mod? Does the table FORUM_SMILES exist in your database?
 |  
                      | German Snitz Forum
 
 |  
                      |  |  |  
                | jeepgenNew Member
 
  
 
                Italy73 Posts
 |  |  
                | RascoAdvanced Member
 
      
 
                Germany3192 Posts
 | 
                    
                      |  Posted - 09 January 2003 :  14:01:32   
 |  
                      | Haven`t that version of the forum installed, but there is more than one error. (the links on post.asp aren`t working, too) 
 Recheck the changes you made during the implementation. With wrong link error to your smilies. Some seems to be a "<a" which causes the x-image and the wrong link after that.
 
 
 |  
                      | German Snitz Forum
 
 |  
                      |  |  |  
                |  |  Topic  |  |  |  |