 | How do I add a user to a MySQL database? |  |
 | In the MySQL Database section, after creating a database and a user, there will be a field listed...
User: xxxx Db:xxxx Add User to DB. Select the correct options and click the Add User to DB button. |
|
|
| How do I backup a MySQL Database? |  |
| In the control panel, within Backup section, under Download a SQL Database Backup will be your MySQL databases that you can download.
In a few cases a database will not restore properly after you download it. This is an issue with phpMyAdmin so you ma |
|
|
| How can I view/modify data in my MySQL database | |
| Only make changes if you know exactly what you are doing. Often incorrect changes can have an impact on the application viewing the database and leaving the app non-functional.
Within control panel select MySQL Database, on the bottom of that screen i |
|
|
| What version of PHP do you use? | |
| We use PHP version 4.4.x and 5.x. |
|
|
| Warning: Unknown(): open_basedir restriction in effect. | |
| Basedir restriction is set for security. This most often occurs when you are calling an app through http://webxx.fluxservices.com/~xxxxxx
When you call it from your domain name it will not occur. |
|
|
| What is the path to PHP? | |
| We are currently running the latest stable version of PHP4. /usr/bin/php |
|
|
| Error 500 - Internal Server Error - PHP | |
| This can be due to several factors. The first thing to check is that the permissions on the file and all relative files to it are set to 755 which you can set in your FTP client or in SSH via chmod.
When multiple files are selected for a permission cha |
|
|
| I am having problems with a script I wrote. | |
| PHP suexec is ran on all of our shared servers. If you are running code that is insecure or uses simple php authentication it may not work as a result of PHP suexec. PHP suexec provides additional security and is becoming a standard. Provided below are ba |
|
|
| What is the proper mysql format? | |
| For proper MySQL format and basic commands check out...
http://www.mysqldeveloper.com/tutorials/index.pcgi?id=4
|
|
|
| Could not connect to the database | |
| You will want to verify you are using the correct database name, username and password.
All databases and username will have your username appended to the beginning to prevent your information from being overwritten by other users using the same names. |
|
|
| What is the Path to ImageMagick? | |
| The path to ImageMagick is /usr/bin/ |
|
|
| 403 Forbidden error with Drupal after install. | |
| Remove the following lines from the .htaccess file...
Options -Indexes
Options FollowSymLinks
This should correct the problem in most cases. If not, view standard forbidden error articles. |
|
|
| Learn MySQL | |
| If you do not know how to use MySQL there are some great guides at the following websites.
http://www.mysql.com/
http://www.w3schools.com/sql/
|
|
|
| How do I import into a mysql database? | |
| Log into your control panel and go into the MySQL section. Make sure you have an existing database that you would like to import your data into. If it is there click "phpMyAdmin". This will open a new window for phpmyadmin. Select the correct database fro |
|
|
| Changing Maximum Upload Size | |
| The default php upload size is 2mb. To change this create a php.ini file in the directory that is used by the application and uploading and include the following values...
LimitRequestBody 0
php_value upload_max_filesize 2M
php_value post_max_size 2M |
|
|
| How can I parse .html as .php? | |
| Create an .htaccess file and upload it to the root of your public_html directory. Include the following line...
AddHandler application/x-httpd-php .php .html .htm
Because these extensions will be processed as PHP with the above command, changing the |
|
|
| Moodle: Notice: Only variable references should be returned by reference | |
| Notice: Only variable references should be returned by reference
The issue is with Moodle using an old adodb set that uses "references" which resulted in memory curruption which was addressed in PHP 4.4.0.
To correct perform the following:
Open |
|
|
| Tiki Wiki: Notice: Only variable references should be returned by reference | |
| You can find the latest version of ADODB here.
To modify the function to not return a reference use the following code in your adodb.inc.php file:
/**
* Fetch a row, re |
|
|
| How can I run PHP5? | |
| You have three options. You can rename .php extensions to .php5, you can create an .htaccess file in the directory you need PHP5 to run with the following line:
AddHandler application/x-httpd-php5 .php .php3 .phtml .php5
or the third option is to tu |
|
|
| osCommerce - This is a potential security risk - please set the right user permissions on this file. | |
| This error is caused when the /includes/configure.php is world writable. To correct this, log into your hosting control panel, select file manager, locate the file and change the permissions (chmod) for the file to 444.
|
|
|
| Register Globals On | |
| If you run a script that requires php "register globals on" create a php.ini file and include the following:
register_globals = 1
Save the file and upload it to the directory of the script that requires register globals on. If the scrip |
|
|
| phpBB: Switching template to default theme | |
| To change your phpBB theme back to the default which may be necessary when upgrading, log into your hosting control panel, mysql section and click the phpmyadmin link on the bottom. Select the proper phpbb database. Click the browse link next to phpbb_con |
|
|
