Shop / e-Commerce Integration

[Solved] Error after VM-checkout

  • Justin Post
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 3 months ago - 12 years 2 months ago #1 by Justin Post
[Solved] Error after VM-checkout was created by Justin Post
Hi,
I'm working on a site that sells courses from virtuemart. I've coupled Moodle and Virtuemart with eachother, but get an SQL error after the payment. Two tables don't exist (since they start with _vm instead of _virtuemart). Does anybody know where to find this code and how to fix the problem?

Kind regards,

Justin Post

EDIT: The error is:
DB functie is mislukt met het volgende foutnummer 1146
Table '*_main.ys1_vm_product_type' doesn't exist SQL=SELECT product_type_id from ys1_vm_product_type where product_type_name='Course'
DB functie is mislukt met het volgende foutnummer 1146
Table '*_main.ys1_vm_order_item' doesn't exist SQL=SELECT * FROM ys1_vm_order_item WHERE order_id ='25'

It seems that the 'old' code for VM1 is used instead of VM2. I however can't find where it happens.
Last edit: 12 years 2 months ago by Antonio Durán.
The topic has been locked.
More
12 years 3 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic [Solved] Error after VM-checkout
That is weird. What Joomla and Joomdle versions are you using? No one has reported a similar problem before.
The topic has been locked.
  • Justin Post
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 3 months ago - 12 years 3 months ago #3 by Justin Post
Replied by Justin Post on topic [Solved] Error after VM-checkout
Joomla 2.5.16
Joomdle 0.94

EDIT: I've fixed the error, turned out that some different code pointed to the wrong method :dry:. Now everything works, exept that the user isn't enrolled in Moodle after purchase.
Last edit: 12 years 3 months ago by Justin Post.
The topic has been locked.
More
12 years 3 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic [Solved] Error after VM-checkout
Can you explain it more? Do you mean that normal Joomdle code was not working right?
The topic has been locked.
  • Justin Post
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 2 months ago #5 by Justin Post
Replied by Justin Post on topic [Solved] Error after VM-checkout
While developing I've made a mistake that involked the wrong code. This is the reason of the error :(. The enrollment wasn't working because there was no defined "courses" category (since all product are courses). But this is fixed as well. Thanks for the support!
The topic has been locked.