Upgrade Failure

ericwongmma

I just upgraded to 2.1.11 and tried to use the update utility and the update failed.

Now I can't load my site at all.

My site is

http://forum.powerdojo.com

Any idea what the issue is?

peregrine

what version did you upgrade from?

use the typical troubleshooting methods.

turn debug on.

In order to reveal full descriptive error messages:

add the following configuration statement to conf/config.php

$Configuration['Debug'] = TRUE;

if you see

$Configuration['Debug'] = FALSE;

change it to

$Configuration['Debug'] = TRUE;

Remember to remove the config statement or change it to FALSE, when you are done.

try running /utility/structure a few times

and try

try running /utility/update a few times

http://vanillaforums.org/discussion/comment/219687/#Comment_219687

delete the ini files from cache folder.
download core files again and try re-installing

http://vanillaforums.org/discussion/comment/188810/#Comment_188810

peregrine

check your .htaccess and make sure it is correct.

http://vanillaforums.org/discussion/comment/220157/#Comment_220157

this is your error.....

"NetworkError: 500 hphp_invoke - http://forum.powerdojo.com/discussions"

try turning off to troubleshoot.

/plugins/Logger
/plugins/Awards
/plugins/AeliaFoundationClasses/

ericwongmma

@peregrine - thanks for the help.

I did what you said in your first message and got this code thrown to me:

=================

drop procedure if exists SearchAnyWhere;

create definer=liviawon_vanillalocalhost procedure SearchAnyWhere(in What varchar(50))
reads sql data
begin

declare Done int default False;
declare TableName, ColumnName, DataType, Dummy varchar(80);
declare FieldValue varchar(255);
declare GetAllColumns cursor for select TABLE_NAME, COLUMN_NAME, DATA_TYPE from information_schema.COLUMNS where TABLE_SCHEMA = 'GDN_liviawon_desserta_pdvanilla' and DATA_TYPE in ('char', 'varchar', 'tinytext', 'text', 'mediumtext', 'longtext', 'int', 'mediumint', 'smallint');
declare continue handler for not found set Done = True;

set @PxLength = 4;
set @SelectAll = Null;

open GetAllColumns;
ReadLoop: loop
fetch GetAllColumns into TableName, ColumnName, DataType;
set TableName = substr(TableName, @PxLength+1);
if Done then leave ReadLoop;
end if;
set @SelectSql = concat('select "', TableName, '" as TableName, "', ColumnName, '" as ColumnName, ', ColumnName, ' as RowValue from ', TableName, ' where ', ColumnName, ' like "%', What, '%"');
set @SelectAll = concat_ws(' union all ', @SelectAll, @SelectSql);
end loop;
close GetAllColumns;

select @SelectAll;

prepare St from @SelectAll;
execute St;

end;

=================

I then click Run Structure and Data scripts and get this error (image file because a lot of text):

I'll try the next steps now.

Thanks again!

BTW - do you do hourly dev/troubleshooting work? If so, PM me with your hourly rates.

ericwongmma

OK I disabled those plugins but no change - site still won't load.

ericwongmma

And just for fun I tried disabling all plugins but still no dice.

peregrine

peregrine

@ericwongmma

if you are not using Useful Functions plugin, I would delete it from your plugins folder after you disable it and remove it from your config.php
you may need to do this temporarily even if you need it.

that is the source of your problem I believe, and it should update successfully after you disable useful functions (if you don't have other issues).

after you disable the plugin, run /utility structure again. then utility/update if structure was successful

and post any errors if not successful.

I don't do paid consulting any more. .

But I can try to help you here. But I can give you suggestions of developers I'd like you to send a donation to, if you would like to send a donation to someone.

ericwongmma

@peregrine - I just deleted Userful Functions and removed it from config.php.

I was then able to run /utility structure and utility/update succesfully.

However, I still cannot load the site.

Oh and yes please send me suggestions for devs to donate to. Why don't you do paid consulting work anymore and why don't you accept donations? Just a bit curious as I find this unique.

peregrine

Oh and yes please send me suggestions for devs to donate to.

ok

I'll pm you if you have time to try to fix now. we can work on it.

peregrine

post your .htaccess if you are using apache.

is your vanilla forum installed under root or /forum or somewhere else/

ericwongmma

here's my .htaccess:

Original

If you modify this file then change the above line to: # Modified

RewriteEngine On
# Certain hosts may require the following line.
# If vanilla is in a subfolder then you need to specify it after the /.
# (ex. You put Vanilla in /forum so change the next line to: RewriteBase /forum)
# RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ index.php\?p=$1 [QSA,L]

peregrine

change

# RewriteBase /

to

RewriteBase /

remove the #

that is a comment.

http://vanillaforums.org/discussion/comment/220157/#Comment_220157

ericwongmma

Done... still no go.

peregrine

can you post your config.php

removany passwords and e-mail info, etc.

do you have a backup of your .htaccess before you upgraded?

peregrine

You see to have disappeared. I have to go now as well. perhaps someone else can help if you decide to come back on line.

ericwongmma

Sorry yes, had to go.

Here's my config.php:

<?php if (!defined('APPLICATION')) exit();

// Conversations
$Configuration['Conversations']['Version'] = '2.1.1';

// Database
$Configuration['Database']['Name'] = '----';
$Configuration['Database']['Host'] = 'localhost';
$Configuration['Database']['User'] = '----';
$Configuration['Database']['Password'] = '----';
$Configuration['Debug'] = TRUE;

// EnabledApplications
$Configuration['EnabledApplications']['Conversations'] = 'conversations';
$Configuration['EnabledApplications']['Vanilla'] = 'vanilla';

// EnabledPlugins
$Configuration['EnabledPlugins']['HtmLawed'] = 'HtmLawed';
$Configuration['EnabledPlugins']['AllViewed'] = TRUE;
$Configuration['EnabledPlugins']['TopPosters'] = TRUE;
$Configuration['EnabledPlugins']['AuthorTimeView'] = TRUE;
$Configuration['EnabledPlugins']['VersionCheck'] = TRUE;
$Configuration['EnabledPlugins']['Logger'] = FALSE;
$Configuration['EnabledPlugins']['LogsWorkout'] = TRUE;
$Configuration['EnabledPlugins']['Awards'] = FALSE;
$Configuration['EnabledPlugins']['FileUpload'] = TRUE;
$Configuration['EnabledPlugins']['VanillaStats'] = TRUE;
$Configuration['EnabledPlugins']['ExpandableCategories'] = TRUE;
$Configuration['EnabledPlugins']['UsefulFunctions'] = FALSE;
$Configuration['EnabledPlugins']['ImageUpload'] = TRUE;
$Configuration['EnabledPlugins']['LikeThis-OLD'] = TRUE;
$Configuration['EnabledPlugins']['PageSpeed'] = TRUE;
$Configuration['EnabledPlugins']['LikeThis'] = TRUE;
$Configuration['EnabledPlugins']['AeliaFoundationClasses'] = FALSE;
$Configuration['EnabledPlugins']['CreativeCLEditor'] = TRUE;
$Configuration['EnabledPlugins']['jsconnect'] = TRUE;
$Configuration['EnabledPlugins']['DiscussionPolls'] = TRUE;
$Configuration['EnabledPlugins']['DefaultAvatar'] = TRUE;

// Garden
$Configuration['Garden']['Title'] = 'powerDOJO Forum';
$Configuration['Garden']['Cookie']['Salt'] = '------';
$Configuration['Garden']['Cookie']['Domain'] = '';
$Configuration['Garden']['Registration']['ConfirmEmail'] = FALSE;
$Configuration['Garden']['Registration']['Method'] = 'Connect';
$Configuration['Garden']['Registration']['CaptchaPrivateKey'] = '';
$Configuration['Garden']['Registration']['CaptchaPublicKey'] = '';
$Configuration['Garden']['Registration']['InviteExpiration'] = '-1 week';
$Configuration['Garden']['Registration']['ConfirmEmailRole'] = '3';
$Configuration['Garden']['Registration']['InviteRoles']['3'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['4'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['8'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['16'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['32'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['33'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['34'] = '0';
$Configuration['Garden']['Registration']['InviteRoles']['35'] = '0';
$Configuration['Garden']['Email']['SupportName'] = 'the MASTERMIND';
$Configuration['Garden']['Email']['SupportAddress'] = '-----';
$Configuration['Garden']['Email']['UseSmtp'] = FALSE;
$Configuration['Garden']['Email']['SmtpHost'] = '';
$Configuration['Garden']['Email']['SmtpUser'] = '----';
$Configuration['Garden']['Email']['SmtpPassword'] = '-----';
$Configuration['Garden']['Email']['SmtpPort'] = '25';
$Configuration['Garden']['Email']['SmtpSecurity'] = '';
$Configuration['Garden']['Version'] = '2.1.11';
$Configuration['Garden']['RewriteUrls'] = TRUE;
$Configuration['Garden']['CanProcessImages'] = TRUE;
$Configuration['Garden']['Installed'] = TRUE;
$Configuration['Garden']['InstallationID'] = '------';
$Configuration['Garden']['InstallationSecret'] = '------';
$Configuration['Garden']['Theme'] = 'EmbedFriendlyTable';
$Configuration['Garden']['Profile']['EditUsernames'] = FALSE;
$Configuration['Garden']['Messages']['Cache'] = 'a:0:{}';
$Configuration['Garden']['Thumbnail']['Size'] = '65';
$Configuration['Garden']['EditContentTimeout'] = '-1';
$Configuration['Garden']['InputFormatter'] = 'Html';
$Configuration['Garden']['Html']['SafeStyles'] = TRUE;
$Configuration['Garden']['Embed']['Allow'] = TRUE;
$Configuration['Garden']['Embed']['RemoteUrl'] = 'http://kyoudai.powerdojo.com/home/forum/';
$Configuration['Garden']['Embed']['ForceDashboard'] = FALSE;
$Configuration['Garden']['Embed']['ForceForum'] = FALSE;
$Configuration['Garden']['SystemUserID'] = '238';
$Configuration['Garden']['TrustedDomains'] = array('');
$Configuration['Garden']['Format']['YouTube'] = TRUE;
$Configuration['Garden']['Format']['Vimeo'] = TRUE;
$Configuration['Garden']['Format']['EmbedSize'] = 'normal';

// Modules
$Configuration['Modules']['Vanilla']['Content'] = array('MessageModule', 'Notices', 'NewConversationModule', 'NewDiscussionModule', 'Content', 'Ads');
$Configuration['Modules']['Conversations']['Content'] = array('MessageModule', 'Notices', 'NewConversationModule', 'NewDiscussionModule', 'Content', 'Ads');

// Plugin
$Configuration['Plugin']['Awards']['MinSearchLength'] = 2;

// Plugins
$Configuration['Plugins']['GettingStarted']['Dashboard'] = '1';
$Configuration['Plugins']['GettingStarted']['Plugins'] = '1';
$Configuration['Plugins']['GettingStarted']['Registration'] = '1';
$Configuration['Plugins']['GettingStarted']['Discussion'] = '1';
$Configuration['Plugins']['GettingStarted']['Categories'] = '1';
$Configuration['Plugins']['GettingStarted']['Profile'] = '1';
$Configuration['Plugins']['EmbedVanilla']['RemoteUrl'] = 'http://kyoudai.powerdojo.com/home/forum';
$Configuration['Plugins']['EmbedVanilla']['ForceRemoteUrl'] = FALSE;
$Configuration['Plugins']['EmbedVanilla']['EmbedDashboard'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['DCount'] = '10';
$Configuration['Plugins']['MembersListEnh']['ShowPhoto'] = '1';
$Configuration['Plugins']['MembersListEnh']['ShowLike'] = '1';
$Configuration['Plugins']['MembersListEnh']['ShowThank'] = '1';
$Configuration['Plugins']['MembersListEnh']['ShowKarma'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowID'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowRoles'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowFVisit'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowLVisit'] = '1';
$Configuration['Plugins']['MembersListEnh']['ShowEmail'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowIP'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowVisits'] = FALSE;
$Configuration['Plugins']['MembersListEnh']['ShowDiCount'] = '1';
$Configuration['Plugins']['MembersListEnh']['ShowCoCount'] = '1';
$Configuration['Plugins']['AuthorTimeView']['Show_AuthorTime'] = '1';
$Configuration['Plugins']['AuthorTimeView']['Show_Vcount'] = FALSE;
$Configuration['Plugins']['AuthorTimeView']['Right'] = FALSE;
$Configuration['Plugins']['PeregrineLeaderBoard']['Limit'] = '5';
$Configuration['Plugins']['PeregrineBadges']['Limit'] = '20';
$Configuration['Plugins']['AddMenuitem']['Name1'] = '';
$Configuration['Plugins']['AddMenuitem']['Link1'] = '';
$Configuration['Plugins']['AddMenuitem']['Name2'] = '';
$Configuration['Plugins']['AddMenuitem']['Link2'] = '';
$Configuration['Plugins']['AddMenuitem']['Name3'] = '';
$Configuration['Plugins']['AddMenuitem']['Link3'] = '';
$Configuration['Plugins']['AddMenuitem']['Name4'] = 'Mobile';
$Configuration['Plugins']['AddMenuitem']['Link4'] = 'http://forum.powerdojo.com';
$Configuration['Plugins']['AddMenuitem']['Name5'] = '';
$Configuration['Plugins']['AddMenuitem']['Link5'] = '';
$Configuration['Plugins']['PlUpload']['PreMaxUploadSize'] = '2';
$Configuration['Plugins']['PlUpload']['PreMaxUploadQuality'] = '100';
$Configuration['Plugins']['PlUpload']['PreMaxUploadWidth'] = '800';
$Configuration['Plugins']['PlUpload']['PreMaxUploadHeight'] = '600';
$Configuration['Plugins']['FileUpload']['Enabled'] = TRUE;
$Configuration['Plugins']['DefaultAvatarPlugin']['AvatarUrl'] = 'http://forum.powerdojo.com/uploads/powerDOJO-default-avatar.jpg';
$Configuration['Plugins']['DefaultAvatarPlugin']['Deleted'] = 'DeletedUser';
$Configuration['Plugins']['DefaultAvatarPlugin']['md5'] = '';
$Configuration['Plugins']['VersionCheck']['TransferType'] = 'proxyrequest';
$Configuration['Plugins']['PageSpeed']['AllInOne'] = 0;
$Configuration['Plugins']['PageSpeed']['DeferJavaScript'] = 0;
$Configuration['Plugins']['PageSpeed']['ParallelizeEnabled'] = FALSE;
$Configuration['Plugins']['PageSpeed']['ParallelizeHosts'] = NULL;
$Configuration['Plugins']['PageSpeed']['CDN']['jquery'] = '1.8.3';
$Configuration['Plugins']['PageSpeed']['CDN']['jqueryui'] = '1.8.4';
$Configuration['Plugins']['PageSpeed']['CDN']['jqueryui-theme'] = '';
$Configuration['Plugins']['PageSpeed']['DisableMinifyCss'] = FALSE;

// Preferences
$Configuration['Preferences']['Email']['AwardEarned'] = 1;
$Configuration['Preferences']['Email']['ConversationMessage'] = '1';
$Configuration['Preferences']['Email']['AddedToConversation'] = '1';
$Configuration['Preferences']['Email']['BookmarkComment'] = '1';
$Configuration['Preferences']['Email']['WallComment'] = '1';
$Configuration['Preferences']['Email']['ActivityComment'] = '0';
$Configuration['Preferences']['Email']['DiscussionComment'] = '1';
$Configuration['Preferences']['Email']['DiscussionMention'] = '1';
$Configuration['Preferences']['Email']['CommentMention'] = '1';
$Configuration['Preferences']['Popup']['AwardEarned'] = 0;
$Configuration['Preferences']['Popup']['ConversationMessage'] = '0';
$Configuration['Preferences']['Popup']['AddedToConversation'] = '0';
$Configuration['Preferences']['Popup']['BookmarkComment'] = '1';
$Configuration['Preferences']['Popup']['WallComment'] = '0';
$Configuration['Preferences']['Popup']['ActivityComment'] = '0';
$Configuration['Preferences']['Popup']['DiscussionComment'] = '1';
$Configuration['Preferences']['Popup']['DiscussionMention'] = '1';
$Configuration['Preferences']['Popup']['CommentMention'] = '1';

// Routes
$Configuration['Routes']['DefaultController'] = array('discussions', 'Internal');
$Configuration['Routes']['XmFmYygvPy4qKSQ='] = 'a:2:{i:0;s:24:"plugin/aeliafoundation$1";i:1;s:8:"Internal";}';
$Configuration['Routes']['XmF3YXJkcygvPy4qKSQ='] = 'a:2:{i:0;s:15:"plugin/awards$1";i:1;s:8:"Internal";}';

// TopPosters
$Configuration['TopPosters']['Limit'] = '10';
$Configuration['TopPosters']['Location']['Show'] = 'discussion';
$Configuration['TopPosters']['Excluded'] = 'a:1:{i:0;s:1:"4";}';
$Configuration['TopPosters']['Show']['Medal'] = 'side';

// Vanilla
$Configuration['Vanilla']['Version'] = '2.1.1';
$Configuration['Vanilla']['Categories']['MaxDisplayDepth'] = '3';
$Configuration['Vanilla']['Categories']['DoHeadings'] = FALSE;
$Configuration['Vanilla']['Categories']['HideModule'] = FALSE;
$Configuration['Vanilla']['Categories']['Layout'] = 'modern';
$Configuration['Vanilla']['Discussion']['SpamCount'] = '3';
$Configuration['Vanilla']['Discussion']['SpamTime'] = '30';
$Configuration['Vanilla']['Discussion']['SpamLock'] = '60';
$Configuration['Vanilla']['Comment']['SpamCount'] = '10';
$Configuration['Vanilla']['Comment']['SpamTime'] = '30';
$Configuration['Vanilla']['Comment']['SpamLock'] = '60';
$Configuration['Vanilla']['Comment']['MaxLength'] = '25000';
$Configuration['Vanilla']['Discussions']['PerPage'] = '30';
$Configuration['Vanilla']['Discussions']['Layout'] = 'modern';
$Configuration['Vanilla']['Comments']['AutoRefresh'] = '0';
$Configuration['Vanilla']['Comments']['PerPage'] = '30';
$Configuration['Vanilla']['Archive']['Date'] = '';
$Configuration['Vanilla']['Archive']['Exclude'] = FALSE;

// Last edited by Eric (76.66.108.142)2015-08-25 00:46:11