by ·1 Comment

I just ran into this error when upgrading a OsCommerce Site:

Fatal error: Call to a member function buildBlocks() on a non-object in public_html/includes/template_top.php on line 13

I saw that others had this error, but no one was able to help them. In case anyone else runs into this error check the following:

In catalog/includes/application_top.php you want to make sure you instantiate oscTemplate.

@@ -420,6 +420,9 @@
require(DIR_WS_FUNCTIONS . 'specials.php');
tep_expire_specials();

+ require(DIR_WS_CLASSES . 'osc_template.php');
+ $oscTemplate = new oscTemplate();
+

// calculate category path
if (isset($HTTP_GET_VARS['cPath'])) {
$cPath = $HTTP_GET_VARS['cPath'];

This code snippet comes from the OsCommerce V2.2RC2a to V2.3 Upgrade guide found here

by ·0 Comments

Here is a list of content types

Ext MIME Type
.doc application/msword
.dot application/msword
.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document
.dotx application/vnd.openxmlformats-officedocument.wordprocessingml.template
.docm application/vnd.ms-word.document.macroEnabled.12
.dotm application/vnd.ms-word.template.macroEnabled.12
.xls application/vnd.ms-excel
.xlt application/vnd.ms-excel
.xla application/vnd.ms-excel
.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
.xltx application/vnd.openxmlformats-officedocument.spreadsheetml.template
.xlsm application/vnd.ms-excel.sheet.macroEnabled.12
.xltm application/vnd.ms-excel.template.macroEnabled.12
.xlam application/vnd.ms-excel.addin.macroEnabled.12
.xlsb application/vnd.ms-excel.sheet.binary.macroEnabled.12
.ppt application/vnd.ms-powerpoint
.pot application/vnd.ms-powerpoint
.pps application/vnd.ms-powerpoint
.ppa application/vnd.ms-powerpoint
.pptx application/vnd.openxmlformats-officedocument.presentationml.presentation
.potx application/vnd.openxmlformats-officedocument.presentationml.template
.ppsx application/vnd.openxmlformats-officedocument.presentationml.slideshow
.ppam application/vnd.ms-powerpoint.addin.macroEnabled.12
.pptm application/vnd.ms-powerpoint.presentation.macroEnabled.12
.potm application/vnd.ms-powerpoint.presentation.macroEnabled.12
.ppsm application/vnd.ms-powerpoint.slideshow.macroEnabled.12

 

by ·0 Comments

So today update data cross table in a MYSQL database. It took me way longer than it should have.  I spent way too much time trying to get my join to work only to continue getting syntax errors.  So long story short. If you are doing a cross table update in MYSQL you cannot use a join. Rather you must use WHERE a simple example looks like:

UPDATE TableToUpdate, TableToPullInfoFrom

SET

TableToUpdate.col1 = TableToPullInfoFrom.col1,

TableToUpdate.col2 = TableToPullInfoFrom.col2,

TableToUpdate.col3 = TableToPullInfoFrom.col3,

TableToUpdate.col4 = TableToPullInfoFrom.col4

WHERE TableToUpdate.id = TableToPullInfoFrom.id

And I will just leave this here so I don’t make that mistake again.

by ·0 Comments

So my girlfriend and I have been talking about how we both neglect our websites and blogs and that we really want to work on them.  I was curious and pulled up my site stats and checked out how much traffic I have been getting. On average I receive about 5,500 views in a month. I am quite proud of that, but there is clearly much room for growth.

So I made a bet with my girlfriend to keep us both motivated and working on our site. We both looked at our site statistics and found the busiest month that we had and are going to see who can double their traffic the fastest.

Now we both target very different audiences so we didn’t bet anything huge but the loser of the challenge has to buy the winner dinner (hopefully a very nice one! Since it is dinner with my girlfriend I guess we both win either way).

My busiest month was May 2011 with 6,161 views.

So my goal is to get 12,322 views in a month.

I am quite excited about this, as my blog tends to be very technical articles or tutorials this will hopefully force me to start researching and writing about some new technologies.  At the same time I am going document various strategies I use to raise the traffic of my site by focusing not only on new content, but also SEO and marketing tactics.

Let the challenge begin!

If you want to help the competition you can check out my girlfriend’s site at http://www.jennifervitti.com

by ·0 Comments

The other day, one of our customers was switching over to 64-bit development machines, and encountered the following issue:

System.BadImageFormatException: Could not load file or assembly'(assembly name)' or one of its dependencies. An attempt was made to load a program with an incorrect format.

The likely reason is that you (or in this instance, our customer) are trying to load a 32-bit assembly into a 64-bit application. This can happen when you have the Any CPU platform selected.

Solution:

If your scenario sounds like the one I described, try setting your application to run in x86 mode. In Visual Studio this can be done by going to Build -> Configuration Manager…
Visual Studio Configuration Manager
…and setting the Platform to be x86.
Visual Studio Configuration Manager

This article and many others like this can be found on my SoftArtisans blog.