Re: [web2py] Re: 2.18.1 is OUT

2019-02-25 Thread Carl Petersen 
Agreed, download link is currently broken.

On Monday, February 25, 2019 at 12:38:01 AM UTC-6, Lovedie JC wrote:
>
> Having trouble with download page:
> See attached.
>
> On Mon, 25 Feb 2019 at 07:57, Alex Glaros  > wrote:
>
>> am on Windows 
>>
>> -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Problem with wsgihandler.py Apache/Python3

2018-12-07 Thread Carl Petersen 
I was able to get web2py up and running by changing the following line 
(131) in http.py  I don't expect that this was the proper way to do it 
(especially considering backward compatibility), but at lease it might 
point out where the issue is:

elif isinstance(body, (str, bytes, bytearray)):
 if isinstance(body, unicodeT):
 body = to_bytes(body)
 return [body]
elif hasattr(body, '__iter__'):
return [x.encode('utf-8') for x in body]  - Changed from  
"return body"
else:
body = str(body)
if isinstance(body, unicodeT):
body = to_bytes(body)
return [body]
 
I didn't know whether I should just apply to_bytes(body) like the other 
returns because the other returns were coded "return [body]" instead of 
"return body".

Thanks

On Friday, December 7, 2018 at 7:50:16 AM UTC-6, Carl Petersen wrote:
>
> Hello,
>
> I'm having a similar issue.  I'm using Python 3.6.6, mod_wsgi 4.6.5, 
> Apache 2.4.6 with web2py 2.17.2.
>
> I can get to the welcome screen, but as soon as I try to access the admin 
> application I get the following on my screen:
>
> Internal Server Error
>
> The server encountered an internal error or misconfiguration and was 
> unable to complete your request.
>
> Please contact the server administrator at root@localhost to inform them 
> of the time this error occurred, and the actions you performed just before 
> this error.
>
> More information about this error may be available in the server error log.
>
>
> And this in my apache error_log:
>
>  [Fri Dec 07 08:32:14.626246 2018] [mpm_prefork:notice] [pid 30005] 
> AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips 
> mod_wsgi/4.6.5 Python/3.6 configured -- resuming normal operations
>
> [Fri Dec 07 08:32:33.572686 2018] [wsgi:error] [pid 30007] [remote 
> 10.20.100.133:56416] mod_wsgi (pid=30007): Exception occurred processing 
> WSGI script '/opt/web-apps/web2py/wsgihandler.py'.
>
> [Fri Dec 07 08:32:33.572836 2018] [wsgi:error] [pid 30007] [remote 
> 10.20.100.133:56416] TypeError: sequence of byte string values expected, 
> value of type str found
>
> Any assistance would be greatly appreciated.
>
>
>
> On Sunday, September 2, 2018 at 1:03:30 PM UTC-5, motionbutterfly wrote:
>>
>> Hello, I was wondering if anyone here could help me. I've been migrating 
>> a web2py application from Python2.7 to Python3.4, this application was 
>> already being hosted in a webserver with Apache2.4 following the steps in 
>> the Deployment Recipes chapter of the web2py book. I reconfigured apache to 
>> run with python 3, and reinstalled mod_wsgi using pip. My problem is that 
>> as soon as I load my application I get an internal error, and when I click 
>> on the ticket it shows me "500 Internal Server Error", and when I look up 
>> the error log for apache this is what comes up: 
>>
>> [Thu Aug 23 22:42:17.748139 2018] [wsgi:warn] [pid 2268:tid 
>> 139927378876288] mod_wsgi: Compiled for Python/3.4.2rc1+.
>> [Thu Aug 23 22:42:17.748154 2018] [wsgi:warn] [pid 2268:tid 
>> 139927378876288] mod_wsgi: Runtime using Python/3.4.2.
>> [Thu Aug 23 22:42:17.896498 2018] [mpm_event:notice] [pid 2268:tid 
>> 139927378876288] AH00489: Apache/2.4.10 (Debian) OpenSSL/1.0.1t 
>> mod_wsgi/4.3.0 Python/3.4.2 mod_perl/2.0.9dev Perl/v5.20.2 configured -- 
>> resuming normal operations
>> [Thu Aug 23 22:42:17.896584 2018] [core:notice] [pid 2268:tid 
>> 139927378876288] AH00094: Command line: '/usr/sbin/apache2'
>> [Thu Aug 23 22:45:29.528373 2018] [wsgi:error] [pid 2272:tid 
>> 139927187830528] 
>> [Thu Aug 23 22:45:29.528468 2018] [wsgi:error] [pid 2272:tid 
>> 139927187830528] 10
>> [Thu Aug 23 22:45:29.968522 2018] [wsgi:error] [pid 2272:tid 
>> 139927213033216] Loads pas\xc3\xb3
>> [Thu Aug 23 22:45:35.289112 2018] [wsgi:error] [pid 2272:tid 
>> 139927179421440] [remote 186.89.23.145:25178] mod_wsgi (pid=2272): 
>> Exception occurred processing WSGI script 
>> '/home/www-data/web2py/wsgihandler.py'.
>> [Thu Aug 23 22:45:35.289293 2018] [wsgi:error] [pid 2272:tid 
>> 139927179421440] [remote 186.89.23.145:25178] TypeError: sequence of 
>> byte string values expected, value of type str found
>>
>> Which seems to suggest that the problem is inside the wsgihandler.py 
>> script, but doesn't point out where. Has this happened to anyone else 
>> before?
>>
>> Thanks in advance for any help.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Problem with wsgihandler.py Apache/Python3

2018-12-07 Thread Carl Petersen 
Hello,

I'm having a similar issue.  I'm using Python 3.6.6, mod_wsgi 4.6.5, Apache 
2.4.6 with web2py 2.17.2.

I can get to the welcome screen, but as soon as I try to access the admin 
application I get the following on my screen:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable 
to complete your request.

Please contact the server administrator at root@localhost to inform them of 
the time this error occurred, and the actions you performed just before 
this error.

More information about this error may be available in the server error log.


And this in my apache error_log:

 [Fri Dec 07 08:32:14.626246 2018] [mpm_prefork:notice] [pid 30005] 
AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips 
mod_wsgi/4.6.5 Python/3.6 configured -- resuming normal operations

[Fri Dec 07 08:32:33.572686 2018] [wsgi:error] [pid 30007] [remote 
10.20.100.133:56416] mod_wsgi (pid=30007): Exception occurred processing 
WSGI script '/opt/web-apps/web2py/wsgihandler.py'.

[Fri Dec 07 08:32:33.572836 2018] [wsgi:error] [pid 30007] [remote 
10.20.100.133:56416] TypeError: sequence of byte string values expected, 
value of type str found

Any assistance would be greatly appreciated.



On Sunday, September 2, 2018 at 1:03:30 PM UTC-5, motionbutterfly wrote:
>
> Hello, I was wondering if anyone here could help me. I've been migrating a 
> web2py application from Python2.7 to Python3.4, this application was 
> already being hosted in a webserver with Apache2.4 following the steps in 
> the Deployment Recipes chapter of the web2py book. I reconfigured apache to 
> run with python 3, and reinstalled mod_wsgi using pip. My problem is that 
> as soon as I load my application I get an internal error, and when I click 
> on the ticket it shows me "500 Internal Server Error", and when I look up 
> the error log for apache this is what comes up: 
>
> [Thu Aug 23 22:42:17.748139 2018] [wsgi:warn] [pid 2268:tid 
> 139927378876288] mod_wsgi: Compiled for Python/3.4.2rc1+.
> [Thu Aug 23 22:42:17.748154 2018] [wsgi:warn] [pid 2268:tid 
> 139927378876288] mod_wsgi: Runtime using Python/3.4.2.
> [Thu Aug 23 22:42:17.896498 2018] [mpm_event:notice] [pid 2268:tid 
> 139927378876288] AH00489: Apache/2.4.10 (Debian) OpenSSL/1.0.1t 
> mod_wsgi/4.3.0 Python/3.4.2 mod_perl/2.0.9dev Perl/v5.20.2 configured -- 
> resuming normal operations
> [Thu Aug 23 22:42:17.896584 2018] [core:notice] [pid 2268:tid 
> 139927378876288] AH00094: Command line: '/usr/sbin/apache2'
> [Thu Aug 23 22:45:29.528373 2018] [wsgi:error] [pid 2272:tid 
> 139927187830528] 
> [Thu Aug 23 22:45:29.528468 2018] [wsgi:error] [pid 2272:tid 
> 139927187830528] 10
> [Thu Aug 23 22:45:29.968522 2018] [wsgi:error] [pid 2272:tid 
> 139927213033216] Loads pas\xc3\xb3
> [Thu Aug 23 22:45:35.289112 2018] [wsgi:error] [pid 2272:tid 
> 139927179421440] [remote 186.89.23.145:25178] mod_wsgi (pid=2272): 
> Exception occurred processing WSGI script 
> '/home/www-data/web2py/wsgihandler.py'.
> [Thu Aug 23 22:45:35.289293 2018] [wsgi:error] [pid 2272:tid 
> 139927179421440] [remote 186.89.23.145:25178] TypeError: sequence of byte 
> string values expected, value of type str found
>
> Which seems to suggest that the problem is inside the wsgihandler.py 
> script, but doesn't point out where. Has this happened to anyone else 
> before?
>
> Thanks in advance for any help.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] db._adapter.is_numerical_type no longer found

2018-12-04 Thread Carl Petersen 
Hello,

The following line in a view which used to work in web2py 2.6.x no longer 
works in 2.17.2.  I expect it has something to do with moving pydal to it's 
own package, but I'm not sure how to rectify the issue.

{{=db.error_invoice_line[fieldname].label}}

The error given is:

1.
2.
3.
4.
5.
6.

Traceback (most recent call last):
  File "/opt/web-apps/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
  File "/opt/web-apps/web2py/applications/wspg/views/error_invoice/view.html", 
line 225, in 
AttributeError: 'PostgrePsyco' object has no attribute 'is_numerical_type'

Any assistance would be appreciated.
Carl

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: UPDATE BOOTSTRAP VERSION FROM 3 TO 4

2018-10-05 Thread Carl Petersen 
Leonel, could you go into a bit more depth on the changes you had to make 
in the menu?  I would certainly appreciate it.


On Wednesday, April 26, 2017 at 8:51:15 AM UTC-5, Leonel Câmara wrote:
>
> The forms in Boostrap 4 are pretty much the same as in bootstrap 3, you do 
> need to change some stuff in the menu and grid.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Conditional IS_IN_DB

2017-06-19 Thread Carl Petersen 
Hello,

I have a screen that updates a code cross-reference table which contains a 
code-type field.  That code-type field has a master table.  What I want to 
do is validate the cross referenced codes in the code cross reference table 
against various master tables depending on the value of the code-type 
field.  For instance:

This is the code cross-reference:






Values:

code_type source_system_id source_code target_code 
target_source_system_id code_type_id source_system_dwid target_system_dwid 
id
TM V UPS 3 DAY SELECT 3DS   
  PS 8 (null)   
  (null) 797
TM V UPS NEXT DAY AIR NDA PS   
  8 (null) 
(null) 798
DT V COD - COLLECT Collect   
  MG 9 (null)   
  (null) 799
DT V COLLECT Collect   
  MG 9 (null)   
  (null) 800

This is the code type table:




Values:


code_type code_description  id

ML UNKNOWN   1

PT Payment Terms   2

CT Country   3

PC Profit Center   4

DP Department   5

SL Ship Location   6

SM GP Ship Method   7

TM Transport Mode   8

DT Delivery Terms   9

TC Transport Carrier 10

PlantCust Plants to Customers 12

II Ignore Inventory Plant 13

MC Shipping Country 11


What I would like is for the source and target code fields to be validated 
against different master tables based on the value of the code-type field. 
 For instance, if the code-type were "CT", I'd like the source and target 
codes validated against the country code master, but if the code-type field 
were "PC", then I'd like the source and target codes validated against the 
GL Profit Center table (ie... IS_IN_DB()).


Thanks,


Carl

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Multiple upload fields in a SQLFORM.factory

2015-10-28 Thread Carl Petersen 
Hello,

I am attempting to use multiple upload fields in a SQLFORM.factory.  The 
first field uploads a file, and the second specifies a filename to be 
written out to.

form = SQLFORM.factory(Field('billing_file', 
'upload',uploadfolder=os.path.join(request.folder, 
'uploads')),Field('excel_file','upload'))

unfortunately, when I press the submit button, I immediately get the 
following message:


This webpage is not found

ERR_FILE_NOT_FOUND
Hide details
No webpage was found for the web address:
*http://localhost:8000/wspg/electrolux_billing_tie_out/upload.html#*

Any ideas as to what I'm doing wrong.  Please let me know if additional 
information is needed.
Thanks,
Carl

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: MSSQLAdapter missing?

2015-05-08 Thread Carl Petersen 
OK,  I deinstalled the dist-packages version of pyDAL (I had just tried it 
on the off-chance that it would work anyway)  It is now using the embedded 
version of pyDAL.  Unfortunately, still the same error.  I ran the command 
from the microsoft odbc driver manager instructions to verify my install:

odbcinst -q -d -n ODBC Driver 11 for SQL Server

and received the following info:

[ODBC Driver 11 for SQL Server]
Description=Microsoft ODBC Driver 11 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Threading=1
UsageCount=1

It seems to me that at least the driver manager is seeing the driver 
correctly.  Is there anything else I can try?  Any assistance would be 
greatly appreciated!

Carl

On Thursday, May 7, 2015 at 2:22:42 PM UTC-5, Niphlod wrote:



 On Thursday, May 7, 2015 at 6:01:17 PM UTC+2, Ron Chatterjee wrote:

 May be now people will start using mongodb and I will get all my question 
 answered! lol


 it doesn't have nothing to do with it.

 @carl: looks like you screwed something up... latest web2py version should 
 use pydal embedded in the repo, not a version stored in dist-packages. 
 moreover, your unixodbc installation seems to fail.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] MSSQLAdapter missing?

2015-05-07 Thread Carl Petersen 
Hello All,

Working with the latest versions of web2py and it seems that my sql server 
connections are breaking.  I noticed that a fairly large section of code 
related to MSSQLAdapter in gluon/dal.py has been taken out.  Should I be 
approaching sql server connections differently now.  I was previously using 
mssql3.

Thanks,

Carl 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: MSSQLAdapter missing?

2015-05-07 Thread Carl Petersen 
OK, obviously I approached this in the wrong manner.  Sorry!  I'm upgrading 
from 2.9.11-stable+timestamp.2014.09.15.23.35.11 to 
2.10.4-stable+timestamp.2015.04.26.15.11.54 
and it looks like DAL has changed somewhat in that timeframe.  For some 
reason it seems my sql server connections are unhappy (maybe related, maybe 
not).  I'm getting the following error:

db_gp_wspg = DAL('mssql3://DRIVER={ODBC Driver 11 for SQL 
Server};SERVER=server;DATABASE=database;port=port;domain=WSPG;UID=user;PWD=passwd',pool_size=1,check_reserved=None,migrate=False)
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py, 
line 169, in __call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py, 
line 456, in __init__
raise RuntimeError(Failure to connect, tried %d times:\n%s % 
(attempts, tb))
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py, 
line 434, in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/base.py,
 
line 53, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/mssql.py,
 
line 155, in __init__
if do_connect: self.reconnect()
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/connection.py,
 
line 126, in reconnect
self.connection = f()
  File 
/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/mssql.py,
 
line 153, in connector
return self.driver.connect(cnxn, **driver_args)
Error: ('01000', [01000] [unixODBC][Driver Manager]Can't open lib 
'/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0' : file not 
found (0) (SQLDriverConnect))

I have checked, and the file libmsodbcsql-11.0.so.2270.0 is located in 
that directory, and is readable.

If I have missed something obvious, my apologies.  website maintainer is my 
part-time hat, and a new one at that!

Thanks,

Carl

On Thursday, May 7, 2015 at 9:25:18 AM UTC-5, Niphlod wrote:

 still there. 
 https://github.com/web2py/pydal/blob/master/pydal/adapters/mssql.py . 
 noone removed anything.

 On Thursday, May 7, 2015 at 3:41:28 PM UTC+2, Carl Petersen wrote:

 Hello All,

 Working with the latest versions of web2py and it seems that my sql 
 server connections are breaking.  I noticed that a fairly large section of 
 code related to MSSQLAdapter in gluon/dal.py has been taken out.  Should I 
 be approaching sql server connections differently now.  I was previously 
 using mssql3.

 Thanks,

 Carl 



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Fill a field based on the value from another autocomplete field

2014-11-17 Thread Carl Petersen 
So what I'd like to do is once a user makes a selection from the drop down 
of an autocomplete field (for instance selecting a customer) in a view , 
I'd like to immediately update the address, city and state fields on the 
same view.  How would I go about that?

Thanks,

Carl

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] reference auth_user from a table in one database to the auth_user table in another database

2014-10-23 Thread Carl Petersen 
Hello,

I'm trying to reference the auth_user table in one database from a field 
definition for a table in a different database.  Hopefully the code below 
will clarify:

db1 = 
DAL('postgres://user:password@host1/database1',pool_size=1,check_reserved=None,migrate=False)
db = 
DAL('postgres://user:password@host/database',pool_size=1,check_reserved=['all'],migrate=False)

db1.executesql(set search_path to 'devxref','public';)
db.executesql(set search_path to 'po','xref','dw','public';)

*db*.define_table('x_vendor',
Field('source_vendor_dwid',db.d_supplier_source),
Field('source_vendor_id'),
Field('source_system_dwid',db.d_source),
Field('source_system_id'),
Field('gp_vendor_dwid',db.d_supplier_source),
Field('gp_vendor_id'),
Field('changed_date_time','datetime',
  default=request.now, update=request.now, writable=False),
Field('changed_user_id','reference *db1*.auth_user',
  default=auth.user_id, update=auth.user_id, writable=False),
format='%(x_vendor)s')

I get the following errors in the dump:

Traceback (most recent call last):
  File /opt/web-apps/web2py/gluon/restricted.py, line 224, in restricted
exec ccode in environment
  File /opt/web-apps/web2py/applications/wspg/controllers/x_vendor.py 
https://dc1ux544/admin/default/edit/wspg/controllers/x_vendor.py, line 127, 
in module
  File /opt/web-apps/web2py/gluon/globals.py, line 392, in lambda
self._caller = lambda f: f()
  File /opt/web-apps/web2py/applications/wspg/controllers/x_vendor.py 
https://dc1ux544/admin/default/edit/wspg/controllers/x_vendor.py, line 85, in 
add
if form.process().accepted:
  File /opt/web-apps/web2py/gluon/html.py, line 2303, in process
self.validate(**kwargs)
  File /opt/web-apps/web2py/gluon/html.py, line 2240, in validate
if self.accepts(**kwargs):
  File /opt/web-apps/web2py/gluon/sqlhtml.py, line 1671, in accepts
self.vars.id = self.table.insert(**fields)
  File /opt/web-apps/web2py/gluon/dal.py, line 9320, in insert
ret =  self._db._adapter.insert(self, self._listify(fields))
  File /opt/web-apps/web2py/gluon/dal.py, line 1354, in insert
query = self._insert(table, fields)
  File /opt/web-apps/web2py/gluon/dal.py, line 2903, in _insert
values = ','.join(self.expand(v, f.type) for f, v in fields)
  File /opt/web-apps/web2py/gluon/dal.py, line 2903, in genexpr
values = ','.join(self.expand(v, f.type) for f, v in fields)
  File /opt/web-apps/web2py/gluon/dal.py, line 1555, in expand
return str(self.represent(expression, field_type))
  File /opt/web-apps/web2py/gluon/dal.py, line 3079, in represent
return BaseAdapter.represent(self, obj, fieldtype)
  File /opt/web-apps/web2py/gluon/dal.py, line 2016, in represent
ftype = self.db[p[0]][p[2]].type
  File /opt/web-apps/web2py/gluon/dal.py, line 8512, in __getitem__
return self.__getattr__(str(key))
  File /opt/web-apps/web2py/gluon/dal.py, line 8522, in __getattr__
return ogetattr(self, key)
AttributeError: 'DAL' object has no attribute 'db1'



Any assistance would be greatly appreciated.

Thanks!

Carl

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.