Solspace Support Forums | Upgrade problem

Upgrade problem

ittsmee2

Posted: 31 May 2008 10:12 PM

[ Ignore ]

Newbie

Total Posts: 9

Joined 2005-08-29

I just upgraded to 2.1.6 and have the following error:

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘no_id’ in ‘field list’

Query: INSERT INTO exp_favorites_prefs ( pref_id, site_id, language, member_id, no_string, no_login, no_id, id_not_found, no_duplicates, no_favorites, no_delete, success_add, success_delete) VALUES (’‘, ‘1’, ‘english’, ‘’, ‘We do not have a proper string.’, ‘You must be logged in before you can add or view favorites.’, ‘An entry id must be provided.’, ‘No entry was found for that entry id.’, ‘This favorite has already been recorded.’, ‘No favorites have been recorded.’, ‘That favorite does not exist.’, ‘Your favorite has been successfully added.’, ‘Your favorite has been successfully deleted.’)

Profile

Kelsey Martens

Posted: 02 June 2008 07:11 AM

[ Ignore ] [ # 1 ]

Administrator

Total Posts: 8223

Joined 2006-10-18

ittsmee2,

Which version did you upgrade from?
Also, which version of ExpressionEngine are you running?
Where does this error occure? When adding an entry to Favs?

Can you try uploading a fresh copy of Favorites… make sure you also go into the Module and run the “upgrade” script.

Signature

Profile

Justin Crawford

Posted: 14 January 2009 07:10 PM

[ Ignore ] [ # 2 ]

Administrator

Total Posts: 12

Joined 2008-11-18

I’m having the same problem after I upload a fresh copy and try to run the upgrade script:

MySQL ERROR:

Error Number: 1054

Description: Unknown column 'no_id' in 'field list'

Query: INSERT INTO exp_favorites_prefs ( pref_id, site_id, language, member_id, no_string, no_login, 
no_id, id_not_found, no_duplicates, no_favorites, no_delete, success_add,
success_delete, success_delete_all) VALUES ('', 1, 'english', '', 'We do not have a proper string.',
'You must be logged in before you can add or view favorites.', 'An entry id must be provided.', 
'No entry was found for that entry id.', 'This favorite has already been recorded.', 'No favorites have been recorded.',
 'That favorite does not exist.', 'Your favorite has been successfully added.',
 'Your Favorite has been successfully deleted.', 'All of your Favorites have been successfully deleted') 

EE 1.6.6
Favorites 2.0.5 -> 2.5.3

Any ideas of what to do, Pie Man?

Thanks!

-Justin

Signature

Profile

Justin Crawford

Posted: 15 January 2009 08:52 AM

[ Ignore ] [ # 3 ]

Administrator

Total Posts: 12

Joined 2008-11-18

I modified mcp.favorites.php, in the _sql_prefs() function:

line 1720:

// ADDED: 20090115 by Justin Crawford (Hop Studios)
            // PURPOSE: Add additional columns for updates from really old versions
            if ( $this->_column_exists( 'no_id', 'exp_favorites_prefs' ) === FALSE )
            {
                $sql[]    = "ALTER TABLE exp_favorites_prefs ADD no_id varchar(100) NOT NULL AFTER no_login";
            }

            // ADDED: 20090115 by Justin Crawford (Hop Studios)
            // PURPOSE: Add additional columns for updates from really old versions
            if ( $this->_column_exists( 'id_not_found', 'exp_favorites_prefs' ) === FALSE )
            {
                $sql[]    = "ALTER TABLE exp_favorites_prefs ADD id_not_found varchar(100) NOT NULL AFTER no_id";
            } 

The upgrade completed without error.

Justin

Signature

Profile

Kelsey Martens

Posted: 15 January 2009 09:30 AM

[ Ignore ] [ # 4 ]

Administrator

Total Posts: 8223

Joined 2006-10-18

Justin (Hop Studios) - 14 January 2009 07:10 PM
EE 1.6.6
Favorites 2.0.5 -> 2.5.3

That’s a big leap…

Thank you for the fix… I’ll queue this up to be corrected

Signature

Profile

‹‹ Favorite Entries for Multiple Weblogs Favorites Bug? ››