Hi Thierry,

For several weeks, I have been getting this message when launching a procedure from xxxServer.prg (webhook). An idea ?

Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        264
Client: 5.39.7.129

Can you reproduce in development?

Please try this fix:

modify command abTxt.prg
…
function lBotSpider
…
  or 'voilabot' $ m.tcUA;
  or 'alexa.com' $ m.tcUA;
  or 'webhook' $ m.tcUA; && insert this line
  or 'ccbot' $ m.tcUA;
…

Thanks Thierry, I try and feedback

Please note it’s a workaround to prevent opening a session on webhook requests

Hi Thierry,

I have this message again, today from https://dooxi.fr/FoxInCloud-Status.doo

This request cannot be served at the moment due to technical difficulties.
Error Number: 1734
Error: Propri?t? SESSIONID introuvable.
Running Method: newsession
Current Code:
Current Code Line: 264
Exception Handled by: Dooprocess.Error()

Hi Vincent,

Did you post the full message or do you also have the IP and User Agent?

I have also the IP and User.

I send to you by email.

You're the only user with this issue, I guess your wwSession table must have something wrong.

Can you try to pack the wwSession table, and/or repair it?

I did it, but no message during the PACK

pack does not provide a particular message… What did you expect?

an error message when the table is damaged

AFAIK that will depend on your Set TableValidate value. If it's 0, don't expect an error, instead expect other problems...

PACK writes a new table on disk

According to SET TABLEVALIDATE values, USE may gives some messages about table integrity.

Yes, thanks, but I haven't any problem with this table

This error happens in wwSession.newSession(), in this piece of code:

SCATTER NAME THIS.oData MEMO BLANK
WITH THIS.oData
	.SessionId = lcSessionID && error happens here
	.FirstOn = DATETIME()
	.LastOn = DATETIME()
	.userID = lcUserID
	.Browser = lcBrowser
	.IP = lcIP
	.Hits = 1
ENDWITH

If the table structure is OK, this code should also execute OK:

THIS.OpenTable() is called in the beginning of this method, and does select wwSession, I can see no reason why Alias() would change, so SCATTER NAME THIS.oData MEMO BLANK should succeed.

Double checked in WC7, this code is unchanged.

UPDATE: maybe you can temporarily log Alias() into a text file and double check when error occurs:

…
strtofile(cl(datetime()) + " - Alias(): " + Alias(), 'newSession.log') && add this instruction
SCATTER NAME THIS.oData MEMO BLANK
…

So, the problem is maybe in THIS.oData ?

Please add any debugging log you may find useful.

Noting more than this:

Processing Error - http://dooxi.fr/Accespart.doo?email=vincent@dooxi.fr&mdp=007

<PRE>
      Error:       1734
    Message: Propriété SESSIONID introuvable.
       Code: 
    Program: newsession
    Line No:        264
     Client: 86.229.xxx.xxx
Post Buffer: 
</PRE>
Exception Handled by: Dooprocess.Error()

------------------------------------------------
Query String     : email=vincent@dooxi.fr&mdp=007
DLL or Script    : /Accespart.doo
                 : C:\inetpub\wwwroot\dooComp\Accespart.doo
Host Server Name : dooxi.fr
Machine Name     : doocompsrv1
Referring Link   : 
Client IP Address: 86.229.xxx.xxx
Client Browser   : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36
Username         : 
Form Variables ---------------------------------

But as I told you before, in this example the user was immediately logged out on the 1st login attempt

In AccesPart() of xxxServer.prg, I have:

THIS.wUserSet(Partners.Id_Partner)

Where Id_Partner is an unique 10 characters expression

I did my best to support you, I explained earlier that I see no rational reason why this error could happen.

When reading code doesn't help find an error, I know only 2 solutions:

1. reproduce in development IDE -- If I understand well, impossible in this case
2. add debugging information such I those I proposed, and/or any you may find useful

I did my best to support you

I know, thanks.

I no longer have the name of the users connected in the dashboard:

Can I ZAP the wwsession.dbf ?

Can I ZAP the wwsession.dbf ?

You can ZAP or just delete wwsession.*. Your users will loose any preference stored in wwSession.vars.

I deleted the table (which was created successfully) but my dashboard is still anonymous

Thierry, where is this code please ?

This thread is 2 months old… which code de you refer to?

Sorry, this one:

This error happens in wwSession.newSession(), in this piece of code:

SCATTER NAME THIS.oData MEMO BLANK
WITH THIS.oData
	.SessionId = lcSessionID && error happens here
	.FirstOn = DATETIME()
	.LastOn = DATETIME()
	.userID = lcUserID
	.Browser = lcBrowser
	.IP = lcIP
	.Hits = 1
ENDWITH

modify command wwSession.prg

almost all wConnect classes live in a prg named the same; eg. wwServer > wwServer.prg

OK. I added that and we'll see:

...
THIS.OpenTable()
IF VARTYPE (SessionId) = "U"
   * Provisoire - 10/12/2020
   strtofile(cl(datetime()) + " - Alias(): " + Alias(), 'c:\temporaire\newSession.log')
ENDIF

And the log is:

{^2020-12-11 14:34:43} - Alias(): CGILOG

OK, thanks for this precious information, I'll investigate

Thanks in advance

It continues, of course.

{^2020-12-18 22:00:05} - Alias(): CGILOG

This happened from a "webhook" contained in xxxServer.prg

Processing Error - http://xxxxx.fr/youxxxxwebhook.doo?

Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        269

Another error, from another function in xxxServer.prg:

{^2020-12-19 12:34:06} - Alias(): CGILOG

Processing Error - http://xxxxx.fr/Acces.doo?D1224519-KIUO-4A8A-AKO8-EA3C9B1B9A23
Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        269
Client: 88.120.49.228
Post Buffer:

It continues, of course … This happened from a "webhook" contained in xxxServer.prg

Not 'of course', since we should no longer open a session when User Agent contains webhook, this method should no longer execute in this case.

Please add the call stack in your log:

strtofile(cL(datetime()) + " - Alias(): " + Alias() + " - call stack: " + cCallingModules(), 'c:\temporaire\newSession.log')

thanks

The new spy is in place !

A new one, more explicit for you I hope:

{^2020-12-30 17:38:09} - Alias(): CGILOG - call stack: 1 processhit > 2 process > 3 routerequest > 4 dooprocess.process > 5 dooprocess.newsession

Can you please provide the request details? URL, user agent, etc.?

Thierry, I send it to you by email

Hi Vincent,

Happy new year

Next release should fix the technical issue (incorrect Alias())

As these errors mostly occur on search engine robot requests, you can add to your site a robots.txt file:

strtofile("User-agent: *" + chr(13) + "Disallow: *.xxx", addBS(<path to your site>) + "robots.txt")

OK, thanks.
Done. I read that this does not prevent the indexing of pages by Google

I read that this does not prevent the indexing of pages by Google

Where?
whenever possible, please provide your source reference(s)

It was a positive reaction 😉

robot.txt disallow

All major search robots such as Google, Bing, etc. respect the robots.txt spec.
Only malicious search robots don't.