29 replies [Last post]
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422

Yep, those letters just keep on climbing. We've got 21 to go before we run out of characters, but as always... we're not planning on any more minor releases until Alpha 8. If a bug makes a new release necessary, I won't hesitate to wield my f.

Details on the release may be found in this news post. Mostly minor bug fixes but the addition of a core system to handle product features on a per product basis is quite exciting. Hopefully some core modules will take advantage of it come Alpha 8.

Until then... it's back to work. Cool

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Alpha 7e Released

Ryan - if we haven't run the 7d upgrade yet, should we do that before going to 7e?

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Alpha 7e Released

Not necessary. All previous updates will be applied when you update to the latest version. Smiling

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Re: Alpha 7e Released

I have an issue. I'm using CPiLL's File Product module, and that seems to cause an error during the final checkout stage. I can review the order, etc., and everything else works fine. But when I click "Submit order" and the cart goes to /checkout/complete, I get a white screen.

Disabling the File Product module fixes this, so it's obvious that's where the issue lies.

The only UC hooks being implemented in the module are hook_cart_item and hook_order. This actually started happening with 7d. I didn't see anything in your release notes that would signify a large change to the way those hooks work, or anything that jumped out at me as causing the error. Any ideas?

--
Help directly fund development: Donate via PayPal!

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Re: Re: Alpha 7e Released

Yeah, the problem is his use of the old order status system. A simple fix would be to change this:

<?php
 
if ($status == uc_get_order_status_id('post_payment'))
  {
?>

To this:

<?php
 
if (uc_order_status_data($status, 'state') == 'completed') {
?>

That should handle completed orders the same.

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Re: Re: Re: Alpha 7e Released

You know I was looking at that line but wasn't quite sure how to change it. Your change worked as expected. Thanks Uberdude!

--
Help directly fund development: Donate via PayPal!

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Re: Re: Alpha 7e Released

Clean upgrade here - no issues so far.

Nice work guys.

Tanjerine's picture
Offline
Bug FinderInternationalizationizerNot KulvikThe other woman.
Joined: 08/31/2007
Juice: 233
Re: Re: Re: Re: Re: Re: Re: Alpha 7e Released

had a very clean upgrade from 7d to 7e. no problems...yet. Ü

zmove's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.Internationalizationizer
Joined: 08/13/2007
Juice: 1192
Re: Re: Re: Re: Re: Re: Re: Re: Alpha 7e Released

I had the folowing error when update the database with the drupal update routine :

user warning: Table 'dp_content_type_product_kit' already exists query: ALTER TABLE dp_content_type_kit RENAME TO dp_content_type_product_kit in \drupal\includes\database.mysqli.inc on line 151.

I tried to update alpha7d to alpha 7e

Boletus's picture
Offline
Joined: 09/09/2007
Juice: 115
A limerick

A Swede contributed in smaller
He was known as the forum holler
In versions we get
Überdudes don't forget
To update the Überinstaller

Eye-wink

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: A limerick

@Boletus - gave me a good laugh. Eye-wink I think the Uberinstaller automatically uses the latest version on Drupal.org, but Shawn will stay on top of it.

somatics's picture
Offline
Joined: 08/18/2007
Juice: 121
Error in product kit while upgrading to 7e

I got this error while upgrading to 7e - when I ran the update routine from Drupal modules.

Can anyone tell me (a) why (b) what kind of problem will this cause (c) how do I fix it?

Thanks in advance..

user warning: Table 'mydatabasename.content_type_kit' doesn't exist query: ALTER TABLE content_type_kit RENAME TO content_type_product_kit in /web/docs/drupal/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'taxonomy_theme_nodetype|casetracker_basic_projec' for key 1 query: INSERT INTO variable (name, value) VALUES ('taxonomy_theme_nodetype|casetracker_basic_project', 's:8:\"somatics\";') in /web/docs/drupal/includes/database.mysql.inc on line 172.
The update process was aborted prematurely while running update # in .module. All other errors have been logged. You may need to check the watchdog database table manually.

Main page
Administration pages
The following queries were executed

uc_product_kit module

Update #4
Failed: ALTER TABLE {content_type_kit} RENAME TO {content_type_product_kit}

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6841
Re: Error in product kit while upgrading to 7e

So far, all the problems about the content_type_kit table look to be harmless. This is either because the table didn't exist, or content_type_product_kit already existed. Either way, CCK should work with the product_kit node type.

somatics's picture
Offline
Joined: 08/18/2007
Juice: 121
Lyle, I looked at my

Lyle,

I looked at my database, thinking from some posts from Lyle and Ryan that my database already had the content_type_product_kit table -- but, the table is still named content_type_kit -- there is no table named content_type_product_kit

Are you sure this isn't going to cause problems? Shouldn't I rename the table to content_type_product_kit ?

If so, what other changes should I make to any records in any other tables?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6841
Re: Lyle, I looked at my

Yeah, just rename that table if that's the only part that messed up during update.

Nick's picture
Offline
Joined: 08/17/2007
Juice: 95
Re: Re: Lyle, I looked at my

Ran into this problem when updating

* user warning: Unknown column 'notify' in 'uc_order_statuses' query: ALTER TABLE uc_order_statuses CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '' in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Duplicate column name 'weight' query: ALTER TABLE uc_order_statuses ADD weight MEDIUMINT(9) NOT NULL in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Duplicate column name 'locked' query: ALTER TABLE uc_order_statuses ADD locked TINYINT NOT NULL DEFAULT '0' in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Table 'demetech_webpage.content_type_kit' doesn't exist query: ALTER TABLE content_type_kit RENAME TO content_type_product_kit in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
The following queries were executed
uc_paypal module
Update #1

    * ALTER TABLE {uc_order_statuses} CHANGE order_status_id order_status_id VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
    * ALTER TABLE {uc_order_statuses} CHANGE title title VARCHAR(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
    * Failed: ALTER TABLE {uc_order_statuses} CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
    * Failed: ALTER TABLE {uc_order_statuses} ADD weight MEDIUMINT(9) NOT NULL
    * Failed: ALTER TABLE {uc_order_statuses} ADD locked TINYINT NOT NULL DEFAULT '0'
    * DELETE FROM {uc_order_statuses} WHERE order_status_id LIKE '_'
    * INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('paypal_pending', 'PayPal pending', 'payment_received', 7, 1);

uc_product module
Update #9

    * CREATE TABLE {uc_product_features} ( `pfid` mediumint(9) NOT NULL default 0, `nid` mediumint(9) NOT NULL default 0, `fid` varchar(32) NOT NULL, `description` text, PRIMARY KEY (`pfid`), KEY nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;

uc_product_kit module
Update #4

    * Failed: ALTER TABLE {content_type_kit} RENAME TO {content_type_product_kit}

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Re: Lyle, I looked at my

The failed alter queries are either from duplicate updates (a just in case thing w/ PayPal and order statuses) or something weird the the product kit update. I believe they're inconsequential, but let us know if the site doesn't function properly.

psynaptic's picture
Offline
Early adopter... addicted to alphas.Not KulvikTheminator
Joined: 08/28/2007
Juice: 731
Re: Re: Re: Re: Lyle, I looked at my

I've just run the alpha7e update and when I go to checkout it throws out this error:

Fatal error: Call to undefined function: uc_cart_checkout_new_pane() in /htdocs/candmflowers/sites/all/modules/ubercart/uc_quote/uc_quote.module on line 721

Any ideas what might have gone wrong here?

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Re: Re: Re: Lyle, I looked at my

I think the problem is the file structure has changed so the new uc_quote.module is actually in a shipping subdirectory. Just delete the /ubercart/uc_quote directory and it should work. While you're at it, you should look through the payment and shipping subdirectories and remove any duplicates from the root Ubercart directory.

psynaptic's picture
Offline
Early adopter... addicted to alphas.Not KulvikTheminator
Joined: 08/28/2007
Juice: 731
Re: Re: Re: Re: Re: Re: Lyle, I looked at my

Hey Ryan, I did notice that the file structure had changed so deleted the contents of the ubercart directory and replace with fresh code from bazaar. Once this had been done more errors started popping up (i.e. table uc_products doesn't exist). To completely resolve the problem I simply needed to truncate the cache tables. I'm posting here because it took me a while to figure that out!

oslinux's picture
Offline
Joined: 09/06/2007
Juice: 461
Re: Re: Re: Re: Re: Re: Lyle, I looked at my
raddy's picture
Offline
Bug Finder
Joined: 08/31/2007
Juice: 127
Just upgrade our site.

Just upgraded our site.
Clean upgrade !
Though some tinkering was needed.

bwv
bwv's picture
Offline
Uber DonorBug FinderEarly adopter... addicted to alphas.Spreading the word - Ubercart for president.
Joined: 08/07/2007
Juice: 403
Re: Alpha 7e Released

Flawless upgrade from D to E. Terrific work (but you already knew that).

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Alpha 7e Released

Fresh installs of Alpha 7e will have a bug in the order comments table. Please refer to the following thread to see how to fix it:

http://www.ubercart.org/forum/bug_reports/1136/inconsistency_order_statu...

phoenix0783's picture
Offline
Joined: 08/07/2007
Juice: 185
I'm getting this error:

I'm getting these two errors:

user warning: Unknown column 'weight_units' in 'field list' query: SELECT model, list_price, cost, sell_price, weight, weight_units, length, width, height, length_units, pkg_qty, default_qty, unique_hash FROM uc_products WHERE vid = 24 in /home/4/a/c/12017/12017/public_html/includes/database.mysql.inc on line 172.
user warning: Unknown column 'p.ordering' in 'order clause' query: SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN uc_products AS p ON n.nid = p.nid WHERE tn.tid = 1 AND n.status = 1 AND n.type IN ("product","workstation","server","laptop") ORDER BY p.ordering, n.title LIMIT 0, 10 in /home/4/a/c/12017/12017/public_html/includes/database.mysql.inc on line 172.
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: I'm getting this error:

Did you run update.php on your site? The ordering column should have been added in, as it is a fairly recent feature.

phoenix0783's picture
Offline
Joined: 08/07/2007
Juice: 185
Re: Re: I'm getting this error:

yes, but some of the drop down menus on update.php were not set at the highest number, so i put them there. should i have left them at where the default was?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6841
Re: Re: Re: I'm getting this error:

Yup. The update script starts at the number in the select box and goes upward to the latest update.

psynaptic's picture
Offline
Early adopter... addicted to alphas.Not KulvikTheminator
Joined: 08/28/2007
Juice: 731
Re: Re: Re: Re: I'm getting this error:

I fell for this one first time I updated too. All you need to do is run the script until there are no further updates required.

phoenix0783's picture
Offline
Joined: 08/07/2007
Juice: 185
Re: Re: Re: Re: Re: I'm getting this error:

got it! thanks for your help guys. Cool