Author Topic: *** 1054 *** Unknown column 'agreed' in 'field list'  (Read 282 times)

marvays

  • Jr. Member
  • **
  • Posts: 155
    • http://marvays.cz
  • Skype Name: marvays
*** 1054 *** Unknown column 'agreed' in 'field list'
« on: December 05, 2018, 12:46:12 pm »
My Virtuemart is ecstatic. One error after another. This time, there is an error in completing the order for the cart when the buyer is logged in to your account.

I noticed that the field list is agreed but not included in the basket. I created a new field, set the same. And this has already appeared in the basket. I first deleted the deal.

Now I have the second agreed, the buyer will mark it, but an error will occur while the order is finished.

When I shop as a guest, the order is finished but the order confirmation appears on a blank white page. Overwrite the entire site template.

Help.

VirtueMart 3.4.2
Joomla! 3.9.1
PHP 7.2.12
mysql 5.5.5-10.2.19-MariaDB-log

marvays

  • Jr. Member
  • **
  • Posts: 155
    • http://marvays.cz
  • Skype Name: marvays
Re: *** 1054 *** Unknown column 'agreed' in 'field list'
« Reply #1 on: December 05, 2018, 13:02:29 pm »
ERROR 1054 - Unknown column 'agreed' in 'field list' in /data/www/23045/lukysipy_cz/test/libraries/joomla/database/driver/mysqli.php:665

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1794
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: *** 1054 *** Unknown column 'agreed' in 'field list'
« Reply #2 on: December 05, 2018, 13:20:56 pm »
Seems that a migration has gone wrong. Try to create a new agreed user field, is used at checkout.

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

marvays

  • Jr. Member
  • **
  • Posts: 155
    • http://marvays.cz
  • Skype Name: marvays
Re: *** 1054 *** Unknown column 'agreed' in 'field list'
« Reply #3 on: December 05, 2018, 16:43:03 pm »
I just decided. I will post the whole eshop again. From zero. Clean. I only import products, categories, orders and customers.

I have questions:

1. In the coming days, will the new version of VM be? (if so, with production waiting for the new version)
2. Should i use jMigrator or copy tables from database via phpMyAdmin?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8556
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: *** 1054 *** Unknown column 'agreed' in 'field list'
« Reply #4 on: December 05, 2018, 20:07:00 pm »
Quote
Should i use jMigrator or copy tables from database via phpMyAdmin?

I just copy the site - update it by installing the vm latest and don't worry about whether it works or not but then u have a VM3 ready set of  products, categories, orders and customers.

Or if the versions are not too old ( you don't say) ...  just dump the products, categories, orders and customers tables in the new VM3 and run the table updater with fingers crossed
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

marvays

  • Jr. Member
  • **
  • Posts: 155
    • http://marvays.cz
  • Skype Name: marvays
Re: *** 1054 *** Unknown column 'agreed' in 'field list'
« Reply #5 on: December 06, 2018, 01:36:39 am »
Quote
Should i use jMigrator or copy tables from database via phpMyAdmin?

I just copy the site - update it by installing the vm latest and don't worry about whether it works or not but then u have a VM3 ready set of  products, categories, orders and customers.

Or if the versions are not too old ( you don't say) ...  just dump the products, categories, orders and customers tables in the new VM3 and run the table updater with fingers crossed

Today my website run on latest joomla and latest virtuemart. But all have many of errors. I developed this site two months. Make much changes. So . . . template I have build in page builder and i can export and import template. Pages too. When I can import product, categories, orders and users into new blank latest virtuemart website, 80% have done. last 20% are custm filter from breackdesign, Akeeba, sh404sef, jch optimize, jsn mobilize and jotCache. And I will feel good about doing everything right.