Correction of the error
22 USD There is a website. It has stopped working.
Response from hosting technical support
"The request to the database took too long to execute and because of this, all subsequent requests were not executed
We have made a copy of the slow query log in a file for analysis
/var/www/ressormarket/tmp/
The problematic query makes a select to product_property_value_id - it is the only one in the file"
It needs to be fixed
-
1 day22 USD
191 1 day22 USD
Good day. The problem described by technical support is related to a slow SQL query that accesses the field product_property_value_id. Due to the excessive duration of this query, the site "hangs" or completely stops responding.
What I will do:
I will analyze the log /var/www/ressormarket/tmp/queryslow.manual.2025.03.08.log.
I will determine the cause of the slow execution (lack of index, incorrect JOIN condition, large selection, etc.).
I will optimize the query: through indexing, rewriting SQL, or caching.
I will check for similar queries in the code.
I will provide a brief report on diagnostics and fixes.
Deadline:
… From 2 to 4 hours (depending on the structure of the tables and access to the code and database).
-
1 day22 USD
628 28 0 1 1 day22 USD
Good day!
Feel free to contact me, I will fix it right now.
------------------------------------
-
1 day24 USD
1154 11 0 1 day24 USD
Good afternoon. I have extensive experience working with SQL. If you are interested, please write to clarify the details.
-
1 day22 USD
5631 77 3 1 day22 USD
Good day!
It is necessary to familiarize yourself with the log, the code, and the database. Perhaps there are simply not enough indexes, or maybe the code is flawed. I will help without any problems. Experience in programming - 14 years
-
1 day22 USD
2853 63 5 1 day22 USD
Hello! Your site is on OpenCart, I can solve the problem and fix everything.
-
1 day89 USD
1212 7 0 1 day89 USD
Good day!
I have reviewed your task and am ready to help fix the issue with the slow SQL query.
I have experience in query optimization, working with databases, and log analysis. I can:
• analyze the log queryslow.manual.2025.03.08.log,
• optimize the SELECT query for product_property_value_id,
• check the indexing of the table and suggest improvements,
• test and verify the functionality of the site after the fix.
…
I am ready to discuss the details and get started.
Best regards,
Ruslan
-
2 days22 USD
674 24 0 2 days22 USD
Good afternoon, Ivan
Write to me in private messages, I'll see what you have there
Sincerely, Alexander
-
1 day22 USD
756 26 1 1 day22 USD
Hello. I will figure it out... I have fixed something similar....................................................................
-
1 day22 USD
844 26 4 1 1 day22 USD
And how do you suggest to replace it, with what? I will take a look, I will replace it.
------------ ---------------- ----------------
-
1 day27 USD
1328 35 1 1 day27 USD
Good day. Feel free to reach out. I will fix it. I have fixed similar problems many times.
-
Покажіть сам сайт, будь-ласка
-
ressomarket.ua
-
Можливо ви десь помилилися, бо такого домену не існує
-
ressormarket.ua - одна літера невірна була)
-
Це OpenCart чи якийсь фреймворк?
-
Yii
-
Чудово, друга версія чи перша?
-
yii2
-
Current freelance projects in the category PHP
Integration of Blade article template | Laravel | Frontend
100 USD
Integration of Blade template for article | Laravel | Frontend Task Essence The site is built on Laravel. A ready HTML/CSS layout for a premium blog article page. It needs to be integrated into the existing Blade structure of the site. The design is ready. You are not designing… PHP, Web Programming ∙ 14 hours 46 minutes back ∙ 55 proposals |
Implementation of a technical SEO audit on OpenCartGood day. Need to implement technical SEO fixes on the site softugo.com. The site is already developed but not fully launched yet. Platform: ocStore 3.0.2.0 / OpenCart + custom code. Hosting: Hostinger. Current PHP version: 7.3. (transition to PHP 8.2 is planned) A checklist… PHP, Web Programming ∙ 16 hours 48 minutes back ∙ 50 proposals |
Execution of work after SEO audit
334 USD
An experienced OpenCart developer is needed to perform SEO and technical improvements for the online store. Main tasks: Correction of the internal linking structure and menu. Adding links to the footer. Implementation of breadcrumbs with Schema.org microdata. Fixing the… PHP, Website Maintenance ∙ 3 days 16 hours back ∙ 63 proposals |
Integration needed: KeyCRM → Cash Register KashalotIt is necessary to set up integration between KeyCRM and the Cash Register Kahalot. When placing an order in KeyCRM, the data must be automatically transmitted to Kahalot: • order information • products, nomenclature • prices • quantity More details in private. Content Management Systems, PHP ∙ 6 days 13 hours back ∙ 29 proposals |
A WordPress site using the Kadence theme and Kadence Blocks.
223 USD
We need to create a website on WordPress using the Kadence theme and Kadence Blocks. There will be no online store (although it may be added in the future). We need a homepage and several internal pages. The graphics are already prepared, the layout structure is mostly defined,… Content Management Systems, PHP ∙ 7 days 22 hours back ∙ 38 proposals |
Dnepr