Gossamer Forum
Home : Products : DBMan : Customization :

user information at signup

(Page 3 of 3)
> >
Quote Reply
Re: user information at signup In reply to
Yay!!!!!

My brain has been in such a fog lately, I couldn't even figure out what was going wrong, much less how to fix it.

Anything else?


JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
Sitting in front of a computer all day definitely turns grey matter into mush -- I can totally relate to that!

I'm still having the problem with all of the comments being listed under the review even if the comment BikeID doesn't correspond with one review BikeID.

Also, you mentioned that I should lose ID in users.cfg. Would I just set $db_key_track to 0 then?

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
Yes. $db_key_track should be set to 0 if you are using the userid field as the key field. This is really important. If you don't, you're going to have major problems.

I've been playing around at your site and I'm not sure what's going on with the commentsbikereviews database. I did a search for all comments and I got two returned, but also links to two other pages. Neither had anything on them, but the links shouldn't have been there.

I don't know what would have caused this, but it could be related to your other problem.

JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
I just removed ID from the cfg, db.cgi and from the .db itself. Changed $db_key_track to 0 as well. I'm still having the comments problem though. I even tried commenting out all of the %rec3 stuff to see if that was causing a conflict but it didn't do anything.

There are only 2 records in the comments db so I don't know what those other 2 links that you were talking about are. The records in the comments db have the correct BikeID and are validated so I don't just can't figure out why they aren't being pulled by the corresponding review. The comments switch/search obviously finds the info but it just doesn't know what to do with it.



-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
I'm not sure either. But you need to make the same change in your other html.pl files that you made in the bikereviews one -- change $i to $rec_count.

JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
In Reply To:
change $i to $rec_count.
Done... didn't effect the problem with the comments though. They all still show up no matter what BikeID they are supposed to go with.

I just updated the files in the tmp folder.

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
I'm still concerned about the commentsbikereviews database. It is not coming up right when I do a "List All." If there's something wrong with the database itself, then the relational mod won't work.

Try starting with a new commentsbikereviews.db file.

JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
How is it not right? I just went to it and it looked okay - sort of. Under "brand" and "model", its taking those from the reviews database. The brand/model's that are listed there do not correspond with the comment. The public will not be able to do a list all/add/delete etc. directly from the comments db - clicking the links will bring them back the the bikereviews. Only admin has access to those functions in the comments db.

Just noticed something interesting. In the comments db, clicking delete/modify gives an error on the validated field. Clicking add gives a blank page - just the header/footer.

Feel free to add/delete/modify anything you want.

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
Right now I'm still logged in to your database. If you go to

http://visit-my-webpage.com/...*&view_records=1

you'll see that the two comments are listed, as well as links to a page 2 and page 3. But there's nothing on those pages. For some reason the script is thinking that there are more results than there really are. This is a problem! Smile


JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
Woa... I didn't even notice that. That's really weird! I had a look at the comments html.pl and for some reason $db_next_hits doesn't show up above the results but it does below it.

Both are:
if ($db_next_hits) { print "
<$font>Pages: $db_next_hits</font>"; }

Could the counter in html_view_success be messed up?

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
There is something with the BikeID field. I'm not sure what it is, but I think that's what's causing both problems.

Are you sure you have it in the correct place in both of the "switch_to_" subroutines?

What seems to be happening is that, not only are all the comments returned on the reviews page, but all of the reviews are returned when you list the comments.


JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
I think its okay.... here's what I have:

sub switch_to_bikereviews {
#----------------------------------------------
$cols = 'BikeID,Name,Email,State,Country,Date,Brand,Model,Review,Category,Rating,Userid,Validated';
@db_cols = split /,/,$cols;
$db_file_name = $db_script_path . "/data/bikereviews.db";
$db_sort{'Date'} = 'date';
$db_validated_field = 'Validated';
}


sub switch_to_comments_bikereviews {
#-----------------------------------------------------
$cols = 'ReviewID,commentsName,commentsEmail,commentsDate,commentsReview,commentsRating,commentsUserid,commentsValidated,BikeID';
@db_cols = split /,/,$cols;
$db_file_name = $db_script_path . "/data/comments_bikereviews.db";
$db_key_pos = 0;
$db_validated_field = 'commentsValidated';
}

omments .cfg:

ReviewID => [0, 'numer', 5, 8, 1, '', ''],
commentsName => [1, 'alpha', 20, 50, 1, '', ''],
commentsEmail => [2, 'alpha', 20, 50, 1, '', ''],
commentsDate => [3, 'date', 12, 15, 1, &get_date, ''],
commentsReview => [4, 'alpha', 0, 500, 1, '', ''],
commentsRating => [5,'alpha', 0, 50, 1, '', ''],
commentsUserid => [6,'alpha', -2, 15, 0, '', ''],
commentsValidated => [7,'alpha', 0, 3, 0, 'No', 'Yes|No'],
BikeID => [8, 'numer', 5, 8, 1, '', '']

bikereviews cfg:

BikeID => [0, 'numer', 5, 8, 1, '', ''],
Name => [1, 'alpha', 20, 50, 1, '', ''],
Email => [2, 'alpha', 20, 50, 1, '', ''],
State => [3, 'alpha', 20, 50, 1, '', ''],
Country => [4, 'alpha', 20, 50, 1, '', ''],
Date => [5, 'date', 12, 15, 1, &get_date, ''],
Brand => [6, 'alpha', 20, 75, 1, '', ''],
Model => [7, 'alpha', 20, 75, 1, '', ''],
Review => [8, 'alpha', 0, 500, 0, '', ''],
Category => [9, 'alpha', 0, 50, 1, '', ''],
Rating => [10,'alpha', 0, 50, 1, '', ''],
Userid => [11,'alpha', -2, 15, 0, '', ''],
Validated => [12,'alpha', 0, 3, 0, 'No', 'Yes|No']


-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
Yep. It does look all right. (I wish it didn't. Then I would know how to fix it. Smile)

Maybe if I play around at your site some more I'll get some inspiration. Doesn't make any sense to me, but maybe I'll get a brain storm.



JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
Sorry it took me so long to reply. I've been trying to access the site since last weekend but I keep getting a DNS error. Found out the IP address now so I'm using that...

Anyways.... About my crazy dbman problems. Could it be something with the %rec3 stuff that was added? It worked before I added all the User stuff to the db.



-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
Carol, your not going to believe this!!!! I just added the security fix that Alex posted and it fixed the comments problem! Comments are now displaying with their corresponding review!

I couldn't believe it when I saw it -- it was a total fluke. I just uploaded the revised db.cgi to the server so you can see it actually working.

I hope that's the last stupid problem that I run into while setting up my db's.

Just want to thank you again for all of your help and patience on this project!!

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
Quote Reply
Re: user information at signup In reply to
Wow!!!! Who woulda thunk it? Smile

That is amazing, but I never argue with success.

You have taken a great load of my mind. I'm almost as happy about this as you are!!!! Smile





JPD
http://www.jpdeni.com/dbman/
Quote Reply
Re: user information at signup In reply to
Certainly a load off my mind too. I can finish the new site now.

Thanks again!

-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net
> >