"View Orders", orders listed multiple times

Here's the full list of enabled modules ...

"actions"
"activesearch"
"activeselect"
"activity"
"aggregator"
"auto_nodetitle"
"avatar_gallery"
"avatargallery2"
"avatar_selection"
"backup_migrate"
"buddylist"
"buymeabeer"
"calendar"
"captcha"
"cck_button"
"cck_flashcard"
"cck_taxonomy_ssu"
"clone"
"collapsiblock"
"color"
"comment"
"compact_forms"
"computed_field"
"contact"
"contemplate"
"content"
"content_taxonomy"
"content_taxonomy_activeselect"
"content_taxonomy_autocomplete"
"content_taxonomy_options"
"content_taxonomy_views"
"controlpanel"
"countdowntimer"
"customimagefield"
"custom_pagers"
"date"
"dcl_importer"
"diggthis"
"editablefields"
"explainfield"
"faq"
"fckeditor"
"fieldgroup"
"finduser"
"fivestar"
"flag_content"
"flashnode"
"formblock"
"formdefaults"
"formfilter"
"gmap"
"guestbook"
"hierarchical_select"
"image"
"imagecache"
"imagefield"
"image_gallery"
"imce"
"invite"
"jcarousel"
"jquery_interface"
"jquery_update"
"jrating"
"jscalendar"
"jstools"
"last_node"
"lightbox2"
"location"
"login_destination"
"me"
"menu_per_role"
"messenger"
"monthgroup"
"mysite"
"nodefamily"
"nodeformpopup"
"nodeprofile"
"nodereference"
"og"
"og_aggregator"
"og_block_visibility"
"og_contact"
"og_forum"
"og_invite_restrict"
"og_joinrole"
"og_notify"
"onlinestatus"
"optionwidgets"
"pageroute"
"panels"
"panels_accordion"
"panels_carousel"
"panels_mini"
"panels_node"
"panels_tabs"
"panels_views"
"path"
"path_redirect"
"phpfreechat"
"poll"
"popdesc_og"
"r4032login"
"reptag"
"rolesignup"
"signup"
"simplemenu"
"site_map"
"split_moderation"
"stringoverrides"
"subform_element"
"subscriptions"
"swftools"
"tabs"
"tapir"
"taxonomy"
"taxonomy_context"
"taxonomygroup"
"teaserthumbnail"
"thickbox"
"token"
"tracker"
"ubrowser"
"uc_attribute"
"uc_cart"
"uc_cart_links"
"uc_catalog"
"uc_flatrate"
"uc_notify"
"uc_order"
"uc_payment"
"uc_paypal"
"uc_product"
"uc_quote"
"uc_recurring"
"uc_reports"
"uc_roles"
"uc_shipping"
"uc_stock"
"uc_store"
"uc_taxes"
"upload"
"user2userpoints"
"user_badges"
"usernode"
"userplus"
"userpoints"
"userpoints_basic"
"userpoints_email"
"userpoints_invite"
"userpoints_nodelimit"
"userpoints_retroactive"
"userpoints_role"
"userpoints_singlenotify"
"userpoints_top_contributors"
"userpoints_ubercart"
"userpoints_views"
"userpoints_votingapi"
"userpoints_workflow_ng"
"user_postcounts"
"userprotect"
"userreference"
"user_visits"
"viewfield"
"views"
"views_bonus_archive"
"views_bonus_export"
"views_bonus_grid"
"views_bonus_panels"
"views_bonus_summary_combo"
"views_bonus_tag_cloud"
"views_rss"
"views_theme_wizard"
"views_ui"
"votingapi"
"votingapiactivity"
"watchdog"
"wijering"
"workflow_ng"

Interestingly enough, I finally saw this happening somewhere other than Ubercart! In my user profile view, if I select a profile field I've created like "Favorite Color" or whatever, The view of "Everyone whose favorite color is..." shows double entries.

Does that give any additional clues?

My full day of Ubercart testing for role assignment presented a new clue related to this issue.

Duplicates always appeared in View Orders for statuses of "Pending" and "Complete". Then, at one point, the PayPal sandbox used an eCheck for my test buyer to pay and that resulted in a status of "PayPal Pending". With a status of "PayPal Pending" NO duplicate was present in View Orders. When I manually changed the status of that order from "PayPal Pending" to "Complete", the duplicate appeared.

I'll give japerry a try and will let you know what I find out.

Interestingly enough, there were dupes of the data in the uc_orders table for transactions I made back in December using the credit card payment type. There were no dupes in the table for my more recent transactions using the WPS payment type.

Wow! That was an unbelievably fast response. You must be the PostgreSQL crisis team.

I want to make sure I'm following your directions correctly. Did you want me to install the uc_purchaseorder module and place an order with it so that we can make a comparison with the uc_orders module?

Okay ... making a purchase with a purchase order was also resulting in duplicate orders being displayed in the View Orders screen.

BUT, I done figured it out!!!

The fact that the "PayPal pending" status was the only one not shoe dupes was a big clue. As it turns out, all the order statuses but "PayPal pending" were duplicated in the uc_order_statuses table. I had my associate work some magic to delete the dupe rows and VOILA my View Orders screen now presents my orders correctly.

Thanks for helping out. You must have been the final inspiration I needed!