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
Hello Tim,
I see VirtueMart has removed this table. Attached is a patch file you can load and the Empty database will work again.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
Hello Tim,
My apologies, I missed some changes. They are included in the attached patch file.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks Roland, thats done the trick.
Great service as normal!
Kind regards
Tim
Log in to reply to this topic.