Databases Reference
In-Depth Information
to be specified, so we need to create the column without an index. We then come
back to the
Structure
page, and use the
Create an index
dialog to choose the
BLOB
column and set a size for the index.
IIS: No Input File Specified
This is a permission problem.
Internet Information Server
(
IIS
) must be able to read
our scripts. As the server is running under the user
IUSR_machinename
, we have to
do the following:
•
•
•
Right-click on the folder where we installed phpMyAdmin
Choose
Properties
Click on
Add
under the
Security
tab, and select the
IUSR_machinename
user
from the list
Ensure that this user has read permission to the directory
•
A "404: page not found" Error when Modifying a
Row
This happens when the
$cfg['PmaAbsoluteUri']
parameter in
config.inc.php
is
not set properly. Chapter 2 explains how to take care of this parameter.
Other Problems
Here we cover solutions to problems that do not show up on screen as a specific
error message.
Blank Page or Weird Characters
By default, phpMyAdmin uses output buffering and compression techniques to
speed up the transmission of results to the browser. These techniques can interfere
with other components of the web server, causing display troubles. We can set
$cfg['OBGzip']
to
FALSE
in
config.inc.php
. This should solve the problem.
Not Being Able to Create a Database
No privileges
appears next to the
Create database
dialog on the
Home
page if
phpMyAdmin detects that the account used to log in does not have the permissions
to create a database. This situation occurs frequently on hosted servers where the
system administrator prefers to create one database for each customer.
Search WWH ::
Custom Search