1b.app
Link copied -

Goods are unloaded into the opencart one per hour

Answers:

Executing error: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. in query: INSERT INTO oc_product (sku, model, quantity, manufacturer_id, price,
status, date_added, date_modified) values ( 'LU-01253',
'', '0', '52', '14976.225242428', '1', NOW(), NOW())

не можем сделать некоторые вставки
09.06.2023, 12:48

Захарюгин Юрий Олегович
Leave a message in this thread and the user's contacts will be shown to you
thanks for the answer
but I did not understand where the error is:
- integration settings (I did something wrong)
- some malfunctions in the box
- there is a problem with the hosting, they are blocking something
09.06.2023, 13:38
Original comment available on version: ua

Захарюгин Юрий Олегович
Leave a message in this thread and the user's contacts will be shown to you
09.06.2023, 13:40
Original comment available on version: ua

it is the opencart database that gives this error as a response to attempts to fulfill our requests. Most likely there is some kind of database replication that interferes with the execution of queries.
09.06.2023, 13:55
Original comment available on version: ru

Захарюгин Юрий Олегович
Leave a message in this thread and the user's contacts will be shown to you
I can't figure something out, please help
I wrote to the hosting, they say there are no bans and limits, they say maybe there is some kind of error in the site's database...
https://lums.com.ua
the site uploads one product per hour to this site, then at night there is an action "Remove from Opencart the products that have been removed from OneBox" - it removes these products and they are added one by one the next time
there is a second site on opencard 3.0 https://www.chirana.kiev.ua/stomatologichne-obladnannya/stiltsi-stomatologichni
(only one brand is loaded here)
in the box in the villages, the brand was changed, which is loaded on this site, the goods flew all at once (9 pieces)
http://test.lums.com.ua
decided to check the theory about the database on the site, made a new subdomain, there is a new opencard 3.0 bare, made integration with the box, and there are also products one per hour
https://lums.crm-onebox.com/app/automatization/hour/edit/
here is the integration
I try to switch ticks, filters, model, pictures, but so far there is no change
before the error, I made a new category, then moved some categories to a new one, I don't understand how this can affect the error.
categories flew to the site, everything is normal
12.06.2023, 20:01
Original comment available on version: ua

Захарюгин Юрий Олегович
Leave a message in this thread and the user's contacts will be shown to you
I'll answer my own question...everything is done and it's working now.

reinstalled opencard 3.0 from scratch, new DB

automation:

- deleted the old integration, and made a new upload of goods through the database (probably there was some error in the system, the goods were added one by one)

- FTP settings on the screen

Hosting and Site

- in the open card in the API, I added the IP address of the box and additionally also the open card in the allowed.

- setting crowns on hosting

- PCB settings when installing modules on the site should be ionCube (it was turned off, I don't know how it can be related)

- on the hosting, the IP address of the box is periodically banned because the box is abroad, and the hoster blocked access for the foreign country, probably before the attack, the goods and orders are not transferred (the ban was lifted in TP, they promised not to ban)

in the Cron.php integration file, the following has been corrected:

- added $userName = 'Default'; (it is not mentioned in the instructions on YouTube) (waited for 3 hours)

- removed the slash line 86 $curl = curl_init( $host .'index.php?route=api/login' ); (I read on the forum that there is an error)

3..4 hours have passed since the last setting (Username) and I saw a photo of the goods on the website

The goods have all arrived (and not one per hour)

orders arrive in the box.

thank you all.

to whom it was useful, I will be glad to donate))
22.06.2023, 19:10
Original comment available on version: ua

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment