1. fatelettronica
  2. RO CSVI
  3. Friday, 03 December 2021
  4.  Subscribe via email
Hello
yesterday I upgraded to 8.0.0. Today I go to export with csv file the products to be published in google merchants and here is an error screenshot.
See Attachment.
There is also an error with SQL
How is it resolved?
Greetings
Attachments (2)
Accepted Answer Pending Moderation
Hello,

Are you sure only RO CSVI is upgraded? This is an error generated by your database which requires you to specify all the fields to group by in your export template. This is something that is controlled by the database not by RO CSVI.

There are 2 options:

  1. Contact your hosting provider to turn off the database setting only_full_group_by
  2. Edit your template and go to the Fields tab. In the Group By section, add all the fields that needs to be grouped by. In the order of most important to least important.
Once the database is satisfied with the group by fields, the export will run.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello
For a template I solved it by adding a group of fields, just like the fields to export. See screenshot.
For another template I did the same thing but it doesn't work, same error is like without adding a group of fields.
I write to the provider.
Greetings
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
For another template I did the same thing but it doesn't work, same error is like without adding a group of fields.

The field which is shown in the error is added to group by fields? Try to put that field as first in order of Group by fields and see if it makes any difference.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Helo
I'll rewrite the Testider's answer.
"Dear customer, I inform you that the Sql1587405 database is of MySQL 5.7 version, in this version the following sql_mode have been set by default:

ONLY_FULL_GROUP_BY
STRICT_TRANS_TABLES
NO_ZERO_IN_DATE
NO_ZERO_DATE
ERROR_FOR_DIVISION_BY_ZERO
NO_AUTO_CREATE_USER
NO_ENGINE_SUBSTITUTION

which cannot be disabled on the machine side.

[b] To solve the problem, you need to disable these code-side functions. [/ b]

The syntax to use to disable all sql_mode is:

set session sql_mode='';


This instruction must be put in all the points where it creates the connection with the MySQL (after the connection instruction).

Here is a code example:

$con = mysqli_connect($host,$user,$password,$databasename);

mysqli_query($con, "set session sql_mode='';";);


As noted above, deactivation cannot be done on the server side. "

It seems clear to me

How can I go back to version 7.20.0 only when you don't make it up to 8.0.0?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
We do not read or understand Italian so we request you to post your answers in English.

Come indicato in precedenza la disattivazione non può essere effettuata lato server."

This setting cannot be set in code as database connection is handled by Joomla and not by RO CSVI.

Come posso tornare alla versione 7.20.0 siano a quando non rendi funzionante al 8.0.0?

We would recommend you to backup your templates and follow the instructions in Uninstall CSVI document to uninstall RO CSVI 8.0.0 version. You can then install RO CSVI 7.20.0 version.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Helo
This is the error generated by the export template.
Although a grouping is being created.
There is no field name in the error

Status error: 200
Status message: OK
{"process":false,"url":"https:\/\/http://www.fatelettronica.it\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=28622"}

In another template I created a grouping with the same fields in seriti in the teplete and it works with this one it doesn't work.
Which fields should I put in the grouping, All ??

Gretings

Lorenzo
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Lorenzo,
Status error: 200
Status message: OK
{"process":false,"url":"https:\/\/http://www.fatelettronica.it\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=28622"}

There is no information on error in this message. We do not know if this is even caused because of grouping. Can you check the document Using Firefox Web Console to analyze problems to get some information on the error? Post it here to check.

In another template I created a grouping with the same fields in seriti in the teplete and it works with this one it doesn't work. Which fields should I put in the grouping, All ??

You don't have to put all the fields in grouping. Try only with the fields added as export fields. Do you see the same SQL error with this template like you saw in the another template?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Lorenzo,

When you get the error on export and you go back to the templates list, do you see an error message there?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Helo
I have already sent you attached the errors I encountered in the export. see screenshot.
Now I can't waste time testing with version 8.0.
I uninstalled 8.0 and went back to 7.2.
I can't waste time with testing. I have to manage an e-commerce with over 20,000 items and every day I have to operate without problems.

I wait until you have solved the problems of the new version.
Greetings
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Lorenzo,
Please send us the template XML to check. We can run the export on our test server and see if we can reproduce the error. To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the export template and download the XML file. Post the XML file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi.

After update similarly, the following error occurs.

I can't deal with it right now; I will try I will uninstall 8.0.0 and install 7.20.0.

i will wait for update

Best Regards

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mutfakme_mumerkezi2.xyce7_virtuemart_product_categories.virtuemart_category_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


Joomla! version 3.10.3
VirtueMart 3.8.8 10472
mysql 5.7.36
PHP version 7.4.26
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,

Any update of RO CSVI will not fix the issue as you need to add the field category_id, category_path, or category_name to the list of grouped fields. This is not a restriction or something of RO CSVI but it is the database telling you. As you can see in the error, your database has been set to use the full group by. It is in the error message that you see:
this is incompatible with sql_mode=only_full_group_by
The message also tells you which column is missing.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello
Sorry but the DB asks for the fields grouped only with version 8.0.0? With version 7.2.0 there is no need to create the field group. Why make these changes?
Not only that, but you have distorted all the graphics, why do I have to go to the template table and look for the template? Before, in the templete bar I wrote the initials and immediately the searched template appeared.
New versions do not always lead to improvements and must also be tested well.
Greetings
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,

Sorry but the DB asks for the fields grouped only with version 8.0.0? With version 7.2.0 there is no need to create the field group. Why make these changes?
Actually we did not make any such specific change. As I mentioned before, this is not a limitation that we require but rather one that the database require. The problem with the group by is that end users have no idea that the database is doing the grouping for them by guessing what you want to group. This is the behavior you see in RO CSVI 7. Since MySQL 8, the MySQL team has said, you must tell us how you want to group, we will no longer guess how to do it. That is controlled by the sql_mode=only_full_group_by setting. All I can think of is that the database driver in Joomla is somehow ignoring this setting if that is even possible. That is something I am going to see if I can find out why or how that happens. Although I am of the opinion that if the configuration of the server says only_full_group_by that must be respected by the code.

Not only that, but you have distorted all the graphics, why do I have to go to the template table and look for the template?
Actually you do not have to go to the template table, usually you are already there. If you have some template you use more than others just drag them to the top and they will be shown at the top of the list and you can click on the Run button.

New versions do not always lead to improvements and must also be tested well.
I of course agree with that. So far the feedback is that users like the Run button on the list and when you edit a template.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Lorenzo,

As promised I would look into the difference with RO CSVI 7 and RO CSVI 8 in regards to the error you see. My findings are that Joomla is indeed turning off strict mode as imposed by your database settings. This is the reason why you do not see the error in RO CSVI 7.

In the upcoming release of RO CSVI, we are now also turning off strict mode so you will no longer see the message that you should set a group by.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,

I also had to change the database settings for every database for multiple websites to specifically allow 127.0.0.1 to connect. There were more database issues with several templates on several websites. But I was able to fix them all and I suppose that only makes things more stable in the end. Turning it off maybe throws up other problems but if it doesn't, it could also save time when you do not have to fix issues that are not really an issue. Not sure what's best in the long run.

My .2 cents
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,

I also had to change the database settings for every database for multiple websites to specifically allow 127.0.0.1 to connect.
You mean you had to set the database host to 127.0.0.1 instead of localhost?

Turning it off maybe throws up other problems but if it doesn't, it could also save time when you do not have to fix issues that are not really an issue. Not sure what's best in the long run.
Turning it off is what Joomla is doing, so if it causes other problems these would be visible with Joomla as well. The plan for now is to change the setting to an option later on where by default it is turned off. So users can decide for themselves which mode they want to use.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Good morning,

You mean you had to set the database host to 127.0.0.1 instead of localhost?

In Plesk I had to change the below setting from the first option to the third:
localhost.jpg

This was only an issue after updating to 8.0.0 and then running an import/export.

Turning it off is what Joomla is doing, so if it causes other problems these would be visible with Joomla as well. The plan for now is to change the setting to an option later on where by default it is turned off. So users can decide for themselves which mode they want to use.


Sounds good. My XML import sometimes stopped because of a duplicate ID. Had to delete a product first before it was able to successfully complete the import. I don't think this was an issue before 8.0.0. So let's see if this problem is now gone as well.

Cheers
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 18
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!