Alpha 7d is out there!

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Well, this release was long in coming... not because it's been a long time since Alpha 7c, but because it updates some long standing features (configurable order statuses, woohoo!) and also because I've been trying to get it out for a few days now. We've been killing some good bugs and trying to get the code in order to make good translation templates, but the latter just wouldn't happen. I'm getting too much grief trying to do CVS on Windows, so I'm just going to have to setup one of our Linux servers to make it easier/faster for me to roll out releases.

Anyways, check the new post for a little more information. This has been mostly a maintenance release, but the order statuses and product revisions now working make it a noteworthy one. Please back up your database before updating, as the update functions do have to update all your orders to use the new order status system. This hasn't turned up any problems in testing, but you just never know what could go wrong... Smiling

Now let's get a move on to Alpha 8 and beyond.

Posts: 50
Joined: 09/09/2007

Is the Überinstaller updated to 7d as well?

Posts: 144
Joined: 08/14/2007
Uber DonorBug FinderEarly adopter... addicted to alphas.Cool profile pic award.Internationalizationizer

Excellent work übermen. I'll download this and provide some überfeedback as usual.

______________
Best regards,
Thomas Kulvik
Ny Media AS
www.nymedia.no

Posts: 151
Joined: 08/07/2007
AdministratorNot Kulvik

Shawn is updating the Uberinstaller as we speak!

Posts: 329
Joined: 08/28/2007
Early adopter... addicted to alphas.Not KulvikTheminator

Yep, gonna get this one installed now. Will report back any problems.

Posts: 332
Joined: 08/07/2007
Administrator

Yes, thanks Boletus for being the update UberInstaller notifier. It is now good to go.

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Posts: 112
Joined: 08/07/2007
Bug FinderGetting busy with the Ubercode.

A flawless upgrade in my test environment. Smiling

Posts: 329
Joined: 08/28/2007
Early adopter... addicted to alphas.Not KulvikTheminator

Just noticed that I now have 2 instances of Product kit under Create content.

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

General FYI... there's a bug in the PayPal install file... I swear I fixed this once already, but somehow the change got lost. In any event, I'll get it back up soon. This only affects new installations of the PayPal module, not updates.

I won't be posting this until I figure out CVS for pete's sake. Plugging away at the command line on our test server right now...

Posts: 329
Joined: 08/28/2007
Early adopter... addicted to alphas.Not KulvikTheminator

On the Content types page one is known as kit and the other as product_kit.

The product_kit doesn't have tabs in the edit content type page and the Manage tab for kit loads a browser error page: The error was: “lost network connection” (NSURLErrorDomain:-1005).

Posts: 42
Joined: 08/08/2007

Just updated from 7c to 7d with no problem

update result

Drupal database update

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

* main page
* administration pages

The following queries were executed
uc_payment module
Update #2

* 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 ''
* ALTER TABLE {uc_order_statuses} CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* ALTER TABLE {uc_order_statuses} ADD weight MEDIUMINT(9) NOT NULL
* 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 ('payment_received', 'Payment received', 'payment_received', 10, 1);

uc_paypal module
Update #1

* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('paypal_pending', 'PayPal pending', 'payment_received', 7, 1);

uc_flatrate module
Update #1

* ALTER TABLE {uc_flatrate_products} ADD COLUMN vid mediumint(9) unsigned NOT NULL default 0 FIRST
* ALTER TABLE {uc_flatrate_products} DROP INDEX nid
* ALTER TABLE {uc_flatrate_products} ADD PRIMARY KEY (vid)

uc_quote module
Update #3

* ALTER TABLE {uc_quote_manufacturer_locations} CHANGE COLUMN address1 street1 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_manufacturer_locations} CHANGE COLUMN address2 street2 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_product_locations} CHANGE COLUMN address1 street1 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_product_locations} CHANGE COLUMN address2 street2 varchar(255) NOT NULL default ''

uc_order module
Update #3

* ALTER TABLE {uc_orders} CHANGE order_status order_status VARCHAR(32) NOT NULL
* UPDATE {uc_orders} SET order_status = 'in_checkout' WHERE order_status = '0'
* UPDATE {uc_orders} SET order_status = 'pending' WHERE order_status = '1'
* UPDATE {uc_orders} SET order_status = 'processing' WHERE order_status = '2' OR order_status = '3'
* UPDATE {uc_orders} SET order_status = 'completed' WHERE order_status = '4'
* ALTER TABLE {uc_order_comments} CHANGE order_status order_status VARCHAR(32) NOT NULL
* UPDATE {uc_order_comments} SET order_status = 'in_checkout' WHERE order_status = '0'
* UPDATE {uc_order_comments} SET order_status = 'pending' WHERE order_status = '1'
* UPDATE {uc_order_comments} SET order_status = 'processing' WHERE order_status = '2' OR order_status = '3'
* UPDATE {uc_order_comments} SET order_status = 'completed' WHERE order_status = '4'
* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('canceled', 'Canceled', 'canceled', -20, 1), ('in_checkout', 'In checkout', 'in_checkout', -10, 1), ('pending', 'Pending', 'post_checkout', 0, 1), ('processing', 'Processing', 'post_checkout', 5, 1), ('completed', 'Completed', 'completed', 20, 1);

uc_product module
Update #6

* ALTER TABLE {uc_products} ADD COLUMN ordering smallint(2) NOT NULL default 0

Update #7

* ALTER TABLE {uc_products} CHANGE units weight_units varchar(255) NOT NULL default 'lb'
* ALTER TABLE {uc_products} ADD length float unsigned NOT NULL default 0 AFTER weight_units
* ALTER TABLE {uc_products} ADD width float unsigned NOT NULL default 0 AFTER length
* ALTER TABLE {uc_products} ADD height float unsigned NOT NULL default 0 AFTER width
* ALTER TABLE {uc_products} ADD length_units varchar(255) NOT NULL default 'in' AFTER height
* ALTER TABLE {uc_products} ADD pkg_qty smallint unsigned NOT NULL default 1 AFTER length_units

Update #8

* ALTER TABLE {uc_products} ADD vid mediumint(9) NOT NULL default 0 FIRST
* ALTER TABLE {uc_products} DROP PRIMARY KEY
* ALTER TABLE {uc_products} ADD PRIMARY KEY (vid)

uc_product_kit module
Update #3

* ALTER TABLE {uc_product_kits} ADD COLUMN vid mediumint(9) NOT NULL default 0 FIRST
* ALTER TABLE {uc_product_kits} DROP PRIMARY KEY
* ALTER TABLE {uc_product_kits} ADD PRIMARY KEY (vid, product_id)

--

www.taggedcheap.co.uk The cheapest price shop

Posts: 116
Joined: 08/07/2007
Uber DonorBug FinderEarly adopter... addicted to alphas.Spreading the word - Ubercart for president.

No errors, DB upgrade was flawless, everything working perfectly. The only thing I had to fiddle with was the product dimensions field (it was on, I merely turned it off). I also had to do a little rearranging of the order of the various fields that I do use on the product page. Congratulations on this fine piece of work.

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Interesting... the fix for the product module was a last minute patch like my fix to the PayPal install file. I wonder if something got rolled back accidentally. I'll roll out a second 7d release... drat these minor releases and our lack of a better numbering scheme. Eye-wink

Posts: 50
Joined: 09/09/2007

And will this new release of 7d.2 make it to the Überinstaller ... Laughing out loud Eye-wink

Posts: 14
Joined: 09/01/2007

I have upgraded to the latest version now, and when coming out of the shopping cart back to the home page I get the following error message.

* warning: Invalid argument supplied for foreach() in /home/pandapou/public_html/modules/ubercart/shipping/uc_quote/uc_quote.module on line 1101.
* warning: Invalid argument supplied for foreach() in /home/pandapou/public_html/modules/ubercart/shipping/uc_quote/uc_quote.module on line 1101.

Over to you Lyle!
Adam

Posts: 14
Joined: 09/01/2007

Then once completing an order I get the following error message

Fatal error: Call to undefined function uc_get_order_status_id() in /home/pandapou/public_html/modules/ubercart/payment/uc_2checkout/uc_2checkout.module on line 217

Any ideas?
Need to know asap!

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Good thing I'm posting an install maintenance release in the morning. I'll have this fixed first thing... I thought I had grepped the code for any uses of old functions. You just need to change this:

<?php
 
if ($order === FALSE || $order->order_status != uc_get_order_status_id('in_checkout')) {
?>

To this:

<?php
 
if ($order === FALSE || uc_order_status_data($order->order_status, 'state') != 'in_checkout') {
?>

Posts: 14
Joined: 09/01/2007

In which .module

do I change the

<?php
 
if ($order === FALSE || uc_order_status_data($order->order_status, 'state') != 'in_checkout') {
?>

Also quick question any ideas why the invoice logo wont show up in customer.itpl.php i'm using this bit of code.

<table width="100%" style="font-family: verdana, arial, helvetica; font-size: small;">
              <tr>
                <td>
                  <img src=http://www.pandapouch.com/images/pplogo.jpg/>
                </td>
                <td width="98%">
                  <div style="padding-left: 1em;">
                  <span style="font-size: large;">[store-name]</span><br/>

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Module to edit is /payment/uc_2checkout/uc_2checkout.module. Also, your HTML might not be working because you need to put quotes around the filename. That's just an idea.

Posts: 14
Joined: 09/01/2007

Okay great fixed that issues But I still have this error message poping up everywhere

warning: Invalid argument supplied for foreach() in /home/pandapou/public_html/modules/ubercart/shipping/uc_quote/uc_quote.module on line 1101.

Any ideas?

Please let me know

Posts: 541
Joined: 08/13/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.Internationalizationizer

good, good, good..

And no need to modify some contributions ?...

it's a perfect day Cool

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

@mintidea: I'm curious what shipping quote modules you're using to generate quotes... it may be that something wasn't updated properly between versions.

Posts: 2267
Joined: 08/07/2007
AdministratoreLiTe!

Adam, could you tell me what shipping methods you expected to return a quote? It's possible that you don't have any enabled at Shipping quote settings > Quote methods, or you're using a broken quote method module that doesn't always return an array of quotes like it should. I'll check the ones in core to be sure none of them are the problem.

Posts: 329
Joined: 08/28/2007
Early adopter... addicted to alphas.Not KulvikTheminator

I just received an error when installing Ubercart on a fresh install of Drupal 5.2:

user warning: Table 'ubercarta7d.uc_order_statuses' doesn't exist query: INSERT INTO uc_order_statuses (order_status_id, title, state, weight, locked) VALUES ('payment_received', 'Payment received', 'payment_received', 10, 1); in /Applications/xampp/xamppfiles/htdocs/ubercarta7d/includes/database.mysql.inc on line 172.

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Interesting... I'm going to have to look into weighting these modules so the core installs/updates happen first. I guess I just assumed it would always work the same. (P is after O...)

That's kind of a bummer... it didn't turn up in my testing b/c I always enable the 4 core modules first and then the others separately. I'll see what I can do to fix this and put it in today's house cleaning release.

Regarding your previous issue... the install file should be fixed for product kits. Sorry if this screwed you up.

Posts: 14
Joined: 09/01/2007

Right now Pandapouch.com is using

- Pickup Product(s) In-Store is enabled.
- Flat Rate per Product is enabled.

Please let me know how to fix this one.

Posts: 332
Joined: 08/07/2007
Administrator

Boletus,

After some painfully slow testing, I've updated the ubercart package so that paypal works fine (I had disabled the paypal module since the bug came up yesterday). When Ryan rolls out the patches for the latest release I will update the UberInstaller as well. Until then, people will just have to manually patch the code themselves.

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Posts: 2267
Joined: 08/07/2007
AdministratoreLiTe!

mintidiea, I wish I knew how. The versions I have of flatrate and pickup look like they should work under any circumstance. Did you notice anything with their country settings that would prevent them from returning quotes?

There hasn't been a major change in the way shipping quotes are retrieved (yet).

Posts: 14
Joined: 09/01/2007

Wanna take a look at my site I can give you the login details Lyle?

I've spent all day and I still get this error

* warning: Invalid argument supplied for foreach() in /home/pandapou/public_html/modules/ubercart/shipping/uc_quote/uc_quote.module on line 1101.
* warning: Invalid argument supplied for foreach() in /home/pandapou/public_html/modules/ubercart/shipping/uc_quote/uc_quote.module on line 1101.

Please let me know really need to sort this out.

Adam

Posts: 22
Joined: 08/17/2007
Bug FinderGetting busy with the Ubercode.

i'll finish up my testing and live updates today, but so far everything's smooth like buttah with this new release! configurable order statuses appear to work great so far, although the update clobbered my "manual" name changes in the database table (no big deal- now there's a web interface to re-configure them!)

i've updated a staging instance of our live site (with live data), and the database update applied cleanly. what's more, none of the (relatively minor) patches we've made to core uc modules conflicts with this update, so everything merged in nicely at the code level, too.

the only contrib modules we're using are uc_ratequote and uc_discounts, neither of which appear to be affected at all. now that we've launched our first ubercart site, i'm working on a full code review and will post a series of patches and a livesite announcement later today or tomorrow.

once again, congratulations on a great piece of software in the making: excellent work, uberdudes!

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

spiderman, I can't wait! I'm glad to hear things are going smoothly, and believe it or not I'm going to be posting a maintenance release today that fixes a few installation bugs and an update bug related to product kits. I also was able to fully implement the framework for product features - basically a simple way for modules to add optional data to products without everyone adding fieldsets to the node edit form.

Posts: 112
Joined: 08/07/2007
Bug FinderGetting busy with the Ubercode.

I'm finding errors similar to this in my log files. The error seems to only occur if you are trying to view a non-existent page. In this case I tried to view catalog/abcd



    * user warning: Unknown column 'abcd' in 'where clause' query: SELECT COUNT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid IN (abcd) AND n.status = 1 in /holidayleds/includes/database.mysql.inc on line 172.
    * user warning: Unknown column 'abcd' in 'where 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 WHERE tn.tid IN (abcd) AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /holidayleds/includes/database.mysql.inc on line 172.

Posts: 2267
Joined: 08/07/2007
AdministratoreLiTe!

Yeah, that's a problem. I think I've fixed it so that bad URLs will display /catalog instead of errors. Data validation is important, yeah?

Posts: 24
Joined: 11/17/2007

whare do i enter this information.
i am actually conserned with this:

uc_order_statuses
user warning: Table 'databasename_xx.uc_order_statuses' doesn't exist query:

INSERT INTO uc_order_statuses (order_status_id, title, state, weight, locked)

VALUES ('paypal_pending', 'PayPal pending', 'payment_received', 7, 1); in

includes/database.mysql.inc on line 172.

what is the best way to edit such things? can i manually do it in the program or do i need some kinda utility for this on my local server?

ksprjms

Posts: 332
Joined: 08/07/2007
Administrator

You want some sort of program that will allow you to connect to your database and run queries. phpMyAdmin is a great web-app that will enable to run queries over your database.

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

kasperjames wrote:

uc_order_statuses
user warning: Table 'databasename_xx.uc_order_statuses' doesn't exist query:

This table should've been added automatically when you updated using update.php. If you did this already and the table still isn't there, you'll need to grab the query out of the uc_order install file and manually enter it.