Jump to content

Ferguson230

Member
  • Content Count

    25
  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I edited the order complete email template, everything seems to be working fine now. Thanks Brian.
  2. Thanks Brian, I did that...Now the order status updates to order complete, but for some weird reason, the order complete email notification is sent in a German Language, it's a little confusing since the default language for the store is set to English. What could be causing that?
  3. I made the changes as you suggested using the code below : CREATE TABLE IF NOT EXISTS `cc_CubeCart_email_log` ( `id` int(11) NOT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `content_html` text COLLATE utf8_unicode_ci NOT NULL, `content_text` text COLLATE utf8_unicode_ci NOT NULL, `to` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `email_content_id` int(11) NOT NULL, `result` tinyint(1) NOT NULL, `fail_reason` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; #EOQ ALTER TABLE `cc_CubeCart_email_log` ADD PRIMARY KEY (`id`); #EOQ ALTER TABLE `cc_CubeCart_email_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; #EOQ And no I'm getting this : Error SQL query: #EOQ ALTER TABLE `cc_CubeCart_email_log` ADD PRIMARY KEY (`id`) MySQL said: Documentation #1068 - Multiple primary key defined How do I resolve it?
  4. I tried to create the table and I got this : Error SQL query: #EOQ ALTER TABLE `CubeCart_email_log` ADD PRIMARY KEY (`id`) MySQL said: Documentation #1146 - Table 'i4558236_cc1.CubeCart_email_log' doesn't exist When I try to create the Table 'i4558236_cc1.CubeCart_email_log' it says that table already exist. How should I address this? Thanks. This was the code I was trying to use to create the table CREATE TABLE IF NOT EXISTS `cc_CubeCart_email_log` ( `id` int(11) NOT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `content_html` text COLLATE utf8_unicode_ci NOT NULL, `content_text` text COLLATE utf8_unicode_ci NOT NULL, `to` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `email_content_id` int(11) NOT NULL, `result` tinyint(1) NOT NULL, `fail_reason` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; #EOQ ALTER TABLE `CubeCart_email_log` ADD PRIMARY KEY (`id`); #EOQ ALTER TABLE `CubeCart_email_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; #EOQ
  5. Yes - the only thing that seems to be the problem, is when I change the status to Order complete...
  6. Thanks, I just did. I'll do the comparisons and let you know.
  7. Thanks Bsmither, I'll do that, but I must say I don't have the structure.sql on the server. I use Cubecart version 6.2.0. If you have that file, can you please attach it?
  8. Yes, how can I solve the issue of missing tables?
  9. Yes you're right, it says "Failed to update order". This is what I'm seeing in the error log, do you think it's related? File: [cubecart.class.php] Line: [1280] "SELECT `I`.`product_id`, `C`.`cat_name` FROM `CubeCart_category_index` AS `I` INNER JOIN `CubeCart_category` AS `C` ON `I`.`cat_id` = `C`.`cat_id` WHERE `I`.`product_id` IN (38,42,44,40,118) AND `primary` = 1 ;" - Table 'i4558236_cc1.CubeCart_category_index' doesn't exist I checked (2B and 3) and can say that no changes have been made.
  10. I had a couple of orders and after customers successfully made payments, the Order status changed from Pending to Processing. However, when I tried to change the Order status to Order Complete, I get an error saying something like "Failed to update order status". What is causing this? Everything else seems to be working fine except for that.
  11. Ferguson230

    New Orders not showing in the order section

    Thanks Brian, it works now. You've always been very helpful, I really appreciate you.
  12. Ferguson230

    New Orders not showing in the order section

    Thanks Brian. I will do a test order and see how it goes.
  13. Ferguson230

    New Orders not showing in the order section

    And at the end of the error log, it says - Duplicate entry '' for key 'custom_oid'.
  14. Ferguson230

    New Orders not showing in the order section

    Not really, I only placed a mylivechat javascript code in the main.php for the front end. Do you think that could be the cause?
  15. Ferguson230

    New Orders not showing in the order section

    Sorry about that. I have attached it in this one.
×