hey thanks peter..I did not know abt MySQLdb....got it now... John
On Nov 18, 12:11 am, "Peter Herndon" <[EMAIL PROTECTED]> wrote: > The other thing that comes to mind is, have you installed the MySQLdb > python library? If you want to connect to a database from a Python > app, you must also install a library that bridges Python and the > database. > > (I apologize in advance if you've already done so). > > ---Peter > > On 11/17/08, Karen Tracey <[EMAIL PROTECTED]> wrote: > > > > > On Mon, Nov 17, 2008 at 3:13 AM, John Antony <[EMAIL PROTECTED]> wrote: > > >> I have currently created a database with the following details: > >> DATABASE_ENGINE = 'mysql' > >> DATABASE_NAME = 'myforum' > >> DATABASE_USER = 'root' > >> DATABASE_PASSWORD = 'myforum' > >> DATABASE_HOST = 'localhost' > >> DATABASE_PORT = '' > > > Is this a cut and paste from your actual setting files? Because that > > setting for DATABASE_ENGINE -- all lowercase mysql -- is correct. > > >> I used phpMyadmin to create the database > > >> I have updated C:\projects\myforum\settings.py in the similar > >> fashion.... > > >> However when i run the the following command i get: > > >> C:\projects\myforum>python manage.py runserver > >> Validating models... > >> Unhandled exception in thread started by <function inner_run at > >> 0x027CC670> > >> Traceback (most recent call last): > >> File "C:\Python26\Lib\site-packages\django\core\management\commands > >> \runserver. > >> py", line 48, in inner_run > >> self.validate(display_num_errors=True) > >> File "C:\Python26\Lib\site-packages\django\core\management\base.py", > >> line 122, > >> in validate > >> num_errors = get_validation_errors(s, app) > >> File "C:\Python26\Lib\site-packages\django\core\management > >> \validation.py", lin > >> e 22, in get_validation_errors > >> from django.db import models, connection > >> File "C:\Python26\Lib\site-packages\django\db\__init__.py", line 34, > >> in <modul > >> e> > >> (settings.DATABASE_ENGINE, ", ".join(map(repr, > >> available_backends)), e_user) > > >> django.core.exceptions.ImproperlyConfigured: 'MySQL' isn't an > >> available database > >> backend. Available options are: 'dummy', 'mysql', 'oracle', > >> 'postgresql', 'post > >> gresql_psycopg2', 'sqlite3' > >> Error was: No module named MySQL.base > > > Whereas what this is saying is that you have 'MySQL' set as your > > DATABASE_ENGINE, and that is not correct. Case matters. What you have in > > your settings file needs to be all lower case for the DATABASE_ENGINE > > setting. > > > Karen- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
