Author |
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 09 June 2004 at 4:47am | IP Logged
|
|
|
Hi Alex,
Alex, I've noticed when saving some contacts in address book. Its not saved actually and even can't
modify some email ids.
I saw the database, when I save something a blank
record appears and like this going on. But for some
email id it works. I mean, I can save some email id
and modify it. Any suggestion ?
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 09 June 2004 at 7:43am | IP Logged
|
|
|
Hi Alex,
Table : wm_address_book
Mostly the rows which are blank are having
(Field: Template) Template = Checked and some
of rows are having Id_record_previous more
than zero number assigned while the successfully
save records are zero.
Hope to get response soon. Thanks and regards.
|
Back to Top |
|
|
MailBeeSupport AfterLogic Support
Joined: 02 December 2003 Location: United States
Online Status: Offline Posts: 0
|
Posted: 09 June 2004 at 8:46am | IP Logged
|
|
|
Unfortunately, we're not able to locate the bug you have encountered. Please send us more details on actions you perform and what happens exactly ? Also, it would be great if you provide us with info on the browser brand and IIS server version you use.
Will be waiting for your reply, and thank you for your valuable input!
Alex
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 09 June 2004 at 9:33am | IP Logged
|
|
|
Thanks Alex. I'm using :
1)Internet Explorer version : 6.0.200.1106.Xpsp2.030422- 1699.
2)IIS version 5
Actually, when I try to ADD/Edit address in address book
intially it worked fine but for perticular email ids
it doesn't allow to edit or add ( There is no message when I edit/add email id, webpage remain as is instead of refreshing )
When I saw database :
a) The address which I was trying to modify was without
any change
b) Field Template was checked for the records which I
was modifying or adding
c) Id_record_previous was holding previous records
number (Id_records)
I can't able to add a perticular email id, though, I
can add several different IDs. I've removed my accounts many times so that I can get rid of this problem but still it persist.
That's all I can say at the moment.
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 10 June 2004 at 2:49am | IP Logged
|
|
|
1) I was trying to edit an email id. When nothing
updated in that perticular address. I deleted that
email id and wanted to add it again but there was
an error message "This email is already exist in
your address book". when I attempt again and again
nothing happened and the page is not refreshing
even. There is no message also at the moment on
adding or modifying. Now its just adding blank rows
in database.
2) I've removed my account from "Settings" "Remove"
several times to get rid of this problem. But still
the same it won't accept some specific email ids
and I can add many different ids.
3) Field: Id_delete in table wm_users. Is there
something related to this ? because first time it has added that email id and after Removing account it won't accept same id second time.
|
Back to Top |
|
|
Alex AfterLogic Support
Joined: 19 November 2003
Online Status: Offline Posts: 2206
|
Posted: 10 June 2004 at 7:42am | IP Logged
|
|
|
It seems we've found the problem. It was caused by the fact that two users could not have the same email address in the Address Book. It was fixed. Please provide your e-mail address so we would be able to send you updated version of the script.
You can just send an e-mail to mailbee@iforum.com
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 10 June 2004 at 3:58pm | IP Logged
|
|
|
Thanks Alex! I just sent an email to you
|
Back to Top |
|
|
Alex AfterLogic Support
Joined: 19 November 2003
Online Status: Offline Posts: 2206
|
Posted: 11 June 2004 at 7:16am | IP Logged
|
|
|
I've sent you the updated file..
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 12 June 2004 at 3:55am | IP Logged
|
|
|
1) I've deleted every addresses from my address book. But still couldn't able to add ( even the previously
added addresses ) though I can add & edit a new address which had not been added by ANY USERS before.
2) When I want to add any email address its prompts "This email is already exist in your address book"
3) May be it depends on users. If a user has already added xyz@test.com in his address book before, so I
can't add xyz@test.com in my address book ( I think
2 different users can't have the same email address
in their address book.)
4) Do I need to delete all the records from Address book table ?
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 13 June 2004 at 6:17am | IP Logged
|
|
|
That's okay now ! gone through the scripts and found "function_address_book.inc.asp" line 655 need some modification as well :
Previous :
fn_SQLtmt = "SELECT id_record FROM wm_address_book WHERE template=0 AND id_record<>" & id_record & _
" AND email='" & email & "'"
Current :
fn_SQLtmt = "SELECT id_record FROM wm_address_book WHERE template=0 AND id_record<>" & id_record & _
" AND email='" & email & "' and Id_user=" & Id_user
( Should consider the user also, Id_user=" & Id_user )
|
Back to Top |
|
|
Alex AfterLogic Support
Joined: 19 November 2003
Online Status: Offline Posts: 2206
|
Posted: 15 June 2004 at 5:34am | IP Logged
|
|
|
We have analyzed the scripts and there really was a problem regarding id_user.
Thank you very much for the fix!
|
Back to Top |
|
|
Newbee Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 15 June 2004 at 7:42am | IP Logged
|
|
|
Your are welcome Alex ! thanks for your time.
Regards.
|
Back to Top |
|
|