Jump to:
| Project: | Backup and Migrate |
| Version: | 7.x-2.4 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Issue Summary
Yes, I know the error says aggregator module but hear me out.
1. I created a base case Drupal installation with the functionality that I need.
2. Installed three separate Drupal 7 installations. Using Backup and migrate I installed my base case.
3. I have a regular install of Drupal with the same modules, no issues. All three of my backup and migrate sites have the same issue.
4. Updating the Drupal 7 installations is not going as planned either. I run the update script, and I know there are db adjustments, but the backup and migrate installations are saying no db adjustments.
5. I have seen a similar issue, that was closed because the issue was not reproduce-able. This I can reproduce.
If anyone has ideas, I'm listening....
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'link' doesn't have a default value: INSERT INTO {aggregator_feed} (title, url, refresh, block, description, image) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => arlee events [:db_insert_placeholder_1] => http://www.arleemontana.com/event/myfeed2 [:db_insert_placeholder_2] => 3600 [:db_insert_placeholder_3] => 5 [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => ) in aggregator_save_feed() (line 540 of /home/domain/public_html/modules/aggregator/aggregator.module).
Comments
#1
The error appears when I try to add a feed. I am taken tp a page that says the site has an error please try again later. The error pasted above is from the error logs.
#2
Sounds like the aggregator_feed table structure didn't come across properly. Possibly others too if update isn't working.
I don't use aggregator much but my guess is that it sets up the 'link' column in that table to be not null and have a default value, but that default value doesn't exist in your cloned sites.
Do you have the ability to inspect the databases of all of the sites with a tool like phpMyAdmin? Take a look at the structure of the aggregator_feed table in both the working base and the broken clones and tell me if they differ? Specifically what does the feed column differ?
What version of B&M did you use to do the export and what version did you use for the import? Do you still have the backup file you used to create the clones with? Are the sites all running on the same version of MySQL?
Thanks
Ronan
#3
Thank you Ronan for your help.
#4
Ronan, I just remembered that I had an issue with my 'base case' and rolled it back using B&M. I added an unrelated aggregator feed table, and there are differences. I am rebuilding my base case from scratch.
#5
Ronan, I have my base case back and working as I want. What can I do to help the B&M module progress?
#6
Yes it seems like the base case and the clone are both missing the default value for the link column. You say the base has been restored with b&m as well? I can't tell why just that default would be missing since all of the other defaults.
It should be noted, that the feed column doesn't appear to have a default defined in the schema:
http://drupalcode.org/project/drupal.git/blob/refs/heads/7.x:/modules/ag...
So I'm really not sure why you were getting that error.
#7
Ah the joys of computers. I do not have time to go research exactly what happened, I thought it was the B&M module.... if I get some free time, I will play some more with this setup and see what I can find out.
For the record, I loved working with the Backup and Migrate module. At the end of each programming session, I would save a back up. If I made a mistake, I could roll it back very easily. Now I do not know if I can trust the module or not. Or if it is a conflict between this module and something else. I guess I will go back to using phpMyAdmin.
Is there any way I can help with this modules development?
#8
The best thing you can do is let me know what your research shows up if you do get some free time. I always need help tracking down these edge cases and reproducing them.
Thanks
Ronan
#9
I have been thinking about this module and my project.
Here is the situation. I have a good base case, I have one of the sites where the aggregator will not work, and the update will not work. I can use the B&M module to copy my good base case into the site that is not working and see what happens. Is there anything you would like me to track?
#10
Step 1: Using B&M I pulled a copy of the db from my good base case.
Step 2: Using the same B&M version, I tried to upload a db into a site I knew was not working correctly. I was not surprised when it gave me an error.
Step 3: Install a clean version of Drupal 7, with a copy of the sites/all folder.
Step 4: Using the good backup and B&M create a good clone.
Step 5: Export aggregator table. The table is listed as aggregator feed last
Ronan, I have been up since 3 am working on this. The site is acceptable. I will check tomorrow.