58
edits
Troubleshooting: Difference between revisions
Jump to navigation
Jump to search
can not upload file
(mix of collations) |
Dolibarr95 (talk | contribs) (can not upload file) |
||
| Line 57: | Line 57: | ||
* /install/repair.php?clean_perm_table=confirmed | * /install/repair.php?clean_perm_table=confirmed | ||
* /install/repair.php?force_utf8_on_tables=confirmed for Mysql only, when ''Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' '' | * /install/repair.php?force_utf8_on_tables=confirmed for Mysql only, when ''Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' '' | ||
= I can't upload files = | |||
<span style="color: #FF0000;">This section needs more informations.</span> | |||
Depending of your configuration, if you encounter the error | |||
<source lang="php"> | |||
Warning: tempnam(): open_basedir restriction in effect. File(C:\WINDOWS\TEMP) is not within the allowed path(s): (c:/dolibarr) in C:\dolibarr\www\dolibarr\htdocs\core\modules\import\import_xlsx.modules.php on line 182 | |||
</source> | |||
You will have to edit the php.ini | |||
Find the directive upload_tmp_dir: uncomment the line and change its value to a required path. In this example it is "/var/tmp": | |||
<source lang="php"> | |||
; Temporary directory for HTTP uploaded files (will use system default if not | |||
; specified). | |||
; http://php.net/upload-tmp-dir | |||
upload_tmp_dir = /var/tmp | |||
</source> | |||
Additionally for PHP versions 5.5 and greater, find the directive sys_temp_dir: uncomment the line and change its value to a required path. In this example, it is "/var/tmp": | |||
<source lang="php"> | |||
; Directory where the temporary files should be placed. | |||
; Defaults to the system default (see sys_get_temp_dir) | |||
sys_temp_dir = "/var/tmp" | |||
</source> | |||
And in Vhosts | |||
<source lang="c"> | |||
open_basedir = {WEBSPACEROOT}{/}{:}{TMP}{/}:/var/tmp | |||
</source> | |||
= My problem is not in the list = | = My problem is not in the list = | ||