General FAQ - Revision history

Han: Marked this version for translation

2025-10-20T14:00:04Z

Marked this version for translation

← Older revision		Revision as of 16:00, 20 October 2025
Line 304:		Line 304:


			<!--T:140-->
	=== Version 6.x ===		=== Version 6.x ===
	# Access to your server with a command line (ssh for example)		# Access to your server with a command line (ssh for example)
Line 310:		Line 311:
	# Launch this command <code>php application/commands/console.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS</code><sup>The php can need complete directory access, example /usr/bin/php</sup>		# Launch this command <code>php application/commands/console.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS</code><sup>The php can need complete directory access, example /usr/bin/php</sup>

	=== Version 2.x === ~~<!--T:73-->~~		<!--T:73-->
			=== Version 2.x ===
	# Access to your server with a command line (ssh for example)		# Access to your server with a command line (ssh for example)
	# Ensure you have php command line access (see http://php.net/features.commandline.php).		# Ensure you have php command line access (see http://php.net/features.commandline.php).
Line 327:		Line 329:


	=== Directly change the password in the database === ~~<!--T:74-->~~		<!--T:74-->
			=== Directly change the password in the database ===
	If you have direct access to the Limesurvey database you can change the old password there by uploading the new password as SHA256 hash. You can [http://www.xorbin.com/tools/sha256-hash-calculator create the SHA256 hash of your password here].		If you have direct access to the Limesurvey database you can change the old password there by uploading the new password as SHA256 hash. You can [http://www.xorbin.com/tools/sha256-hash-calculator create the SHA256 hash of your password here].

Gabrieljenik: Reset Password with CLI - Added section for LS v6

2025-09-05T15:52:22Z

Reset Password with CLI - Added section for LS v6

← Older revision		Revision as of 17:52, 5 September 2025
Line 303:		Line 303:
	==I forgot my admin password. How do I reset it?== <!--T:31-->		==I forgot my admin password. How do I reset it?== <!--T:31-->


			=== Version 6.x ===
			# Access to your server with a command line (ssh for example)
			# Ensure you have php command line access (see http://php.net/features.commandline.php).
			# Go to your LimeSurvey directory
			# Launch this command <code>php application/commands/console.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS</code><sup>The php can need complete directory access, example /usr/bin/php</sup>

	=== Version 2.x === <!--T:73-->		=== Version 2.x === <!--T:73-->
Line 313:		Line 319:
	<!--T:116-->		<!--T:116-->
	{{Alert\|Title=Attention\|text=Please note that this method will not work in LimeSurvey 3.x!}}		{{Alert\|Title=Attention\|text=Please note that this method will not work in LimeSurvey 3.x!}}


	===Version 2.x.x and newer with only FTP access=== <!--T:82-->		===Version 2.x.x and newer with only FTP access=== <!--T:82-->

Han: Marked this version for translation

2023-03-28T13:49:41Z

Marked this version for translation

← Older revision		Revision as of 15:49, 28 March 2023
Line 87:		Line 87:
	}		}

	# Allow access to well-known directory, different usage, for example ACME Challenge for Let's Encrypt		<!--T:139-->
			# Allow access to well-known directory, different usage, for example ACME Challenge for Let's Encrypt
	location ~ /\.well-known {		location ~ /\.well-known {
	allow all;		allow all;

DenisChenu: Add ^/tmp/runtime for nginx

2023-03-03T10:52:11Z

Add ^/tmp/runtime for nginx

← Older revision		Revision as of 12:52, 3 March 2023
Line 78:		Line 78:
	charset utf-8;		charset utf-8;
	try_files $uri /index.php?$uri&$args;		try_files $uri /index.php?$uri&$args;
	#Disallow reading inside php script directory, see issue with debug > 1 on note		# Disallow reading inside php script directory, see issue with debug > 1 on note
	location ~ ^/(application\|docs\|framework\|locale\|protected\|tests\|themes/\w+/views) {		location ~ ^/(application\|docs\|framework\|locale\|protected\|tests\|themes/\w+/views) {
	deny all;		deny all;
	}		}
	# Allow access to well-known directory, different usage, for example ACME Challenge for Let's Encrypt		# Disallow reading inside runtime directory
			location ~ ^/tmp/runtime/ {
			deny all;
			}

			# Allow access to well-known directory, different usage, for example ACME Challenge for Let's Encrypt
	location ~ /\.well-known {		location ~ /\.well-known {
	allow all;		allow all;

DenisChenu: Fix for survey sid

2022-09-29T09:44:00Z

Fix for survey sid

← Older revision		Revision as of 11:44, 29 September 2022
Line 77:		Line 77:
	root /PATH/TO/LIMESURVEY;		root /PATH/TO/LIMESURVEY;
	charset utf-8;		charset utf-8;
	try_files ~~$uri~~ $uri/ /index.php?r=$uri&$args;		try_files $uri /index.php?$uri&$args;
	#Disallow reading inside php script directory, see issue with debug > 1 on note		#Disallow reading inside php script directory, see issue with debug > 1 on note
	location ~ ^/(application\|docs\|framework\|locale\|protected\|tests\|themes/\w+/views) {		location ~ ^/(application\|docs\|framework\|locale\|protected\|tests\|themes/\w+/views) {

C schmitz: Text replacement - " enclose="div"" to ""

2022-02-16T13:03:08Z

Text replacement - " enclose="div"" to ""

← Older revision		Revision as of 15:03, 16 February 2022
Line 55:		Line 55:

	<!--T:65-->		<!--T:65-->
	<syntaxhighlight lang="php~~" enclose="div~~">'showScriptName' => true,</syntaxhighlight>		<syntaxhighlight lang="php">'showScriptName' => true,</syntaxhighlight>

	<!--T:66-->		<!--T:66-->
Line 61:		Line 61:

	<!--T:67-->		<!--T:67-->
	<syntaxhighlight lang="php~~" enclose="div~~">'showScriptName' => false,</syntaxhighlight>		<syntaxhighlight lang="php">'showScriptName' => false,</syntaxhighlight>

	<!--T:68-->		<!--T:68-->
Line 153:		Line 153:

	<!--T:98-->		<!--T:98-->
	<syntaxhighlight lang="css~~" enclose="div~~">.asterisk {display: none;}</syntaxhighlight>		<syntaxhighlight lang="css">.asterisk {display: none;}</syntaxhighlight>


Line 321:		Line 321:
	<!--T:76-->		<!--T:76-->
	For example, you can use this instruction to set password to password:		For example, you can use this instruction to set password to password:
	<syntaxhighlight lang="sql~~" enclose="div~~">		<syntaxhighlight lang="sql">
	UPDATE lime_users SET password = 0x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438 WHERE uid =1;		UPDATE lime_users SET password = 0x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438 WHERE uid =1;
	</syntaxhighlight>		</syntaxhighlight>

DenisChenu: Add docs, protected, tests directory to deny all.

2021-11-29T15:56:48Z

Add docs, protected, tests directory to deny all.

← Older revision		Revision as of 17:56, 29 November 2021
Line 79:		Line 79:
	try_files $uri $uri/ /index.php?r=$uri&$args;		try_files $uri $uri/ /index.php?r=$uri&$args;
	#Disallow reading inside php script directory, see issue with debug > 1 on note		#Disallow reading inside php script directory, see issue with debug > 1 on note
	location ~ ^/(application\|protected\|~~framework~~\|themes/\w+/views) {		location ~ ^/(application\|docs\|framework\|locale\|protected\|tests\|themes/\w+/views) {
	deny all;		deny all;
			}
			# Allow access to well-known directory, different usage, for example ACME Challenge for Let's Encrypt
			location ~ /\.well-known {
			allow all;
			}
			# Deny all attempts to access hidden files
			# such as .htaccess, .htpasswd, .DS_Store (Mac).
			location ~ /\. {
			deny all;
	}		}
	#Disallow direct read user upload files		#Disallow direct read user upload files

Han: Marked this version for translation

2021-11-17T19:43:38Z

Marked this version for translation

← Older revision		Revision as of 21:43, 17 November 2021
Line 366:		Line 366:
	=== ...regarding survey size=== <!--T:42-->		=== ...regarding survey size=== <!--T:42-->

	==== MySQL and MariaDB ====		==== MySQL and MariaDB ==== <!--T:133-->

	<!--T:43-->		<!--T:43-->
Line 388:		Line 388:
	*Add 10% for the usual overhead		*Add 10% for the usual overhead

	==== With Microsoft SQL ====		==== With Microsoft SQL ==== <!--T:134-->

			<!--T:135-->
	There are no fixed limit on MSSQL. Some [https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15 information on microsoft website].		There are no fixed limit on MSSQL. Some [https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15 information on microsoft website].

			<!--T:136-->
	The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.		The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.

	====With PostgreSQL====		====With PostgreSQL==== <!--T:137-->

			<!--T:138-->
	When you try to export response : you can have SQLSTATE[54000] error. You can export some columns. See [https://forums.limesurvey.org/forum/french-forum/125447-erreur-sqlstate-54000 forum post].		When you try to export response : you can have SQLSTATE[54000] error. You can export some columns. See [https://forums.limesurvey.org/forum/french-forum/125447-erreur-sqlstate-54000 forum post].

DenisChenu: /* With Microsoft SQL */

2021-10-19T05:46:01Z

With Microsoft SQL

← Older revision		Revision as of 07:46, 19 October 2021
Line 390:		Line 390:
	==== With Microsoft SQL ====		==== With Microsoft SQL ====

	~~Like MySQL : there~~ are no fixed limit on MSSQL. Some [https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15 information on microsoft website]].		There are no fixed limit on MSSQL. Some [https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15 information on microsoft website].

	The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.		The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.

DenisChenu at 14:25, 23 September 2021

2021-09-23T14:25:13Z

← Older revision		Revision as of 16:25, 23 September 2021
Line 394:		Line 394:
	The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.		The 8,060 bytes per row can appear after activation when you want to browse response and data. You can export answer code and not answer text or try to export only some columns.

	====How to increase the maximum number of columns in PostgreSQL==== <!--T:46-->		====With PostgreSQL====

			When you try to export response : you can have SQLSTATE[54000] error. You can export some columns. See [https://forums.limesurvey.org/forum/french-forum/125447-erreur-sqlstate-54000 forum post].

			=====How to increase the maximum number of columns in PostgreSQL===== <!--T:46-->