News:

Support the VirtueMart project and become a member

Main Menu

Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'

Started by Rene.C, October 25, 2018, 13:46:42 PM

Previous topic - Next topic

Rene.C

Hello,:)
Sorry i speak bad english.
I post here because we can not answer the post that talks about this subject (http://forum.virtuemart.net/index.php?topic=140960.0)
The solution dont work !  :'(
I have a big problem that has just appeared!
When clients click confirm the command appears error: 1054 Unknown column 'STsameAsBT' in 'list of fields' :(
I can not find anything on STameSBT in PHP Search .If we click on the migration tables in admin virtuemart. I end up with a 504 error.
How to make it happen and my customers can finally order?
Thanking you :)

René

Joomla! 3.8.13
VirtueMart 3.4.2
Hosting Mochahost.com

GJC Web Design

have u checked your table structure in the table ?

is the field STsameAsBT there

if not add it manually if your table updater wont work  ( normally a server problem)

if not present try this query .. backup first and change the prefix to yours

ALTER TABLE `xxxx_virtuemart_orders` ADD `STsameAsBT` TINYINT(1) NOT NULL DEFAULT '0' AFTER `ip_address`;
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

Rene.C

Hello GJC Web Design,  :)
Thank you for your SQL query.
Everything works properly and I hope it's the only table that has had a problem.
thanks again
Have a good day  :)

GJC Web Design

if u now run the vm3.4.2 again .. just from the installer ..  it should pick up/fix any missed table alterations

just install again this file:  http://dev.virtuemart.net/attachments/download/1143/com_virtuemart.3.4.2.9966.zip
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

Rene.C

Hello GJC Web Design,
Thank you for your post.
I apparently have other problem tables.
I tried to install the component but I have the logo joomloa that turns and does not stop. while another component is easy to install. I do not know what to do to fix that.
Do you think there is a solution?
thank you

GJC Web Design

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

Rene.C

Tahnk you
I think my configuration is good :
max_execution_time   600
memory_limit   512M
post_max_size   128M
upload_max_filesize   1G
Current PHP version:  7.2

I do not understand why it does not work

GJC Web Design

Clues:

1. 99%+ of users have no installation or update problems

2. On reports of this (and I have had experience of a host like this) changing the host was the solution

the other possibilities are in the other post ( do everything locally and transfer to the crappy host when finished) - but why?
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