VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Rene.C on October 25, 2018, 13:46:42 PM

Title: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: Rene.C 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
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: GJC Web Design 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`;
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: Rene.C 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  :)
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: GJC Web Design 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
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: Rene.C 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
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: GJC Web Design 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
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: Rene.C 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
Title: Re: Erreur: 1054 Unknown column 'STsameAsBT' in 'field list'
Post by: GJC Web Design 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?