I recently did an update from an old OXID eShop Version PE 3.0.4 to the newest Version of PE 4.1.5.
Although most of the things went well I ran into several problems. Sharing the solutions here might help you and will for sure help me for the next update 
1. no cumulative updates: As there are no cumulative updates you are forced to do each update step separately from Version 4.0.0.0 to 4.1.5. As there is only an updatescript from 3.0.4. to 4.0.0.0 you are forced to do all 9! updates afterwards. OXID promised that there will be cumulative updates in the future so you’ll be able to say “give me a patch from 4.0.0.0 to 4.1.X and you’ll get a single file. But as we are not living in the future (yet) here is a simple list of 9 SQL scripts you have to execute to come from freshly updated 4.0.0.0 to version 4.1.5. Be aware that there are also 2 PHP files you have to copy to doc root and execute after the according SQL has been executed.
Download all OXID update SQLs at once.
2. OXACTIVE > 1 in oxarticles table: The oxactive field in oxarticle table is responsible to activate/deactivate an article. Allowed values are 0 and 1. But after update it may happen that you have a lot of “2″s as values, leading to “half active” articles. I can tell you, thats quite confusing 
. Here is the accorind note by OXID and with the following SQL you can fix it:
3. Old orders have sum of 0 and all articles of an old order have thr price of 0. Nearly all entries in the order overview in admin might become “0″ after an update. The reasons are new fields in oxorder and oxorderarticles tables. These fields might not be filled. Thats why you’ll need the following SQL:
update oxorderarticles set oxbprice = oxprice where oxbprice = 0 and oxprice <> 0update oxorderarticles set oxnprice = ((oxprice*100) / (100 + oxvat)) where oxnprice = 0 and oxprice <> 0
UPDATE `oxorder` AS _main SET _main.oxtotalordersum = _main.oxdelcost + _main.oxpaycost + _main.oxwrapcost – _main.oxdiscount + ( SELECT SUM( oxbrutprice ) FROM `oxorderarticles` WHERE oxorderid = _main.oxid ), _main.oxtotalbrutsum = ( SELECT SUM( oxbrutprice ) FROM `oxorderarticles` WHERE oxorderid = _main.oxid ), _main.oxtotalnetsum = ( SELECT SUM( oxnetprice ) FROM `oxorderarticles` WHERE oxorderid = _main.oxid ) WHERE _main.oxtotalnetsum = 0 AND _main.oxtotalbrutsum = 0 AND _main.oxtotalordersum = 0;
An according note by OXID about the third of these SQLs. The first two I build myself.
Of course all the files and SQLs are without ANY warranty and you use them at your own risk! Don’t forget a backup before you do anything!
Please leave feedback
Update OXID eShop from PE 3.X to PE 4.1.5 SQL issues « die … | 7Dollar
on Sep 23rd, 2009
@ 11:56:
[...] from: Update OXID eShop from PE 3.X to PE 4.1.5 SQL issues « die … Share and [...]
Replica jerseys
on Jul 31st, 2010
@ 04:45:
hey,you have posted such a effectful article that it will certainly help me.
cheap jerseys
on Aug 31st, 2010
@ 17:02:
Thanks for such a great post and the review, I am totally impressed! Keep stuff like this coming.
dissertation paper
on Sep 6th, 2010
@ 06:47:
Good post and a fantastic read. You have raised some valid points. Great work, keep it up. I love returning back to this site and reading the quality content you always have on offer.
louboutins uk
on Jun 13th, 2011
@ 12:13:
Postmortem oneself life louboutins uk, see oneself satisfactory for direction is of vital importance? See if you need in life in some way to change louboutins shoes on sale? See yourself whether getting results? Practice life christian louboutin 70% off, there are many things can’t use an excuse to cover. Don’t find excuses thoughts can enhance your self-worth christian louboutin pumps, improve your own respect and love. You will not pull the other people as you do christian louboutin sandals, and learn to depend on oneself committed to create christian louboutin mary jane pumps new relationships and new life.
canada goose
on Jun 16th, 2011
@ 07:39:
In our daily life, we pay more attention to our dress-up and life taste. In 2011 summer, we don’t need to worry about it because summer clothing is always stylish and charming. However, we often feel annoyed in winter because those winter coats in general are heavy. Thus, we cannot show our personality and style during the winter time. However, when the canada gooselabel comes into our sights, we know that everything would be all right. It is because Canada goose clothing can bring us a stylish and charming look even under the brutal conditions.(yang)
MBT Shoes
on Jul 11th, 2011
@ 09:10:
Nice topic and post, as we were just talking about what things can happen in the medicine industry.
penny auctions site
on Jul 25th, 2011
@ 10:32:
The reasons are new fields in oxorder and oxorderarticles tables. These fields might not be filled. Thats why you’ll need the following SQL
chi flat iron
on Aug 16th, 2011
@ 11:11:
Good article makes constant progress, thank you share, the accumulation of knowledge is to keep learning, attention is the beginning of wealth.
nike shox sale
on Aug 30th, 2011
@ 04:45:
Thanks for your free articles. i like this site very much. so nice site for me!!!
Football Jerseys
on Aug 30th, 2011
@ 05:46:
Our Wholesale Jerseys Online Store is a professional jerseys store sells cheap jerseys including nfl jerseys, nhl jerseys, mlb jerseys, nba jerseys and others for men and women and kids, welcome to http://www.nfljerseysretailer.com
Benefit Foundation
on Aug 30th, 2011
@ 10:05:
The article is worth Benefit Concealerreading, I like it very much. I will keep your new Benefit Foundation articles
Longchamp Outlet
on Sep 7th, 2011
@ 08:51:
imiwmwe
Wholesale NBA Jerseys Onsale
on Sep 7th, 2011
@ 08:52:
IWMEWIMEW
the north face sale
on Sep 27th, 2011
@ 08:40:
Ecstasy well aware Ripples Cang anxious to see out of that forehead sweat fraud laugh. Is he? ! I have a cold heart, chest pressure immediately prada sunglasses sale want to be gushing out of a grudge withthe north face sale each other in stature, on a dark heart and said the other really extraordinary escape virtually the martial arts in the micro-Lan Cang I am afraid I did not fall upon the wearer the ability .
discount jerseys
on Okt 6th, 2011
@ 10:54:
3. Old orders have sum of 0 and all articles of an old order have thr price of 0. Nearly all entries in the order overview in admin might become “0″ after an update. The reasons are new fields in oxorder and oxorderarticles tables. These fields might not be filled. Thats why you’ll need the following SQL:
belstaff jacket
on Okt 17th, 2011
@ 09:29:
Belstaff jackets is a leading make of motorcycle jackets and also the motorcycle jackets within the Belstaff range are finished with best quality.And the belstaff coat are just about the most well-known belstaff leather inside thegood reputation for motorcycling and also the version belstaff jacket produce today is without a doubt a lot better than the main whilst still maintains the classic look. The north face jackets can be component of the north face collection and is also another good quality north face jacket with classic style. Here, in our store ,we show the picture, display the north face jackets in gentle black. http://www.northface-uk.net
discount jerseys
on Okt 21st, 2011
@ 11:23:
Of course all the files and SQLs are without ANY warranty and you use them at your own risk! Don’t forget a backup before you do anything!
boots online
on Okt 26th, 2011
@ 08:27:
With the retro wood at the end of the successful launch of the series, added a new work this season: high-heeled clogs retro series (High Clog Collection) with high 4-inch, dark wood at the end, more elegance, exaggerated the details of the accessories, fashion sense of design and shiny leather to give a single product brand new style. Desert boots series (Desert Boot Collection) will be low-key and stylish to the extreme interpretation. UGG will not reduce the trace from the pursuit of comfort, even high-heeled fashion fashion models. Desert Series, Oxford at the end with a soft comfort UGG Boots Discount fashion show perfect comfort perfect unity. Jose is a dual-boots, clinch dotted around on the upper side in, boots boots the system to be used mainly as free turn, filling the desert series and handsome modern footwear. UGG footwear in the production has a long history, each pair of shoes embody the sophisticated craftsmanship, avant-garde style and luxury casual fashion the material used, and now, all of the elements will also be simultaneously applied to high-quality bag production. UGG bags not only set functionality and durability in one, but also will serve as the brand’s debut fashion accessories. To select the top fabric bags, both visual and tactile UGG will bring new fans to experience pleasure, catch, or embrace UGG bags when they are feeling comfortable. UGG Leah Larson, vice president, said: Classic series bag is a timeless style and a unique multi-purpose design of the symbol, which is like a trusted old friend, as a reflection of the classic UGG footwear personality. Bags The soft grain leather with side pockets and durable for the highlights, will become the subject never out of fashion accessories.
mulberry handbags
on Okt 29th, 2011
@ 11:22:
Thank u for your sharing.Your blog has a unique feature that can make the people who reads become happy.After reading your blog,I feel happy.
caiyifang/comment201110
ugg boots on sale
on Nov 5th, 2011
@ 05:40:
I wanted to drop you a quick note to express my thanks. I’ve been following your blog for a month or so anp a ton of good information as well as enjoyed the way you’ve structured your site.
ugg boots clearance
on Nov 16th, 2011
@ 08:48:
PUKYODZ8H2PZ9PB0DVW6
Do you desire to get the ugg collection
louboutin outlet
on Nov 23rd, 2011
@ 17:22:
Adult females just love to order exquisite and then beautiful products of all types, now it really has been really easy to order custom made shoes on the net, who travels fantastic that have every clothing. Involving many of the fashion accessories also make it possible for found in gracing women and seeking additional wonderful, Christian shoes at the christian louboutin outlet need were obtain a category for their own use during the custom made markets. Should a wife wants to enrich the lady’s shoes range on the other hand cannot afford to invest in the actual cheap christian louboutin overshoes, she will buy all the copy shoes even.With regards to shoes or perhaps purses, girl dedicate time and effort imagining things to get plus what sort look best on the. Also, gal likes the fact that purses coupled with christian louboutin sale ought to supplement both way too. And so, to overpower these kinds of issues, the best thing is to order your gadgets on line when you obtains loads of selections consisted that have variable hues, designs, styles and designs.
ugg boots clearance
on Nov 26th, 2011
@ 05:36:
JTTQHQLWYCQWHHDJYDYT
While buying them habitually use your aesthetic sense and discover your`s heart voice entails which kind of
xlpharmacy reviews
on Dez 1st, 2011
@ 17:19:
Thanks, I really like to read the release notes, because you can find interesting information that you consider when you are using the program.
North Face Jackets On Sale
on Dez 2nd, 2011
@ 10:44:
Based on the popular brand,the products are always not cheap.So we come to shop but just can only do the window shopping. Especially for the young women and man,we do not get the high salary,but we want the top brand products,just like North Face Jackets, how can I own them? The easy way is finding the North Face clearance or North Face Jackets Sale time.
Cheapbagshoppingcom
on Dez 8th, 2011
@ 22:20:
cheapbagshopping.com—wholesale cheap men and women clothing,bags,shoes,jewelries,accessories from China.http://www.cheapbagshopping.com
wholesale replica D&G ties on line
discount northface
on Dez 24th, 2011
@ 03:57:
Upon reaching the box, keep an eye out for a field called North Face promotional code like this is what we call The North Face rei outlet codes available.
Canada Goose Jacket
on Dez 26th, 2011
@ 02:24:
For amplified than fifty countless years, Canada Goose Jacket has prolonged been producing genuine serious surroundings garments Canada Goose Expedition Parka profit founded up of concentrate on and function, Canada Goose Sale，produced for all individuals nowadays who will make get in touch with with for the self-confidence that appears from most extraordinary quality. Canada Goose Men Down Jackets， commencing acquiring a modest sequence of jackets and woolen shirts produced within of only only just merely a tiny warehouse in Toronto. Canada Goose Men Vest these intervals has grown to alter into acknowledged internationally contemplating how possibly possibly probably the most effective customized of serious surroundings outerwear for that planet. do not certainly genuinely really feel one thing slip your favored butter gentle and versatile leather-based jacket amazing Canada Goose Men Down Jackets .It is old, it appears right to place on within your personal pores andnorth confront backpack profit pores and complexion as nicely. Welcome you to canada goose stores.
north face outlet store
on Dez 27th, 2011
@ 05:01:
The north face jackets are suitable for outdoor activities such as mountaineering with your friends. cheap north face jackets is not only have high quality and comfortable, but also keep your warm in cold winter. Online north face outlet offer kinds of discount north face jackets, vests and other equipment with Free Shipping and No Tax! north face outlet store where you can buy discount north face fleece, denali jackets for women & men, cheap north face jackets online store.
nike free run
on Jan 7th, 2012
@ 04:47:
Keep your
nike free sko laptop battery healthy by fully charging and then fully discharging
Canada goose jakke it at least once a month
oakleys
on Jan 16th, 2012
@ 07:20:
CWDMQHZLZ I like it very much!