Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Error occured

 

Posted 11 September 2012 - 01:57 PM #1

καλησπέρα,
Ξέρει κανείς να με βοηθήσει πως μπορώ να διορθώσω το μήνυμα που εμφανίζει όταν ο πελάτης είναι στο τελικό στάδιο της παραγγελία και διαλέγει με πιο τρόπο να γίνει η αποστολή του προϊόντος και όταν παταει το κουμπί κάντε την παραγγελία σας του εμφανίζει λεύκη σελίδα και το μήνυμα Error occured

Μπήκα σε live mode και μου εμφάνισε το έξεις μήνυμα
Database error: Duplicate entry '16777215' for key 1 (1062)
Invalid query: INSERT INTO cscart_orders (`discount`, `total`, `subtotal`, `shipping_cost`, `promotions`, `subtotal_discount`, `payment_id`, `payment_surcharge`, `user_id`, `status`, `company_id`, `title`, `firstname`, `lastname`, `company`, `email`, `phone`, `fax`, `url`, `tax_exempt`, `lang_code`, `b_title`, `b_firstname`, `b_lastname`, `b_address`, `b_address_2`, `b_city`, `b_county`, `b_state`, `b_country`, `b_zipcode`, `b_phone`, `s_title`, `s_firstname`, `s_lastname`, `s_address`, `s_address_2`, `s_city`, `s_county`, `s_state`, `s_country`, `s_zipcode`, `s_phone`, `timestamp`, `ip_address`, `is_parent_order`, `shipping_ids`) VALUES ('0', '228', '228', '0', 'a:0:{}', '0', '5', '0', '1', 'N', '', '', 'mitsopoulos', 'giorgos', '', 'giorgos@mitsopoulos.com', '2631300490', '', '', 'N', 'EL', '', 'mitsopoulos', 'giorgos', 'stournara 4', '', 'mesolonghi', '', '2', 'GR', '30200', '2631300490', '', 'giorgos', 'mitsopoulos', 'stournara 4', '', 'mesolonghi', '', '2', 'GR', '30200', '6955558817', '1347371565', '46.176.123.109', 'N', '6')
Backtrace:
File:
/home/eshop/public_html/core/fn.database.php
Line:
259
Function:
db_error
File:
/home/eshop/public_html/core/fn.cart.php
Line:
469
Function:
db_query
File:
/home/eshop/public_html/controllers/customer/checkout.php
Line:
412
Function:
fn_place_order
File:
/home/eshop/public_html/core/fn.control.php
Line:
578
Function:
include
File:
/home/eshop/public_html/core/fn.control.php
Line:
432
Function:
fn_run_controller
File:
/home/eshop/public_html/index.php
Line:
28
Function:
fn_dispatch
Giorgos Mitsopoulos
Project Manager

Alluminium systems
www.mitsopoulos.com
@alugate

 

Posted 12 September 2012 - 10:47 AM #2

You have an existing order with the order_id '16777215'.

Change the initial order value in the CS-Cart administration area to something higher than 16777215, try 20000000?
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 12 September 2012 - 10:52 PM #3

THANK YOU :-) are all ok
Giorgos Mitsopoulos
Project Manager

Alluminium systems
www.mitsopoulos.com
@alugate

 
  • frankis72
  • Newbie
  • Members
  • Join Date: 26-Oct 12
  • 4 posts

Posted 22 November 2012 - 04:32 AM #4

Bringing up this topic again. I am experiencing the same issue. I have tried lowering my initial order value, raising it, deleting it, clearing the cache. Nothing seems to make a difference. All orders coming in are stuck at 16777215. Only thing I can do is delete that order, but then the next order will be at 16777215, which stops new orders again. I don't know where this came from, the order number before that is at a much lower number.

This started right after upgrading to 3.04. Didn't have this problem with 3.03

Database error: Duplicate entry '16777215' for key 'PRIMARY' (1062)
Invalid query: INSERT INTO cscart_orders (`user_id`, `discount`, `total`, `subtotal`, `shipping_cost`, `promotions`, `subtotal_discount`, `payment_id`, `payment_surcharge`, `b_firstname`, `b_lastname`, `b_title`, `s_firstname`, `s_lastname`, `s_title`, `firstname`, `lastname`, `title`, `b_address`, `b_address_2`, `b_city`, `b_county`, `b_state`, `b_country`, `b_zipcode`, `b_phone`, `s_address`, `s_address_2`, `s_city`, `s_county`, `s_state`, `s_country`, `s_zipcode`, `s_phone`, `s_address_type`, `company`, `email`, `phone`, `fax`, `url`, `timestamp`, `lang_code`, `tax_exempt`, `status`, `ip_address`, `is_parent_order`, `shipping_ids`) VALUES ('0', '0', '12.02', '2.58', '8.72', 'a:0:{}', '0', '1', '0', 'Test', 'Test', '', 'Test', 'Test', '', 'Test, 'Test', '', '123 Test Ave', '', 'Chicago', '', 'IL', 'US', '60640', '', '123 Test Ave', '', 'Chicago', '', 'IL', 'US', '60640', '', '', '', 'test@gmail.com', '', '', '', '1353558500', 'EN', 'N', 'N', '99.41.245.55', 'N', '8')
Backtrace: File: /home/glendal0/public_html/core/fn.database.php Line: 267 Function: db_error File: /home/glendal0/public_html/core/fn.cart.php Line: 514 Function: db_query File: /home/glendal0/public_html/controllers/customer/checkout.php Line: 422 Function: fn_place_order File: /home/glendal0/public_html/core/fn.control.php Line: 640 Function: include File: /home/glendal0/public_html/core/fn.control.php Line: 459 Function: fn_run_controller File: /home/glendal0/public_html/index.php Line: 22 Function: fn_dispatch

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10955 posts

Posted 22 November 2012 - 05:08 AM #5

Ensure that the attribute of the order_id column in your cscart_orders table is "unsigned".

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • frankis72
  • Newbie
  • Members
  • Join Date: 26-Oct 12
  • 4 posts

Posted 22 November 2012 - 07:18 PM #6

it appears to be unsigned already

Attached Thumbnails

  • orders unsigned.JPG


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10955 posts

Posted 22 November 2012 - 07:33 PM #7

Well, just as an experiment, you might try changing it to an unsigned mediumint(9). If that works, then you can go find all the 'object_id', 'product_id' and other '*_id' fields in your database and change them too. The maximum value for an unsigned mediumint is 16777215. And I believe by default that a meidum int is mediumint(8).

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • frankis72
  • Newbie
  • Members
  • Join Date: 26-Oct 12
  • 4 posts

Posted 22 November 2012 - 07:40 PM #8

Thanks for that response. Actually I just made some test orders, and everything seems to be working now. I don't know what the problem was. If this happens again I'll be sure to try what you just suggested.

Thanks again!

 
  • abcd
  • Advanced Member
  • Trial users
  • Join Date: 10-Sep 16
  • 52 posts

Posted 15 September 2016 - 10:45 AM #9

plzz help me to resolve this...

when i open default order status from administration->order status and then try to save it.. it gives service unavailable error and generates below error in logs..

 

 

Database (error)
Error: Duplicate entry 'Y-O' for key 'status' <b>(1062)</b>
Query: INSERT INTO cscart_statuses (`status`, `status_id`, `type`) VALUES ('Y', NULL, 'O')

Backtrace››

admin.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 455
app/functions/fn.control.php (include): 699
app/controllers/backend/statuses.php (fn_update_status): 23
app/functions/fn.common.php (db_query): 3571
app/functions/fn.database.php (call_user_func_array): 129
app/Tygh/Database/Connection.php (query): 458


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18348 posts

Posted 15 September 2016 - 02:14 PM #10

Status ID should not be empty. But it is hard to find a reason without code examination. Feel free to PM me temporary FTP access if you do not find a solution


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.