Gossamer Forum
Home : Products : DBMan : Installation :

Display Record Problem

Quote Reply
Display Record Problem
Hello people.
I have installed DBMAN and everything seems to be working.
I am working with a database that has 221 records. I have changed the
%db_def as follows:

db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Type => [1, 'alpha', 40, 255, 1, '', ''],
Description => [2, 'alpha', 40, 255, 1, '', ''],
OtherDesc => [3, 'alpha', 40, 255, 1, '', ''],
Price => [4, 'numer', 10, 15, 1, '', ''],
Postage => [5, 'numer', 10, 15, 1, '', ''],
Image => [6, 'alpha', 20, 50, 0, '', ''],
Img_Wdt => [7, 'numer', 5, 6, 0, '', ''],
Img_Hte => [8, 'numer', 5, 6, 0, '', ''],
Userid => [9, 'alpha', -2, 15, 0, '', '']
);

I have also changed the html.pl accordingly. The problem is that, when I do a
search to "modify" or "list all" records, the first record looks perfect.
Other records that come after that are not do not have my database field put
in their correct fields. Please go to this url and log in as admin/admin.

http://www.scandiaimaging.com/dbman/db.cgi

Then so a search for canon or xerox, or list all. You will see the result.
I will appreciate any help.
Many thanks people.

Quote Reply
Re: Display Record Problem In reply to
Hi Tunji

I see what you are talk about.
I am am not a pro with DBman, but my best bet would be that the problem is in the html.pl.
My advice: re- debug the coding for the html.pl or you can have it viewable on your site at a .txt file.

Then help you much better.



Quote Reply
Re: Display Record Problem In reply to
Thanks, my html.pl is now viewable as text at this url: http://www.scandiaimaging.com/dbman/html2.txt
Again, dbman login is at this url: http://www.scandiaimaging.com/dbman/db.cgi
Use the default logon admin/admin

Quote Reply
Re: Display Record Problem In reply to
I was looking through my DBman script and I realized something.

see if you default.cfg is set for:

# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 1;

if so change it to:

# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 0;



Quote Reply
Re: Display Record Problem In reply to
Autogenerate was and is set to 0... so this would not be the problem.
Thanks for the effort...

Quote Reply
Re: Display Record Problem In reply to
Hi Tunji, the problem you are describing results when you have records in the db file and then add additional fields to the config and html.pl file. The db ends up with the wrong number of | symbols on the records which were in the database before the config changes.

To correct the problem, you'll need to download default.db and open the file in a TEXT editor. Review the entries and determin which records need to have a | (pipe) symbol added. After making the corrections, upload the file to the server again (using ascii text mode) and then access your db.cgi file. The records should display properly.

Karen

PS - It may be only one record with the problem.


Quote Reply
Re: Display Record Problem In reply to
Thanks, I think you are right!!! I'll try this solution tonight.

Quote Reply
Re: Display Record Problem In reply to
Thanks people for your suggestions, which helped me to look deeper into the code. However, I discovered that the problem was something else and I fixed it.
Cheers...