Gossamer Forum
Home : Products : Gossamer Links : Discussions :

LSQL 2.20 link modification error

Quote Reply
LSQL 2.20 link modification error
Since upgrading to 2.20 I've been getting this error on a link to be modified that was in the database before the upgrade.
Code:

Unable to validate link: 1079. Reason: Column Expiry notification sent cannot be left blank.
Column Expiry Date cannot be left blank.

link modifications since the upgrade work fine.
Any help
Thanks
CCUnet
my Christian web
Quote Reply
Re: [ccunet] LSQL 2.20 link modification error In reply to
Its probably because no option has been set for those 2 fields, on old links. Try setting them before submitting the changed link, and it should work fine :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] LSQL 2.20 link modification error In reply to
Andy,
Been trying that but it doesn't take.

CCUnet
my Christian web
Quote Reply
Re: [ccunet] LSQL 2.20 link modification error In reply to
It's a bug the way changes are stored in the database. I'll have someone fix this on Tuesday (Monday's a public holiday here).

Adrian

Last edited by:

brewt: May 22, 2004, 4:03 PM
Quote Reply
Re: [brewt] LSQL 2.20 link modification error In reply to
Hi

Has this bug been fixed yet?

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] LSQL 2.20 link modification error In reply to
hello

Does anybody have received a fix for this bug?
I still have this problem, and my editors can't modify links.
Quote Reply
Re: [ridesworld] LSQL 2.20 link modification error In reply to
The problem is that those links were modified before the upgrade. The following code should fix the problem (admin/Links/Tools.pm, line 686):
Code:
@@ -686,6 +686,9 @@
my $link = eval $link_data->{ChgRequest};
my $user = $user_db->get($link->{LinkOwner});
my $update_user = '';
+ foreach my $col (keys %{$db->{schema}->{cols}}) {
+ exists $link->{$col} or $link->{$col} = $db->{schema}->{cols}->{$col}->{default};
+ }
$link->{$i . "-CatLinks.CategoryID"} = $link->{'CatLinks.CategoryID'};
my $form = $html->form({ values => $link, extra_table => 0, mode => 'validate', view_key => 1, multiple => $i, file_field => 1, file_delete => 1, file_use_path => 1 });

Adrian
Quote Reply
Re: [brewt] LSQL 2.20 link modification error In reply to
hello Brewt,

The problem still exist.
I think, there is something wrong in Links::HTML::Links
or in Links::Table::Links.

The column ExpiryDate has a default value that I wish to modify.

I can set link that has No Payment Required to Awaiting Payment or Never without problems,
but I get the error message when I set an ExpiryDate.

I have this when I update existing or recently added links from my admin, or from my Browser panel.
Quote Reply
Re: [brewt] LSQL 2.20 link modification error In reply to
Hello

The modify error comes from the form_expiry subroutine in Links::HTML::Links module.
This will submit 2 data strings for one column.
I found also insert errors the famous (you have an error in your SQL syntax near...) message.

Hopefully GT would rewrite this part of code & submit it here, so that users can update this module for their distribution.
In Reply To:
Quote Reply
Re: [ridesworld] LSQL 2.20 link modification error In reply to
Quote:
The column ExpiryDate has a default value that I wish to modify.
You don't need to, nor should you change the default value of the ExpiryDate column.

Quote:
I can set link that has No Payment Required to Awaiting Payment or Never without problems,
but I get the error message when I set an ExpiryDate.

I have this when I update existing or recently added links from my admin, or from my Browser panel.
Not sure what you're trying to do here.

Adrian
Quote Reply
Re: [ridesworld] LSQL 2.20 link modification error In reply to
In Reply To:
The modify error comes from the form_expiry subroutine in Links::HTML::Links module.
This will submit 2 data strings for one column.
I found also insert errors the famous (you have an error in your SQL syntax near...) message.

Hopefully GT would rewrite this part of code & submit it here, so that users can update this module for their distribution.
The code above only fixes the error initially reported. It occurs when link changes are submitted, then columns are added to the database (the upgrade to 2.2.0 added columns), and someone attempts to validate the change.

Adrian
Quote Reply
Re: [brewt] LSQL 2.20 link modification error In reply to
Hi Adrian,

Is this bug/problem fixed in the version that is available for download? am just little worried. cuz I am thinking of updating my current site to the new version of Links SQL.

Thanks for the help.

Vishal

Vishal
-------------------------------------------------------
Quote Reply
Re: [NeedScripts.Com] LSQL 2.20 link modification error In reply to
No it isn't. You can get around this problem by approving all the changes before upgrading.

Adrian