ERROR: insert or update on table "product_productvariation_options" violates foreign key constraint "product_productvariation_options_productvariation_id_fkey" DETAIL: Key (productvariation_id)=(20) is not present in table "product_productvariation". STATEMENT: COMMIT
On Thu, Jul 2, 2009 at 2:12 PM, m1chael<[email protected]> wrote: > Still having the problem.. but I have checked the postgresql log file.. > > I see the error as being: > > ERROR: insert or update on table "product_productvariation_options" > violates foreign key constraint "product_productvariation_opti$ > DETAIL: Key (productvariation_id)=(20) is not present in table > "product_productvariation". > STATEMENT: COMMIT > > Hope gives more insight on what is going on here... > > Any ideas??? > > ~Mike > > > > On Thu, Jul 2, 2009 at 1:28 AM, m1chael<[email protected]> wrote: >> I am getting an error on /admin/product/productvariation/add/ >> >> TransactionManagementError attempting to create product variation from >> configurable product... >> >> I see this ticket, but don't see much more information or fixes... >> http://www.satchmoproject.com/trac/ticket/643 >> >> I am At satchmo revision 2055 and Django version 1.1 beta 1 SVN-11082. >> >> Does anyone know what this might mean??? >> >> Environment: >> >> Request Method: POST >> Request URL: >> http://www.voodookey.com:8000/admin/product/productvariation/add/ >> Django Version: 1.1 beta 1 SVN-11082 >> Python Version: 2.4.3 >> Installed Applications: >> ['django.contrib.flatpages', >> 'django.contrib.admindocs', >> 'django.contrib.sites', >> 'satchmo_store.shop', >> 'django.contrib.admin', >> 'django.contrib.auth', >> 'django.contrib.contenttypes', >> 'django.contrib.comments', >> 'django.contrib.sessions', >> 'django.contrib.sitemaps', >> 'registration', >> 'keyedcache', >> 'livesettings', >> 'l10n', >> 'sorl.thumbnail', >> 'satchmo_store.contact', >> 'tax', >> 'tax.modules.no', >> 'tax.modules.area', >> 'tax.modules.percent', >> 'shipping', >> 'product', >> 'payment', >> 'payment.modules.giftcertificate', >> 'satchmo_utils', >> 'app_plugins', >> 'survey', >> 'voodookey.accounting', >> 'voodookey.expense', >> 'voodookey.newsletter', >> 'voodookey.password', >> 'voodookey.todo'] >> Installed Middleware: >> ('django.middleware.common.CommonMiddleware', >> 'django.contrib.sessions.middleware.SessionMiddleware', >> 'django.middleware.locale.LocaleMiddleware', >> 'django.contrib.auth.middleware.AuthenticationMiddleware', >> 'django.middleware.doc.XViewMiddleware', >> 'threaded_multihost.middleware.ThreadLocalMiddleware', >> 'satchmo_store.shop.SSLMiddleware.SSLRedirect', >> 'django.contrib.flatpages.middleware.FlatpageFallbackMiddleware') >> >> >> Traceback: >> File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py" >> in get_response >> 92. response = callback(request, *callback_args, >> **callback_kwargs) >> File "/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py" in root >> 480. return self.model_page(request, *url.split('/', 2)) >> File "/usr/lib/python2.4/site-packages/django/views/decorators/cache.py" >> in _wrapped_view_func >> 44. response = view_func(request, *args, **kwargs) >> File "/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py" >> in model_page >> 499. return admin_obj(request, rest_of_url) >> File "/usr/lib/python2.4/site-packages/django/contrib/admin/options.py" >> in __call__ >> 1088. return self.add_view(request) >> File "/usr/lib/python2.4/site-packages/django/db/transaction.py" in >> _commit_on_success >> 251. leave_transaction_management() >> File "/usr/lib/python2.4/site-packages/django/db/transaction.py" in >> leave_transaction_management >> 77. raise TransactionManagementError("Transaction managed >> block ended with pending COMMIT/ROLLBACK") >> >> Exception Type: TransactionManagementError at >> /admin/product/productvariation/add/ >> Exception Value: Transaction managed block ended with pending COMMIT/ROLLBACK >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
