Gossamer Forum
Home : Products : DBMan : Customization :

Record(s) not deleted

(Page 1 of 2)
> >
Quote Reply
Record(s) not deleted
Hi,
my database runs, but I have one problem. If I wish delete a record I got this:

Record(s) not deleted ... no records specified ...

I have a field 'User ID' as db_key and set the db_key_track = 1. This field 'User ID' is a hidden field.

What can I do????

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
The problem could be is that if you are using the defaulted forms that has the ID field rather than the UserID field, then you cannot find the appropriate records to delete.

Please save the following files as text files:

html.pl ==> html.txt
default.cfg ==> default.txt

Upload them to your server in a publicly accessible directory, and then provide links where we can view the file TEXT files.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------









Quote Reply
Re: Record(s) not deleted In reply to
Hi Eliot,
you find the files on

http://www.alverskirchen.de/default.txt
http://www.alverskirchen.de/html.txt

Regards Ecki


------------------
Quote Reply
Re: Record(s) not deleted In reply to
Your problem is caused by your authentication permissions.

Change the following:

Code:
@auth_default_permissions = (1,1,0,0,0);

to the following:

Code:
@auth_default_permissions = (1,0,0,0,0);

So, that default users can only VIEW records in the database.

Then change the following:

Code:
@auth_signup_permissions = (1,1,0,0,0);

to the following:

Code:
@auth_signup_permissions = (1,1,1,1,0);

Currently, you have only set-up the database to allow people to view and add records. If you want them to delete and modify records, you need to use the settings I provided.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------









Quote Reply
Re: Record(s) not deleted In reply to
Sorry Eliot,
I think, my permissions are right. I must default user allow to view and add. Only the admin can delete and modify.

Modify is possible for admin only.

I don't need registerd user.

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Well, have you tried deleting the records logged in as ADMIN. You cannot login as default user or regular user to delete records.

If only the ADMIN can delete records, then you have to be logged in as ADMIN.

If that doesn't work...then we will need to spend more time looking at your html.pl file.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------









Quote Reply
Re: Record(s) not deleted In reply to
Here is another problem:

Code:
$auth_user_field = -1;

THIS NEEDS TO BE SET TO THE USERID FIELD, WHICH IS 0.

Change this variable to the following:

Code:
$auth_user_field = 0;

Also, change the columns for your Userid to the following:

Code:
Userid = > [0, 'alpha', -2, 15, 0, '', ''],

You have -1 rather than -2.

Regards,

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------









Quote Reply
Re: Record(s) not deleted In reply to
Good morning,

of course I have looged in as ADMIN. As ADMIN I can modify all records, but no record delete.

Thanks for your time.

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Hi Eliot,

I change the default.cfg how do you said, but I have an error: records not deleted ... no records specified.
If you have the time, look at

http://www799.cgi.l5.xodox.com/cgi-bin/dbman/db.cgi

and make your own trial.

Thanks and regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Okay...I have tried it out. (BTW: The next time you post an example, could you please provide instructions for which link to use...I DO NOT have time to browse through the DBMAN site to find the damn delete screen.)

Wink

Again...I cannot see the problem by looking at your files and the example you've provided.

Again, I would recommend changing the default.cfg permissions as I have suggested to see if it makes any difference.

BTW: To test the suggestions I gave for the -2 column, you NEED to ADD a new record, and then try to delete it!

Regards,



------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. Smile
----------------------











[This message has been edited by Eliot (edited February 13, 2000).]
Quote Reply
Re: Record(s) not deleted In reply to
Oh god,
Eliot help me. I make it as you say, but there is the mistake. Is there a hole in my head?
I change it:

$auth_user_field = 0;
'User ID' => [ 0, 'alpha', -2, 15, 0, '',''],

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Now I have create a new Database with one more field (ID).

The mistake is the same.

As ADMIN I can add, modify, search but I can't delete.

What can I do? Thank you for an answer.

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Hi johnsonny,
first I make with jpdeni configurator a new default.cfg, but there was the error-message again.
Then I overwrite the sub_html_record and the sub_html_record_form with jpdenis configurator. I got the error-message.
After this message I overwrite the html.pl with the original html.pl, make with the configurator new sub_html_records... and now runs my database.
I think, I have make a mistake by the translation into german, before there was a mistake.
(I hope, you understand me, by my bad english)
Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
Hi!!! Ecki
So,have u got your errors fixed??
how did u do that???
Because i stil cant delete the record by using the admin login..

Quote Reply
Re: Record(s) not deleted In reply to
Step by step,

1. error-message "Records not deleted"
2. I made a new default.cfg with jpdenis configurator - error-message
3. I made a new sub_html_record and sub_html_record_form with jpdenis configurator. Overwrite they in my old html.pl - error-message
4. Then I have overwrite my old html.pl with the original html.pl from dbman. Then I made with the jpdeni configurator new sub_html_record and sub_html_record_form and paste this in the html.pl.
5. After this is my database o. k.

The error-message come after I translate something in the html.pl. I think, I have overwrite or delete by the translation. I dont know. Also it could be another mistake.

It was not a problem for me to make a new database, because there wasn't real records in the database. It was a test.

Regards Ecki
Quote Reply
Re: Record(s) not deleted In reply to
I get the exactly same error message.
Could any one help both of us??
Thanks

Quote Reply
Re: Record(s) not deleted In reply to
Thanks for your help very much...
But i would like to know where to get the "jpdenis configurator"...Could you please point me to the right direction???

Thanks!!
Quote Reply
Re: Record(s) not deleted In reply to
Go here:

www.jpdeni.com/dbman/

Click on the Configurator link.

Also, I believe I did link to this site in one of your other Threads.

Wink

Regards,

------------------
Eliot Lee....
* Check Resource Center
* Search Forums

Quote Reply
Re: Record(s) not deleted In reply to
Help me!!!!
Sad to say,i still cant get the problem fixed. I have been trying to work it out for the whole day but still got the message of the errors :

Error: Record(s) Not Deleted
The records with the following keys were not found in the database: 'no records specified.'.

I put the files there.
100online.hypermart.net

Could any one help me?? I would be very very appreicated.
Thanks


Quote Reply
Re: Record(s) not deleted In reply to
I think I saw your mistake:
In the html.pl, sub delete form, you've changed the value of the checkbox in Loschen, the script do not understand that. Let it in the original delete

Your code:
Code:
# Go through each hit and convert the array to hash and send to
# html_record for printing. Also add a checkbox with name=key and value=delete.

if ($status ne "ok") { # There was an error searching!
print qq|<P><FONT COLOR="RED" SIZE=4>Error: $status</FONT></P>|;
}
else {
print "<P>";
for (0 .. $numhits - 1) {
%tmp = &array_to_hash($_, @hits);
print qq|<TABLE BORDER=0><TR><TD><INPUT TYPE=CHECKBOX NAME="$tmp{$db_key}" VALUE="Löschen"></TD><TD>|;
&html_record (%tmp);
print qq|</TD></TR></TABLE>\n|;
}
if ($db_next_hits) {
print "<br><$font>Pages: $db_next_hits</font>";
}
}
change in:
Code:
# Go through each hit and convert the array to hash and send to
# html_record for printing. Also add a checkbox with name=key and value=delete.

if ($status ne "ok") { # There was an error searching!
print qq|<P><FONT COLOR="RED" SIZE=4>Error: $status</FONT></P>|;
}
else {
print "<P>";
for (0 .. $numhits - 1) {
%tmp = &array_to_hash($_, @hits);
print qq|<TABLE BORDER=0><TR><TD><INPUT TYPE=CHECKBOX NAME="$tmp{$db_key}" VALUE="delete"></TD><TD>|;
&html_record (%tmp);
print qq|</TD></TR></TABLE>\n|;
}
if ($db_next_hits) {
print "<br><$font>Pages: $db_next_hits</font>";
}
}
Let me know what happens.

Good luck.
---------
Mart.


[This message has been edited by mart (edited February 22, 2000).]
Quote Reply
Re: Record(s) not deleted In reply to
OK, thats not the solution, you can call the value whatever you want, except '0'. We need to see your script too.

And 'johnsonny', be more specific for what about the location of the files.
Quote Reply
Re: Record(s) not deleted In reply to
Thanks for finding out the problem

http://100online.hypermart.net/

http://100online.hypermart.net/db1.txt
http://100online.hypermart.net/default1.txt
http://100online.hypermart.net/html1.txt

Thanks!!

Quote Reply
Re: Record(s) not deleted In reply to
Thanks Mart!!
If possible, could please point me out the error coding??? and tell me how to fix it??

I would be very appreciated
Quote Reply
Re: Record(s) not deleted In reply to
Well,
For 'ecki' I think, after trying myself, I was hitting the target on the right place, so that might solved.

For 'johnsonny' I think its something with the authorisation settings. Tomorrow I take a look further.

---------
Mart.
Quote Reply
Re: Record(s) not deleted In reply to
johnsonny,
I've looked at your html.pl, and the code in the sub delete_form do not looks good for me. Are you sure, that this part works for you??
Code:
## Go through each hit and convert the array to hash and send to
# html_record for printing.
print "<table>";
print "<tr><td>",join('</td><td>',@db_cols),"</td></tr>";
for (0 .. $numhits - 1) {
&html_record_row (&array_to_hash($_, @hits));
}
print "</table>";
It seems to me like that it courses a syntax error. Try to leave out the part:

print "<tr><td>",join('</td><td>',@db_cols),"</td></tr>";


(maybe I'm wrong)
Let me know what happens in a new thread.
--------
Mart
> >