Error after Joomla -UG 2.5>3.3

26.05.2014 12:39
#1
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Error after Joomla -UG 2.5>3.3

Hi,
comming from Joomla 2.5 with Joomshopping 3.16.4 I installed the JS Upgrade 3.14.3 => 4.2.2

I was expecting that that would already work but I got a error:

JHtml: :bootstrap nicht unterstützt. Datei nicht gefunden.

Ok, maybe I need Joomla 3 to start JShopping4: So I upgraded to 3.3 without problems. Then JS Upgrade 4.2.2 => 4.3.0 but now I get the installation error

Duplicate column name 'basicprice' SQL=alter table j25_jshopping_order_item add column `basicprice` DECIMAL(12,2) NOT NULL;

And in the frontend, when I start my webpage : error 500 Please install component "joomshopping"

The backend works fine. All products there etc only the Frontend is missing ;-( What shall I do? Continue the upgarde-path up to the final JS version?

Thanks for your help

Andreas


Letzte Änderung: 26.05.2014 12:41
 
26.05.2014 19:38
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error after Joomla -UG 2.5>3.3

delete module (old version)

 
27.05.2014 14:24
#3
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

Hi,
thanks for supporting me!

After I install the Upgrade to JS 4.2.2 (which ends with the bootstrap Error) I have the following modules installed (see attachment).

What shall I delete? As far as I can see all are old and nothing is new.

Andreas
Aw: Error after Joomla -UG 2.5>3.3

 
27.05.2014 20:16
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error after Joomla -UG 2.5>3.3

Module version 3.x for joomla 2.5

See
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/modules.html

 
28.05.2014 11:37
#5
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

OK.
you think the upgrade of Joomshopping core went well (it gave no error message during the installation process) but I have to install the other modules.

I'll try that this weekend and will report my progress.

Cheers & thanks for your help!

Andreas

 
02.06.2014 10:04
#6
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

Hello,

thanks to your tip I'm a step closer to my goal.

Upgrade to JS 4.2.2 is now running with Joomla 3.3

Next problem: Upgrade 4.2.2 to 4.3.0 result is an error:

=> Duplicate column name 'basicprice' SQL=alter table j25_jshopping_order_item add column `basicprice` DECIMAL(12,2) NOT NULL;

What to do?

Thanks for your time and help so far!

Andreas

 
02.06.2014 12:14
#7
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error after Joomla -UG 2.5>3.3

extract JoomShopping-update-4.2.2-4.3.0.zip

change file update sql

delete
alter table #__jshopping_order_item add column `basicprice` DECIMAL(12,2) NOT NULL;

create archive and install.

 
02.06.2014 13:05
#8
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

The problem might result from my installation comming from 3.16.4.
To upgrade to 4.2.2 I needed to install the Upgrade 3.14.3 => 4.2.2

So if there are any DB changes between the release of 3.13.4 and 3.16.4 the problem will occur with every follwing update ;-(

If that's the case, you will see lots of people getting problems in the update process while comming from Joomla 2.5 to 3.x with your "downgrade - update" 3.13.4 => 4.2.2

I'll try your recommended fix and report my result. If I have sucessfully reached the actual release of Joomshopping with Joomla 3.x I'll write a summary for all who have to face the "move" in the future.

Tx

Andreas

 
02.06.2014 14:07
#9
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

Yep,

it seems to be the case that all "new" SQL-Updates which have been installed previously in 3.16.4 cause a new error message while updating from 4.2.2 upwards.

With your fix, I ended up in 4.3.0 without problems.

The Upgrade 4.3.0 => 4.3.1 generated error:

Duplicate column name 'invoice_date' SQL=alter table j25_jshopping_orders add column `invoice_date` DATETIME NOT NULL;

As I do have several updates before me, could you please advise how to proceed?

Worst case - just tell me, which SQL statement has to be modified/removed in which update
Best case - Please provide a fix. You may be asked the same thing several times by others in the future ;-)


Thanks so far - at least there is a (bright) light at the horizon!

Andreas

 
02.06.2014 15:36
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error after Joomla -UG 2.5>3.3

Then - do not pay attention to the error.

Files are updated, and the base danyh you already new.

 
02.06.2014 17:49
#11
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

OK, thanks.

I got errors on the following upgrades:

=> 4.4.0
=> 4.4.1

All others went well. So I'm now (a bit unsure wether it has worked or not) with Joomla 3.3 and JS 4.4.2

After some final tests I'll write my "howto" in this forum.

A final question: Do I have to buy my addons again for JS 4.x?

Thanks for your help!

Andreas

 
02.06.2014 21:22
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error after Joomla -UG 2.5>3.3

--A final question: Do I have to buy my addons again for JS 4.x?

No. (See version and download)

 
03.06.2014 08:22
#13
Dr.Rivera
Joomshopping forum user no avatar
Name: Jürgen
13.09.2010
Posts: 2251
Quote
Aw: Error after Joomla -UG 2.5>3.3

Hallo Andreas,

wenn du Zeit hast, könntest du eine kurze Zusammenfassung schreiben, wie man mit dem Shop von Joomla 2.5 auf Joomla 3.3 "umzieht"?
Das würde dem ein oder anderen sicher helfen, wenn du deine Erfahrungen zusammenfassen würdest. Das wäre klasse. Kann natürlich nur eine Bitte sein.
So etwas wie
1. ...
2. ....
usw.

Hintergrund:
Da die Roadmap von Joomla ja die Versionen bis 3.11 vorsieht und gleichzeitig Joomla 2.5 Ende des Jahres ausläuft, muss in den nächsten Monaten eh jeder updaten.

Grüße


Letzte Änderung: 03.06.2014 08:24

Nicht ganz aktuell, aber vielleicht doch noch für einige hilfreich, das E-Book Joomshopping.
Bei Amazon (kindl) und xinxii (ePub):

http://www.amazon.de/JoomShopping-Joomla-Shop-Online-Shop-ebook/dp/B005L9D8MC

http://www.xinxii.com/joomshopping-der-joomla-shop-p-339561.html
 
03.06.2014 13:46
#14
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

Hallo Jürgen,

ja klar. Mache ich. Ich muss mich noch um ein paar Details ausserhalb JS kümmern und dann haben wir ja alle den 13.6. vor uns ;-)

Danach werde ich die Komplette Umstellung hier dokumentieren. Schreibe schon fleissig alle Punkte auf.

Gruß

Andreas

 
04.06.2014 13:11
#15
Dingens
Joomshopping forum user no avatar
Name: Rolf Wagels
28.03.2012
Posts: 144
Quote
Aw: Error after Joomla -UG 2.5>3.3

Moin
super! Da bin ich sehr, sehr dankbar! Das steht in den nächsten Wochen hier auch an, und ich bin sicher nicht der Einzige! Danke für Deine Hilfe!
Grüße
Der Dingens

 
12.06.2014 16:10
#16
agrupe
Joomshopping forum user no avatar
Name: Grupe
30.10.2012
Posts: 90
Quote
Aw: Error after Joomla -UG 2.5>3.3

Habs gemacht:

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/1/7606.html?lang=de

Gruß

Andreas

 
13.06.2014 14:42
#17
Dingens
Joomshopping forum user no avatar
Name: Rolf Wagels
28.03.2012
Posts: 144
Quote
Aw: Error after Joomla -UG 2.5>3.3

Genial, Danke!!!!

 
13.06.2014 16:48
#18
Dr.Rivera
Joomshopping forum user no avatar
Name: Jürgen
13.09.2010
Posts: 2251
Quote
Aw: Error after Joomla -UG 2.5>3.3

Noch nicht getestet, aber dennoch auch:

Danke!


Nicht ganz aktuell, aber vielleicht doch noch für einige hilfreich, das E-Book Joomshopping.
Bei Amazon (kindl) und xinxii (ePub):

http://www.amazon.de/JoomShopping-Joomla-Shop-Online-Shop-ebook/dp/B005L9D8MC

http://www.xinxii.com/joomshopping-der-joomla-shop-p-339561.html
 
Copyrights MAXXmarketing GmbH. All Rights Reserved