Hi Guys
Hoping someone could help me with what went wrong as I came across the error below when trying to access the VM Shop page in the backend. I couldn't figure out why so decided to do a restore to 3 days back but the error still happened. I'm not sure if the error is going back that far or if something has went wrong with the database which isn't restoring correctly. When I go into phpmyadmin it nearly looks like I have duplicates of the almost same database, but not identical.
I can access anything else in the website front and back but haven't finished configuring shipping and payment yet. I searched for the same error but could not find anything that resolved the same issue.
An error has occurred.
1146 Table 'database_user.dbname_virtuemart_userfield_plg_realex_hpp_api' doesn't exist SQL=SELECT * FROM `dbuser_virtuemart_userfield_plg_realex_hpp_api` WHERE `virtuemart_user_id` = "516" ORDER BY `modified_on` DESC
VM 3.0.8
Joomla 3.4.1
Thanks for any help
FP
That error is from a Realex plugin, so I guess the first step is to disable that plugin, and then ask the plugin developer?
Thanks for the reply Jenkinhill
Yes disabling the plugin does cure the problem but I don't think its a problem with the actual plugin I'm thinking it a screw up with the database. Realex is part of VM now and works fine with another couple of site I'm working on. Why I have the contents of like 2 databases I have no idea but one has realex and one hasn't. I'm going to try and copy across the realex tables to see what happens, although I have no real clue about how databases work so I'd say I'll be reverting to a backup again ::)
Thanks
I think alatak did the development for the inbuilt plugin. I have never used it on any of my client sites.
The table of the plugin is setup while AIO installation, usually. You can use the update butttin within the AIO to update/install the tables.
The table should be also updated/installed, when you store a paymentmethod.
For your root problem (almost doubled dbs), we cant know, what you did with your page.
Hi Milbo
I did a restore of an older backup which seems to have straightened up the duplicate database mystery, but the problem with realex persists. I updated to VM3.0.9 also AIO and tcpdf (in that order). Now that you mentioned the AIO, I then went to go into the AIO to click the update button but get "404 Component not found." The same error for tcpdf. I usually don't go in here so don't know what the normal is.
On another VM2.6.14 site I can access the update AIO button ok but another VM3.0.8 which does not have any errors I cannot access the AIO button either. Should AIO act this way?
I have updated an old ticket that was previously resolved by Valerie at alatak to ask would she have any ideas but haven't heard back yet. I have also notified Realex themselves but don't think they are the developers so not sure how much help they can be.
Here is much the same error when I try to access user "Account Maintemance" front end
Table 'database_user.dbname_virtuemart_userfield_plg_realex_hpp_api' doesn't exist SQL=SELECT * FROM `prefix_virtuemart_userfield_plg_realex_hpp_api` WHERE `virtuemart_user_id` = "527" ORDER BY `modified_on` DESC
Hello
I have checked, and you are rigth, it looks like the table xxx_virtuemart_userfield_plg_realex_hpp_api on VM3 has not been created.
I am checking why
Meanwhile you can create it:
CREATE TABLE IF NOT EXISTS `yourprefix_virtuemart_userfield_plg_realex_hpp_api` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`virtuemart_user_id` int(1) unsigned DEFAULT NULL,
`merchant_id` varchar(128) DEFAULT NULL,
`realex_hpp_api_saved_pmt_type` varchar(20) DEFAULT NULL,
`realex_hpp_api_saved_pmt_ref` char(50) DEFAULT NULL,
`realex_hpp_api_saved_pmt_digits` varchar(128) DEFAULT NULL,
`realex_hpp_api_saved_pmt_expdate` varchar(16) DEFAULT NULL,
`realex_hpp_api_saved_pmt_name` char(255) DEFAULT NULL,
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Userfield Realex Realvault Table'
Hello
Can you try with this file
replace it here:plugins/vmpayment/realex_hpp_api/realex_hpp_api.php
Hi
I have looked at creating the table mentioned but I have no idea on how to do this. You have gave a list of values but I don't know where to put them.
I have however downloaded the file you attached and uploaded to my server but it has made no difference, this may be due to the missing table again. Can you explain more on how to create the table.
Thanks
FP
Open your database in phpMyAdmin
(at this point I would download a copy of the current db for use as a backup by selecting Export and Go)
Select SQL
Copy and paste the table code from alatak into the textbox
Hit Go
YOu should then get confirmation and can exit phpMyAdmin.
Thanks Jenkinhill
I'm not sure where the textbox is you mention but took a guess and selected the SQL tab at the top and found what I think is a textbox. I copied the code from alatak and pasted it in here, hit Go and it gave me this 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 '`myprefix_virtuemart_userfield_plg_realex_hpp_api` ( `id` int(11) unsigned NOT NU' at line 1
Hello
Take the file i gave you, and save your payment method once. It will create your table automatically.
Hi Valerie, thanks for your help
I have tried this again but no luck. I deleted the payment method too and re-created it again to see if that made a difference but did not work. I'll PM login details if you want to have a look in the backend etc..
Thanks
FP
Hello
QuoteI'll PM login details if you want to have a look in the backend etc..
yes please
it should have worked
I have resent them Valerie, let me know if you don't get them.
Thank you :)
hello fastpat27
thank you for the credentials.
I have fixed your problem
I will check again if the table is created on my test environment.
Hi Valerie
Thanks so much for your help, this was putting me under severe pressure from the client and Realex themselves did nothing to help. Think they'll be getting an email >:(
Was there something I did wrong or was it just something corrupt?
Thanks
FP
Thanks alatak. The SQL did the job!
I have been facing the same error but now not any more. This is a great help to sort that out.
Hi Valerie
I have just migrated an ecommerce website to a new server but it is giving problems with payments via the realex plugin again. Realex are telling me there is no response URL defined on the account which is causing the error, but from what I remember the plugin now doesn't require a response url, it is automatically generated with the plugin.
Can you help please, 3 sites sitting like this at the moment.
Thank you
FP
Hello
Quotethe plugin now doesn't require a response url, it is automatically generated with the plugin.
yes it is correct. That URL is generated by the plugin.
But there is a refering URL which must be set by Realex.
The refering URL is the one that will redirect the client to the payment page.
The response URL is the one that from the payment page redirects the client back to VM.
When do you have the problem?
The problem was when a customer placed an order and the payment gave the customer a problem report. see attached. Then perhaps the payment remained at pending in VM sometimes, and sometimes it was confirmed.
We have the problem now resolved, one site we think had a corrupt file perhaps during the transfer to the new server. The other sites I believe to be slow DNS propagation (over 5 days) causing the IP address or URLs to conflict with what Realex had setup. Again I'm only guessing as I'm not an expert on these things.
I got this error in VirtueMart 3.0.12:
1146 Table 'DB2351975.do3dx_virtuemart_vendors_nl_nl' doesn't exist SQL=SELECT `do3dx_virtuemart_vendors`.* ,`do3dx_virtuemart_vendors_nl_nl`.* FROM `do3dx_virtuemart_vendors` INNER JOIN `do3dx_virtuemart_vendors_nl_nl` using (`virtuemart_vendor_id`) WHERE `do3dx_virtuemart_vendors`.`virtuemart_vendor_id` = "1"
I did a new install on Joomla 3.4.5. Joomla functions good.
Please tell us your language setup, which language are set in vm, which in joomla.
And in which view, or action you get the error?
The administrator is in English, the frontend is in Dutch. Getting the error in the administrator. Wasn't able to set the language in vm as I kept getting the error. I only just installed it.
Hi Alatak,
We are using your realex payment plugin, you have mentioned that the plugin generates the merchant response URL from within itself. Can you point me to the specific code that generates this response URL, as i want to hard code it to use a non HTTPS url.
To cut a long story short, Realex have recently introduced an upgrade to TLS1.2, we use cloudflare and have found that the cyper suites realex and cloudflare use to not work with each other, so I am trying to find a way to force the reponse url to to be no encrypted.
Thanks in advance for your help on this matter.