Categories
View Replies (6)

Resolved Orphan records stored in the database

  1. cmolik
    cmolik
  2. RO CSVI
  3. Wednesday, 12 January 2022
  4.  Subscribe via email
I am solving the following problem. I have some orphan records stored in the database (products that cannot be found in the VM, but are in the DB).
I need to delete them. I exported them from DB, I have their virtuemart_product_id. I would like to import a table with the universal product_name "DELETE" via RO CSVI and then delete it in the VM.

The import based on virtuemart_product_id succeeds, but the names do not change and the products in the VM still cannot be found.

You can advise me?
Thanks a lot.
DC
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Debug log shows that product has been deleted. See the attached screenshot with delete queries from debug log. The csv files you sent in your previous reply has sist_ as prefix, is that Joomla database table prefix? I am asking this because the table prefix in the queries in debug log is ss_ so just want to make sure you are looking at right tables.
Attachments (1)
Screenshot 2022-01-13 at 5.27.27 PM.png Screenshot 2022-01-13 at 5.27.27 PM.png
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 (6)
cmolik
cmolik
Accepted Answer Pending Moderation
Thank you very much for your help.
I'm embarrassed, but I really looked at the old database. The products are also visible as standard in the VM.

Thanks again for the great support!
  1. more than a month ago
  2. RO CSVI
  3. # 1
cmolik
cmolik
Accepted Answer Pending Moderation
Debug log in the attachment
Attachments (1)
com_csvi.log.2313.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please send the debug log of the import. To get the debug log check How to collect debug information? document.
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
cmolik
cmolik
Accepted Answer Pending Moderation
Hello,
Thank you for the quick reply. Unfortunately, it doesn't work.
I tried it on one product.

Import OK - "Product deleted"
I will find it in the database again in 2 tables (I did not look for more).

I send the tables in the attachment

Best regards
DC
Attachments (2)
sist_virtuemart_products.csv
sist_virtuemart_products_cs_cz.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Use fields virtuemart_product_id and product_delete with value set to Y in import file so to delete the products in VirtueMart using RO CSVI import. Let me know if that solves your issue.
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
  • Page :
  • 1


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