Fix My Source Code

MySQL said: Cannot add or update a child row: a foreign key constraint fails

When working with MySQL InnoDB relationships, I ran into a snag when dealing with foreign keys. I was attempting to creating a cascading relationship between a “projectID” and the “ID” field of the “projects” table. BUT, I kept getting an annoying error stating: “MySQL said: Cannot add or update a child row: a foreign key constraint fails”.

After 30 minutes of failed Google searches, I finally figured out the issue myself.

Problem:

Attempting to create a foreign key cascade relationship between tables failed. MySQL simply said NO, Scott, you’re DUMB!

Solution:

I was attempting to relate a foreign key in one table to a primary key in another table where a matching row did not exist. In order to create a cascading foreign key relationship from one table to the next, you cannot have records in the foreign table without a corresponding record in the primary table.

For example: if I have a taskList with a foreign key for “projectID” with a value of 3, I must have a record in the table for “projects” with a matching “ID” of 3.

Hope this helps you keep your hands out of your hair!

Backbone.js Collection Creates Blank Model When it is Initialized

If you’ve ever had an issue with a blank Backbone model showing up every time you initialize a collection, I may have found your problem.

It seems that when you initialize a Backbone collection, the collection does not handle the object you pass the initialize() method the  same way that a model or a view does. A Backbone collection, minus a few keywords (model, etc.), will automagically try to initialize a new model with the object you are passing it’s initializer. See the solution below:

Problematic Code:

// in a view, or wherever
this.collection = new Collection({
  url : 'http://someurl.com',
  anotherOption : 'This is another option'
});

Solution:

// in a view, or wherever
this.collection = new Collection;
this.collection.url = 'http://someurl.com';
this.collection.anotherOption = 'This is another option';

Please let me know if you’ve found a better solution!

Backbone.js model.save() creates POST request instead of a PUT request while using MongoDB

I could not, for the life of me, figure out why Backbone.js was sending a POST request to my server rather than a PUT request while I was trying to save a model that had already been created. 

I am using Node.js on the back-end, Backbone.js on the front-end, and MongoDB as my database. I finally found a few solutions and it made it ALL work!

Here was my problem:

Backbone.js model.save() creates POST request instead of a PUT request while using MongodDB

Here is solution 1:

This sets the default place that Backbone looks for the id of the model

var Model = Backbone.Model.extend({
  idAttribute : '_id'
});

Here is solution 2:

This uses the set function of the model to set the attribute to either ‘_id’ or ‘id’, depending on which one is already set

var Model = Backbone.Model.extend({
  initialize : funcition(opts){
    this.set({
      id : attributes['_id'] || attributes['id']
    });
  }
});

Add and Save Multiple Items to Shopping Cart with WP E-Commerce

var function_callback = function(result) { 
 // callback code goes here 
}
function add_item_to_cart(product_id,quantity) {  
  /* set default for product quantity to 1 */ 
  if(!quantity){ quantity = 1 }  

  /* query string to send wordpress to tell it to add these options to the cart */ 
  var data = "custom_text=&wpsc_quantity_update="+ quantity +"&key=-1&wpsc_update_quantity=true&wpsc_ajax_action=add_to_cart&product_id="+ product_id +"&is_customisable=true";  

  /* uses custom function from WP E-Commerce to update cart with ajax */ 
  ajax.post('index.php?ajax=true', function_callback, data);
}

Screenshot of New Web Design Project

Here’s a quick screenshot of a project I’m working on for a client right now. Call to action…

Posted via email from Scott Corgan | Comment »

15 Essential WordPress Plugins for Portfolio Sites - Web Design Blog – DesignM.ag

via designm.ag

Definitely worth a read!

Posted via web from Scott Corgan | Comment »

Daily Free @font-face Ready Font #9

Distant Galaxy - by Shy Fonts

Download Distant Galaxy @font-face kit

Posted via email from Scott Corgan | Comment »

Daily Free @font-face Ready Font #8

Blackout - by The League of Moveable Type

Download Blackout @font-face kit

Posted via email from Scott Corgan | Comment »

Daily Free @font-face Ready Font #7

Shangri La - by Nick’s Fonts

Download Shangri La @font-face kit

Posted via email from Scott Corgan | Comment »

Logo for ‘Classic Church’ Updated

Per request of the customer, I have made some color adjustments and additions to the logo for Classic Church. The client requested a “wine-ish” color with and “cream” background. They were looking for a logo that mirrored that of an old Cadillac emblem.

What do you think?

Posted via email from Scott Corgan | Comment »