Author Topic: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'  (Read 876 times)

Rene.C

  • Beginner
  • *
  • Posts: 7
  • A beginner
Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« on: October 25, 2018, 13:46:42 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9194
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #1 on: October 25, 2018, 14:01:59 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Rene.C

  • Beginner
  • *
  • Posts: 7
  • A beginner
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #2 on: October 25, 2018, 16:39:20 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9194
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #3 on: October 25, 2018, 17:53:31 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Rene.C

  • Beginner
  • *
  • Posts: 7
  • A beginner
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #4 on: October 29, 2018, 22:03:30 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9194
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #5 on: October 29, 2018, 22:59:37 pm »
These errors sound like an unsuitable host ..   read here:  http://forum.virtuemart.net/index.php?topic=129343.0
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Rene.C

  • Beginner
  • *
  • Posts: 7
  • A beginner
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #6 on: October 30, 2018, 00:29:55 am »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9194
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
« Reply #7 on: October 30, 2018, 12:25:14 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation