Categories
View Replies (6)

Resolved Emptying VM database using csvi maintenance

  1. batetim
    batetim
  2. RO CSVI
  3. Wednesday, 11 February 2015
  4.  Subscribe via email
Hi Roland

Having problems using csvi to purge and empty virtuemart database

Using csvi 5.20
VirtueMart 3.0.2

On using this option get error message:

1146 Table 'a-jooml-lo.hal3m_virtuemart_product_relations' doesn't exist SQL=TRUNCATE TABLE `hal3m_virtuemart_product_relations`;

I want to purge the virtuemart database as i keep being advised of duplicate slug entries in the categories (even when i manually empty these vm category tables from my Mysql)

Any help would be greatly appreciated

Kind regards

Tim
0
Responses (6)
batetim
batetim
Accepted Answer Pending Moderation
Thanks Roland, thats done the trick.

Great service as normal!

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

My apologies, I missed some changes. They are included in the attached patch file.
Attachments (1)
patch_logs_20150213.zip
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. # 2
batetim
batetim
Accepted Answer Pending Moderation
Thanks Roland, have loaded that patch file, but afraid its still generating below error message when trying to clean temp folders

1054 Unknown column 'import_id' in 'where clause' SQL=SELECT CONCAT('.... my server address..../tmp/com_csvi/debug/com_csvi.log.', run_id, '.php') AS filename FROM hal3m_csvi_logs WHERE import_id > 0 GROUP BY import_id

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Thanks for letting me know about this issue also and sorry for the inconvenience. Attached is the patch file that fixes this problem.
Attachments (1)
patch_logs_20150212.zip
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. # 4
batetim
batetim
Accepted Answer Pending Moderation
Morning Roland, thanks for your quick response, that has resolved that.

Similar issue with using maintenance>CSVI Pro >Clean temp folder.

Throws up this error message:

1054 Unknown column 'import_id' in 'field list' SQL=SELECT CONCAT('....my server address...../tmp/com_csvi/debug/com_csvi.log.', import_id, '.php') AS filename FROM hal3m_csvi_logs WHERE import_id > 0 GROUP BY import_id

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

I see VirtueMart has removed this table. Attached is a patch file you can load and the Empty database will work again.
Attachments (1)
patch_maintenance_20150212.zip
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. # 6
  • Page :
  • 1


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