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: www.limesurvey.org/manual/Installation_o...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 "https://localhost/".

My problem right now is that I a) don't know what I need to put in here: https://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

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 https://127.0.0.1/limesurvey in your browser. https://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 https://
 

Thank you,

https://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?

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.

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.

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.

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.

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.