Message quote exceeded

Message quote exceeded SearchSearch
Author Message
Alessandro Guimarães
New member
Username: Inconnext

Post Number: 8
Registered: 04-2010
Posted on Sunday, May 30, 2010 - 11:51 am:   

Hello,

I am a problem when sending a sms for my connection returns http error Message exceeded quote. I am writing to the database by eating below:

[SMSGW]
Debug = Yes
PreAuth = yes
SMSAccountingURL = http://localhost/now2way/enviadas.asp

Script of the page write:


<%
Response.ContentType = "text/plain"

Dim celular, account, Sms, Smstime, Smsdate, vstatus, banco, conexao, rsConsulta

celular = Request.QueryString("to")
account = Request.QueryString("from")
Sms = Request.QueryString("Text")
Smsdate = date
Smstime = time
vstatus = Request.QueryString("status")

Set Conexao = Server.CreateObject("ADODB.Connection")
Conexao.CursorLocation = 3 ' adUseClient
Conexao.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db1.mdb")

set rsConsulta = server.createobject("adodb.recordset")

SQL = "INSERT INTO smsenviados (phone, user, texto, data, hora, status) VALUES ( '" & celular & "','" & account & "','" & Sms & "','" & Smsdate & "','" & Smstime & "', '" & vstatus & "')"

Set rsConsulta = conexao.execute(SQL)

Response.Write ("Gravado com sucesso!")

%>

when the line of fire SMSGW SMSAccountingURL = http://localhost/now2way/enviadas.asp can not send.

Where is the problem?

Thanks,

Alessandro
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 2174
Registered: 08-2008
Posted on Monday, May 31, 2010 - 02:44 pm:   

Hi Alessandro,

I suspect that the accounting callback is returning an error. Perhaps something is going wrong with the database transaction.

Have you tried connecting to your script with a web browser, simulating the type of request that NowSMS makes?

I'd suggest enabling the SMSDEBUG.LOG in NowSMS, then you can see in that log the HTTP request that NowSMS is making, and the HTTP response that it is receiving back from the script. There are some ASP errors that result in a script returning back an "Internal Server Error" response, which will cause NowSMS to block SMS message submissions because it sees that there is an error that is stopping the messages from being properly accounted for.

--
Des
NowSMS Support