[freeside-users] error while adding an export

[Ivan Kohler]

On Mon, Aug 14, 2006 at 10:05:21AM -0400, Chris Mazuc wrote:
> I'm using a CVS snapshot from 08/01/06, HTML::Mason version 1.33, Debian 
> 3.1, perl 5.8.8, Postgresql 8.1.4, DBI 1.51, and DBd::Pg 1.49.
> 
> Whenever I attempt to add an export (shellcommands_withdomain) I get 
> this error:
> 
> Error: can't parse part_export.exportnum default value for sequence name:

Did you upgrade an existing database to Pg 8.1?

Does bin/dbdef-create help?

-- 
_ivan

> I'm sure that means something to someone more familiar with freeside 
> than myself, but that is incomprehensible to me at this time. If you 
> need any more information to help me I would be more than happy to get 
> that to you.
> 
> The only other error I could find was in the apache error log, but I'm 
> not sure if it has anything to do with the error I received above.
> 
> [Thu Aug 10 14:32:53 2006] [error] [client 209.168.219.139] 
> mod_mime_magic: invalid type 0 in mconvert().
> FS::CGI::menubar deprecated; include /elements/menubar.html instead at 
> /var/www/freeside/edit/part_export.cgi line 107
> 
> When attempting to add the export, the query generated is as follows:
> 
> https://<myip>/freeside/edit/part_export.cgi?exportnum=;machine=localhost;exporttype=shellcommands_withdomain;user=freeside;useradd=%2Fusr%2Flocal%2Fbin%2Fmailbox.pl%20add%20%24username%20cmghost.net%20%24quoted_password%20%20;useradd_stdin=;userdel=%2Fusr%2Flocal%2Fbin%2Fmailbox.pl%20del%20%24username%20cmghost.net;userdel_stdin=;usermod=%2Fusr%2Flocal%2Fbin%2Fmailbox.pl%20mod%20%24username%20cmghost.net%20%24quoted_password%20%20;usermod_stdin=;usermod_pwonly=1;usermod_nousername=1;suspend=%2Fusr%2Flocal%2Fbin%2Fmailbox.pl%20suspend%20%24username%20cmghost.net%20;suspend_stdin=;unsuspend=%2Fusr%2Flocal%2Fbin%2Fmailbox.pl%20unsuspend%20%24username%20cmghost.net;unsuspend_stdin=;crypt=md5;options=user%2Cuseradd%2Cuseradd_stdin%2Cuserdel%2Cuserdel_stdin%2Cusermod%2Cusermod_stdin%2Cusermod_pwonly%2Cusermod_nousername%2Csuspend%2Csuspend_stdin%2Cunsuspend%2Cunsuspend_stdin%2Ccrypt;nodomain=;error=can%27t%20parse%20part_export.exportnum%20default%20value%20for%20sequence%20name%
> 3A%20
> 
> Is freeside supposed to be setting exportnum? I've tried looking at 
> part_export.cgi, but I'm a relative beginner in perl and what's going on 
> in there is greek to me.
> 
> Thank you for your time,
> Chris Mazuc
> Systems Administrator
> DataGroup Technologies