Correct MySQL error after changing server
[Fri Jun 17 20:59:53.253937 2022] [proxy_fcgi:error] [pid 17308] [client 193.111.63.252:52068] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Exception: Error: Incorrect DATE value: ' 'Error No: 1525SELECT ps.price FROM oc_product_special ps LEFT JOIN oc_customer_group cg ON cg.customer_group_id = ps.customer_group_id WHERE ps.product_id = '120127' AND ps.customer_group_id = '2' AND ((date_start = '0000-00-00 ' OR date_start = '' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end = '' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 in /home/ admin/alphatorgstorage/modification/system/library/db/mysqli.php:43\nStack trace:\n#0 /home/admin/alphatorgstorage/modification/system/library/db.php(61): DB\\MySQLi- >query('SELECT ps.price...')\n#1 /home/admin/public_html/catalog/model/extension/module/cgp.php(13): DB->query('SELECT ps.price. ..')\n#2 /home/admin/public_html/catalog/model/extension/module/cgp.php(56): ModelExtensio
nModuleCgp->getCustomerGroupPrice('120127', '2')\n#3 /home/admin/alphatorgstorage/modification/system/engine/loader.php(248): ModelExtensionMod...',
At the moment it is not possible to enter the site control panel on Opencart. Also, product cards on the site itself do not work. That is some kind of problem with the database. Apparently….
It needs to be corrected so that the site works as it should again.
Client's review of cooperation with Dmytro A.
Correct MySQL error after changing serverFast and quality. Consulting on Interesting Matters
Freelancer's review of cooperation with Denis Kovalev
Correct MySQL error after changing serverEverything is clear, clear and clear. Current feedback and assistance. Fast payment, I recommend everyone to cooperate.
-
553 107 0 Hello, I'm ready to do your job, I have the necessary experience.
-
436 11 2 2 Good afternoon.
A lot of experience working with OpenCart. I'll fix it now.
With respect, Artham.
-
2617 427 9 1 решить проблему не сложно, обращайтесь
=- = -=- = -= -= -=- =- ==- = -=- = -= -= -=- =- ==- = -=- = -= -= -=- =- ==- = -=- = -= -= -=- =- =
-
12490 600 0 Hello, download the old site's database's dam into personal access to the hostel.
-
5773 264 0 Good afternoon, ready to make up for the mistake, I can do it right away.
Good afternoon, ready to make up for the mistake, I can do it right away.
-
3068 805 0 I can fix it, I'm married to an Open Card,
--------------------------------------------------------------------------------------------
-
13926 293 0 Good afternoon, specializing in Ophen cards, I'm gonna need you to fix everything quickly.
-
6455 267 1 3 Hello, I'm ready to
Write to L.S., specializing in Opencart.
-
Проверьте права на запись файлов, может там загрузка было от рута и надо под пользователя сделать.
-
спасибо за совет. Дело было не в этом)
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 17 hours 16 minutes back ∙ 13 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 2 days 16 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 3 days 3 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 6 days 10 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 8 days 14 hours back ∙ 61 proposals |