News:

Looking for documentation? Take a look on our wiki

Main Menu

V.M. Consultant Needed

Started by jeffhoneyager, December 23, 2015, 19:13:21 PM

Previous topic - Next topic

jeffhoneyager

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
Peace & Joy,
Jeff Honeyager
...using VirtueMart since 2006
http://jeff.honeyager.com

jenkinhill

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 ".
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Nilsy

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.

welrachid

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.
Best regards,
Wel

jeffhoneyager

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.
Peace & Joy,
Jeff Honeyager
...using VirtueMart since 2006
http://jeff.honeyager.com

Nilsy

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).

GJC Web Design

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.
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

jeffhoneyager

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.
Peace & Joy,
Jeff Honeyager
...using VirtueMart since 2006
http://jeff.honeyager.com