Upgrade problem
Posted: 31 May 2008 10:12 PM   [ Ignore ]
Newbie
Rank
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
 
 
Posted: 02 June 2008 07:11 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  8223
Joined  2006-10-18

ittsmee2,

Which version did you upgrade from?
Also, which version of ExpressionEngine are you running? smile
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
 
 
Posted: 14 January 2009 07:10 PM   [ Ignore ]   [ # 2 ]
Administrator
Avatar
Rank
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 Number1054

Description
Unknown column 'no_id' in 'field list'

QueryINSERT INTO exp_favorites_prefs pref_idsite_idlanguagemember_idno_stringno_login
no_idid_not_foundno_duplicatesno_favoritesno_deletesuccess_add,
success_deletesuccess_delete_allVALUES (''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
 
 
Posted: 15 January 2009 08:52 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
Rank
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
 
 
Posted: 15 January 2009 09:30 AM   [ Ignore ]   [ # 4 ]
Administrator
Avatar
RankRankRankRankRank
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… wink

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

 Signature 
Profile