-
Notifications
You must be signed in to change notification settings - Fork 55
/
faq.pot
2140 lines (1610 loc) · 97.8 KB
/
faq.pot
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
# SOME DESCRIPTIVE TITLE.
# Copyright (C) 2012 - 2021, The phpMyAdmin devel team
# This file is distributed under the same license as the phpMyAdmin package.
# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
#
#, fuzzy
msgid ""
msgstr ""
"Project-Id-Version: phpMyAdmin 6.0.0-dev\n"
"Report-Msgid-Bugs-To: \n"
"POT-Creation-Date: 2023-10-26 00:00+0200\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
#: ../phpmyadmin/doc/faq.rst:4
msgid "FAQ - Frequently Asked Questions"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:6
msgid "Please have a look at our `Link section <https://www.phpmyadmin.net/docs/>`_ on the official phpMyAdmin homepage for in-depth coverage of phpMyAdmin's features and or interface."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:14
msgid "Server"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:19
msgid "1.1 My server is crashing each time a specific action is required or phpMyAdmin sends a blank page or a page full of cryptic characters to my browser, what can I do?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:21
msgid "Try to set the :config:option:`$cfg['OBGzip']` directive to ``false`` in your :file:`config.inc.php` file and the ``zlib.output_compression`` directive to ``Off`` in your php configuration file."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:28
msgid "1.2 My Apache server crashes when using phpMyAdmin."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:30
msgid "You should first try the latest versions of Apache (and possibly MySQL). If your server keeps crashing, please ask for help in the various Apache support groups."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:34
msgid ":ref:`faq1_1`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:39
msgid "1.3 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:44
msgid "1.4 Using phpMyAdmin on IIS, I'm displayed the error message: \"The specified CGI application misbehaved by not returning a complete set of HTTP headers ...\"."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:46
msgid "You just forgot to read the *install.txt* file from the PHP distribution. Have a look at the last message in this `PHP bug report #12061 <https://bugs.php.net/bug.php?id=12061>`_ from the official PHP bug database."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:54
msgid "1.5 Using phpMyAdmin on IIS, I'm facing crashes and/or many error messages with the HTTP."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:56
msgid "This is a known problem with the PHP :term:`ISAPI` filter: it's not so stable. Please use instead the cookie authentication mode."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:62
msgid "1.6 I can't use phpMyAdmin on PWS: nothing is displayed!"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:64
msgid "This seems to be a PWS bug. Filippo Simoncini found a workaround (at this time there is no better fix): remove or comment the ``DOCTYPE`` declarations (2 lines) from the scripts :file:`src/Header.php` and :file:`index.php`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:72
msgid "1.7 How can I gzip a dump or a CSV export? It does not seem to work."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:74
msgid "This feature is based on the ``gzencode()`` PHP function to be more independent of the platform (Unix/Windows, Safe Mode or not, and so on). So, you must have Zlib support (``--with-zlib``)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:82
msgid "1.8 I cannot insert a text file in a table, and I get an error about safe mode being in effect."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:84
msgid "Your uploaded file is saved by PHP in the \"upload dir\", as defined in :file:`php.ini` by the variable ``upload_tmp_dir`` (usually the system default is */tmp*). We recommend the following setup for Apache servers running in safe mode, to enable uploads of files while being reasonably secure:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:90
msgid "create a separate directory for uploads: :command:`mkdir /tmp/php`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:91
msgid "give ownership to the Apache server's user.group: :command:`chown apache.apache /tmp/php`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:93
msgid "give proper permission: :command:`chmod 600 /tmp/php`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:94
msgid "put ``upload_tmp_dir = /tmp/php`` in :file:`php.ini`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:95
msgid "restart Apache"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:100
msgid "1.9 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:105
msgid "1.10 I'm having troubles when uploading files with phpMyAdmin running on a secure server. My browser is Internet Explorer and I'm using the Apache server."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:107
msgid "As suggested by \"Rob M\" in the phpWizard forum, add this line to your *httpd.conf*:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:114
msgid "It seems to clear up many problems between Internet Explorer and SSL."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:119
msgid "1.11 I get an 'open\\_basedir restriction' while uploading a file from the import tab."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:121
msgid "Since version 2.2.4, phpMyAdmin supports servers with open\\_basedir restrictions. However you need to create temporary directory and configure it as :config:option:`$cfg['TempDir']`. The uploaded files will be moved there, and after execution of your :term:`SQL` commands, removed."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:129
msgid "1.12 I have lost my MySQL root password, what can I do?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:131
msgid "phpMyAdmin does authenticate against MySQL server you're using, so to recover from phpMyAdmin password loss, you need to recover at MySQL level."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:134
msgid "The MySQL manual explains how to `reset the permissions <https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html>`_."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:137
msgid "If you are using MySQL server installed by your hosting provider, please contact their support to recover the password for you."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:143
msgid "1.13 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:148
msgid "1.14 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:153
msgid "1.15 I have problems with *mysql.user* column names."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:155
msgid "In previous MySQL versions, the ``User`` and ``Password`` columns were named ``user`` and ``password``. Please modify your column names to align with current standards."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:162
msgid "1.16 I cannot upload big dump files (memory, HTTP or timeout problems)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:164
msgid "Starting with version 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:168
msgid "The first things to check (or ask your host provider to check) are the values of ``max_execution_time``, ``upload_max_filesize``, ``memory_limit`` and ``post_max_size`` in the :file:`php.ini` configuration file. All of these settings limit the maximum size of data that can be submitted and handled by PHP. Please note that ``post_max_size`` needs to be larger than ``upload_max_filesize``. There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:176
msgid "Look at the :config:option:`$cfg['UploadDir']` feature. This allows one to upload a file to the server via scp, FTP, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the :ref:`config` of this document."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:180
msgid "Using a utility (such as `BigDump <https://www.ozerov.de/bigdump/>`_) to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:184
msgid "If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the \"source\" command from within MySQL:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:195
msgid "1.17 Which Database versions does phpMyAdmin support?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:197
msgid "For `MySQL <https://www.mysql.com/>`_, versions 5.5 and newer are supported. For older MySQL versions, our `Downloads <https://www.phpmyadmin.net/downloads/>`_ page offers older phpMyAdmin versions (which may have become unsupported)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:201
msgid "For `MariaDB <https://mariadb.org/>`_, versions 5.5 and newer are supported."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:206
msgid "1.17a I cannot connect to the MySQL server. It always returns the error message, \"Client does not support authentication protocol requested by server; consider upgrading MySQL client\""
msgstr ""
#: ../phpmyadmin/doc/faq.rst:208
msgid "You tried to access MySQL with an old MySQL client library. The version of your MySQL client library can be checked in your phpinfo() output. In general, it should have at least the same minor version as your server - as mentioned in :ref:`faq1_17`. This problem is generally caused by using MySQL version 4.1 or newer. MySQL changed the authentication hash and your PHP is trying to use the old method. The proper solution is to use the `mysqli extension <https://www.php.net/mysqli>`_ with the proper client library to match your MySQL installation. More information (and several workarounds) are located in the `MySQL Documentation <https://dev.mysql.com/doc/refman/5.7/en/common-errors.html>`_."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:223
msgid "1.18 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:228
msgid "1.19 I can't run the \"display relations\" feature because the script seems not to know the font face I'm using!"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:230
msgid "The :term:`TCPDF` library we're using for this feature requires some special files to use font faces. Please refers to the `TCPDF manual <https://tcpdf.org/>`_ to build these files."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:237
msgid "1.20 I receive an error about missing mysqli and mysql extensions."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:239
msgid "To connect to a MySQL server, PHP needs a set of MySQL functions called \"MySQL extension\". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably *mysqli.so* or *php\\_mysqli.dll*. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called \"PHP-MySQL\" or something similar."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:247
msgid "There was two interfaces PHP provided as MySQL extensions - ``mysql`` and ``mysqli``. The ``mysql`` interface was removed in PHP 7.0."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:250
msgid "This problem can be also caused by wrong paths in the :file:`php.ini` or using wrong :file:`php.ini`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:253
msgid "Make sure that the extension files do exist in the folder which the ``extension_dir`` points to and that the corresponding lines in your :file:`php.ini` are not commented out (you can use ``phpinfo()`` to check current setup):"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:265
msgid "The :file:`php.ini` can be loaded from several locations (especially on Windows), so please check you're updating the correct one. If using Apache, you can tell it to use specific path for this file using ``PHPIniDir`` directive:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:280
msgid "In some rare cases this problem can be also caused by other extensions loaded in PHP which prevent MySQL extensions to be loaded. If anything else fails, you can try commenting out extensions for other databases from :file:`php.ini`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:287
msgid "1.21 I am running the CGI version of PHP under Unix, and I cannot log in using cookie auth."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:289
msgid "In :file:`php.ini`, set ``mysql.max_links`` higher than 1."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:294
msgid "1.22 I don't see the \"Location of text file\" field, so I cannot upload."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:296
msgid "This is most likely because in :file:`php.ini`, your ``file_uploads`` parameter is not set to \"on\"."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:302
msgid "1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and column names are changed to lowercase!"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:304
msgid "This happens because the MySQL directive ``lower_case_table_names`` defaults to 1 (``ON``) in the Win32 version of MySQL. You can change this behavior by simply changing the directive to 0 (``OFF``): Just edit your ``my.ini`` file that should be located in your Windows directory and add the following line to the group [mysqld]:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:316
msgid "Forcing this variable to 0 with --lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:320
msgid "Next, save the file and restart the MySQL service. You can always check the value of this directive using the query"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:327
msgid "`Identifier Case Sensitivity in the MySQL Reference Manual <https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html>`_"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:332
msgid "1.24 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:337
msgid "1.25 I am running Apache with mod\\_gzip-1.3.26.1a on Windows XP, and I get problems, such as undefined variables when I run a SQL query."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:339
msgid "A tip from Jose Fandos: put a comment on the following two lines in httpd.conf, like this:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:347
msgid "as this version of mod\\_gzip on Apache (Windows) has problems handling PHP scripts. Of course you have to restart Apache."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:353
msgid "1.26 I just installed phpMyAdmin in my document root of IIS but I get the error \"No input file specified\" when trying to run phpMyAdmin."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:355
msgid "This is a permission problem. Right-click on the phpmyadmin folder and choose properties. Under the tab Security, click on \"Add\" and select the user \"IUSR\\_machine\" from the list. Now set their permissions and it should work."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:363
msgid "1.27 I get empty page when I want to view huge page (eg. db\\_structure.php with plenty of tables)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:365
msgid "This was caused by a `PHP bug <https://bugs.php.net/bug.php?id=21079>`_ that occur when GZIP output buffering is enabled. If you turn off it (by :config:option:`$cfg['OBGzip']` in :file:`config.inc.php`), it should work. This bug will has been fixed in PHP 5.0.0."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:373
msgid "1.28 My MySQL server sometimes refuses queries and returns the message 'Errorcode: 13'. What does this mean?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:375
msgid "This can happen due to a MySQL bug when having database / table names with upper case characters although ``lower_case_table_names`` is set to 1. To fix this, turn off this directive, convert all database and table names to lower case and turn it on again. Alternatively, there's a bug-fix available starting with MySQL 3.23.56 / 4.0.11-gamma."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:385
msgid "1.29 When I create a table or modify a column, I get an error and the columns are duplicated."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:387
msgid "It is possible to configure Apache in such a way that PHP has problems interpreting .php files."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:390
msgid "The problems occur when two different (and conflicting) set of directives are used:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:398
msgid "and"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:404
msgid "In the case we saw, one set of directives was in ``/etc/httpd/conf/httpd.conf``, while the other set was in ``/etc/httpd/conf/addon-modules/php.conf``. The recommended way is with ``AddType``, so just comment out the first set of lines and restart Apache:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:418
msgid "1.30 I get the error \"navigation.php: Missing hash\"."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:420
msgid "This problem is known to happen when the server is running Turck MMCache but upgrading MMCache to version 2.3.21 solves the problem."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:426
msgid "1.31 Which PHP versions does phpMyAdmin support?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:428
msgid "Since release 4.5, phpMyAdmin supports only PHP 5.5 and newer. Since release 4.1 phpMyAdmin supports only PHP 5.3 and newer. For PHP 5.2 you can use 4.0.x releases."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:432
msgid "PHP 7 is supported since phpMyAdmin 4.6, PHP 7.1 is supported since 4.6.5, PHP 7.2 is supported since 4.7.4."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:435
msgid "HHVM is supported up to phpMyAdmin 4.8."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:437
msgid "Since release 5.0, phpMyAdmin supports only PHP 7.1 and newer. Since release 5.2, phpMyAdmin supports only PHP 7.2 and newer. Since release 6.0, phpMyAdmin supports only PHP 8.1 and newer."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:444
msgid "1.32 Can I use HTTP authentication with IIS?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:446
msgid "Yes. This procedure was tested with phpMyAdmin 2.6.1, PHP 4.3.9 in :term:`ISAPI` mode under :term:`IIS` 5.1."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:449
msgid "In your :file:`php.ini` file, set ``cgi.rfc2616_headers = 0``"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:450
msgid "In ``Web Site Properties -> File/Directory Security -> Anonymous Access`` dialog box, check the ``Anonymous access`` checkbox and uncheck any other checkboxes (i.e. uncheck ``Basic authentication``, ``Integrated Windows authentication``, and ``Digest`` if it's enabled.) Click ``OK``."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:455
msgid "In ``Custom Errors``, select the range of ``401;1`` through ``401;5`` and click the ``Set to Default`` button."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:458
msgid ":rfc:`2616`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:463
msgid "1.33 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:468
msgid "1.34 Can I directly access a database or table pages?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:470
msgid "Yes. Out of the box, you can use a :term:`URL` like ``http://server/phpMyAdmin/index.php?server=X&db=database&table=table&target=script``. For ``server`` you can use the server number which refers to the numeric host index (from ``$i``) in :file:`config.inc.php`. The table and script parts are optional."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:476
msgid "If you want a URL like ``http://server/phpMyAdmin/database[/table][/script]``, you need to do some additional configuration. The following lines apply only for the `Apache <https://httpd.apache.org>`_ web server. First, make sure that you have enabled some features within the Apache global configuration. You need ``Options SymLinksIfOwnerMatch`` and ``AllowOverride FileInfo`` enabled for directory where phpMyAdmin is installed and you need mod\\_rewrite to be enabled. Then you just need to create the following :term:`.htaccess` file in root folder of phpMyAdmin installation (don't forget to change directory name inside of it):"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:495
msgid ":ref:`faq4_8`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:499
msgid "Support for using the ``target`` parameter was removed in phpMyAdmin 5.1.0. Use the ``route`` parameter instead."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:505
msgid "1.35 Can I use HTTP authentication with Apache CGI?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:507
msgid "Yes. However you need to pass authentication variable to :term:`CGI` using following rewrite rule:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:518
msgid "1.36 I get an error \"500 Internal Server Error\"."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:520
msgid "There can be many explanations to this and a look at your server's error log file might give a clue."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:526
msgid "1.37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn't work."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:528
msgid "If your cluster consist of different architectures, PHP code used for encryption/decryption won't work correctly. This is caused by use of pack/unpack functions in code. Only solution is to use openssl extension which works fine in this case."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:536
msgid "1.38 Can I use phpMyAdmin on a server on which Suhosin is enabled?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:538
msgid "Yes but the default configuration values of Suhosin are known to cause problems with some operations, for example editing a table with many columns and no :term:`primary key` or with textual :term:`primary key`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:542
msgid "Suhosin configuration might lead to malfunction in some cases and it can not be fully avoided as phpMyAdmin is kind of application which needs to transfer big amounts of columns in single HTTP request, what is something what Suhosin tries to prevent. Generally all ``suhosin.request.*``, ``suhosin.post.*`` and ``suhosin.get.*`` directives can have negative effect on phpMyAdmin usability. You can always find in your error logs which limit did cause dropping of variable, so you can diagnose the problem and adjust matching configuration variable."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:552
msgid "The default values for most Suhosin configuration options will work in most scenarios, however you might want to adjust at least following parameters:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:556
msgid "`suhosin.request.max\\_vars <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-request-max-vars>`_ should be increased (eg. 2048)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:558
msgid "`suhosin.post.max\\_vars <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-post-max-vars>`_ should be increased (eg. 2048)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:560
msgid "`suhosin.request.max\\_array\\_index\\_length <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-request-max-array-index-length>`_ should be increased (eg. 256)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:562
msgid "`suhosin.post.max\\_array\\_index\\_length <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-post-max-array-index-length>`_ should be increased (eg. 256)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:564
msgid "`suhosin.request.max\\_totalname\\_length <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-request-max-totalname-length>`_ should be increased (eg. 8192)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:566
msgid "`suhosin.post.max\\_totalname\\_length <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-post-max-totalname-length>`_ should be increased (eg. 8192)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:568
msgid "`suhosin.get.max\\_value\\_length <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-get-max-value-length>`_ should be increased (eg. 1024)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:570
msgid "`suhosin.sql.bailout\\_on\\_error <https://suhosin5.suhosin.org/stories/configuration.html#suhosin-sql-bailout-on-error>`_ needs to be disabled (the default)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:572
msgid "`suhosin.log.\\* <https://suhosin5.suhosin.org/stories/configuration.html#logging-configuration>`_ should not include :term:`SQL`, otherwise you get big slowdown"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:575
msgid "`suhosin.sql.union <https://suhosin5.suhosin.org/stories/configuration.html#suhosin- sql-union>`_ must be disabled (which is the default)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:577
msgid "`suhosin.sql.multiselect <https://suhosin5.suhosin.org/stories/configuration.html# suhosin-sql-multiselect>`_ must be disabled (which is the default)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:579
msgid "`suhosin.sql.comment <https://suhosin5.suhosin.org/stories/configuration.html#suhosin- sql-comment>`_ must be disabled (which is the default)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:582
msgid "To further improve security, we also recommend these modifications:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:584
msgid "`suhosin.executor.include.max\\_traversal <https://suhosin5.suhosin.org/stories/ configuration.html#suhosin-executor-include-max-traversal>`_ should be enabled as a mitigation against local file inclusion attacks. We suggest setting this to 2 as ``../`` is used with the ReCaptcha library."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:588
msgid "`suhosin.cookie.encrypt <https://suhosin5.suhosin.org/stories/configuration.html# suhosin-cookie-encrypt>`_ should be enabled."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:590
msgid "`suhosin.executor.disable_emodifier <https://suhosin5.suhosin.org/stories/config uration.html#suhosin-executor-disable-emodifier>`_ should be enabled."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:593
msgid "You can also disable the warning using the :config:option:`$cfg['SuhosinDisableWarning']`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:598
msgid "1.39 When I try to connect via https, I can log in, but then my connection is redirected back to http. What can cause this behavior?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:600
msgid "This is caused by the fact that PHP scripts have no knowledge that the site is using https. Depending on used webserver, you should configure it to let PHP know about URL and scheme used to access it."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:604
msgid "For example in Apache ensure that you have enabled ``SSLOptions`` and ``StdEnvVars`` in the configuration."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:607
msgid "<https://httpd.apache.org/docs/2.4/mod/mod_ssl.html>"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:612
msgid "1.40 When accessing phpMyAdmin via an Apache reverse proxy, cookie login does not work."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:614
msgid "To be able to use cookie auth Apache must know that it has to rewrite the set-cookie headers. Example from the Apache 2.2 documentation:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:624
msgid "Note: if the backend url looks like ``http://server/~user/phpmyadmin``, the tilde (~) must be url encoded as %7E in the ProxyPassReverse\\* lines. This is not specific to phpmyadmin, it's just the behavior of Apache."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:634
msgid "<https://httpd.apache.org/docs/2.2/mod/mod_proxy.html>, :config:option:`$cfg['PmaAbsoluteUri']`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:639
msgid "1.41 When I view a database and ask to see its privileges, I get an error about an unknown column."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:641
msgid "The MySQL server's privilege tables are not up to date, you need to run the :command:`mysql_upgrade` command on the server."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:647
msgid "1.42 How can I prevent robots from accessing phpMyAdmin?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:649
msgid "You can add various rules to :term:`.htaccess` to filter access based on user agent field. This is quite easy to circumvent, but could prevent at least some robots accessing your installation."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:677
msgid "1.43 Why can't I display the structure of my table containing hundreds of columns?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:679
msgid "Because your PHP's ``memory_limit`` is too low; adjust it in :file:`php.ini`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:684
msgid "1.44 How can I reduce the installed size of phpMyAdmin on disk?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:686
msgid "Some users have requested to be able to reduce the size of the phpMyAdmin installation. This is not recommended and could lead to confusion over missing features, but can be done. A list of files and corresponding functionality which degrade gracefully when removed include:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:690
msgid ":file:`./locale/` folder, or unused subfolders (interface translations)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:691
msgid "Any unused themes in :file:`./public/themes/` except the default theme `pmahomme`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:692
msgid ":file:`./app/language_stats.inc.php` (translation statistics)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:693
msgid ":file:`./doc/` (documentation)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:694
msgid ":file:`./setup/` (setup script)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:695
msgid ":file:`./examples/` (configuration examples)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:696
msgid ":file:`./resources/sql/` (SQL scripts to configure advanced functionalities)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:697
msgid ":file:`./resources/js/src/` (Source files to re-build `./public/js/dist/`)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:698
msgid ":file:`./resources/js/global.d.ts` JS type declaration file"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:699
msgid "Run `rm -rv vendor/tecnickcom/tcpdf && composer dump-autoload --no-interaction --optimize --dev` (exporting to PDF)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:700
msgid "Run `rm -rv vendor/williamdes/mariadb-mysql-kbs && composer dump-autoload --no-interaction --optimize --dev` (external links to MariaDB and MySQL documentations)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:701
msgid "Run `rm -rv vendor/code-lts/u2f-php-server && composer dump-autoload --no-interaction --optimize --dev` (U2F second factor authentication)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:702
msgid "Run `rm -rv vendor/pragmarx/* && composer dump-autoload --no-interaction --optimize --dev` (2FA second factor authentication)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:703
msgid "Run `rm -rv vendor/bacon/bacon-qr-code && composer dump-autoload --no-interaction --optimize --dev` (QRcode generation for 2FA second factor authentication)"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:708
msgid "1.45 I get an error message about unknown authentication method caching_sha2_password when trying to log in"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:710
msgid "When logging in using MySQL version 8 or newer, you may encounter an error message like this:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:712
msgid "mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:714
msgid "mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:716
msgid "This error is because of a version compatibility problem between PHP and MySQL. The MySQL project introduced a new authentication method (our tests show this began with version 8.0.11) however PHP did not include the ability to use that authentication method. PHP reports that this was fixed in PHP version 7.4."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:720
msgid "Users experiencing this are encouraged to upgrade their PHP installation, however a workaround exists. Your MySQL user account can be set to use the older authentication with a command such as"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:727
msgid "<https://github.com/phpmyadmin/phpmyadmin/issues/14220>, <https://stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0>, <https://bugs.php.net/bug.php?id=76243>"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:732
msgid "Configuration"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:737
msgid "2.1 The error message \"Warning: Cannot add header information - headers already sent by ...\" is displayed, what's the problem?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:739
msgid "Edit your :file:`config.inc.php` file and ensure there is nothing (I.E. no blank lines, no spaces, no characters...) neither before the ``<?php`` tag at the beginning, neither after the ``?>`` tag at the end."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:746
msgid "2.2 phpMyAdmin can't connect to MySQL. What's wrong?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:748
msgid "Either there is an error with your PHP setup or your username/password is wrong. Try to make a small script which uses mysql\\_connect and see if it works. If it doesn't, it may be you haven't even compiled MySQL support into PHP."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:756
msgid "2.3 The error message \"Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ...\" is displayed. What can I do?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:758
msgid "The error message can also be: :guilabel:`Error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:761
msgid "First, you need to determine what socket is being used by MySQL. To do this, connect to your server and go to the MySQL bin directory. In this directory there should be a file named *mysqladmin*. Type ``./mysqladmin variables``, and this should give you a bunch of info about your MySQL server, including the socket (*/tmp/mysql.sock*, for example). You can also ask your ISP for the connection info or, if you're hosting your own, connect from the 'mysql' command-line client and type 'status' to get the connection type and socket or port number."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:770
msgid "Then, you need to tell PHP to use this socket. You can do this for all PHP in the :file:`php.ini` or for phpMyAdmin only in the :file:`config.inc.php`. For example: :config:option:`$cfg['Servers'][$i]['socket']` Please also make sure that the permissions of this file allow to be readable by your webserver."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:775
msgid "On my RedHat-Box the socket of MySQL is */var/lib/mysql/mysql.sock*. In your :file:`php.ini` you will find a line"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:782
msgid "change it to"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:788
msgid "Then restart apache and it will work."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:790
msgid "Have also a look at the `corresponding section of the MySQL documentation <https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html>`_."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:796
msgid "2.4 Nothing is displayed by my browser when I try to run phpMyAdmin, what can I do?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:798
msgid "Try to set the :config:option:`$cfg['OBGzip']` directive to ``false`` in the phpMyAdmin configuration file. It helps sometime. Also have a look at your PHP version number: if it contains \"b\" or \"alpha\" it means you're running a testing version of PHP. That's not a so good idea, please upgrade to a plain revision."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:807
msgid "2.5 Each time I want to insert or change a row or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication, I'm asked to log in again. What's wrong?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:809
msgid "Check your webserver setup if it correctly fills in either PHP_SELF or REQUEST_URI variables."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:811
msgid "If you are running phpMyAdmin behind reverse proxy, please set the :config:option:`$cfg['PmaAbsoluteUri']` directive in the phpMyAdmin configuration file to match your setup."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:818
msgid "2.6 I get an \"Access denied for user: 'root@localhost' (Using password: YES)\"-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:820
msgid "When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected. Erik Wasser explains: The solution is: if your host is \"localhost\" MySQL (the command line tool :command:`mysql` as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding. If you enter \"127.0.0.1\" as hostname, everything is right and MySQL uses the :term:`TCP` connection."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:832
msgid "2.7 Using and creating themes"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:834
msgid "See :ref:`themes`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:839
msgid "2.8 I get \"Missing parameters\" errors, what can I do?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:841
msgid "Here are a few points to check:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:843
msgid "In :file:`config.inc.php`, try to leave the :config:option:`$cfg['PmaAbsoluteUri']` directive empty. See also :ref:`faq4_7`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:845
msgid "Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See <https://bugs.php.net/bug.php?id=31134>."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:847
msgid "If you are using Hardened PHP with the ini directive ``varfilter.max_request_variables`` set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:852
msgid "In the :file:`php.ini` directive ``arg_separator.input``, a value of \";\" will cause this error. Replace it with \"&;\"."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:854
msgid "If you are using `Suhosin <https://suhosin5.suhosin.org/stories/index.html>`_, you might want to increase `request limits <https://suhosin5.suhosin.org/stories/faq.html>`_."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:856
msgid "The directory specified in the :file:`php.ini` directive ``session.save_path`` does not exist or is read-only (this can be caused by `bug in the PHP installer <https://bugs.php.net/bug.php?id=39842>`_)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:863
msgid "2.9 Seeing an upload progress bar"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:865
msgid "To be able to see a progress bar during your uploads, your server must have the `uploadprogress <https://pecl.php.net/package/uploadprogress>`_ extension, and you must be running PHP 5.4.0 or higher. Moreover, the JSON extension has to be enabled in your PHP."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:870
msgid "If using PHP 5.4.0 or higher, you must set ``session.upload_progress.enabled`` to ``1`` in your :file:`php.ini`. However, starting from phpMyAdmin version 4.0.4, session-based upload progress has been temporarily deactivated due to its problematic behavior."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:878
msgid "2.10 How to generate a string of random bytes"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:880
msgid "One way to generate a string of random bytes suitable for cryptographic use is using the `random_bytes <https://www.php.net/random_bytes>`_ :term:`PHP` function. Since this function returns a binary string, the returned value should be converted to printable format before being able to copy it."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:884
msgid "For example, the :config:option:`$cfg['blowfish_secret']` configuration directive requires a 32-bytes long string. The following command can be used to generate a hexadecimal representation of this string."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:891
msgid "The above example will output something similar to:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:897
msgid "And then this hexadecimal value can be used in the configuration file."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:903
msgid "The `sodium_hex2bin <https://www.php.net/sodium_hex2bin>`_ function is used here to convert the hexadecimal value back to the binary format."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:909
msgid "Known limitations"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:914
msgid "3.1 When using HTTP authentication, a user who logged out can not log in again in with the same nick."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:916
msgid "This is related to the authentication mechanism (protocol) used by phpMyAdmin. To bypass this problem: just close all the opened browser windows and then go back to phpMyAdmin. You should be able to log in again."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:924
msgid "3.2 When dumping a large table in compressed mode, I get a memory limit error or a time limit error."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:926
msgid "Compressed dumps are built in memory and because of this are limited to php's memory limit. For gzip/bzip2 exports this can be overcome since 2.5.4 using :config:option:`$cfg['CompressOnFly']` (enabled by default). zip exports can not be handled this way, so if you need zip files for larger dump, you have to use another way."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:935
msgid "3.3 With InnoDB tables, I lose foreign key relationships when I rename a table or a column."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:937
msgid "This is an InnoDB bug, see <https://bugs.mysql.com/bug.php?id=21704>."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:942
msgid "3.4 I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:944
msgid "The problem is that older versions of ``mysqldump`` created invalid comments like this:"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:955
msgid "The invalid part of the code is the horizontal line made of dashes that appears once in every dump created with mysqldump. If you want to run your dump you have to turn it into valid MySQL. This means, you have to add a whitespace after the first two dashes of the line or add a # before it: ``-- -------------------------------------------------------`` or ``#---------------------------------------------------------``"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:965
msgid "3.5 When using nested folders, multiple hierarchies are displayed in a wrong manner."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:967
msgid "Please note that you should not use the separating string multiple times without any characters between them, or at the beginning/end of your table name. If you have to, think about using another TableSeparator or disabling that feature."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:972
msgid ":config:option:`$cfg['NavigationTreeTableSeparator']`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:977
msgid "3.6 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:982
msgid "3.7 I have table with many (100+) columns and when I try to browse table I get series of errors like \"Warning: unable to parse url\". How can this be fixed?"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:984
msgid "Your table neither have a :term:`primary key` nor an :term:`unique key`, so we must use a long expression to identify this row. This causes problems to parse\\_url function. The workaround is to create a :term:`primary key` or :term:`unique key`."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:992
msgid "3.8 I cannot use (clickable) HTML-forms in columns where I put a MIME-Transformation onto!"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:994
msgid "Due to a surrounding form-container (for multi-row delete checkboxes), no nested forms can be put inside the table where phpMyAdmin displays the results. You can, however, use any form inside of a table if keep the parent form-container with the target to tbl\\_row\\_delete.php and just put your own input-elements inside. If you use a custom submit input field, the form will submit itself to the displaying page again, where you can validate the $HTTP\\_POST\\_VARS in a transformation. For a tutorial on how to effectively use transformations, see our `Link section <https://www.phpmyadmin.net/docs/>`_ on the official phpMyAdmin-homepage."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1008
msgid "3.9 I get error messages when using \"--sql\\_mode=ANSI\" for the MySQL server."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1010
msgid "When MySQL is running in ANSI-compatibility mode, there are some major differences in how :term:`SQL` is structured (see <https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html>). Most important of all, the quote-character (\") is interpreted as an identifier quote character and not as a string quote character, which makes many internal phpMyAdmin operations into invalid :term:`SQL` statements. There is no workaround to this behaviour. News to this item will be posted in `issue #7383 <https://github.com/phpmyadmin/phpmyadmin/issues/7383>`_."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1022
msgid "3.10 Homonyms and no primary key: When the results of a SELECT display more that one column with the same value (for example ``SELECT lastname from employees where firstname like 'A%'`` and two \"Smith\" values are displayed), if I click Edit I cannot be sure that I am editing the intended row."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1024
msgid "Please make sure that your table has a :term:`primary key`, so that phpMyAdmin can use it for the Edit and Delete links."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1030
msgid "3.11 The number of rows for InnoDB tables is not correct."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1032
msgid "phpMyAdmin uses a quick method to get the row count, and this method only returns an approximate count in the case of InnoDB tables. See :config:option:`$cfg['MaxExactCount']` for a way to modify those results, but this could have a serious impact on performance. However, one can easily replace the approximate row count with exact count by simply clicking on the approximate count. This can also be done for all tables at once by clicking on the rows sum displayed at the bottom."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1040
msgid ":config:option:`$cfg['MaxExactCount']`"
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1045
msgid "3.12 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1050
msgid "3.13 I get an error when entering ``USE`` followed by a db name containing an hyphen."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1052
msgid "The tests I have made with MySQL 5.1.49 shows that the API does not accept this syntax for the USE command."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1058
msgid "3.14 I am not able to browse a table when I don't have the right to SELECT one of the columns."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1060
msgid "This has been a known limitation of phpMyAdmin since the beginning and it's not likely to be solved in the future."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1066
msgid "3.15 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1071
msgid "3.16 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1076
msgid "3.17 (withdrawn)."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1081
msgid "3.18 When I import a CSV file that contains multiple tables, they are lumped together into a single table."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1083
msgid "There is no reliable way to differentiate tables in :term:`CSV` format. For the time being, you will have to break apart :term:`CSV` files containing multiple tables."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1090
msgid "3.19 When I import a file and have phpMyAdmin determine the appropriate data structure it only uses int, decimal, and varchar types."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1092
msgid "Currently, the import type-detection system can only assign these MySQL types to columns. In future, more will likely be added but for the time being you will have to edit the structure to your liking post-import. Also, you should note the fact that phpMyAdmin will use the size of the largest item in any given column as the column size for the appropriate type. If you know you will be adding larger items to that column then you should manually adjust the column sizes accordingly. This is done for the sake of efficiency."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1104
msgid "3.20 After upgrading, some bookmarks are gone or their content cannot be shown."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1106
msgid "At some point, the character set used to store bookmark content has changed. It's better to recreate your bookmark from the newer phpMyAdmin version."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1112
msgid "3.21 I am unable to log in with a username containing unicode characters such as á."
msgstr ""
#: ../phpmyadmin/doc/faq.rst:1114
msgid "This can happen if MySQL server is not configured to use utf-8 as default charset. This is a limitation of how PHP and the MySQL server interact; there is no way for PHP to set the charset before authenticating."