Errors saving shipment and payment configs

Started by gringo211985, August 16, 2014, 14:36:05 PM

Previous topic - Next topic

GJC Web Design

weird error  - I have been working all week on 2.9.9 ship plugins and the tables always create fine for me

they are created in administrator/components/com_virtuemart/plugins/vmplugin.php and the prim key is set

see around line 433  function createTableSQL()   - its called on the 1st store of a method

ends

$query .= "         PRIMARY KEY (`id`)
       ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='" . $tableComment . "' AUTO_INCREMENT=1 ;";
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

alopmar

Hi again, I opened the file vmplugin.php and it is as you say, the PRIMARY KEY (`id`) is present, but still having the same error when saving the first shipping method. The SQL statement does not include it and it fails.


alopmar

Reinstalled VM 2.9.9a again, for the third time yet, the error is no longer shown. It may have been incorrect installation or could it be some kind of cache or update issue?
Thanks again

gringo211985

Glad to see that this is being looked into now, do you guys have any idea how frustrating it is to be told "no we wont look into it" when it was clearly a genuine bug. I felt very let down guys, as I was trying to help.