Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Noob Question: How to actually install Limesurvey on PC?

  • Omti90
  • Omti90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 1 month ago #211215 by Omti90
Hello everyone,

I've been trying to install limesurvey on my local PC to test and write some custom question templates. I've just been stalled at the very first step.

I've been trying to follow the manual: manual.limesurvey.org/Installation_of_th...Survey_XAMPP_package
But apparently the LimeSurvey_XAMPP_package doesn't exist anymore.

This thread forums.limesurvey.org/forum/installation...survey-on-windows-10 suggests, I just download XAMPP and unpack limesurvey into its "htdocs" folder. I downloaded limesurvey from here: community.limesurvey.org/downloads/ and used the Long Term Stable version.

Following some explanation on youtube www.youtube.com/watch?v=N6ENnaRotmo , I activated the Apache server, allowing me to connect to "http://localhost/".

My problem right now is that I a) don't know what I need to put in here: http://localhost/pathtoyourlimesurveyfolder/ because https://localhost/C:/xampp/htdocs/limesurvey doesn't work and b) I'm not actually sure I downloaded the right stuff and what I actually need to activate in the XAMPP control panel.

Kind Regards,
Omti90
The following user(s) said Thank You: MikeHammer
The topic has been locked.
More
3 years 1 month ago #211216 by jelo

Omti90 wrote: .https://localhost/C:/xampp/htdocs/limesurvey doesn't work and b) I'm not actually sure I downloaded the right stuff and what I actually need to activate in the XAMPP control panel.

 

The path in the URL is not the windows path. htdocs is the webroot  of Apache. So you might try http://127.0.0.1/limesurvey in your browser. http://localhost/limesurvey would be the same.
You can try https:// too, but you will getra warning cause you only will have a selfsigned certifiate for TLS-Transportencryption. Since you won't leave your own PC, you can use the unencrypted access via http://
 

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: Omti90
The topic has been locked.
  • Omti90
  • Omti90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 1 month ago #211222 by Omti90
Thank you,

http://localhost/limesurvey works brilliantly.

The installation is suggesting a number of libraries:
PHP GD Bibliothek
PHP LDAP Bibliothek
PHP zip Bibliothek (installed)
PHP imap Bibliothek

where only the zip library is installed. Do I need the other ones, and where do I find them?
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211226 by holch
Not for developing custom themes. LDAP only if you use LDAP, GD only for the generation of images/graphs, IMAP if you want to send emails via IMAP.

ZIP is needed for some exports.

But I assume you are not using limesurvey on XAMPP for running surveys (which I wouldn't recommend!), but only for development. So you most probably won't need these libraries.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: Omti90
The topic has been locked.
More
3 years 1 month ago #211228 by jelo

Omti90 wrote: where only the zip library is installed. Do I need the other ones, and where do I find them?
 

These are all questions which are not LimeSurvey specific. They are part of what an administrator has to know.

On the XAMPP windows packages most of these libraries are already part of the installation. Look for the relevant php.ini, which should contain libraries to be activated via removing the comment in the relevant textline.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • Omti90
  • Omti90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 1 month ago - 3 years 1 month ago #211240 by Omti90
Thank you,

yeah, I'm just trying to use it for development purposes.

So I continued, but now I'm getting a weird error after creating a database and while trying to create tables:

Bitte beheben Sie die folgenden Fehler:

There is no active transaction
 

which resets me to the configuration window. If I try to open the previously created database again, it asks me to create tables again, but produces a different error:

Bitte beheben Sie die folgenden Fehler:

CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_answers' already exists


I can't progress to admin settings for some reason.
Last edit: 3 years 1 month ago by Omti90.
The topic has been locked.
  • Omti90
  • Omti90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 1 month ago #211488 by Omti90
Alright, I found the solution to the problem for the "There is no active transaction" bug.

I needed to download an older Version of XAMPP and now it seems to work. www.apachefriends.org/de/download.html

In case someone else has the same problem, I picked Version 7.3.26 / PHP 7.3.26.
The topic has been locked.
More
2 years 10 months ago #215754 by MarcoChin
QUICK FIX description (at least worked in my case with XAMPP PHP8.0):

Using Lime Survey Stable (LTS) Release 3.26.2,
current XAMPP (Win10-64bit) version with PHP 8.0.1 and 10.4.17-MariaDB,
I managed to complete the installation scripts by modifying (commenting out) the following lines in
.../limesurvey/installer/create-database.php
line 29: //$oTransaction = $oDB->beginTransaction();
line 830: //$oTransaction->commit();

(I was expecting that rollback line 832 would remove all tables which is not the case; and note that line 832 with $oTransaction would probably fail/ but note that this is a quick fix).

Hope this is helpful.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose