Categories
View Replies (8)

Resolved Import of multi language customfieldsforall is broken

  1. roderic
    roderic
  2. RO CSVI
  3. Friday, 17 June 2022
  4.  Subscribe via email
Hello,

Today I noticed that my template of importing multi language values for customfieldsforall is not working anymore. These are the errors I'm getting:

Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_en_gb`' doesn't exist
Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_de_de`' doesn't exist
Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_fr_fr`' doesn't exist

Seems like it's searching in the wrong table? Should be looking in xx_yy_virtuemart_custom_plg_customsforall_values_xx_xx.
Instead of #__virtuemart_custom_plg_customsforall_values_xx_xx

Tables do exist.

Only noticed it today but I assume this has been happening since 8.3.0.

Related?
https://rolandd.com/support/ro-csvi/customfields-multi-language-not-importing-for-all-languages


All other multi-language things still seem to work normally.


Cheers
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Thank you for posting the details. I was able to find the cause for the error and fix it. Please load the attached patch file and run the import and check.
Attachments (1)
patch_cf4all_2022_06_27.zip
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. # Permalink
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_en_gb`' doesn't exist
Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_de_de`' doesn't exist
Table 'xx_yy.`#__virtuemart_custom_plg_customsforall_values_fr_fr`' doesn't exist

Seems like it's searching in the wrong table? Should be looking in xx_yy_virtuemart_custom_plg_customsforall_values_xx_xx.
Instead of #__virtuemart_custom_plg_customsforall_values_xx_xx

I doubt if table prefix is a problem here as we are using Joomla code to replace table prefix in queries and in checking if table exists. Is there a test site where i can check these errors? Can you send me the administrator login details and (S)FTP details on Site detail tab?
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. # 1
roderic
roderic
Accepted Answer Pending Moderation
Hello Tharuna,

Sorry for late response. I have imported the template that gives the problems to the well-known test environment. There it gives the same error.

Update:
Forgot to mention the template name / ID: Vendit -> VM: Product Import - kenmerken (id 92) and Vendit -> VM: Product Import - kenmerken varianten (id 93)


Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
The site URL posted does not load for me and says Site can't be reached. Is there any IP address check for the site? Also the username and password for the site are missing in the details.
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
roderic
roderic
Accepted Answer Pending Moderation
Good morning,

That's weird. There are some IP's from India on the firewall blacklist, just removed them. Can you try again? I added the username, I don't know the password. You have logged in to this test site many times :)

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Good morning Roderic,
Site link worked now and the login too. Tried import with the templates you mentioned. I could see the error table does not exists. Can you please send me (S)FTP details? Need to check the database tables and the code on where it breaks.
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
roderic
roderic
Accepted Answer Pending Moderation
Hello Tharuna,

FTP details added.

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 6
roderic
roderic
Accepted Answer Pending Moderation
Hello Tharuna,

Thanks for the fix. The import now runs without error.


Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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