Field Frame errors on upgrading to 1.4.2
Development and Programming
I am using field frame 1.0 and EE 1.6.7. I was having trouble with conditions so I tried to update to FF 1.4.2, but when I do it didn’t fix my problem, it caused more. So I tried to go back to FF 1.0 and I get the following error on EVERY page on my site!!!! HELP
MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘site_id’ in ‘where clause’
Query: SELECT * FROM exp_ff_fieldtypes WHERE site_id = “1” AND enabled = “y”
and when I go back to 1.4.2 I get these errors:
Warning: Invalid argument supplied for foreach() in /home/e3women/public_html/admin/extensions/ext.fieldframe.php on line 2225
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/e3women/public_html/admin/extensions/ext.fieldframe.php on line 2238
Warning: implode() [function.implode]: Invalid arguments passed in /home/e3women/public_html/admin/extensions/ext.fieldframe.php on line 2238
So I guess the MySQL error is because when you upgrade to 1.4.2 it changes something in the database and I have no idea what I need to do to get back to FF1.
Pixel and Tonic say to restore the DB, well the lack of any updating instructions did not inform me that this would happen so I have no backup.
Now I have no way of getting back to FF 1.
Does anyone have a suggestion as to what I can do in my DB to get back to FF1.? Do I have to delete something and then reinstall the extension?