MySQL

Plesk: saved admin password error

Posted by on November 10, 2008 at 4:22 pm

Service is not available now, probably your Plesk is misconfigured. Contact Your provider for details. Internal Plesk error occurred: Unable to connect to database: saved admin password is incorrect. ———— Fix ———– you will need to edit the mysql config file add skip-grant-tables under mysqld /etc/my.cnf then restart mysql connect to the mysql db issue [...]

Mysql: handling null values during a insert

Posted by on October 6, 2008 at 11:17 am

Example of inserting null values/string is as follows null columns for testing purpose test1 and test2 INSERT INTO reguser_active (test1, test2) values (”,”); ” tells mysql to insert a empty string into the column , you may also insert a null value into the not null column as such INSERT INTO reguser_active (test1, test2) values [...]

SugarCRM: mysql error

Posted by on September 27, 2008 at 6:47 pm

Query Failed: AND users.id = ’1′::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND users.id = ’1” at line 1 – PHP Safe mode must be off .., duh

Mysql – error lookup

Posted by on August 17, 2008 at 2:39 pm

if you check the mysql logs and see a error code such as error 24 you can lookup the code by using the perror command perror 24

Horde: DB connection error

Posted by on August 10, 2008 at 1:24 pm

A fatal error has occurred DB Error: connect failed Details have been logged for the administrator create a symlink to the mysql.sock from the /tmp/ folder example cd /tmp ln -s /usr/local/lib/mysql.sock mysql.sock