New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Expected argument of type "object, array or empty", "string" given #11909
Comments
Hi @dritancami, Could you please try to replace the |
I can try, in the meantime I tried to redo what is indicated here http://forge.prestashop.com/browse/BOOM-5982?focusedCommentId=171708&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-171708 but did not solve the problem. |
@dritancami, yes because the exception is a different page. |
@dritancami, Could you please follow this link: https://github.com/PierreRambaud/phppsinfo
|
@dritancami, thanks for your feedback. |
Hi |
In Italian. Now I did the reverse test, I imported the "ps_configuration_lang" table from the ps in production to the one just installed 1.7.5 and the problem does not exist. |
I received this from my page: |
@dritancami, so your issue is fixed? |
Hi, |
No, it has not been solved. Summary, if I import the table of the clean installation in the db of the ps in production - the problem continues. If i import the table of ps in production in the db of the clean installation, the problem does not occur. |
@dritancami, could you please provide me the table ps_configuration_lang of your fresh installation (where the error occurs) |
It's the opposite, new installation = without problems, production = problems. |
Hi |
I attach the file |
@dritancami, @nuevoenesto Did you made an upgrade from a previous version PrestaShop? |
Here it is: |
Yes this a upgrade form PD 1.6 to 1.7 without error in the process |
The file |
Hi @dritancami, @nuevoenesto, Despite our several trials, I could not reproduce your issue with the provided information. |
YES!!!!!!! @rdy4ever have a good 2019 year! |
@nuevoenesto Great! HNY! |
SIMPLE SOLUTION TO TEST AND FIX THIS ERROR
You should have an equal number of rows with the number of each enabled language for each of the three queries. This is how the result looks like for a shop with 5 enabled languages.
(replace 1 with each of your language ids (id_lang) To fix missing (replace 1 with each of your language ids (id_lang) To fix missing (replace 1 with each of your language ids (id_lang) Also, if your table prefix isn't |
@dritancami INSERT INTO chy_configuration_lang (id_configuration, id_lang, value, date_upd) values ((select id_configuration FROM chy_configuration WHERE name = "PS_INVOICE_LEGAL_FREE_TEXT"), 1, "TEXT", NOW()); I put 1 and 2 as I assume that you have two enabled languages (with id's 1 and 2), but adjust the SQL if otherwise. I think it should fix it for you. |
@rdy4ever big thanks, this works!! |
Hi @rdy4ever , I run the query, but the problem is not solved: |
Could you export just the two tables (chy_configuration and chy_configuration_lang) as sql and attach them here? I’ll take a look and tell you exactly what sql’s you should run to fix the error.
Trimis de pe iPhone‑ul meu
Pe 29 dec. 2018, la 02:46, Dritan Cami <notifications@github.com> a scris:
… INSERT INTO chy_configuration_lang (id_configuration, id_lang, value, date_upd) values ((select id_configuration FROM chy_configuration WHERE name = "PS_INVOICE_LEGAL_FREE_TEXT"), 2, "TEXT", NOW());
Hi @rdy4ever , I run the query, but the problem is not solved:
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or mute the thread.
|
@dritancami INSERT INTO chy_configuration_lang (id_configuration, id_lang, value, date_upd) values ((select id_configuration FROM chy_configuration WHERE name = "PS_INVOICE_FREE_TEXT"), 1, "TEXT", NOW()); |
Hi, I run the query, but the problem is not solved.. |
Could you screenshot the stack trace after this sql? |
@dritancami |
@dritancami Please run this SQL one more time and screenshot the whole response page (I need to see the result for each of the 3 queries): SELECT * FROM chy_configuration_lang WHERE id_configuration = (select id_configuration FROM chy_configuration WHERE name = "PS_INVOICE_PREFIX"); |
@dritancami I see you still don't have "legal_free_text". Please run both of these SQLs: INSERT INTO chy_configuration_lang (id_configuration, id_lang, value, date_upd) values ((select id_configuration FROM chy_configuration WHERE name = "PS_INVOICE_LEGAL_FREE_TEXT"), 1, "TEXT", NOW()); |
@dritancami if it still doesn't work, you could just DROP |
Hurray, the problem is now solved! Thanks a lot @rdy4ever! Thanks - Thanks - Thanks!!! |
@dritancami Great! |
Describe the bug
Error 500 when I click on the invoice item in the backend menu.
To Reproduce
Steps to reproduce the behavior:
Screenshots
Additionnal information
Prestashop 1.7.5
The text was updated successfully, but these errors were encountered: