Jump to:
| Project: | Quotes |
| Version: | 7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (works as designed) |
Issue Summary
I went to enable Quotes, and it threw this error on the install page:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'vid' cannot be null: UPDATE {quotes_blocks} SET vid=:db_update_placeholder_0, cron_last=:db_update_placeholder_1 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => 1319123111 [:db_condition_placeholder_0] => 3 ) in quotes_block_view() (line 888 of .../public_html/sites/all/modules/quotes/quotes.module).
I cannot uninstall the mod, or disable the mod, as this error crashes the modules admin page. The only way I've been able to get back in is to delete the quotes folder from the server. Without the code, the site runs. I cannot uninstall or disable.
The quotes.install file lists several columns as not null, but doesn't supply default values for them.
I'm running Drupal core 7.8, fully up to date.
PHP Version 5.2.17 on Linux.
MySQL 5.1.56
Comments
#1
Downloaded 7.8 and installed fresh copy on empty DB
downloaded and installed dev release of quote
Did not get any errors.
Had you installed quotes before and disabled it? Was this a upgraded DB that had quotes installed before?
#2
It was a DB I had originally set up on a local (Windows) box, then exported the DB and imported it up to a linux ISP.
I had enabled the Quotes mod on the local and had it working, then disabled it prior to the move. The error threw when I went to re-enable it on my production (linux) host.
The database was original a Drupal 6 setup, but I never installed the quotes mod in the 6 version. (I used the 6 version to import phpbb3 forums, then upgraded to 7, then tested a few mods before setting up my production site).
Sorry I didn't supply enough detail.
Since I cannot run the admin pages with the mod's folder on the server, I don't know how to uninstall it completely so I can try to make a fresh install of the mod.
#3
Go into the DB blocks table and remove any rows that list quotes under the module column.
Empty the quotes_block table
That should allow you to get in to the admin/modules page and reinstall quotes.
#4
Thanks! deleting those entries fixed the problem and I was then able to reinstall it successfully!
#5
clearing issue queue