Following code snippet converts a date time in GMT to Local timezone.
|
1 2 3 |
$myDateTime = new DateTime('2014-08-27 18:21', new DateTimeZone('GMT')); $myDateTime->setTimezone(new DateTimeZone('America/New_York')); echo $myDateTime->format('Y-m-d H:i'); |
If you are getting this error
mysql table is marked as crashed and last (automatic?) repair failed
Go to your data folder and try running
|
1 |
myisamchk -r <table_name>. |
You should stop MySQL process first. If that doesn’t work, you can try with
|
1 |
myisamchk -r -v -f <table_name>. |
I had to navigate to /var/lib/mysql/<database> and run myisamchk -r -v -f ./<table name>.
PS – This was answered at following thread, this post is for just personal reference in future.
Reference – http://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed
If you are running a migration to change the data type of a column in a table. You might come across this error message in terminal.
|
1 2 3 |
[RuntimeException] Changing columns for table "***" requires Doctrine DBAL; install "doctrine/ dbal". |
This error message is telling you to install doctrine/dbal to make this work. You can learn more about this package here https://github.com/doctrine/dbal
To install this package through composer, run following command in terminal.
|
1 |
composer require doctrine/dbal |
Now you can run your migration by running
|
1 |
php artisan migrate |
This should work now.
If you are getting this error while running npm install, then you are not having write permission on .npm directory.
To get the ownership of this directory run following command
|
1 |
sudo chown -R $(whoami) ~/.npm |
Also we need to give write permission to node_modules directory
|
1 |
sudo chown -R $USER /usr/local/lib/node_modules |
ref – http://stackoverflow.com/questions/16151018/npm-throws-error-without-sudo
I was getting this error in my error log, after searching for solutions online I stumbled upon this solution that worked for me. I am writing this post for my personal reference, it would be great if someone gets benefited by this.
To install Mcrypt PHP extension on Ubuntu / Debian run following command ( this step is same for Nginx and apache )
|
1 |
<span class="pln">sudo apt</span><span class="pun">-</span><span class="kwd">get</span><span class="pln"> install php5</span><span class="pun">-</span><span class="pln">mcrypt</span> |
This will create a mcrypt module in /etc/php5/mods-available directory. If it doesnt we need to create symlink for this.
|
1 |
<span class="pln">sudo ln </span><span class="pun">-</span><span class="pln">s </span><span class="pun">/</span><span class="pln">etc</span><span class="pun">/</span><span class="pln">php5</span><span class="pun">/</span><span class="pln">conf</span><span class="pun">.</span><span class="pln">d</span><span class="pun">/</span><span class="pln">mcrypt</span><span class="pun">.</span><span class="pln">ini </span><span class="pun">/</span><span class="pln">etc</span><span class="pun">/</span><span class="pln">php5</span><span class="pun">/</span><span class="pln">mods</span><span class="pun">-</span><span class="pln">available</span><span class="pun">/</span><span class="pln">mcrypt</span><span class="pun">.</span><span class="pln">ini</span> |
Now enable mcrypt by running
|
1 |
<span class="pln">sudo php5enmod mcrypt</span> |
After this restart php5-fpm service by
|
1 |
<span class="pln">sudo service php5</span><span class="pun">-</span><span class="pln">fpm restart</span> |
There two ways you can upgrade or downgrade your VM instances.
a. Stop – configure – start
b. Minimum downtime ( by swapping the disk )
a. This is a very easy method to do this. The main disadvantage of this is, it requires downtime. If you are okay with a 5 – 10 minute of downtime then you can go with this method.
b. If you this to happen almost real time then follow these steps
If you have a Google cloud compute engine VM Instance and wants to upgrade or downgrade Continue reading
To connect your PHP 5.4 application to SQL Server 2012 database. I assume you have PHP 5.4 installed through Wamp Server ( 32 bit ) Continue reading
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDBwith the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables,fields or rows; executing SQL statements; or managing users and permissions. source: wikipedia
To access remote mysql database from your local phpmyadmin, open config.inc.php file by
|
1 |
sudo nano /etc/phpmyadmin/config.inc.php |
Add following line
|
1 2 3 4 5 |
$i++; $cfg['Servers'][$i]['host'] = 'ip-address-of-db-server'; //provide hostname and port if other than default $cfg['Servers'][$i]['user'] = 'my_db_user'; //user name for your remote server $cfg['Servers'][$i]['password'] = 'password'; //password $cfg['Servers'][$i]['auth_type'] = 'config'; // keep it as config |
You can refer this article to install phpmyadmin on Ubuntu: http://devendraverma.com/install-phpmyadmin-on-ubuntu/
To add Splash Screen to you android application
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
package co.laterbox.laterbox; /** * Created by deven on 26/8/15. */ import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.os.Handler; public class SplashScreen extends Activity { // Splash screen timer private static int SPLASH_TIME_OUT = 3000; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_splash); new Handler().postDelayed(new Runnable() { /* * Showing splash screen with a timer. This will be useful when you * want to show case your app logo / company */ @Override public void run() { // This method will be executed once the timer is over // Start your app main activity Intent i = new Intent(SplashScreen.this, MainActivity.class); startActivity(i); // close this activity finish(); } }, SPLASH_TIME_OUT); } } |
AndroidManifest.xml
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 |
<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="co.laterbox.laterbox" > <uses-sdk android:minSdkVersion="8" android:targetSdkVersion="17"/> <!-- GCM Permissions - Start here --> <uses-permission android:name="android.permission.INTERNET" /> <uses-permission android:name="android.permission.GET_ACCOUNTS" /> <uses-permission android:name="android.permission.WAKE_LOCK" /> <permission android:name="co.laterbox.pushnotification.permission.C2D_MESSAGE" android:protectionLevel="signature" /> <uses-permission android:name="co.laterbox.pushnotification.permission.C2D_MESSAGE" /> <uses-permission android:name="com.google.android.c2dm.permission.RECEIVE" /> <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" /> <uses-permission android:name="android.permission.VIBRATE" /> <!-- GCM Permissions - End here --> <application android:allowBackup="true" android:icon="@mipmap/ic_launcher" android:label="@string/app_name" android:theme="@style/AppTheme" > <meta-data android:name="com.google.android.gms.version" android:value="@integer/google_play_services_version" /> <!-- Splash screen --> <activity android:name=".SplashScreen" android:label="@string/app_name" android:screenOrientation="portrait" android:theme="@android:style/Theme.Black.NoTitleBar" > <intent-filter> <action android:name="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> <activity android:name=".MainActivity" android:label="@string/app_name" > <intent-filter> <action android:name="co.laterbox.laterbox.MAINACTIVITY" /> <category android:name="android.intent.category.DEFAULT" /> </intent-filter> </activity> <!--<activity--> <!--android:name=".MainActivity"--> <!--android:label="@string/app_name" >--> <!--<intent-filter>--> <!--<action android:name="android.intent.action.MAIN" />--> <!--<category android:name="android.intent.category.LAUNCHER" />--> <!--</intent-filter>--> <!--</activity>--> <receiver android:name=".GcmBroadcastReceiver" android:permission="com.google.android.c2dm.permission.SEND" > <intent-filter> <action android:name="com.google.android.c2dm.intent.RECEIVE" /> <action android:name="com.google.android.c2dm.intent.REGISTRATION" /> <category android:name="co.laterbox.pushnotification" /> </intent-filter> </receiver> <!-- Register Service --> <service android:name=".GCMNotificationIntentService" /> </application> </manifest> |
activity_splash.xml
|
1 2 3 4 5 6 7 8 |
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:background="@drawable/splash_image" android:orientation="vertical" android:weightSum="1"> </RelativeLayout> |
Output
