Login Form

QR Code of :

Latest users

  • admin
  • recaetano
  • MaimiSwillowl
  • alikon
  • pippo

my knowledge is knowing not to know

Welcome, Guest
Username Password: Remember me

MySQL Syntax Error
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: MySQL Syntax Error

MySQL Syntax Error 1 year, 5 months ago #6073

  • spirit66
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Hi,
just installed the latest version of AUser Manager 1.5.13 and get now a syntax error at login.

400 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \')\' at line 1 SQL=INSERT INTO ucbfh_users_visit VALUES ( 76 , 0 , 0, 0, ADDDATE(\"2010-08-14 15:21:21\", 60),\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',)

Maybe somebody can help.
Thanks
Rudolf Aigner

Re: MySQL Syntax Error 1 year, 5 months ago #6074

  • royko
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
I am having similar problem on a near ready production site. Tried to install the new user plugin but more problems. 400 error is now also showing a 500 error.

Disabling and uninstalling the plugin as well as module and component are also not helping. Please assist URGENTLY.

Regards

Royko

Re:MySQL Syntax Error 1 year, 5 months ago #6075

  • admin
  • OFFLINE
  • Administrator
  • Posts: 894
  • Karma: 0
@spirit66 and @royko
the 400 error arise when the plugin: System - Route2Auser is
disabled.
please enable it

check if the plugin :User - AUser Plugin is enalbed too
Last Edit: 1 year, 5 months ago by admin.

Re:MySQL Syntax Error 1 year, 5 months ago #6076

  • spirit66
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Hi,
thanks for the quick response but this login function doesn\'t work for me. The login button is never activ. So I use the original Joomla login function. I also prefer the captcha security method.

I don\'t understand how a disabled plugin can solve a syntax error. I found that in auser.php at statements 106 - 108 and 296 - 298 is a problem. Is this term $user[\'hscore\'] correct? I changed to $db->Quote($options[\'hscore\']) and this worked for me.

Would be nice if you can look again for that conflict.

Thanks
Spirit

Re:MySQL Syntax Error 1 year, 5 months ago #6077

  • admin
  • OFFLINE
  • Administrator
  • Posts: 894
  • Karma: 0
The plugin enabled set the correct value for
$user[\'hscore\']


the login module issue is under reviw
  • Page:
  • 1
  • 2
Time to create page: 1.01 seconds