So it rather fast not slow :=)
But the edited_by column is not showing a name, it shows a number.
But that is not very intresting as I don´t need a list like that, it was
just a test. I´m trying to optimize some reporting functions. I´ll have
to start from an other angle.
Kenneth
Now I
Apache 2, wsgi, MySQL, Python 2.6.5, web2py 1.90.6
After upgrading to the new DAL I occasionally get this error. Sometimes
I have to reload the page 1-4 times to get it working.
Should I upgrade to 1.91.4 or do you need some more info?
Kenneth
Error ticket for init
Ticket ID
980 rows, 10 columns of data,
38 sec.
MySQL server is on the same server, Apache server is not local, but the
delay is allways 38-39 seconds.
Kenneth
No idea. How much data.
What db? is it local? Probably something is wrong anyway.
On Dec 24, 5:55 pm, Kenneth Lundströmkenneth.t.lundst
sanitized error report without IP-addresses, folders and so on that you
can just copypaste to the list. I don´t know if I´m paranoid but I
don´t like to put everything on an open list. Maybe a link at top of the
page to a sanitized error report.
What do you think?
Kenneth
. It
takes 1.2-1.3 seconds to fetch the data, but then over 60 seconds to display it.
Kenneth
I have never seen this before I upgraded to a version with the new DAL
and it show any very occasionally. Today I got it a lot, so I upgraded
to 1.91.4 and so far havn´t got it.
Kenneth
I cannot tell. The traceback is in pymysql so I would post there too.
Can you tell us more?
On Dec 25, 4
the trunk. Could
not find the hg command in the book?
Kenneth
+1
On Fri, Dec 24, 2010 at 8:20 AM, Luis Díazdiazluis2...@gmail.com wrote:
+1
2010/12/24 ron_mron.mco...@gmail.com
I for one am happy with the current release cycle. It is a good balance
between new features and the ultimate
to a not
stable release candidate.
Kenneth
On Fri, Dec 24, 2010 at 10:18 PM, VPvtp2...@gmail.com wrote:
For one thing, I don't think the 2-button suggestion is a good idea;
it's just another indirect layer of information that might not be
meaningful if the underlying mechanism is meaningful
I finally had time to find out a little about loggin.conf.
In my logs/web2py.log I get this line:
2010-12-25 01:42:30,097 - root - INFO - time to fetch 1.81220602989
So it takes under 2 seconds to fetch the data and the rest 37 to show
it? How come?
Kenneth
Were is this logged, I could
?
- If I choose to make a different table, some of the members will be
using the intranet so they their e-mailaddress would be in two places
Kenneth
Have you tried to upgrade to 1.90.2 that uses the new DAL interface?
Kenneth
https://groups.google.com/forum/#!topic/pymysql-users/vrnKcoE6ZD0
Try to move the web2py.pid file and try again.
Kenneth
Thanks for the tip! Removed --quiet from the two lines. The service
still doesn't appear to start on startup (after reboot). When I
manually start with /etc/init.d/web2py (root user) I get this: No
process in pidfile '/var/run/web2py
return dict(records=db().select(db.tablename.ALL))
You can´t use the word tablename if you don´t have a table named
tablename. If you wan´t to have everything from a table named customers use
return dict(records=db().select(db.customers.ALL))
Kenneth
it throws below error
Traceback (most
One way of doing this is to export all data while connected to Postgres
and then import to MySQL. And doing the import and export via web2py.
Kenneth
Hi, i wanto to know if there is a way to change from Postgres to MySQL
and keep all the information in the db. How can i do that?
Thanks
http://web2py.com/book/default/chapter/06?search=csv#Exporting-and-Importing-Data
Kenneth
Thaks Kenneth, do you know where can i find some examples or
documentation about this?
On Dec 10, 4:16 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
One way of doing this is to export all
Just curious but are you sure that column 3 on rows 1-15 and 32 onward
are empty. When just tested to make a CSV file with Excel 2010 and if
column 3 is empty Excel doesn´t put any closing characters on column 2.
Kenneth
Weird, looks like an Excel'97 bug. It stopped putting the closing
This just a crazy idea but would it be better to move the XML() into the
view so return would look like:
return dict(results=urllib2.urlopen(req).read())
and view:
div class=entryp{{=XML(results)}}/p
Kenneth
I am trying to display some XML that has been screen scraped I want to
display
Hello,
have you read the web2py book, specifically chapter 11,
http://web2py.com/book/default/chapter/11 it should tell the most.
If you still have questions will try to answer them.
Kenneth
Now I do understand that I am probably asking a very rudimentary
question but in the end I need
Hi Ryan,
you can find a fcgihandler.py file in the root web2py folder. I havn't
used fcgi but the fcgihandler seems to have an example on how webserver
should be configured.
Kenneth
Thanks for the responses guys. I read all of chapter 11 and I must say
this is why I feel like really am
Were is this logged, I could not find anything in any logs?
Kenneth
try
import time, logging
def testing():
t0=time.time()
orders = db(db.orders.id 0).select()
logging.info('time to fetch %s' % (time.time()-t0))
return orders
so you can isolate the problem and see
long times?
Kenneth
Of course I forgot something,
python 2.6.5
Kenneth
Hello list,
need some help finding out why my server is so slow.
The server is with a Intel Celeron 2.66 GHz CPU, 4 GB of memory
CentOS 5.5 64-bit, Apache 2.2.3, MySQL 5.0.77, mod_wsgi, Web2py 1.89.5
The server is dedicated to web2py
(troops) it only takes 1,5 seconds.
I have no view defined, just trying out the database.
Kenneth
On Dec 2, 5:13 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
Hello list,
need some help finding out why my server is so slow.
The server is with a Intel Celeron 2.66 GHz CPU, 4 GB
.
Kenneth
2010/12/2 Kenneth Lundströmkenneth.t.lundst...@gmail.com:
Please tell us more about the setup. Are the three instances behind
running on the same server?
Yes.
why three? What do they do?
One is production, one is testing and last one is development. I had two
instances running
, when looking at the file in
notepad I can find out what character to replace with.
Kenneth
def __responseHeaders(fName=None):
response.headers['Content-Type'] = 'text/csv; charset=utf-8'
# duplicita s gluon\main.py, ale Expires se tam dělá pomocí time
objektu
response.headers
If there is nothing else on the market and it costs enough (it has to be
good).
Kenneth
Learning Scorm what a crappy protocol:
1) it is a method for zipping lectures and metadata
2) lectures are in html and are vulnerable to XSS
3) mixes content and presentation
4) can contain quizzes
I have no problem using åäö when reading and writing these characters
from database, also no problem displaying them on screen.
But when sending them to a CSV file and opening it in Excel åäö are not
shown correctly.
Has anybody succeeded in this?
Kenneth
If you have access to the file system you can find the error ticket in
the folder /applications/admin/errors
Kenneth
I tried the last version in trunk, and the admin application generates
a ticket... and looking at the ticket generates another ticket! (which
is the reason why I cannot
Please send it, it´s the only way to find out what the problem is.
Kenneth
Thank you Kenneth!
I must admit the file is difficult to analyze manually -- I'm happy to
send it as an attachement if useful.
On 26 nov, 09:21, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
If you have
Are the group and ownership of the files in /applicatios/admin correct.
Could you send a copy of the error file as I can´t access it from
outside without a password and not when admin is no working.
Kenneth
Open this file with an editor
/home/www-data/web2py/applications/admin/errors
kind of a problems do you have?
Kenneth
I ran into a problem with setting up SSL too which turned out to be
caused by an ssl.conf file that was overriding the web2py.conf
settings. I had similar messages in error.log, but as the [warn]
indicates, they do not seem to be fatal errors. The errors I
found the problem, I had no deposit folder in my web2py root folder. I
don´t know when it should have been created but I created it now by hand
and not it works.
Kenneth
2010/11/22 Kenneth Lundström kenneth.t.lundst...@gmail.com:
Can you clarify what does this mean?
When I select a layout
. Where
do I store this value and how do I sort the list of partners so I get a
TOP10 list?
Somehow this doesn´t feel like a big deal to implement but can´t get
started.
Kenneth
Calculation is a lot more complicated then just a sum. I have to select
data from 3-4 tables and then do the calculations.
Maybe your second suggestion is the solution. How would you maintain
the list so ten biggest rows is on the list and the list stays in
correct order?
Kenneth
a firewall issue. Port 443 should be open.
Kenneth
Your are receiving that warning because your certifcate is for domain
pypy.domain.com but in your configuration your are talking about an
ip-address.
This is a university computer, so I actually don't have a real domain
name, it's only IP-based
that
started two years ago that I have now upgraded to 1.89.5. I just tested
to create a new application there and applying layout works.
Kenneth
minor bug fixes, addressing some of the recently raised issues, please
check it and report any open issue.
Can you clarify what does this mean?
When I select a layout when using the wizard to create a new application
the layout is not applied. It shows the application without the layout I
have selected.
Kenneth
This is a relative fresh installation of web2py, maybe 1.88 something
this is my
I have tried 2 or 3 different layouts, non of them worked. Which files
are updated?
Is it possible from the Admin to change the layout later on?
Kenneth
Is this for one particular layout?
On Nov 20, 8:53 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
because edit is more
I´m getting the exact same error, on 1.89.4 and python 2.6.5
Apache, linux, mod_wsgi, mysql
Kenneth
Can't change admin password in new version. See traceback below..
--
VERSION web2py™ Version 1.88.2 (2010-10-29 23:04:43)
Python Python 2.5.2: /usr/bin/python
TRACEBACK
Traceback
that application works. When I tried again I couldn´t get the
error, so I don´t know why this happened.
Kenneth
Version
web2py™ Version 1.89.4 (2010-11-19 02:50:05)
Python Python 2.6.5: /usr/bin/python
Traceback
Traceback (most recent call last):
File /data/domains/web2py/gluon/restricted.py
the
layout to see a bigger picture.
Kenneth
?
Kenneth
Fixed the typo, thanks.
On Nov 20, 2:41 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
Admin first page, why is the edit button black when all the others are
grey? It looks like the edit button is allready pressed.
On page /admin/wizard/step5/0:
Use the markmin syntax syntax
{{for company in companies:}}
tr
td{{=uuid}}/td
td{{=address}}/td
/tr
{{pass}}
Shouldn´t this be like
td{{=company.uuid}}/td
td{{=company.address}}/td
or maybe
td{{=companies[company].uuid}}/td
td{{=campanies[company].address}}/td
Kenneth
has no attribute 'endswith'
Error snapshot help Detailed traceback description
type 'exceptions.AttributeError'('NoneType' object has no attribute
'endswith')
Kenneth
be if the help button would be page sensitive, so when you
are on say step 3 in the wizard you´d get a step 3 help page.
Kenneth
What can I do to fix this? What kind of path issue is this?
Kenneth
hmmm. I can make the error go away but this is a path issue
On Nov 17, 3:31 pm, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
I tried to upgrade version 1.89.1 to 1.89.3. I got the following error.
I m running
The Upgrade problem I can´t test of course but now I manually upgraded
to 1.89.3 and still have the problem with creating a new application.
Kenneth
I do not have enough information to debug this. I suggest get 1.89.3
and see if you still have the problem, then I will suggest a test
Apache, mod_wsgi, Linux, MySQL, source
Kenneth
what is you configuration (source/binary, apache/rocket)?
On Nov 18, 6:35 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
The Upgrade problem I can t test of course but now I manually upgraded
to 1.89.3 and still have the problem
else to write.
Kenneth
I see the problem but I do not understand why you have it. This should
manifest itself when you upgrade, not when you create a new app. Can
you list steps to reproduce the problem?
I am close to fixing it...
On Nov 17, 3:31 pm, Kenneth Lundströmkenneth.t.lundst
OK, I have no idea if they are related, it was just a thought on my part.
Kenneth
Thanks Kenneth,
the traceback you posted applies to the second problem and I
understand that. I am scratching my head on why that traceback would
also apply to the first problem.
Massimo
On Nov 18, 7:09 am
I´m too happily employed but doing some web2py development on my spare
time. You never know when a big,perfect job comes looking for you. If
your not on the list it might go to somebody else.
Kenneth
A bit off topic question -
I am currently happily employed and developing web2py based open
Correct, you edit the db.py file and reload a page and the database is
updated.
Kenneth
They are not set to false.
I'm coming from a slight rails perspective (some experience with it). In rails,
migrations are sequential. If you want to add a field to a table, you create a
new migration
for this beginners mistake.
But the problem with creating a new application stays.
Kenneth
On Nov 18, 2010, at 7:03 AM, Kenneth Lundström wrote:
OK, I have no idea if they are related, it was just a thought on my part.
Kenneth, in gluon/admin.py you'll find this code:
full_url = url
Now I finally found the problem. It looks like welcome.w2p is missing
from the source package.
When I copied a welcome.w2p to my web2py root directory I can create
applications.
Kenneth
On Nov 18, 2010, at 7:03 AM, Kenneth Lundström wrote:
OK, I have no idea if they are related
I tried to upgrade version 1.89.1 to 1.89.3. I got the following error.
I´m running Linux, Apache and mod_wsgi. Is this too an file permission
problem. I still can´t create a new application with admin. Don´t know
where to start looking for the problem.
Kenneth
Version
web2py™ Version
be it started to work. I just
hate when things start to work without knowing what the problem was.
Kenneth
Now that I got the MySQLdb solved I'm trying to solve the problem with the new
admin.
I did a chmod -R 777 * on all files in my web2py directory and also a chown -R
apache:web2py * and still I get a Failed to create application testing.
In what file I start to look for the problem?
Kenneth
via yum
and tried to install it from source, no luck.
Kenneth
Doesn´t SQLFORM do this automatically?
One other way to do this would be like this.
In controller:
rows = db(db.data_table.id 0).select()
return dict(rows=rows)
In view:
form
table
{{for row in rows:}}
trtdrow.id/tdtdrow.data/td/tr
{{pass}}
/table
/form
Kenneth
Hi! I want to create a FORM
Where can I start to look for the problem. Is the problem written in
some log?
Kenneth
It is a file permission issue.
On Nov 13, 12:33 am, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
Centos 5.5, Apache 2 and mod_wsgi.
I tried using the New simple application. I gave it a name
I´ve read many posts about domains linked to different apps but still I
don´t know how to do it with Apaches virtual hosts.
I have looked at the web2py slices number 14.
Does anybody have two virtual hosts files or entries that you could send
that I could look at?
Kenneth
+1
I was thinking the same when I was using the wizard first time. Maybe so
that you still could do like you do now, write evertything or then you
could select everything from a dropdown box and checkboxes.
Kenneth
In the table creation step, how about having some columns with all
I hate about websites is empty
pages, why have a link in the menu if the page is empty. Maybe remove
the Projects link until there is something. Or atleast write something
there.
Kenneth
Not at all. It just happened that I have been monitoring today and I
know the people who filled
/81.17.193.228.2010-11-12.13-29-46.5651ebc2-31b8-43df-94f0-44b48c2d4647
Kenneth
Not at all. It just happened that I have been monitoring today and I
know the people who filled the form, so I approved them. You
specifically have been a contributing member of this community for
some time. I
the error?
Kenneth
of the applications directory to 777 but no luck.
Kenneth
On Nov 12, 5:30 pm, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
Just installed the newest version of web2py (1.89.1) and tested the
wizard to create a new appl.
I came to step 6 when I got a error.
Version
web2py Version
Centos 5.5, Apache 2 and mod_wsgi.
I tried using the New simple application. I gave it a name och pressed
create. I get unable to create application 'testing'.
Kenneth
What is your setup? apache?mod_wsgi?
On Nov 12, 5:48 pm, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
Can
Hello list,
have any of you tried to find out data about a book via the ISBN
number, maybe using web2py.
Kenneth
to be in
the database it can´t be empty.
Kenneth
hi
why is order of validators important?
i have
db.tecaj.voditelj.requires=IS_NOT_EMPTY()
db.tecaj.voditelj.requires=IS_IN_DB(db,'person.id','%(name)s')
why does putting the IS_NOT_EMPTY() at the end doesn't produce
dropdown list?
do i need
of
the appontment. 5 and 2 are not exactly neccesary as all appointments have a
unique id, but often it is good to have them in the address. If nothing else it
is good to allways use the same syntax.
Kenneth
- Alkuperäinen viesti -
I have an app that supports multiple organizations
Isn´t there a special character code for space to, like for åäö?
Kenneth
This gets me pretty close!
I can't put spaces in the field... is there a way to do that?
In the end I will be parsing by space for a search feature I am trying
to implement.
Best Regards,
Jason Brower
On Thu, 2010-10
1) sounds like a problem with Apache configuration. Please post your
Apache configuration.
2) First thing that comes into mind with this is that communication
between Python and MySQL is not working. Is MySQL-python installed,
are database privileges correct?
Kenneth
On Oct 22, 2:19 am, VP
Definitely A
Kenneth
P.S. Anyway... everybody should say their opinion now:
A)
http://www.web2py.com/examples/static/img/logo_lb.png
B)
http://www.solieworks.com/images/solie_web2py.png (first)
C)
http://www.solieworks.com/images/solie_web2py.png (second)
a coherent overwhelming response
http://web2py.com
Looking very nice.
New demo_admin:
http://web2py.com/demo_admin
Whats new in the new admin? Could not see anything new with a fast look.
Kenneth
know
about all extensions, hopefully somebody else can help you with that.
Kenneth
if i wanna execute every day the function daytask in my controller
automatictask i neet to do:
1) edit web2py 1.84.4\applications\xxx\cron\crontab
2) add a row (my crontab is empty) -- @dayly root
?
If I use _type=submit I get the variable, but then the submit button
shows the ordernumber value.
Any ideas?
Kenneth
Now I have set the ID but where do I see it when the form is sent?
Kenneth
On Oct 4, 4:09 pm, Kenneth kenneth.t.lundst...@gmail.com wrote:
I set the name, thats where Firefox picks it up, but no ID. I´ll try
with the ID.
Kenneth
On Oct 4, 4:05 pm, rochacbruno rochacbr...@gmail.com wrote
Does anybody know if this is even possible?
Kenneth
On 4 loka, 20:04, Kenneth kenneth.t.lundst...@gmail.com wrote:
Now I have set the ID but where do I see it when the form is sent?
Kenneth
On Oct 4, 4:09 pm, Kenneth kenneth.t.lundst...@gmail.com wrote:
I set the name, thats where
and Chrome, works well.
Can you share your piece of code?
2010/10/4 Kenneth kenneth.t.lundst...@gmail.com
Does anybody know if this is even possible?
Kenneth
On 4 loka, 20:04, Kenneth kenneth.t.lundst...@gmail.com wrote:
Now I have set the ID but where do I see it when the form
Any ideas how to disable a user to login?
I don´t want to delete users as they have done things in the system
and I want to be able to check whos done what.
Is the easiest thing to change theres passwords? But then they can
request a new password.
Kenneth
.
Kenneth
But how should that list look like.
mail_receivers = 'kenn...@test.com, kenn...@test2.com' does not work,
it only sends that mail to the first receivers.
Kenneth
On Sep 28, 3:50 pm, mdipierro mdipie...@cs.depaul.edu wrote:
exactely like you said:
def send(
self
Hello,
The auth_user table contains field login_date
Should this contain the date and time when user has last time logged
in?
Is this field updated automatically?
If it should update automatically why isn´t it doing it anymore?
Kenneth
)
but adding bcc like this:
mail.send(to = email_receivers, cc = cc_receivers, bcc=bcc_receiver,
subject = subject, message = message)
doesn´t work. bcc_receiver contains one address
Kenneth
On Sep 28, 4:31 pm, mdipierro mdipie...@cs.depaul.edu wrote:
mail_receivers = ['kenn...@test.com','kenn
('view_only', 'boolean', default=0),
db.Field('hide_setting', 'integer', default=0))
I guess it is the guy before me who added that field. I´ll have to ask
him whats the point with it.
Kenneth
On Sep 28, 8:49 pm, mdipierro mdipie...@cs.depaul.edu wrote:
there is no login_date field
.
Kenneth
I installed Firebug and restarted firefox. Voila yellow color is
visible. Was it the installation of Firebug, restarting firefox or
reloading the page that made the color appear again.
Kenneth
It should still work but the color be orange instead of red. Can you
check the source
I´m just updating my CSV import which generates password so I found
this line of code:
password =
base64.b64encode(sha.sha(str(random.random())).hexdigest())[:8]
Kenneth
hi all,
how i can generate a random string of 8 numbers/letters?
i need for generate an automatic
example.com/phpsite and example.com/web2py your going to
the same place. The part after / is part of the hostname so
NameVirtualHost doesn´t use it.
Kenneth
Your answer convinced me that I do not know enough of NameVirtualHost
and I decided read some documentation about it.
I have it working
import sha, random, base64
I have theese imports.
Kenneth
i have an error
NameError: global name 'base64' is not defined
On 14 Set, 10:10, Kenneth Lundströmkenneth.t.lundst...@gmail.com
wrote:
I m just updating my CSV import which generates password so I found
this line of code
Would it be possible to look into the fact that when storing 24:00:00
and read out it will be converted into a value of 1 day instead of 24:00:00.
Kenneth
I will look. If this is a web2py issue it will be fixed.
On Sep 14, 4:14 pm, Fredfre...@gmail.com wrote:
I've got an application
I´m trying to change the length of a string from 35 to 50 but I get
errors.
db.define_table('district',
db.Field('name', 'string', length=35, requires=IS_NOT_EMPTY()),
I´m trying to change it to:
db.define_table('district',
db.Field('name', 'string', length=50,
Hello,
I have a tablefield defined as decimal(10,2).
Fields for SQLFORM is defined as:
fields=['price_consumer']
field_labels=['price_cunsumer': T('price consumer')]
and then the form is generated as:
form = SQLFORM(db.product, fields=fields, labels=field_labels)
When I try to fill the form
is no
very, very easy. Why not make it as easy to upgrade to newest version
in trunk. I know it is very easy already but why not take it the last step.
Kenneth
flash now stays put in the top right corner
improved behavior for URL and T objects
new app level logging with logging.conf (thanks Jonathan
One way of solving this would be like this:
table
{{counter = 1}}
{{for row in rows:}}
{{if counter == 1:}}
trtd{{=row.facility}}/td
{{counter = 2}}
{{else:}}
td{{=row.facility}}/td/tr
{{counter = 1}}
{{pass}}
{{pass}}
/table
Kenneth
I have the following
I´m pretty sure this worked before but now i can´t get the texts Email
and Password translated on the login page.
Kenneth
Is there a way to log unseccessful logins, with username, tried
password and things like that?
I´m having some problems with a couple of users not been able to
login. Or do you have some other ways/ideas to troubleshoot this?
Kenneth
Hello,
how do I use HTML Helper to get make a th and checkbox tag.
THINPUT type=checkbox name=check_all onClick=return
popup(this, 'notes')/th
The TH and checkbox is easy, but where do I put the onClick part?
Kenneth
Thank you Massimo again for a very fast reply.
Kenneth
TH(INPUT(_type=checkbox, _name=check_all, _onclick=return
popup(this,'notes')))
On Sep 4, 8:25 am, Kennethkenneth.t.lundst...@gmail.com wrote:
Hello,
how do I use HTML Helper to get make a th and checkbox tag.
THINPUT type=checkbox
://groups.google.com/group/web2py/browse_thread/thread/5aa2e4d43e1776a0/e727f2b5c635346d?lnk=gstq=cpanel#e727f2b5c635346d
Hopefully this helps.
Kenneth
3) Any other stuff I am missing. I am not at all familiar with
deployment. please help...
Please help.
Thanks, Rahul
401 - 500 of 546 matches
Mail list logo