June 18, 2009

Windows XP 64-bit Edition is not compatible with Google Calendar Sync at this time

Calendar sync works in XP 64 using compatibility mode :-)

Well it does work for me – two way sync with Outlook 2007!

Simply save the installer to your machine, right click on the installer executable and select properties in the second tab Compatibility check the checkbox “Run this program in compatibility mode for: Windows XP.

Run the installer

Then before running the program, navigate to the installed executable with windows explorer. It will probably be in: C:\Program Files x86\Google\Google Calendar Sync\ right click on GoogleCalendarSync.exe and do the same as for the installer. Compatibility with Windows XP

run the sync…

via Windows XP 64-bit Edition is not compatible with Google Calendar Sync at this time – Calendar Help.

MySQL Table Is Marked As Crashed and Should Be Repaired

I was greeted by the following error this evening from within my SugarCRM instance:

MySQL error 1194: Table 'contacts' is marked as crashed and should be repaired

So this is what I did to fix it:

[root@crm ~]# mysql -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.

mysql> use sugarcrm
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> CHECK TABLE contacts;
+-------------------+-------+----------+-----------------------------+
| Table             | Op    | Msg_type | Msg_text                    |
+-------------------+-------+----------+-----------------------------+
| sugarcrm.contacts | check | error    | Found wrong record at 73544 |
| sugarcrm.contacts | check | error    | Corrupt                     |
+-------------------+-------+----------+-----------------------------+
2 rows in set (0.18 sec)

mysql> REPAIR TABLE contacts;
+-------------------+--------+----------+-----------------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                            |
+-------------------+--------+----------+-----------------------------------------------------+
| sugarcrm.contacts | repair | info     | Key 1 - Found wrong stored record at 73544          |
| sugarcrm.contacts | repair | info     | Found block with too small length at 78096; Skipped |
| sugarcrm.contacts | repair | warning  | Number of rows changed from 892 to 877              |
| sugarcrm.contacts | repair | status   | OK                                                  |
+-------------------+--------+----------+-----------------------------------------------------+
4 rows in set (0.26 sec)

Sorting Multiple Columns With MySQL

Ever wanted to sort your MySQL results by several columns?

SELECT * FROM orderspecs ORDER BY height, depth, width;

Now what if you want the columns to have different sort orders in the sub-sorted columns? No problem. Just specify the order for each column.

SELECT * FROM orderspecs ORDER BY height DESC, depth ASC, width DESC;

June 12, 2009

Google Gravity

Gotta love it…  A Chrome experiment called “Google Gravity”  I totally love it.  Works in Safari 4 and somewhat in FireFox as well.

Smooth Rounded Corners in Photoshop

I have often struggled with getting nice, smoothly-rounded corners in Photoshop.  I have tried the smooth command from the select Menu, only to have my shoulders sag every time I see the jagged selection.  I never thought of using the shape tool to make a path, then convert that path into a selection or a mask…  DUH.  Gotta love Google, eh?

Older Posts »