OXID Community Forum

> International Forums > Administration > benutzerdaten lassen sich nicht ändern - user data update not possible
Login
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread: benutzerdaten lassen sich nicht ändern - user data update not possible


Reply
 
Thread Tools Search this Thread Display Modes
#Top   #1  
Old 07-19-2009, 06:23 PM
hartlef hartlef is offline
Junior Member
Join Date: May 2009
Posts: 9
hartlef is on a distinguished road
Default benutzerdaten lassen sich nicht ändern - user data update not possible

Hello Community,

while trying to update user data in the backend, something very strange appears:
Some users can be updated without a problem,
With other users I get a "Duplicate entry 'xxxxxxxxxxxxx' for key 1" because OXID is trying an INSERT instead of an UPDATE.
I cannot find any differences between the data which are updateble and those which are not.
Does anyone know this problem?

Yours,
Nils

UPDATE: Obviously the exixtance-check is done by "select oxid from oxnewssubscribed where oxid = ...". But why is this table used and noch the 'oxuser'. Where can I change this?

Last edited by Marco Steinhaeuser; 07-20-2009 at 07:56 AM. Reason: Please English only in the international Forum
Reply With Quote
#Top   #2  
Old 07-19-2009, 08:56 PM
hartlef hartlef is offline
Junior Member
Join Date: May 2009
Posts: 9
hartlef is on a distinguished road
Default AW: benutzerdaten lassen sich nicht ändern - user data update not possible

Solution: I had 6 records in my database where OXSHOPID was not set to 'oxbaseshop'. It was empty. Does anybody know how this could happen?

Yours,
Nils
Reply With Quote
#Top   #3  
Old 07-20-2009, 07:58 AM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is offline
Community Manager @OXID
Join Date: Oct 2008
Posts: 12,669
Marco Steinhaeuser is on a distinguished road
Default AW: benutzerdaten lassen sich nicht ändern - user data update not possible

Quote:
Solution: I had 6 records in my database where OXSHOPID was not set to 'oxbaseshop'. It was empty. Does anybody know how this could happen?
Actually no. Did you import some data?
__________________
Marco
http://oxidforge.org
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
#Top   #4  
Old 07-20-2009, 03:16 PM
hartlef hartlef is offline
Junior Member
Join Date: May 2009
Posts: 9
hartlef is on a distinguished road
Default AW: benutzerdaten lassen sich nicht ändern - user data update not possible

Quote:
Originally Posted by Marco Steinhäuser View Post
Actually no. Did you import some data?
No, these records must have been added in the backend.
I only remember that I changed the OXCUSTNR of oxuser to "unique", because otherwise leaving the field empty in the backend caused a '0' there in DB which also was not changeable in the backend (only with phpMyAdmin).
Can it be that leaving that field empty causes OXID not to write the "oxbaseshop" into OXSHOPID?
I have not tested again.

Yours,
Nils
Reply With Quote
#Top   #5  
Old 07-20-2009, 05:27 PM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is offline
Community Manager @OXID
Join Date: Oct 2008
Posts: 12,669
Marco Steinhaeuser is on a distinguished road
Default AW: benutzerdaten lassen sich nicht ändern - user data update not possible

Quote:
Can it be that leaving that field empty causes OXID not to write the "oxbaseshop" into OXSHOPID?
No idea. Shall be tested. BTW: Doesn't matter if OXCUSTNR is unique or not. The main point is to have the OXID unique.
__________________
Marco
http://oxidforge.org
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
#Top   #6  
Old 02-12-2014, 10:53 AM
mkoch_kp mkoch_kp is offline
Junior Member
Join Date: Jul 2013
Posts: 15
mkoch_kp is on a distinguished road
Default AW: benutzerdaten lassen sich nicht ändern - user data update not possible

Anybody found a solution for the problem or has a clue how this error could happen?

I have a similar problem sometimes. When a new user was created it gets oxcustnr 0 and the oxshopid field is empty (in oxuser table)... My shop version is 4.8.0 PE.

Cheers
Markus
Reply With Quote
Reply

Bookmarks

Tags
benutzerdaten, data, update, user

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Nicht Sichtbar
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Artikel und Bestellungen lassen sich nicht bearbeiten/anlegen marggraf Administration 5 05-08-2010 03:29 PM
Stichwörter / Tags lassen sich nicht mehr löschen kathrin-77 Administration 7 02-16-2010 01:14 PM
Topseller Artikel lassen sich nicht ändern ans316 Administration 0 11-25-2009 05:57 PM
Nachrichten lassen sich nicht speichern maja340 Installation und Konfiguration 11 12-11-2008 08:21 PM
Aktionen lassen sich nicht mit dem Auswahlfeld deaktivieren. JOSTI Administration 1 11-12-2008 08:00 PM

All times are GMT +1. The time now is 10:14 PM.