no phone column in uc_quote_product_locations

Project:Ubercart Contributions
Component:Code
Category:
Priority:normal
Assigned:Unassigned
Status:active
Description
Project: 
Ubercart

I just upgraded to Ubercart 1.0 Beta 7 and had to manually insert a column for phone in uc_quote_product_locations.

Version: 
beta7
bowwowadmin's picture
Offline
Bug FinderEarly adopter... addicted to alphas.
Joined: 12/09/2007
Juice: 70
Re: no phone column in uc_quote_product_locations

adding the phone table did not solve all the error

still getting:

user warning: Unknown column 'phone' in 'field list' query: uc_quote_nodeapi SELECT first_name, last_name, company, street1, street2, city, zone, postal_code, country, phone FROM uc_quote_manufacturer_locations WHERE tid = 0 in /home/macdsto9/public_html/bowwow/includes/database.mysql.inc on line 172.

Eric

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: no phone column in uc_quote_product_locations
Assigned to:bowwowadmin» Lyle

uc_quote_update_6() has the code to add that column to the location tables. You can select the version to upgrade to on the update.php page. Version 7 is just a compatibility issue with Postgres that shouldn't affect anything if it's done twice.

bowwowadmin's picture
Offline
Bug FinderEarly adopter... addicted to alphas.
Joined: 12/09/2007
Juice: 70
Re: Re: no phone column in uc_quote_product_locations
Assigned to:Lyle» bowwowadmin

what if I added the columns manually will that be bad or should I remove them and do the upgrade as you suggested. thanks for your reply Lyle.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Re: Re: no phone column in uc_quote_product_locations
Assigned to:bowwowadmin» Lyle

It'd be best to remove the columns just to prevent an error and so that you ensure that the column is set up the way Übercart expects.