Welcome, Guest
Username: Password: Remember me

TOPIC: SQL Syntax error

SQL Syntax error 2 years 4 months ago #79939

  • dac
  • dac's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hi,

Just installed limesurvey192plus-build120501. Logged with initial default username and password. The resulting page gives this error:

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 '"";)users WHERE uid=1' at line 1:SELECT create_survey, configurator, create_user, delete_user, superadmin, manage_template, manage_label FROM $dbprefix="";)users WHERE uid=1

I'm a noob, so I would appreciate any help!

Thanks in Advance!
The administrator has disabled public write access.

Re: SQL Syntax error 2 years 4 months ago #79944

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 779
  • Thank you received: 111
  • Karma: 92
Looks like an error in your config.php
Check what you set for $dbprefix.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re: SQL Syntax error 2 years 4 months ago #79976

  • dac
  • dac's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
That was it! Thanks much!
The administrator has disabled public write access.

Re: SQL Syntax error 2 years 4 months ago #79977

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
You're welcome :-)

If our hints have been helpful and you enjoy limesurvey please consider a donation to give Limesurvey a future .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.109 seconds
Donation Image