 | 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 both PHP versions 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 PHP5? | |
| We are currently running the latest stable version of PHP5. /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 running 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 ar |
|
|
| 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 = 6M
php_value post_max_siz |
|
|
| 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 lines...
AddHandler application/x-httpd-php .htm .html
Because these extensions will be processed as PHP with the above command, changing the per |
|
|
| How can I run PHP5? | |
| PHP5 is now the default PHP ran on our servers. Nothing further is required.
|
|
|
| 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 |
|
|
| PHP information | |
| To view your current version of PHP you will create a php file, for example info.php, and place the file in your public_html folder.
In the file you will add the following code...
Then view the new file in your internet br |
|
|
| Running a PHP file with a cron job | |
| To run a PHP file from cron, use the following line and modify it for your account and filename and location:
php -q -f /home/username/public_html/location/script.php
|
|
|
| Warning: system() has been disabled for security reasons | |
| To resolve this download the following file http://support.ultrawebsitehosting.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=6&nav=0 and remove the exec reference on the disable_functions line. Save the file, and upload it to any folder the sc |
|
|
| When trying to connect to MySQL you receive error “2003 – Cannot connect to MySQL on ‘x.x.x.x’ on port 3306 (10060) | |
| Please ensure you have added the remote IP to the allow list in your hosting control panel MySQL area. Contact us with a support ticket with the remote IP and we can allow it at the firewall for MySQL usage as well.
If you are behind a router, make sur |
|
|
| Premature end of script headers | |
| If you receive an Internal Server Error 500 and checking your log files displays "Premature end of script headers" errors this can occur for a couple reasons.
This can represent a permission issue. If using PHP be sure to set your .php files to 755 wi |
|
|
| Error: SoftException in Application.cpp:303 UID of script is small than min_uid | |
| Error: SoftException in Application.cpp:303 UID of script is small than min_uid when going through error logs. GID errors can also occur.
You can receive such an error if the ownership of your files are not setup properly.
To crrect the issue be su |
|
|
| Optimizing WordPress | |
| The following article may be useful for those optimizing WordPress:
http://codex.wordpress.org/WordPress_Optimization
|
|
|
| Useful CSV to MySQL Script | |
| Provided below is a great tool we have run into for converting CSV files into MySQL format:
CSV to MySQL Conversion |
|
|
