Anyone know what this is:

Failed to execute query: 'SELECT Newsletter,Password,Name,s,d,Username,Email,ReceiveMail FROM Users WHERE Username = ? '
Reason: Unknown column 's' in 'field list'

This ocurs when updating the user info from the user plugin.

--------------------------------
Privacy Software

Just an idea. Did you try to Resync user table?
BTW: user plugin? You mean the Changeinfo plugin?

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

It looks perhaps like the plugin is _very_ insecure. It seems to be passing in all input to GT::SQL which is why you have d and s - I assume d is the dynamic parameter and s...hmm i'm not sure, but anyway that is what I think is happening.

This bug means I could change my user status to admin if I wanted (if it works the same way on the UPDATE query).

You should check the plugin perl module to see what the code looks like. Post it here if you are unsure.

Hi - Resync - no effect still error.

User plug is the plugin from http://2muslims.com/ called just user.

But what is the column 's' ??

--------------------------------
Privacy Software

OK - code I cant post as it long. But you could look at the plugin from the admin download?

--------------------------------
Privacy Software

As Paul pointed out, this is very likely an error in the plugin. I aggree with Paul.

IMHO, you should contact plugin developer, to correct the problem.
I would NOT use it until these problems are not solved...

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Just did some more test and it seams the problem is only present when using user_sessions set to URL

When using user_sessions set to Cookies, it works fine with no error.

Perhaps the fault is with Links SQL 2.12 after all?

s= URL user session

--------------------------------
Privacy Software

The most likely is, that plugin has wrong code.
OR, maybe the plugin in not compatible with Links SQL v2.1.2.
Try the plugin with v2.1.1.

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

I'd recommending contacting the author. The plugin has a few other bugs that I just noticed too. For example a string comparison operator (eq) is used instead of the numeric operator (==). This can lead to strange results.

The plugin needs looking at I think.

Thanks!

I'll suspend use then until this is fixed, or I use the community program when done (I assume updating a user record can be done by the user?)

--------------------------------
Privacy Software