Problem: YII Command tool was not working in the newly created YII application, While using the below command in the command prompt not getting any respond, but normally its work with other YII application. Every path has been configured correctly and not getting any errors. /var/www/yii-1.1.16/framework/yiic shell Screenshot: Solution: This caused due to access rules …
Category: Windows
Microsoft Windows operating system.
Permanent link to this article: https://blog.openshell.in/2015/03/yii-command-tool-not-working/
Nov 12
MySQL Error, “java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp” on ColdFusion 11
Issue: Queries to MySQL may return the error, “java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp” or similar. This error appears when using the Adobe ColdFusion MySQL 5 JDBC driver. Reason: This error occurs when the MySQL Date or DateTime columns have a value of all zeros (for example, ‘0000-00-00 00:00:00’). The default …
Permanent link to this article: https://blog.openshell.in/2014/11/mysql-error-java-sql-sqlexception-value-0000-00-00-000000-can-not-be-represented-as-java-sql-timestamp-on-coldfusion-11/
Permanent link to this article: https://blog.openshell.in/2014/10/attachment-failed-on-gmail-using-firefox-32/
Sep 28
How to read large XML files efficiently using PHP?
Recently I was faced problem of parsing large XML file using PHP. While parsing small files are no problem and all its quickly parsed, an attempt to parse larger files often causes time-out or Internal Sever Error. We will not able to use DOM or SimpleXML extension to parse the large XML documents in PHP. …
Permanent link to this article: https://blog.openshell.in/2014/09/how-to-read-large-xml-files-efficiently-using-php/
Sep 27
How to remove Ubuntu option on the Windows Boot Manager menu?
Recently I have installed ubuntu using Wubi (Ubuntu installer) side by side with windows 7, After that I have uninstalled ubuntu successfully. However when I boot my machine, the Windows Boot Manager will displayed both Windows and Ubuntu. I have followed the below steps to remove Ubuntu from the Windows Boot Manager option: Step 1: …
Permanent link to this article: https://blog.openshell.in/2014/09/how-to-remove-ubuntu-option-on-the-windows-boot-manager-menu/
Sep 10
MySQL zerofill and lpad – Shape digits in DB
I’m working with an application to have the item code. Item code column is set as an INT(5) but not all the item code values are 5 digits. So I need to round off the item code based on 5-digits. If the item code is 199, it should be display as 00199. How to make …
Permanent link to this article: https://blog.openshell.in/2014/09/mysql-zerofill-and-lpad-shape-digits-in-db/
Aug 21
Create URL Slug from Post Title using PHP
The following functions will helps to create search engine optimization url for the website. This will strip all the special characters and punctuation away from the URL and place hyphen in between each words. For acheving the required results, used regular expression function that replaces spaces between words with hyphens and its remove the special …
Permanent link to this article: https://blog.openshell.in/2014/08/create-url-slug-from-post-title-using-php/
Aug 19
Best way to order the best matching records in MySQL
If we are searching a word (string) in the mysql table, usually we will use the below method: [sql] SELECT * FROM user WHERE name LIKE ‘%searchstring%’ ORDER BY name ASC; [/sql] If you search like this, It will order the result set based on the ASC of name. It will not order the result …
Permanent link to this article: https://blog.openshell.in/2014/08/best-way-to-order-the-best-matching-records-in-mysql/
Aug 15
How to save an image of the highcharts on the server?
Highcharts have a built-in option to export the current chart, it have the option to save the chart as PNG, JPEG, PDF or SVG. It doesn’t have option to save the image on the server, instead of downloading in browser (clinet). To save an image of the highcharts on the server, follow the steps: Step …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-save-an-image-of-the-highcharts-on-the-server/
Aug 09
How to create the JAR file
The JAR file format is a compressed format used primarily to distribute Java applications and libraries. It is built on the ZIP file format, and functions in a similar way; many files are compressed and packaged together in a single file, making it easy to distribute the files over a network. If you need to …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-create-the-jar-file/