Trying to disable MySQL strict mode

I need to turn off MySQL strict mode for a couple of applications to work properly and have been unsuccessful. System is as follows:

WHM 11.28.52
Centos 5.5
MySQL 5.1.51

I have tried editing etc/my.cnf

The original is:

Code:

[mysqld]<br />
set-variable = max_connections=500<br />
safe-show-database<br />
local-infile=0

I have tried adding each of the below individually and restarting MySQL after each

Code:

sql-mode=&quot;NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;<br />
sql-mode=&quot;&quot;<br />
sql-mode=&quot;TRADITIONAL&quot;

Any ideas on what I am doing wrong?

Tags: - - - - - - - - - - - - - - - - -
Read More...

Community links: Open source motivations edition

What’s more fun to do over the weekend then catch up on WordPress community links? Set up the Christmas tree? Clean out the gutters? Shovel the driveway?

Alright, if you have to. Chores are chores. But when you’re done, reward yourself with a hot coffee and a good dose of WordPress reading. We have a truckload of links for you, so settle in.

The full list of links is after the jump.

In blog posts this week:

There were a few WordPress resources posted fresh this week too:

Finally, in WordPress tutorials this week:

Wow, that may be a record for number of WordPress related links in a roundup post (for us). Who gets the plaque?

That’s it for links this week. If you run across something link worthy, don’t hesitate to let us know about it. If it’s worth a story we’ll jump on it, and if it’s best suited for a community news post it will show up in this space next week.

Tags: - - - - - - - - - - - - - - - - - - - - - - - - - -
Read More...

WPEngineer gears up for their own WordPress Advent Calendar

WP Engineer Advent Calendar

In the spirit of Christmas, WP Engineer is cranking up their second annual advent calendar of tips and tricks.  They will be publishing new tips every day from December 1st through December 24th.

Last year provided all sorts of good stuff, from an interesting discussion on working with WP 2.9 post thumbnails, to extending user info, managing multiple excerpt lengths, and more.

Check out their blog post about it, and be sure to keep up with WP Engineer throughout December to open new doors to WordPress knowledge.

Also, Merry Christmas.  Was I the first to say that to you this season?

Tags: - - - - - - - - - - - - - -
Read More...

Why Percentage-Based Designs Don’t Work in Every Browser

Here’s a rule any web designer can live by: Your designs don’t need to look exactly the same in every browser, they just need to look good in every browser.

It’s a maxim that will spare you many a hair-pulling hour. That said, there some things you would expect to be the same across browsers that aren’t. One such problem that’s likely to crop up more often as designers jump on the responsive, flexible-width bandwagon is percentage-width CSS rules.

According to the spec, browsers, given a percentage width, would simply render the width of the page based on the size of the container element. And, in fact, that’s what browsers do, but how they do it varies quite a bit. As a result, percentage-based widths are often displayed quite differently across web browsers.

Developer Steffan Williams recently ran into this problem when trying to create a percentage-based version of his Gridinator CSS framework. Williams created a container

&lt;div>

with a width of 940 pixels and then wanted to create a 12 column grid within that container. Do the math and you end up with columns set to a width of 6.38298 percent.

Pull that up in Firefox or Internet Explorer 6/7 and you’ll see what you expect to see. In Safari, Chrome and Opera, however, you’ll see something different. IE 8 and 9 are also slightly off.

The problem is not a new one; developer John Resig pointed this out years ago. But as Williams notes, it’s odd that browser behavior when rendering percentage-width grids is still so inconsistent across vendors, especially given how much today’s browsers tout their CSS 3 support.

The problem isn’t necessarily a simple case of Firefox and IE being right and the others wrong. As Opera CTO and CSS creator Håkon Wium Lie tells Webmonkey, the problem is “the CSS specification does not require a certain level of precision for floating point numbers.”

This means browsers are free to round your carefully computed percentages up or down as they see fit. According to Lie, Opera considers the result of Williams’ experiment to be a bug. Same with the WebKit project, the engine that handles rendering in both Safari and Chrome, though in Webkit’s case the bug has been unassigned since 2006. But really, there is no right or wrong here, just different ways of rounding.

Fortunately, for most of your stylesheets, the differences in each browsers’ floating point precision will not result in visible differences on the screens of various devices. However, as Williams’ experiment shows, it’s easy to write a page where those very small differences in rounding become visible when compounded — like a grid-based layout.

What irks Williams and others is that these problems are old and well-known, and yet most browser vendors have still made no move to fix them. Instead, they focus on supporting the shiny new features in CSS 3.

We certainly wouldn’t want to suggest that browsers should stop innovating and supporting the latest and greatest standards-based tools, but sometimes it’s worth postponing playtime with the newest toys to make sure the foundations are solid. In this case, Opera, Safari and Chrome have some cracks showing, and it’s high time they fix them.

Until they do, we suggest you learn to live with the slightly different rendering behaviors in those browsers. After all, pixel-perfect cross-browser support is never going to happen. Given that the web of the future will have even more mobile phones, tablets, and small screen laptops, responsive designs and fluid grids are a trend we expect to grow.

There are also some workarounds. For example, you can use ems instead of percentages, which render much more consistently across browsers. Opera’s Lie also points out that the CSS Working Group has several specifications in draft to address the need for grid-based design, including multi-column text and the CSS Template Layout Module, though neither are widely supported at the moment.

iPad photo by Jim Merithew/Wired

See Also:

Tags: - - - - - - - - - - - - - - - - - - - - - - -
Read More...

Enhance your web forms with new HTML5 features

Please note that HTML5 is an emerging technique. These examples are not intended for use on a production site. Results may vary according to browser implementation. Please use Chrome or Safari for best results.

Required fields

Whose ever tried to submit a form and gotten an error message saying that you “forgot” to enter your email address? Probably not a lot of us: In fact, 99 percent of all web forms have at least one field marked as required.

In good ol’ HTML, we had to manually display that a specific field is required, most of the time by using a red asterisk. But with HTML5, you can set up a input field to be required:

<input type="text"  name="client_name" required>

And on the CSS side, something like

input:required {
    border: 1px red solid;
}

will save you a lot of time.

Two similar attributes are also available:

optional

and

invalid

. They work exactly as the

required

attribute explained above.

Placeholders

In a form, an input field always has a label explaining what kind of information is required. While you can currently use the

label

tag to display a label for a specific text field, HTML5 introduces the

placeholder

attribute. As shown below, using it is pretty simple:

<input name="firstname" placeholder="Please enter your first name">

The HTML5

placeholder

attribute works exactly as the

value

attribute, except that when the user click on the text field, the placeholder text is automatically removed so the user can easily enter his information.

The placeholder attribute currently works only in safari/webkit. Don’t worry about other browsers though, it is pretty easy to simulate placeholders using javascript:

Autofocus

A new HTML5 attribute is named

autofocus

. If applied to an element, the element will automatically receive the focus once the page is loaded. This can be seen on some sites and most search engines.

Nothing complicated, just use the syntax below, and remember that in HTML5, there’s no more need for attributes to have a value like in XHTML 1.0.

<input name="search" autofocus>

Email fields

Asking someone’s email on a web form is extremely common because email is still the easiest way to contact someone over the internet. HTML5 introduces a new type for the input element, named

email

.

<input name="email" type="email">

Pattern attribute

When validating a web form, we have to validate the data entered by the visitor. The new

pattern

HTML5 attribute allows you to define a regular expression pattern. Only the data that matches the defined pattern will be validated. If the data doesn’t match the pattern, then the form will not be submitted.

This is, in my opinion, an extremely good thing, which will save lots of time to developers when coding forms. Though, remember that you should always validate data on the server side as well.

<input type="text" name="Phone" pattern="^0[1-689][0-9]{8}$" placeholder="Phone" required>

Url fields

Nowadays, many people have a website, blog, or at least a Twitter profile. This is why many web forms offer the possibility to enter an url.

HTML5 introduces a new type for the

input

element, designed specifically for entering urls:

<input name="url" type="url">

Although I didn’t test it myself, I heard that the W3C validator will raise an error if the value of a url field doesn’t match a proper url structure.

Date pickers

Many businesses are offering an appointment request through their website. In that case, the visitor has to specify the day they would like an appointment. HTML5 introduces the

date

type for the

input

element:

<input name="day" type="date">

When clicked, the

date

attribute will display a date picker so visitors will simply have to choose a date instead of entering it manually. Unfortunately, except in Opera, most browsers don’t have it implemented yet.

Note that a date picker can be implemented on your forms using the following types:

<input type="date">
<input type="datetime">
<input type="month">
<input type="week">
<input type="time">

Isn’t that user friendly? Personally, I can’t wait to implement this in my forms but as I said earlier this isn’t very well implemented in browsers at the time of writing this post. Of course, Javascript is always here to help. On this site I found a simple fallback implementation for the

input type=date

HTML5 attribute:

var i = document.createElement("input");
i.setAttribute("type", "date");
if (i.type == "text") {
    // No HTML5 native date picker support, use jQuery or your favorite framework to create one.
}

Search boxes

To enhance ease of retrieving information, many websites have implemented their own search engine. HTML5 has created a new type for search fields.

<input name="q" type="search">

For now, the only difference with regular text inputs is that, if you use Safari, the search box will have rounded corners. But maybe interesting functionalities will be implemented in the future. Let’s hope, because right now I have to admit that I don’t really see why we should use this type.

Sliders type and step attribute

HTML5 is also introducing sliders: A new type for the input element, which allows visitors to easily select a number instead of entering it manually.

<input name="number" type="range" min="0" max="10">

The example above allows the visitor to choose a number between 0 and 10. If you want the slider to be incremented/decremented 2 by 2, you’ll have to use one more new attribute: step. Here is an example:

<input name="number" type="range" min="0" max="10" step="2" >

That way, visitors will only be able to select numbers like 0, 2, 4, and so on.

Like CatsWhoCode? If yes, don’t hesitate to check my other blog CatsWhoBlog: It’s all about blogging!

Enhance your web forms with new HTML5 features

Tags: - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Read More...

Electrical glitch delays final Discovery launch another day

Problems with the circuitry of a critical main engine control computer prompted NASA managers to order another delay, to at least Thursday, for launch of the shuttle Discovery on its 39th and final mission.

Tags: - - - - - - - - - - - - - -
Read More...

Repairs complete, shuttle countdown begins

Engineers successfully repair suspect pressurization fittings and started the shuttle Discovery’s countdown for a Wednesday launch to the International Space Station.

Tags: - - - - - - - - - - - - - - -
Read More...

Blekko: Another Human-Edited Search Engine Hopes To Take On Google By Stopping Spam

ReelSEO is, first and foremost, about video.  Video marketing, video production, and of course, video SEO.  So search engine news is something we tend to pay attention to.  There’s a new search engine in town, and it claims to have the one thing that Google’s search engine does not:  human editors. Here we go again. [...]

Tags: - - - - - - - - - - - - - - - - -
Read More...

ReelSEO’s Online Video Happenings – Fall 2010 Podcast

ReelSEO’s Grant Crowell and Mark Robertson spliff in our podcast shue about our amazing video coverage, including: YouTube’s Promoted Videos improvements, speaking on Video SEO at the Search Engine Strategies conference in Chicago, our upcoming coverage of the Streaming Media West conference, Facebook video marketing tactics, and interviews at the Blogworld New Media Expo. Did [...]

Tags: - - - - - - - - - - - - - - - - - - - -
Read More...

Microsoft Giving Up On Silverlight, Joining HTML5 Party

We now have further confirmation that Microsoft is giving up on its Silverlight rich Internet application platform. Bob Muglia, Microsoft’s president in charge of server and tools, told ZDNet that the company is “shifting away” from Silverlight as a cross-platform development framework, and pushing the HTML5 web standard instead.

There’s been plenty of evidence to suggest this was the case. After all, with the launch of Internet Explorer 9, Microsoft has fully embraced and touted many of HTML5′s features. But it doesn’t just stop there; Microsoft will be leveraging HTML5 for the latest version of its Bing search engine, and is using H.264-encoded HTML5 video in lieu of Silverlight Smooth Streaming for delivery of live video on its Xbox 360 game console.

Microsoft will continue to develop and lean on Silverlight, especially for application development on its recently launched Windows Phone 7 operating system for mobile devices. However, Muglia told ZDNet, “HTML is the only true cross-platform solution for everything, including (Apple’s) iOS platform.”

That Microsoft would align itself with Apple, especially in the embrace of a web standard, might seem peculiar to some. After all, the two software makers have been battling for decades in the PC space, and now are bumping heads in mobile as Microsoft tries to offer up a compelling alternative to Apple’s iPhone.

But it also makes sense that Microsoft would begin de-emphasizing Silverlight as a cross-platform development platform. Despite some of the advances Microsoft was able to push with its development, including HTTP and adaptive bit rate streaming, it wasn’t able to dethrone Flash as the de facto rich Internet application and video platform on the web. And with the emergence of HTML5, it was no longer a matter of playing second fiddle to Adobe, but lagging behind a web standard that was also being rapidly adopted.

To see what Adobe CTO Kevin Lynch has to say about adoption of HTML5 and its positioning against Flash, come see him speak at NewTeeVee Live on November 10 in San Francisco.

Related content on GigaOM Pro:

Tags: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Read More...