We are using:
J! 3.4.7
Yootheme (Avion)
MySQL ver. 5.6.27
php 6.6.17
JoomlaLMS 2.0.2
VirtueMart 3.0.12
If you have worked with V.M. you know it can be a pain and there is virtually no support. Clean install - category display gives us a
Error: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT cat.description FROM hnp37_categories cat WHERE cat.id=
We need help with V.M.
Please contact: jeff @ honeyager. com
Quote
virtually no support
Just what do you mean by that?
AFAIK VM 3.0.12 has not been tested with PHP6.6.17 so MySQL errors are a possibility. But the first step with such error is to try the tool "Install or if necessary update tables ".
Quote from: jenkinhill on December 24, 2015, 00:45:36 AM
Quote
virtually no support
Just what do you mean by that?
Got to agree with
Jenkinhill here... I have used VM since the early days on J1.0, and whenever I have had trouble, the response rate here has been very good, or the issue has already been fixed by someone.
I also sent you (jeffhoneyager) a mail yesterday on this issue, offering to attempt help.
Can you tell us a little more about the error?
maybe turn on debugging details so we can see where it is raised?
#__categories does not belong to VM. and from what i know (i have less than 1 year of experience with VM) so this must be something calling Joomla's article categories.
As I read the quick responses, I take back my mention of slow response - My first attempt with V.M. was in 2006. I can see the forum responses are much quicker and more accurate. Thank all of you for the effort.
QuoteAFAIK VM 3.0.12 has not been tested with PHP6.6.17 so MySQL errors are a possibility. But the first step with such error is to try the tool "Install or if necessary update tables ".
I tried this with no effect.
Any other ideas?
What is the latest version of php that V.M. was tested with?
Thank you.
Try turning off the cache.
I read somewhere that this can cause the problem you have.
(If that works, at least you know where the problem may stem from).
Quotephp 6.6.17
????
surely 5.6.x?
PHP 6.x Not released N/A Abandoned version of PHP that planned to include native Unicode support.
SOLVED
I had a SEO plugin installed that tried to read the contents the "currently displayed" article and dynamically create a meta tag description. When viewing V.M. there were no categories - so the plugin caused the error message.
Once the plugin was disabled - no problem.
Thanks for all the replies to help.