Android - Browse an Android Emulator SQLite Database in Eclipse

UPDATE - It appears the Questoid SQLite Browser is no longer available from the maker's website, sorry! Perhaps this link will be of use: http://www.java2s.com/Code/Jar/c/Downloadcomquestoidsqlitebrowser120jar.htm
After a fresh format in Ubuntu I needed to browse an Android emulator's SQLite database inside Eclipse. After a bit of research, I recalled this is how it can be done with DDMS and a cool plugin for Eclipse called Questoid SQLite Browser.

1. Download the Questoid Plugin
2. Place the plugin .jar file in your Eclipse plugins folder (e.g. /usr/lib/eclipse/plugins)
3. Restart Eclipse
4. Start up an Android Emulator w/ Debugging in Eclipse
5. Switch to the DDMS Perspective in Eclipse
6. Go to the 'File Explorer' tab to locate your device's database file
7. Navigate to: e.g. 'data -> data -> com.myproject -> databases -> myproject
8. Open the database file in Questoid (see screen shot)
9. Switch to the 'Questoid SQLite Browser' tab that appears (mine appears next to LogCat by default)
10. Switch to the 'Browse Data' sub tab
11. Select your table from the drop down menu
12. Browse your data here and onward into the digital sunset

Source: http://tylerfrankenstein.com/browse-android-emulator-sqlite-database-eclipse

Read More

Joomla: Session is marked as crashed and should be repaired

"Error displaying the error page: Application Instantiation Error: Incorrect key file for table"
https://www.ostraining.com/blog/joomla/joomla-session-crashed/


The image below shows an error message that sometimes occurs on Joomla sites:

The message is actually fairly clear once you know what to look for.
The message says that one of your database tables has crashed. It says that the solution is repair that table.
Which table do we need to repair? The message above reads: Table './nass_j25testdb/usjbr_session
This contains two pieces of information:

• Our database name is nass_j25testdb
• Our database table is usjbr_session

That's the solution: we need to find the database called nass_j25testdb and repair the table called usjbr_session.

Repairing a database table

Login to your hosting account.
We need to find our "MySQL Databases". In this example, the link is marked below.

One very easy solution here is the "Modify Databases" option.

• Look for the Repair DB option.
• Choose the nass_j25testdb.
• Click the Repair DB button.

You'll now see a series of messages. One of those will probably say that your _session had a problem that has now been fixed:

Your site should now be back online.

An alternative solution

Here's another way to solve this problem.
Many hosting companies will give you direct access to the database via phpMyAdmin. You can see a sample link below:

Find your database on the left of the page:

Check the box next to your _session table.
Choose the Repair table option at the bottom of the page.

You'll get a message saying that your SQL query has been executed successfully. Your site should now be back online.

Read More

XAMPP, Apache - Error: Apache shutdown unexpectedly

when start Apache server in XAMPP Control Panel, get following errors:

16:50:25  [Apache]  Status change detected: running
16:50:26  [Apache]  Status change detected: stopped
16:50:26  [Apache]  Error: Apache shutdown unexpectedly.
16:50:26  [Apache]  This may be due to a blocked port, missing dependencies, 
16:50:26  [Apache]  improper privileges, a crash, or a shutdown by another method.
16:50:26  [Apache]  Press the Logs button to view error logs and check
16:50:26  [Apache]  the Windows Event Viewer for more clues
16:50:26  [Apache]  If you need more help, copy and post this
16:50:26  [Apache]  entire log window on the forums

If you are using the latest Skype, go to Tools -> Options -> Advanced -> connection. Disable the "Use port 80 and 443 for alternatives for incoming connections"
Sign Out and Close all Skype windows. Try restart your Apache again.

Read More

Joomla - External Link in One Page

Menu: DichVu (id=section-dichvu)
Link Type: #section-dichvu

Read More

How to perform a system recovery using the VAIO Care version 7 software.

The VAIO Care version 7 software can be used to restore the computer to the original factory software configuration. Follow the procedure below to run a system recovery:
WARNING: There is a risk of data loss. All data, settings, and programs added to the computer will be deleted. During this procedure you will have a chance to back up your data. Sony does not guarantee your personal data can be backed up and restored properly.
IMPORTANT:

• Before performing a recovery, check for software and driver updates available online through the Drivers & Software link on this page. Also, check for knowledge base solutions available through the FAQs & Solutions link on this page.
• This model does not require Recovery Discs. Recovery data is included on a special partition of the hard drive. That said, it is highly recommended to create a set of Recovery Discs.
• If the operating system will not start and no other troubleshooting can be performed, a system recovery can be performed by starting the computer and pressing the F10 key.
• It is recommended to connect the AC adapter to the computer so power is not interrupted.
• Disconnect all external devices, such as printers, network cables, cameras, external hard drives or flash drives.

1. Make sure the computer is powered on and press the Assist button. NOTE:  If your computer does not have an Assist button on the top of the keyboard, click Start, then click All Programs.
2. In the All Programs menu, click the VAIO Care folder and then click VAIO Care. NOTE:  If prompted for an administrator password or a User Account Control prompt is displayed, type the appropriate password, or click Yes.
3. In the VAIO Care application click Advanced Tools.
4. Click Recovery & Restore.
5. Click Recover Computer.
6. Click Yes to proceed with the Recovery. NOTE: The computer will restart.
7. In the VAIO Care Rescue window, click Start recovery wizard.
8. In the Do you need to rescue your data? window, click Yes, I'd like to rescue my data. NOTE: If you do not have any data on your computer that you need to back up, click the Skip Rescue button and proceed to step 15.
   
9. Connect an external storage device to the computer, such as a USB hard drive or thumb drive.
10. In the Select Rescue type window, click Easy rescue. NOTE: If you would like to manually select files to back up, click Custom Rescue and then follow the on-screen instructions.
    NOTE: The software will automatically detect your data.
    
11. Click to select the drive where you would like to back up your data and then click the Next button. NOTE: This screen displays the amount of disc space required and the amount of free space on the external drive.
    
12. In the Confirm options and start rescue window, click the Start Rescue button. NOTE: A progress window will show the status of the backup.
    
13. In the Rescue has completed successfully window, click the Next button.
14. In the Are you sure you want to start recovery? window, click to select Yes, I'm sure and then click the Start Recovery button. NOTE: A status window is displayed indicating the progress of the different applications. No action is required. This process may take up to 2 hours and the computer may restart several times.
    
15. In the Recovery complete window, click the Restart button. NOTE: The computer will restart.
16. Follow the on-screen instructions to set up the operating system and complete the system recovery.

Read More