Category Archives: MySQL

By September 27, 2008

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


Read More
By August 17, 2008

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


Read More
By August 10, 2008

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


Read More
By June 08, 2008

Reference http://ushost.name/training/repairing_a_mysql_database.htm http://dev.mysql.com/doc/refman/5.0/en/repair-table.html http://dev.mysql.com/doc/refman/5.0/en/repair.html http://www.informit.com/articles/article.aspx?p=29406&seqNum=3 IBM Helpdesk


Read More
By May 24, 2008

The number following the message indicates a database problem. The error number is generated by joomla! and error numbers 1, 2 and 3 indicate the following: Error 1 = FATAL ERROR: MySQL support not available. Error 2 = FATAL ERROR: Connection to database server failed. Error 3 = FATAL ERROR: Database not found my view


Read More
1 2 3 4 5