OpenOffice Base MySQL ALTER table structure

I may have missed it, but it's likely that you will have trouble refreshing table structure in OpenOffice Base if you connect to MySQL and ALTER a table.

Basically, the answer is to add the fields in the Edit of the table(s) in Base to match the new columns. If you don't know what they are, create a new table connecting to the ODBC of MySQL and edit the appropriate table.

It's a real pain, but there you are.

YUI3 accordion

I had the hardest time trying to override the label color in YUI3-accordion.
It turns out that !important was used in the default style, so I had to !important again to overwrite it. (I didn't want/need black on a dark background).

Increase the number of entries in Media Library of Wordpress

Have lots of images? Don't want to paginate? Using Faster Image Inserter?

Change from 10 to whatever:

back up wp-admin/includes/media.php

find this:

$start = ( $_GET['paged'] - 1 ) * 10;
if ( $start < 1 )
$start = 0;
add_filter( 'post_limits', create_function( '$a', "return 'LIMIT $start, 10';" ) )

and this:

$page_links = paginate_links( array(
'base' => add_query_arg( 'paged', '%#%' ),
'format' => '',
'prev_text' => __('«'),
'next_text' => __('»'),
'total' => ceil($wp_query->found_posts / 10),
'current' => $_GET['paged']
));


and change 10 to 50 or 100 or ...

MySQL fix some phone numbers

This is long and convoluted, but basically, it takes unknown inputs of phone numbers from a table:

5551212

555-1212

212555-1212

212-555-1212

and makes them all

2125551212

select Concat(if(length(PhoneNumber)< 10, "212", ""), replace(PhoneNumber, "-","")) FROM AddressBook;

update addressbook set PhoneNumber=Concat(if(length(PhoneNumber)< 10, "212", ""), replace(PhoneNumber, "-",""));

Evernote works well with WINE

Installed Evernote on WINE, and it seems so far to be pretty stable and works well enough to grab my information.

Serial Port access from OpenOffice.org

This is my post in the forum.

http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=682#p168678

Set up Harmony Remote for Motorola VIP-1216

We just installed Prism from CenturyLink. I just wanted to post something how easy it was (should have been) to convert my Harmony H659 remote to control the Motorola VIP-1216.

If you remember nothing else, "No, I don't have the original remote". Don't try learning it. Don't try guessing from the remote brand. I did this and was extremely frustrated.

You really just have to load your Harmony software, connect your remote, add the device (Video Recorder -> PVR), choose Motorola as a brand, and VIP-1216 as the model. Next, "No, I don't have the remote"! Next/Done, but then go to the Activities tab (watch TV?) and add the Motorola VIP-1216 to the TV.

Now, what functions will you not have immediately that you may want to add to the display?

Certainly, you won't have all the direct input power/mode buttons at the top. But if you have a Harmony remote, you understand why those aren't necessary. If you have an errant device in the wrong on/off state, you'll use Help to get it back in sync, though if it you're having constant issues, you may want to verify the remote is controlling that device properly in the Harmony software.

Other buttons: "On Demand", "Recorded TV", "Learn" (Not needed), "Back" (Probably unnecessary as there are other buttons that can do it), "Go Interactive" (May never use), TV/Exit to "TV (again, may never use). Certainly you can add those to the display of the Harmony if you want them.