hi! i install magento 2 by quick start claue theme and now on checkout page when i place order after giving all the details as guest or as user it show an error under payment method that "an error occured on server. please place order again "
i m worried about it plzzzzzzzzzz help me as soon as u can
I also see this error when trying to checkout on the Luma them ( default magento2 theme ), this is not error of theme I can't support to fix it, I also search with google, so please refer this post for more detail
hi9brother thanks to recognize the problem i check it and got that some tables in the database given with theme in quickstart are missing so its theme issue and i create those tables
the tables for austria store which i m using as default were missing . those tables are:
sequence_order_12
sequence_shipment_12
sequence_invoice_12
sequence_creditmemo_12
i export these tables of english store and change its id from 1 to 12 in sql file than import them
after it i place order
the order placed successfully but with order no #000000000
mean a totally 0 value
after it i place another order but it again show error and when i check the error it seems that the order no that is #000000000 is not auto increment
i check and sure that in table is it auto increment and in all tables auto increment enabled in database but the order id is not auto incrementing itself that is why its showing error of duplication
the error is like that as shown in screenshot below:
brother plzz help me to fix it i will be very thankful to u for this help. plzzz
Thanks for your feedback, what theme version that you installed with quickstart? Because on newest theme package, the quickstart installation is on magento 2.2.0
- I also don't make sure that, your edit way is correct, maybe it fix an error but other error will occur
hi! i install magento 2 by quick start claue theme and now on checkout page when i place order after giving all the details as guest or as user it show an error under payment method that "an error occured on server. please place order again "
i m worried about it plzzzzzzzzzz help me as soon as u can
here is the screen shot below plzzzz help
Hi
Can you please provide your site info ( admin account and ssh account ) I will check it
Hi
I just checked and this is actual error
I also see this error when trying to checkout on the Luma them ( default magento2 theme ), this is not error of theme I can't support to fix it, I also search with google, so please refer this post for more detail
https://magento.stackexchange.com/questions/110701/magento-2-syntax-error-or-access-violation-1103-incorrect-table-name-query
Or find more with google search:
https://www.google.com.vn/search?q=SQLSTATE%5B42000%5D%3A+Syntax+error+or+access+violation%3A+1103+Incorrect+table+name+%27%27%2C+query+was%3A+INSERT+INTO+%60%60+()+VALUES+()+magento2&rlz=1C1CHZL_viVN761VN761&oq=SQLSTATE%5B42000%5D%3A+Syntax+error+or+access+violation%3A+1103+Incorrect+table+name+%27%27%2C+query+was%3A+INSERT+INTO+%60%60+()+VALUES+()+magento2&aqs=chrome..69i57.3531j0j7&sourceid=chrome&ie=UTF-8
hi9brother thanks to recognize the problem i check it and got that some tables in the database given with theme in quickstart are missing so its theme issue and i create those tables
the tables for austria store which i m using as default were missing . those tables are:
i export these tables of english store and change its id from 1 to 12 in sql file than import them
after it i place order
the order placed successfully but with order no #000000000
mean a totally 0 value
after it i place another order but it again show error and when i check the error it seems that the order no that is #000000000 is not auto increment
i check and sure that in table is it auto increment and in all tables auto increment enabled in database but the order id is not auto incrementing itself that is why its showing error of duplication
the error is like that as shown in screenshot below:
brother plzz help me to fix it i will be very thankful to u for this help. plzzz
Hi
Thanks for your feedback, what theme version that you installed with quickstart? Because on newest theme package, the quickstart installation is on magento 2.2.0
- I also don't make sure that, your edit way is correct, maybe it fix an error but other error will occur
hi brother i installed claue theme with quickstart of magento 2.1.7
and as i told u before that the tables were missing so i just add the missing tables in db
but now the order id in not auto incrementing
Hi
Thanks for your feedback, so please edit those tables and set as below:
Hi
Can you please provide cpanel account? I will try to check it