API tools faq
paste
Guest User

Porting old Standard catalog to Strap

a guest
Feb 28th, 2017
41
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.99 KB | None | 0 0
raw download clone embed print report
  1. Porting old Standard catalog to Strap.
  2.  
  3. I dumped all the tables.
  4.  
  5. bin/makecat
  6.  
  7. cp -p inventory.txt merchandising.tx logt options.txt orderline.txt pricing.txt products.txt transactions.txt variants.txt /home/user/new_catalog/products/
  8.  
  9. Edited variable.txt
  10.  
  11. Started Interchange with the files.
  12.  
  13. I get this error when trying to finalize the order.
  14.  
  15. (log_orderline_table): There was an error adding the items to the orderline table: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from `inventory` where `sku` = '40042'' at line 1 at /usr/local/interchange-5.10/lib/Vend/Table/DBI.pm line 972.
  16.  
  17. The logs have
  18.  
  19. error.log
  20. >
  21. 168.103.176.53 5ghSLeBT:168 - [28/February/2017:15:52:50 -0700] amazingprice /cgi-bin/amazingprice.biz/ord/finalize set_slice error as called by Vend::UserDB: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '='ZENEZ',='Boyd Lynn',='Gerber',='1042 East Fort Union Blvd. #135',='',='Midval' at line 1 at /usr/local/interchange-5.10/lib/Vend/Table/DBI.pm line 1448.
  22. >
  23. > query was:update `userdb` SET =?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=? WHERE `username` = 'U00009'
  24. > values were:'ZENEZ','Boyd Lynn','Gerber','1042 East Fort Union Blvd. #135','','Midvale','UT','84047','US','801-849-0213','free_or_upsg','US','gerberb@zenez.com','2017-02-28 15:52:50','{'default' => {'phone_cell' => "",'fax_order' => "",'mv_credit_card_exp_year' => "17",'account_id' => "",'mv_same_billing' => "1",'mv_credit_card_exp_month' => "2",'po_number' => "",'mv_credit_card_exp_type' => "",},}'
  25. 168.103.176.53 5ghSLeBT:168 - [28/February/2017:15:52:51 -0700] amazingprice /cgi-bin/amazingprice.biz/ord/finalize Route log failed.
  26. 168.103.176.53 5ghSLeBT:168 - [28/February/2017:15:52:51 -0700] amazingprice /cgi-bin/amazingprice.biz/ord/finalize ERRORS on ORDER :
  27. > Error during creation of order routing log:
  28. > Route log failed. at /usr/local/interchange-5.10/lib/Vend/Order.pm line 1861.
  29. >
  30.  
  31. log
  32. #### begin order logging of transaction ID 000042 #####
  33. 1
  34. Total order: $44.10
  35. Payment processing...payment_method=credit_card
  36. Offline credit card visa 42**4242.
  37. Payment: credit_card
  38. Set order number in values: 1035
  39. Set order number in session: 1035
  40. Auto-created user U00009.
  41. Add main order 1035 to transactions: 1
  42. There was an error adding the items to the orderline table: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from `inventory` where `sku` = '40042'' at line 1 at /usr/local/interchange-5.10/lib/Vend/Table/DBI.pm line 972.
  43. #### end order logging of tid=000042, order_number=1035 #####
  44.  
  45. tracking.asc
  46. ##### BEGIN ORDER #####
  47.  
  48. ##### END ORDER #####
  49.  
  50. userdb.log
  51. 20170228155251 U00009 168.103.176.53 Successful login by user 'U00009'
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!