Gossamer Forum
Home : Products : Gossamer Links : Discussions :

2.04 questions / problems

Quote Reply
2.04 questions / problems
Just did the upgrade to 2.04 and now I'm having a few questions about some things...

1. Custom form fields (multi-select) and add.cgi

I added such a field to add.html and it is displayed correctly on the page. In 2.03 the selected values of this field were transfered to add_success.html as a string (each value separated by the '#' character). I just did output this string (it's the Form Names that get saved in the database, e.g. "de#en#fr") on add_success.html, because I still didn't figure out how to display the corresponding Form Values ("German, English, French").
Now, after upgrading I get the message 'ARRAY(0x42342)' instead. And it seems that exactly this is saved in the database: the string 'ARRAY(0x42342)'....

So my questions on this:
- How to store the selected values correctly into the database?

- How to display Form Names on add_success.html instead of Form Values? (This one was already discussed, but couldn't work it out)

- In the admin the multi select field is still shown as a single select field when validating a new link, and only the first value is stored into the database. So this bug wasn't fixed? Or did I miss something?


2. Date(s)

When adding a link I receive the notification mail, but its Date is set to 25th of January instead of May.

What could be the reason for this?
And - more important - how to set the correct date?
(All other programs I run still show the correct date, so it's definitely not a wrong server setting)


3. Dynamic display of cool links page

When I try to view the cool page in dynamic mode (haven't built since upgrading) I get a fatal error:
In Reply To:

A fatal error has occured:
Can't call method "fetchrow_hashref" on an undefined value at (eval 1) line 49.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (8698): Links::environment called at /homepages/24/d11723845/htdocs/cgi-bin/links2/admin/Links.pm line 450 with no arguments.
Links (8698): Links::fatal called at (eval 1) line 49 with arguments
(Can't call method "fetchrow_hashref" on an undefined value at (eval 1) line 49.
).
Links (8698): Links::Build::build_cool called at /homepages/24/d11723845/htdocs/cgi-bin/links2/admin/GT/Plugins.pm line 84 with arguments
(HASH(0x83c7adc)).
Links (8698): GT::Plugins::dispatch called at /homepages/24/d11723845/htdocs/cgi-bin/links2/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, /homepages/24/d11723845/htdocs/cgi-bin/links2/admin/Plugins, build_cool, *Links::Build::build_cool, HASH(0x83c7adc)).
Links (8698): Links::Build::build called at /homepages/24/d11723845/htdocs/cgi-bin/links2/page.cgi line 182 with arguments
(cool, HASH(0x83c7adc)).
Links (8698): main::generate_cool_page called at /homepages/24/d11723845/htdocs/cgi-bin/links2/page.cgi line 56 with no arguments.
Links (8698): main::main called at /homepages/24/d11723845/htdocs/cgi-bin/links2/page.cgi line 23 with no arguments.

System Information
======================================
Perl Version: 5.00502
Links SQL Version: 2.0.4
DBI.pm Version: 1.13
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT * FROM L2_Links WHERE ( isValidated = 'Yes' AND isPopular = 'Yes' )
ORDER BY Hits DESC,Rating DESC DESC
LIMIT 0, 10' Reason: You have an error in your SQL syntax near 'DESC
LIMIT 0, 10' at line 2
@INC =
/homepages/24/d11723845/htdocs/cgi-bin/links2/admin
/usr/lib/perl5/5.00502/i586-linux
/usr/lib/perl5/5.00502
/usr/lib/perl5/site_perl/5.005/i586-linux
/usr/lib/perl5/site_perl/5.005
.

CGI INPUT
======================================
d => 1
g => hits/
It seems that the SQL statement for building the cool page is incorrect (for some reason it added a second 'DESC'). In setup, I have build_sort_order_cool 'Hits DESC,Rating DESC' and build_cool_gb set to no.
I think this will happen when building static pages, too. So for now I won't build...

Any suggestions would be welcome!

Thank you,
Andreas

Andreas
http://www.archaeologie-online.de
Subject Author Views Date
Thread 2.04 questions / problems Digger 2681 May 25, 2001, 8:40 AM
Thread Re: 2.04 questions / problems
Alex 2581 May 27, 2001, 8:25 PM
Post Re: 2.04 questions / problems
Digger 2538 May 31, 2001, 1:06 AM
Post Re: 2.04 questions / problems
Digger 2491 Jun 1, 2001, 2:05 AM
Thread Re: 2.04 questions / problems
OnlineMlm 2427 Jun 17, 2001, 12:38 PM
Post Re: 2.04 questions / problems
Alex 2394 Jun 18, 2001, 3:45 PM
Post Re: 2.04 questions / problems
pugdog 2424 Jun 17, 2001, 3:10 PM