Author - TheWebsiteGuy

Magento can’t upload images after CE 1.9.2.3 / SUPEE-7405 update

After the recent Magento update which included patch SUPEE-7405 it appears many people have an issue uploading images through the Magento backend. As part of the SUPEE-7405 patch Magento has increased security around the upload and checking of images to prevent malicous content. Cause The permissions for folders/files created when uploaded are too restritive, they where 777 and now after the recent update are 750 for folders and 640 for files. Solution To fix this issue I had to revert change the permissions to more [...]

Read more...

Magento backend order view broken (PHP syntax error after SUPEE-7405 : unexpected [ )

Recently I came across an issue after upgrading a client site to Magento CE 1.9.2.3 which includes the recent SUPEE-7405 security patch. When trying to view the details of an individual order you would get a white page body with no details or data shown. Upon inspecting the source the following error was shown; <code> PHP Parse error: syntax error, unexpected ‘[‘ in app/code/core/Mage/Adminhtml/Helper/Sales.php on line 124 </code> Problem SUPEE-7405 was coded with PHP 5.4 in mind, older PHP versions are incompatible with the new language [...]

Read more...
Magento Dataflow Error

Magento 1.9.2 Dataflow Export Error – Undefined index: website

Shortly after updating Magento 1.9.1.1 to 1.9.2 I needed to do a Dataflow export of product data. When the ‘Run Profile In Popup’ button was pressed I was almost instantly greeted with an error messages. Notice: Undefined index: website in /var/www/vhosts/domain.com/htdocs/app/code/core/Mage/Catalog/Model/Convert/Parser/Product.php on line 510 To fix this issue I had to make 3 changes to the Product.php file. Line 423 change ‘websites’      => ”, to ‘website’      => ”, Line 436 change $row[‘websites’] = join(‘,’, $websiteCodes); to $row[‘website’] = join(‘,’, $websiteCodes); Line 438 change $row[‘websites’] = $this->getStore()->getWebsite()->getCode(); [...]

Read more...

Moving Magento To Another Server

Overview Here is an overview of the steps we’ll take to do this: Make a MySQL dump file of the database Archive the media and theme directories Copy the files to the other server Install a clean version of Magento Import the dump file to a blank database Move our copied data to the correct places Old Server The first thing you’ll want to do is login to the server where Magento currently resides. You will need to go to the directory where Magento is installed. For the [...]

Read more...

M2ePro slow to add products to listings groups on large catalog

If your running a Magento store with a large catalog of products you may notice that when adding products using the ‘Add from product list’ option that it can become very slow to load. The problem is related to the fact that MySql query used for adding the products to the Listing works differently on the different versions of MySql servers. There is an alternative query already written in the code that should be much faster. Please look at the specified files: app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Amazon/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Buy/Listing/Product/Grid.php app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Play/Listing/Product/Grid.php 1. Find [...]

Read more...

Magento M2ePro ‘1690 BIGINT UNSIGNED’ Database Error

Recently we have come across a few clients that have an SQL database error appear in the search tab of the M2ePro eBay Listings page. The error looks like this; Fatal error occurred: “SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(SELECT COUNT(*) FROM (SELECT DISTINCT `l`.`account_id`, `l`.`marketplace_id`, `main_table`.`product_id`, `cpev`.`value` AS `product_name`, `cpe`.`sku` AS `product_sku`, `em`.`currency`, `ebit`.`item_id` AS `ebay_item_id`, `main_table`.`status`, `second_table`.`online_sku`, `second_table`.`online_title`, (second_table.online_qty – second_table.online_qty_sold) AS `online_qty`, `second_table`.`online_qty_sold`, `second_table`.`online_buyitnow_price`, `l`.`id` AS `listing_id`, `l`.`title` AS [...]

Read more...

Best FREE Magento Extensions of 2015

Over the last couple of years we have stumbled across some great extensions for Magento, both paid and FREE. Some of these proved invaluable to the sites we build in terms of added functionality, improved customer experience and increasing sales. Below we have compiled a list of what we consider to be the Best FREE Magento Extensions 2015. Apologies if you have a great FREE Magento extension and its not included, it may simply be that we haven’t come across [...]

Read more...

Using phpinfo and print_r $_SERVER

Some times when developing on a server you arent familiar with you need to know the PHP configuration of the web server. This can be easily achieved by using the below script saved as a .php file and called in a web browser. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Innov8 Internet Test Page - PHP + Server</title> </head> <body> <?php echo "<xmp>".print_r( $_SERVER, true )."</xmp>"; ?> <?php echo phpinfo(); ?> </body> </html> The above script also includes the print_r( $_SERVER, true ) [...]

Read more...

Removing extra linebreaks and spaces in Dreamweaver

Ever been coding and looked at the source in your favourite browser and wondered why so much white space and empty lines were present. How to remove extra spaces in dreamweaver While the document is open in Dreamweaver, press CTRL+F to load the Find & Replace dialog box. Do the search on the source code view. Check the box “Use regular expression” and uncheck any other boxes. Find: [\r\n]{2,} Replace: \n Then hit “replace all” And that’s it!

Read more...

Executing Magento Indexer From Shell

Some times when Magento has a very large catalog you will need to rebuild the indexes from shell / SSH. Executing the Magento Indexer From Shell is fairly straight forward and I personally use Putty as my SSH client. Once connected to your server via SSH navigate to the shell directory within your Magento install. [root@159 ~]# cd var/www/vhosts/******/public_html/shell/ [root@159 shell]# This next command will show the help options for the Magento Indexer from the “indexer.php” script, you will need to execute “php [...]

Read more...