Author's posts
Sep 06
How to reset a Magento password using Mysql Server
If you are unable to log in to your magento application? Follow the below steps to reset your magento store password from Mysql server. Step1: Select your database from the Mysqlserver. Step2: Find admin_user table from the selected database. Step3: In that table, edit the user which you want to reset their admin password. Step4: For security …
Permanent link to this article: https://blog.openshell.in/2013/09/how-to-reset-a-magento-password-using-mysql-server/
Sep 03
How to Reset a WordPress Password from Mysql Server
Its essential thing to knowing, how to reset the wordpress password from Mysql server without following traditional method. Because your site may hacked, you may forgot your admin password and its email id to reset the password, you are no longer able to login into wordpress using login credentials. This method will very useful to …
Permanent link to this article: https://blog.openshell.in/2013/09/how-to-reset-a-wordpress-password-from-mysql-server/
Aug 28
Find number of working days between two dates in Mysql
This which helps to find number of working days between two dates in Mysql. There is no specific or inbuilt function in mysql, For that we need to use the SQL query as below. [sql] SELECT 5 * ((DATEDIFF(@end_date, @start_date) ) DIV 7) + MID(‘0123455501234445012333450122234501101234000123450’, 7 * WEEKDAY(@start_date) + WEEKDAY(@end_date) + 1, 1) [/sql] For …
Permanent link to this article: https://blog.openshell.in/2013/08/find-number-of-working-days-between-two-dates-in-mysql/
Aug 25
Java Essential Tips: Automatic Resource Management
Java7 introduced many features that simplifies coding which are overhead in older Java versions. In this blog we will see the feature called Automatic Resource Management. This is really a good feature in Java7 which close the resources like IO streams automatically. Everything you need to do is implement java.lang.AutoCloseable. try-with-resources Statement try-with-resources statement simply …
Permanent link to this article: https://blog.openshell.in/2013/08/java-essential-tips-automatic-resource-management/
Aug 04
MySQL Error – SQL_BIG_SELECTS
While executing JOIN SQL query in live server, i got the following error. [code] The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay: [/code] To resolve this error, I have used the following SQL query before executing the JOIN SQL query. …
Permanent link to this article: https://blog.openshell.in/2013/08/mysql-error-sql_big_selects/
Jul 18
Turn off resize textarea
It is very easy to turn off the users ability to resize the textarea. To turn off this feature, use the following css code. This is used to remove the users ability to resize the textarea. [css] textarea{resize: none} [/css] The two properties that can be used are max-width and max-height. This will give the …
Permanent link to this article: https://blog.openshell.in/2013/07/turn-off-resize-textarea/
Jun 25
How to Compare Two Versions of the Same Word Document in Office 2010
1) Open the word document in Office 2010, Click the Review tab and choose Compare -> Compare. The Compare Documents dialog box shows up. 2) Select the original document from the Original Document drop-down list. If you can’t find the original document, click the wee folder icon to browse for it. 3) Select the edited …
Permanent link to this article: https://blog.openshell.in/2013/06/how-to-compare-two-versions-of-the-same-word-document-in-office-2010/
May 04
How to remove dead node out of the Cassandra cluster?
This tutorial will helps you to remove unused / dead node from the cassandra cluster ring. Run the following command in console to list the cluster node ring formation. [code] nodetool -h <cluster-ip1> ring [/code] Results of the command it list details as like below: [code] Note: Ownership information does not include topology, please specify …
Permanent link to this article: https://blog.openshell.in/2013/05/how-to-remove-dead-node-out-of-the-cassandra-cluster/
May 02
Mysql GROUP_CONCAT
MySQL has useful extention to the GROUP BY operation – function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Returns NULL when there are no non-NULL values. Where it can be useful? For example to get array without looping inside the code, In single SQL query …
Permanent link to this article: https://blog.openshell.in/2013/05/mysql-group_concat/
Apr 10
Connect MS SQL Server with Rails
To connect MS SQL Server with Ruby on Rails follow the below steps: SQL Server (2005 or higher recommended) Install the adapters and driver [code] gem install tiny_tds gem install activerecord-sqlserver-adapter [/code] Ensure the activerecord adapter and db driver gems are defined in your Gemfile [code] gem ‘tiny_tds’ gem ‘activerecord-sqlserver-adapter’ [/code]
Permanent link to this article: https://blog.openshell.in/2013/04/connect-ms-sql-server-with-rails/