Skip to main content
14 events
when toggle format what by license comment
Apr 10, 2017 at 12:26 comment added Antony Working perfectly now, thank you very much indeed Jaimin.
Apr 10, 2017 at 12:25 vote accept Antony
Apr 10, 2017 at 10:17 comment added Jaimin Sutariya Let us continue this discussion in chat.
Apr 10, 2017 at 10:13 comment added Jaimin Sutariya Check with updated code, I have tested it on my machine and its working without errors
Apr 10, 2017 at 10:12 history edited Jaimin Sutariya CC BY-SA 3.0
added 1 character in body
Apr 10, 2017 at 10:04 comment added Antony Now getting: "Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use". Maybe a typo mistake?
Apr 10, 2017 at 9:59 comment added Jaimin Sutariya Yes, use updated code, you need to use Mage::getSingleton('core/resource')->getTableName('sales/ord‌​er_address') for all of your table instances. I have updated the same in answer.
Apr 10, 2017 at 9:58 history edited Jaimin Sutariya CC BY-SA 3.0
added 100 characters in body
Apr 10, 2017 at 9:57 comment added Antony Thank you for your efforts Jaimin, but I am now getting: "Column not found: 1054 Unknown column 'sales_flat_order_address.address_type'"
Apr 10, 2017 at 9:51 comment added Jaimin Sutariya Try Mage::getSingleton('core/resource')->getTableName('sales/order_address')
Apr 10, 2017 at 9:51 history edited Jaimin Sutariya CC BY-SA 3.0
deleted 5 characters in body
Apr 10, 2017 at 9:43 history edited Jaimin Sutariya CC BY-SA 3.0
added 51 characters in body
Apr 10, 2017 at 9:27 comment added Antony Hi Jaimin, unfortunately I get a database error, I guess it is due to the fact the my tables have prefix in front.
Apr 10, 2017 at 2:30 history answered Jaimin Sutariya CC BY-SA 3.0