[freeside-users] New User Looking for version suggestions

[Tim Yardley]

Robert;

I have also seen this error.  Ivan's code "fix" mentioned as a reply to
the previous thread doesn't solve this problem... As you have already
seen.  Looking in cvs, I don't see a fix in general for it... But I
could be missing it.

The problem lies in this call:
my $default = $self->dbdef_table->column($primary_key)->default;

Which on a fresh clean install will return the string "ERROR: null value
in column".  This may be fixed in a number of ways, a manual insert into
the table which will then prime the sequence, for example.

Ivan, do you have an approved workaround for this?

Side note, any place that returned text is going to be leveraged by
javascript (in the little pop-up display for example), should not use an
apostrophe.  If it does, it will break the javascript function call.
There are numerous places this applies at, but as a simple example (from
1.5.8 tarball):

--- Record.pm.orig      2006-06-20 14:12:36.000000000 -0500
+++ Record.pm   2006-06-20 15:11:32.000000000 -0500
@@ -759,7 +759,7 @@
       my $default = $self->dbdef_table->column($primary_key)->default;
       unless ( $default =~ /^nextval\('"?([\w\.]+)"?'/i ) {
         dbh->rollback if $FS::UID::AutoCommit;
-        return "can't parse $table.$primary_key default value".
+        return "cannot parse $table.$primary_key default value".
                " for sequence name: $default";
       }
       my $sequence = $1; 


----

Tim Yardley
Vice President of Research and Development
Pavlov Media, Inc.
(217) 353-3005

---- 


----

Tim Yardley
Vice President of Research and Development
Pavlov Media, Inc.
(217) 353-3005

----
 
-----Original Message-----
From: freeside-users-bounces at sisd.com
[mailto:freeside-users-bounces at sisd.com] On Behalf Of Robert Smith
Sent: Tuesday, June 13, 2006 7:25 PM
To: Freeside users mailing list
Subject: Re: [freeside-users] New User Looking for version suggestions

Sorry, should have mentioned I'd already read through the lists and had 
tried that.  I didn't use the Record.pm version there, but got the 
latest that was posted.  No change.  (The latest version seemed to have 
all of the same changes in it.  I scanned it but did not read it line 
for line.)

Robert

John wrote:

>Sorry Robert, this may be closer to the mark-
>http://www.sisd.com/pipermail/freeside-users/2006-January/004961.html
>
>
>
>
>  
>
>>I'm trying to get Freeside running for the first time.
>>
>>Using FreeBSD 6
>>PostgreSQL 8.1 (Didn't disable OID's, so assume they are there.)
>>Freeside 1.5.8
>>Apache22
>>Perl 5.8.8
>>DBI 1.51
>>DBD-Pg-1.49
>>
>>Everytime I try to add the initial svc_domain, I get " (progress of
job 
>>#can't parse queue.jobnum default value for sequence name: )"
>>
>>Any suggestions are welcome, to include a preferred list of versions
to 
>>run on FreeBSD.
>>
>>Robert Smith
>>
>>_______________________________________________
>>freeside-users mailing list
>>freeside-users at sisd.com
>>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>>
>>
>>-- 
>>No virus found in this incoming message.
>>Checked by AVG Free Edition.
>>Version: 7.1.394 / Virus Database: 268.8.3/362 - Release Date:
12/06/2006
>>
>>
>>    
>>
>_______________________________________________
>freeside-users mailing list
>freeside-users at sisd.com
>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
>  
>

_______________________________________________
freeside-users mailing list
freeside-users at sisd.com
http://420.am/cgi-bin/mailman/listinfo/freeside-users