Jump to content

Search the Community

Showing results for tags '1364 error'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
  • osCommerce v4.x
    • General Support
    • Design and Templates
    • Apps / Add-ons
    • Translations
    • API and import/export
    • Marketplace integration
    • Manuals and How-to
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Developer Feedback
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 1 result

  1. I am currently going through the process of moving an OSCommerce 2.3.4 website from a php 5 server to a PHP 7.4 server. Boss wants it doing even though ideally it should be written with a newer version of OSC. Nearly finished updating and now going through the checkout pages. Having an issue on checkout_process.php. The order process is fine until I click confirm order and then I get this error: 1364 - Field 'Sp_Status' doesn't have a default value insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('464786', '1', now(), '1', '') A bit more information: The live website uses Sage-Pay as a payment module so I thought I would use the standard pay on delivery module as a test to see if the checkout is working and then I can clear any errors with Sage-Pay once I go live. Having looked at the above error, I think I understand it to mean the query can't insert the field 'Sp_Status' as there is no value given for it. I tried looking for any reference for the field and values needed but I can't find any. I've also tried setting a default value in the table but it still doesn't fix the issue. Any ideas on what may be causing this? This appears to be the only issue I'm having (fingers crossed). Thanks.