db = DAL('mysql://....w2p,pool_size=100')
should be
db = DAL('mysql://....w2p',pool_size=100)
On Nov 26, 5:34 am, tOlorun <[email protected]> wrote:
> Hi guys
>
> iam new to using web2py framework and iam getting this error
>
> Traceback (most recent call last):
> File "/usr/lib/pymodules/python2.7/gluon/restricted.py", line 192,
> in restricted
> exec ccode in environment
> File "/home/oluwaseun/web2py/applications/mySQLsbApp/models/db.py",
> line 18, in <module>
> db = DAL('mysql://root:root@localhost:3306/
> w2p,pool_size=100') # if not, use SQLite or other DB
> File "/usr/lib/pymodules/python2.7/gluon/dal.py", line 3905, in
> __init__
> raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
> (attempts, error)
> RuntimeError: Failure to connect, tried 5 times:
> (1049, u"Unknown database 'w2p,pool_size=100'")
>
> i have used a wrong password and i get the a different error
>
> i have also researched the internet to see if i will get a
> solution ... but i could not find a solution
>
> can anyone here PLEASE help ... ?
>
> i have been on this for quite some days now ...
>
> Thanks in advance ...