netbeans Failed to connect to device 6! Reason: Emulator 6 failed to register in time

Failed to connect to device 6!
Reason:
Emulator 6 failed to register in time!
 
So you encounter this error when you are run netbeans right?
This is normally a data execution prevention issue. DO the ff.

Goto
control panel>>system>>advance system settings>>advanced tab>>settings under performance field set>>data execution prevention tab>>Turn on DEP for all programs and services except those I select

add "runMidlet.exe" as an exception by navigating to its directory in your netbeans installation folder
in my case it was located here

NetBeans/mobility/Java_ME_platform_SDK_3.0/runtimes/cldc-hi-javafx/bin

Restart your PC and you are good to go.
Sometimes you may have to go on to disable your firewall and antivirus if it is still not working.

If still not working, you are not out of luck...
In your netbeans, go to tools>java platforms>>CLDC Oracle Java(TM) Plaform Micro Edition SDK 3.0.5>>Click refresh
Do it again if it fails.
Then you should be good to go.
Hope this helps someone. :)

MSSQL Server: Database (In Recovery)

This can happen when the SQL Server Service has gone down hard in the middle of write operations and sometimes during mode during server startup

It means the database is still recovering and if the database is huge, it will cost a long time to finish the recovery. When this happens, it is advisable to remain calm and wait till the recovery is done.

Below is a script to help monitor and determine how long the database will be in recovery..

DECLARE @DBName VARCHAR(64) = 'GED_DRILLHOLES'

DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))

INSERT INTO @ErrorLog

EXEC sys.xp_readerrorlog 0, 1, 'Recovery of database', @DBName

SELECT TOP 5

       [LogDate]

      ,SUBSTRING([TEXT], CHARINDEX(') is ', [TEXT]) + 4,CHARINDEX(' complete (', [TEXT]) - CHARINDEX(') is ', [TEXT]) - 4) AS PercentComplete

      ,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0 AS MinutesRemaining

      ,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0/60.0 AS HoursRemaining

      ,[TEXT]

FROM @ErrorLog ORDER BY [LogDate] DESC

Please note that towards the final completion(SAY 95%) of the recorvery, the file might not be updated anymore and this will indicate the end. Just REFRESH the DB and you are good to go

 

php twitter: undefined index: oauth_token_secret

The problem is that there is an error in the request so you don't get oauth_token_secret in the respond from Twitter. Instead you get an error message.

Turn of php notice by typing the following at the top of the page
error_reporting(E_ALL ^ E_NOTICE);

print_r() the $request_token or $request variable to the screen. It will show you the type of error returned by twitter
print_r($request_token );

An example of the error message when you print the array is "Desktop applications only support the oauth_callback value 'oob' /oauth/request_token?oauth_callback=...."

Go to your app settings on twitter and make the correct settings.
In the case of the above error, set the callback url to the one you send in the request and try again!!

Good Luck.

svnserve: Can't bind server socket: Address already in use

I was done setting up svn and i ran "svnserve -d -r path"  and got the following:


svnserve: Can't bind server socket: Address already in use.

In my case I had previously set up svn which was already listening on the default port 3690.
I solved this simply by looking for that svn process and killing it.
Grep it on commandline with;
ps -ef  | grep svnserve

This will show the running svn process. Just get the processID/number and kill it and you should be set..

e.g sudo kill processID.

pg_query(): Query failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe28022

Has anyone been face with this problem while trying some inserts into a postgres  DB with some character.

PHP Warning: pg_query(): Query failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe28022
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

Now this is not actually a posgres error but a php issue with html entity encode and decode functionalities. The same effect will happen on a MySQL db since MySQL and PostGre are fairly similar. This can be resolved by setting the character encoding in the php file to that of the database base. Eg for UTF-8 DB set the following in metadata the php file.

 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />



 

android application **** has stopped unexpectedly try again. Android development

So I was working on my one of my first android apps and there were no errors but when I ran it I had the emulator telling me this: "Application ***** has stopped unexpectedly try again" then I had to force close it. I realized this happens a when some value is not set in the manifest file. In this my case it was the fact that the app would connect to Internet eventually and I had not set the Internet permissions correctly in the manifest file


So i added this line to on top of the application node in the android manifest xml file: <uses-permission android:name="android.permission.INTERNET" />

 A simple manifest file will look like this (the fix is i red):

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
      package="com.example"
      android:versionCode="1"
      android:versionName="1.0">
    <uses-sdk android:minSdkVersion="8" />
    <uses-permission android:name="android.permission.INTERNET" />
    <application android:icon="@drawable/icon" android:label="@string/app_name">
        <activity android:name=".Login"
                  android:label="@string/app_name">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>

    </application>
</manifest>

Postgres - How to check if an array is empty or not

To check how many rows have an empty array of values for a certain column,

Such as to "select from table where dataset is not null";
by dataset it could be array of values. for instance another select query could be a dataset
e.g. (array(select from table2))

See an illustration below. Hope it helps.

so lets say you have two tables for customers and their favorite  foods

customer
ID  | name
---------
1     stanley
2     sheldon
3     sarah

favorite_food
ID  | customer_id(FK to customer ID)|food_name
------------------------------------------------------------------------
1    3                                                     rice
2    3                                                     wheat
3    1                                                     mango
4    2                                                     orange


--the following query will help to make get all instances of customers with food
--this is based on the fact that array_upper and array_lower functions, on empty arrays return null 

select * from customer where array_upper(array(select food_name::text
                                               from favorite_food
                                              where customer_id = customer.id),1) is not null;


--there are other alternative to this solution like the example below.
--In the alternative below "{}" is s string literal that is returned when there are no values in the csv table

select * from customer where not (array(select food_name::text
                                               from favorite_food
                                              where customer_id = customer.id),1) = '{}';


--third alternative is to use regular expressions and this can be done in several ways besides what is shown below;
Feel free to add your options are comment or ask a question ;)

select * from customer where not array_to_string(array(select food_name::text
                                                   from favorite_food
                                                   where customer_id = customer.id),1)  ~ '^$';









--of course you can try to remove the "not" to get the opposite result you know what we do.hope this saves someone some time.