Problem: Receive either “1630: FUNCTION MAX does not exist. Check the ‘Function Name Parsing and Resolution’ section in the Reference Manual” or “1305: FUNCTION MAX does not exist”.
Solution: Remove all spaces between the function and the parenthesis or set sql_mode=’IGNORE_SPACE’;
This is causing the error:
SELECT MAX (id) as something FROM Example
This will work correctly:
SELECT MAX(id) as something FROM Example
Whenever you have accidentally chose a wrong collation or changed your mind afterward you may use the following script to change the collation (the character set that data are stored) automatically.
This is especially useful when for example you want to support greek characters in a forum and after you have created the database you didn’t change the collation to utf_general_ci and you proceeded by installing the forum platform. The only solution would be to remove the database, recreate it, change the collation and then reinstall the forum software. With this script you can fix the issue directly.
Problem: I was trying to make a mysql query after a function, that was taking a lot of time to load, and my query was not being executed. In addition I was receiving the error: “MySQL server has gone away”. This was caused because the mysql server was timed out and closed the connection.
Found at: http://laurajul.dk/2011/03/01/this-is-direct-marketing/
Original Source: http://9gag.com/gag/84524
Goal #1: vbulletin 4 bbcode [code] have syntax highlight like [php]
Goal #2: Code wrapped in the [code] and [php] bbcodes to have Consolas as font like StackOverflow
The default [code] bbcode of vbulletin doesn't highlight the code which is wrapped inside of it. It actually is using a "pre" html tag to keep the format. The solution for this is mainly a 2 steps process:
Goal: Any file or directory uploaded / created under a specific folder to have read, write, execute (777) permissions.
Environment: CentOS 5.5, Kernel: 2.6.18-194.17.1.el5
I was looking for a solution to have read, write, execute permissions for all since I wanted to delete files and folders from a php script and the files were created by an external application, not able to set permissions. My php script is using the unlink() function to delete the file and then the rmdir() to delete the folder.
It has been a long time that I was thinking to start blogging, focusing on web development and other related areas.
My main goal is to write about problems and solutions that I face in my every day programming tasks in order to help others and keep track of them so it will be easily also for me to refer to them at future.
Another goal is to start communicating with other people web development issues so we can exchange knowledge, help each other and at the end improve ourselves. For this reason I also plan to publish code that I develop and that it could be useful.
There will be no specific plan for blogging like one post per week or something similar, but I will post as soon as I think something is useful.