Uitleg error nodig
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
SQLError Object
(
[sql] => INSERT INTO `user` (`clan_id`,`clan_access`,`currency`,`bank`,`user_name`,`password_hash`,`password_hash_salt`,`current_salt`,`current_salt_expiration`,`registered_ip_addr`,`last_ip_addr`,`last_activity`,`access_level`,`email`,`age`,`gender`,`profile`,`signature`,`avatar_id`,`user_title`,`datetime_created`,`post_count`,`textarea_preference`,`datetime_last_post`,`active_user_pet_id`,`timezone_id`,`datetime_format_id`,`password_reset_requested`,`password_reset_confirm`,`show_online_status`,`user_page`,`ref`,`refby`,`template`,`active_char_id`) VALUES (0,0,'','','Marlinda','fac98cf841a582a2332ed39f5a8bf23c','8ef5be62ec5929513ed22d02be8f1326','9737c988a7fa284fdb9c218a4ee2f5bb','2008-10-29 16:42:35','83.81.33.135','','2008-09-29 17:42:35','user','[email protected]','14','female','','',0,'User','2008-09-29 17:42:35',0,'tinymce','2008-09-29 17:42:35',0,54,1,'2008-09-29 17:42:35','','Y','',0,'','',0) [nativecode=1062 ** Duplicate entry 'Marlinda' for key 2]
[message:protected] => INSERT INTO `user` (`clan_id`,`clan_access`,`currency`,`bank`,`user_name`,`password_hash`,`password_hash_salt`,`current_salt`,`current_salt_expiration`,`registered_ip_addr`,`last_ip_addr`,`last_activity`,`access_level`,`email`,`age`,`gender`,`profile`,`signature`,`avatar_id`,`user_title`,`datetime_created`,`post_count`,`textarea_preference`,`datetime_last_post`,`active_user_pet_id`,`timezone_id`,`datetime_format_id`,`password_reset_requested`,`password_reset_confirm`,`show_online_status`,`user_page`,`ref`,`refby`,`template`,`active_char_id`) VALUES (0,0,'','','Marlinda','fac98cf841a582a2332ed39f5a8bf23c','8ef5be62ec5929513ed22d02be8f1326','9737c988a7fa284fdb9c218a4ee2f5bb','2008-10-29 16:42:35','83.81.33.135','','2008-09-29 17:42:35','user','[email protected]','14','female','','',0,'User','2008-09-29 17:42:35',0,'tinymce','2008-09-29 17:42:35',0,54,1,'2008-09-29 17:42:35','','Y','',0,'','',0) [nativecode=1062 ** Duplicate entry 'Marlinda' for key 2]
[string:private] =>
[code:protected] => 907
[file:protected] => /mnt/web8/30/86/51796586/htdocs/myhorsez/external_lib/aphp/active_table/active_table.class.php
[line:protected] => 1420
[trace:private] => Array
(
[0] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/includes/classes/user/user.class.php
[line] => 227
[function] => save
[class] => ActiveTable
[type] => ->
[args] => Array
(
)
)
[1] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/scripts/user/register.php
[line] => 183
[function] => login
[class] => User
[type] => ->
[args] => Array
(
)
)
[2] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/index.php
[line] => 210
[args] => Array
(
[0] => /mnt/web8/30/86/51796586/htdocs/myhorsez/scripts/user/register.php
)
[function] => include
)
)
)
(
[sql] => INSERT INTO `user` (`clan_id`,`clan_access`,`currency`,`bank`,`user_name`,`password_hash`,`password_hash_salt`,`current_salt`,`current_salt_expiration`,`registered_ip_addr`,`last_ip_addr`,`last_activity`,`access_level`,`email`,`age`,`gender`,`profile`,`signature`,`avatar_id`,`user_title`,`datetime_created`,`post_count`,`textarea_preference`,`datetime_last_post`,`active_user_pet_id`,`timezone_id`,`datetime_format_id`,`password_reset_requested`,`password_reset_confirm`,`show_online_status`,`user_page`,`ref`,`refby`,`template`,`active_char_id`) VALUES (0,0,'','','Marlinda','fac98cf841a582a2332ed39f5a8bf23c','8ef5be62ec5929513ed22d02be8f1326','9737c988a7fa284fdb9c218a4ee2f5bb','2008-10-29 16:42:35','83.81.33.135','','2008-09-29 17:42:35','user','[email protected]','14','female','','',0,'User','2008-09-29 17:42:35',0,'tinymce','2008-09-29 17:42:35',0,54,1,'2008-09-29 17:42:35','','Y','',0,'','',0) [nativecode=1062 ** Duplicate entry 'Marlinda' for key 2]
[message:protected] => INSERT INTO `user` (`clan_id`,`clan_access`,`currency`,`bank`,`user_name`,`password_hash`,`password_hash_salt`,`current_salt`,`current_salt_expiration`,`registered_ip_addr`,`last_ip_addr`,`last_activity`,`access_level`,`email`,`age`,`gender`,`profile`,`signature`,`avatar_id`,`user_title`,`datetime_created`,`post_count`,`textarea_preference`,`datetime_last_post`,`active_user_pet_id`,`timezone_id`,`datetime_format_id`,`password_reset_requested`,`password_reset_confirm`,`show_online_status`,`user_page`,`ref`,`refby`,`template`,`active_char_id`) VALUES (0,0,'','','Marlinda','fac98cf841a582a2332ed39f5a8bf23c','8ef5be62ec5929513ed22d02be8f1326','9737c988a7fa284fdb9c218a4ee2f5bb','2008-10-29 16:42:35','83.81.33.135','','2008-09-29 17:42:35','user','[email protected]','14','female','','',0,'User','2008-09-29 17:42:35',0,'tinymce','2008-09-29 17:42:35',0,54,1,'2008-09-29 17:42:35','','Y','',0,'','',0) [nativecode=1062 ** Duplicate entry 'Marlinda' for key 2]
[string:private] =>
[code:protected] => 907
[file:protected] => /mnt/web8/30/86/51796586/htdocs/myhorsez/external_lib/aphp/active_table/active_table.class.php
[line:protected] => 1420
[trace:private] => Array
(
[0] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/includes/classes/user/user.class.php
[line] => 227
[function] => save
[class] => ActiveTable
[type] => ->
[args] => Array
(
)
)
[1] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/scripts/user/register.php
[line] => 183
[function] => login
[class] => User
[type] => ->
[args] => Array
(
)
)
[2] => Array
(
[file] => /mnt/web8/30/86/51796586/htdocs/myhorsez/index.php
[line] => 210
[args] => Array
(
[0] => /mnt/web8/30/86/51796586/htdocs/myhorsez/scripts/user/register.php
)
[function] => include
)
)
)
Het is voor een reg. systeem. Kan iemand mijn uitleggen wat er verkeerd is?
Hij maakt wel een record aan met enkele gegevens maar je kan niet inloggen (en je krijgt dus als je op aanmelden klikt deze error)
Groetjes
Gewijzigd op 01/01/1970 01:00:00 door Water Lilly
Quote:
Duplicate entry 'Marlinda' for key 2
Er wordt een UNIQUE-constraint overtreden, de waarde 'Marlinda' staat blijkbaar al in de database.
De query is trouwens behoorlijk smerig, al die gore backticks ` mogen zo richting schroothoop. Die onzin heeft helemaal niets met SQL te maken en is alleen voor prutsers. Je kunt dankzij deze onzin hele nare bugs in je systeem inbouwen... Denk aan een situatie dat je ineens al je data kwijt bent. Leer het gebruik van deze rommel z.s.m. af, bespaart je een hoop onzinnig tikwerk en minder risico op bugs.