Error insert in table #__jshopping_users

31.10.2012 05:09
#1
shcompact
Joomshopping forum user no avatar
Name: shcompact
15.09.2012
Posts: 6
Quote
Error insert in table #__jshopping_users

Ich nutze in Joomla Deutsch und English:

1. Der Fehler taucht nach der Neukundenregistrierung auf.

- War Auslöser das ich einen Kunden aus Joomshopping gelöcht (automatisch dann aich in Jommla) habe?

Ich kann so keine Neukunden registrieren lassen.

Bitte um Hilfe
Error insert in table #__jshopping_users


Joomla: 2.57
JoomShopping: 3.11.4 (Update von 3.50 hoch)
PHP: 5.3.17
MySQL: 5.5.25-cll
 
31.10.2012 08:17
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

Enable debug mode joomla

 
17.07.2014 14:10
#3
Minikoecher
Joomshopping forum user no avatar
Name: Minikoecher
04.07.2013
Posts: 2
Quote
Aw: Error insert in table #__jshopping_users

Wenn ich das Thema noch mal aufgreifen darf... Welche Lösung gab es konkret für dieses Problem. Ich habe dasselbe. Mein Shop funktioniert ansonsten einwandfrei. Nur die Neukunden-Registrierung bringt immer den Fehler:

Error insert in table #__jshopping_users

Die Neukunden können sich nicht selbst registrieren. Ich kann sie manuell erfassen und danach ist ein Login auch problemlos möglich.

Kann mir jemand helfen? Könnte das Leeren der Tabelle mit den Kunden-IDs in der Datenbank helfen?

Danke


Joomla: 2.5.22
JoomShopping: 3.18.2

Letzte Änderung: 13.07.2015 10:29
 
17.07.2014 20:49
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

Try enable debug mode joomla.

 
18.07.2014 07:39
#5
Minikoecher
Joomshopping forum user no avatar
Name: Minikoecher
04.07.2013
Posts: 2
Quote
Aw: Error insert in table #__jshopping_users

Dann bekomme ich die angehängte Fehlermeldung zu sehen.
Ich bin kein Joomla-Profi. Was muss ich tun?

Danke für die Hilfe.
Aw: Error insert in table #__jshopping_users


Letzte Änderung: 18.07.2014 07:41
 
18.07.2014 07:45
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

url?
admin login?
ftp?
phpmyadmin?
(privat)

 
25.09.2014 19:47
#7
indbjoe
Joomshopping forum user no avatar
Name: Espen
28.04.2012
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Hi. I got the same problem. Can you help me?


Joomla: 2.5.9 Stable
JoomShopping: 3.18.5
PHP: 5.3.29
MySQL: 5.5.38-MariaDB-1~wheezy
Website Url: www.dykkerlappen.no
 
26.09.2014 07:49
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

enable debug mode joomla.
See errors.

 
26.09.2014 19:29
#9
indbjoe
Joomshopping forum user no avatar
Name: Espen
28.04.2012
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Here is the error message
Aw: Error insert in table #__jshopping_users


Letzte Änderung: 26.09.2014 19:31
 
26.09.2014 21:36
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

Update need step to step!

Start update again.

 
26.09.2014 22:31
#11
indbjoe
Joomshopping forum user no avatar
Name: Espen
28.04.2012
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

webdesigner - 26.09.2014 21:36
Update need step to step!

Start update again.


Is it joomshoping i need to update again? How do i do it? not sure I know what you mean

 
26.09.2014 23:08
#12
indbjoe
Joomshopping forum user no avatar
Name: Espen
28.04.2012
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Problem solved :)

Went back and upgraded from a previous version and upgraded until the final version. Everything works now. Thanks for the great support

 
23.12.2014 10:32
#13
Red-Indian
Joomshopping forum user no avatar
Name: Werner
26.10.2014
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Hello together,
I just got a website running on Joomla 2.5x with this shop to administrate and now I also get this message.
The online website was updated by an Akeeba backup of a local site and this local site is no longer available.
I got this error in the beginning and also after I updated from 3.19.2 to 3.20. Now I had a look on the Joomla debugging and also had a look into the database and just see that there is a database filed missing:
the field 'number' in the table _jshopping_users

How can I manage this? Mybe add a field manually?
Thank you in advance
Aw: Error insert in table #__jshopping_users


Joomla: 2.5.28
JoomShopping: 3.20
 
23.12.2014 12:03
#14
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

Your version before update?
PLEASE!
Update need step to step.
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/7/286.html?lang=en#1

 
23.12.2014 12:35
#15
Red-Indian
Joomshopping forum user no avatar
Name: Werner
26.10.2014
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

I just read your tips and solutions but the problem is:
I got only the online website which was 3.19.2 and there this error appears also.
The website has been backed up on a local server and put into internet - online website.
I only have this online website and do NOT have any access to the local website where the backup was made from. So I unfortunately do not know which was the version before backup on the local site before it has been restored into the online website.

I think the one who made the local site made a backup from an older version and then put this backup onto the online site which has a newer version, or maybe the other direction.

Sorry for this inconvenience.
Let's say: how can I manage this error with ONLY this database I have? Is there maybe a DB field for the version so I can uninstall this one and install an older one ?
Or maybe can I delete the whole shop, install a new one and put in only the database I have?
Thank you for your help

 
23.12.2014 15:05
#16
Red-Indian
Joomshopping forum user no avatar
Name: Werner
26.10.2014
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Or maybe where can I get some older versions before 3.19.2 to try ?
I see I have fields in another clean domo installation of Joomshop 3.19.2 which I do not have in the backup I have on my online site like:

_joomshop_users
street_nr
d_street_nr

also I have much more keys than in the clean 3.19.2 version like:
UNIQUE KEY `user_id` (`user_id`),
KEY `u_name` (`u_name`),
KEY `usergroup_id` (`usergroup_id`),
KEY `usergroup_id_2` (`usergroup_id`),
KEY `payment_id` (`payment_id`),
KEY `shipping_id` (`shipping_id`),
KEY `client_type` (`client_type`),
KEY `email` (`email`)

In my clean 3.19.2 version I only have the first two keys.

Maybe this can help ?

 
23.12.2014 16:06
#17
Red-Indian
Joomshopping forum user no avatar
Name: Werner
26.10.2014
Posts: 4
Quote
Aw: Error insert in table #__jshopping_users

Sorry again :-)
I see in the version history, that the customer field 'number' has been added in version 3.16.2 so I think my database backup should be a version prior to this.

3.16.2 (4.4.1)
Added field customer number.
Changed payment system Debit.
Bug fixes.

That means:
I have a database backup of a version prior 3.16.2 and a shop version 3.19.2

 
23.12.2014 16:59
#18
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25939
Quote
Aw: Error insert in table #__jshopping_users

Start update 3.16.0 or later

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.