Author Topic: Error 1146  (Read 3343 times)

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Error 1146
« on: June 14, 2015, 02:32:34 am »
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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 25258
  • On vacation
    • Jenkin Hill Internet
Re: Error 1146
« Reply #1 on: June 14, 2015, 10:29:50 am »
That error is from a Realex plugin, so I guess the first step is to disable that plugin, and then ask the plugin developer?
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

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

Currently using VM3.0.18.8 on Joomla 3.6.5 PHP 7.0.12

Testing VM3.0.18.9 On J!3.6.5

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #2 on: June 14, 2015, 14:15:08 pm »
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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 25258
  • On vacation
    • Jenkin Hill Internet
Re: Error 1146
« Reply #3 on: June 14, 2015, 15:59:39 pm »
I think alatak  did the development for the inbuilt plugin. I have never used it on any of my client sites.
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

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

Currently using VM3.0.18.8 on Joomla 3.6.5 PHP 7.0.12

Testing VM3.0.18.9 On J!3.6.5

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 8493
  • VM3 ready to take off
    • VM2 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Error 1146
« Reply #4 on: June 15, 2015, 15:11:45 pm »
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #5 on: June 15, 2015, 16:13:41 pm »
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


alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 1995
    • alatak.net
Re: Error 1146
« Reply #6 on: June 19, 2015, 11:28:27 am »
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'

alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 1995
    • alatak.net
Re: Error 1146
« Reply #7 on: June 19, 2015, 12:01:32 pm »
Hello
Can you try with this file
replace it here:plugins/vmpayment/realex_hpp_api/realex_hpp_api.php

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #8 on: June 21, 2015, 14:44:05 pm »
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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 25258
  • On vacation
    • Jenkin Hill Internet
Re: Error 1146
« Reply #9 on: June 21, 2015, 16:53:17 pm »
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.
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

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

Currently using VM3.0.18.8 on Joomla 3.6.5 PHP 7.0.12

Testing VM3.0.18.9 On J!3.6.5

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #10 on: June 21, 2015, 17:38:07 pm »
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


alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 1995
    • alatak.net
Re: Error 1146
« Reply #11 on: June 23, 2015, 10:11:38 am »
Hello
Take the file i gave you, and save your payment method once. It will create your table automatically.

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #12 on: June 23, 2015, 20:17:57 pm »
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

alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 1995
    • alatak.net
Re: Error 1146
« Reply #13 on: June 24, 2015, 17:37:14 pm »
Hello
Quote
I'll PM login details if you want to have a look in the backend etc..
yes please
it should have worked

fastpat27

  • Jr. Member
  • **
  • Posts: 98
Re: Error 1146
« Reply #14 on: June 24, 2015, 17:58:23 pm »
I have resent them Valerie, let me know if you don't get them.

Thank you :)