Database Error after upgrade to beta 5-1

[sburke930]

I have an database error after the upgrade to beta 5-1.  Only the back end is available at this point.  I am using SMF1.1.11 and have the following mods installed:

 
1. Admin Notepad 1.0 
2. Custom_Greeting_Depending_on_Time 1.1   
3. Aeva ~ Auto-Embed Video & Audio 6.9.101   
4. Custom Board Sort 1.0.1   
5. Force Topic Read On Login Mod 2.1 
6. SMF Arcade 2.0.18   [1.1 - 1.1.9]
7. User Control Panel By Alan S 2.0 
8. Users Online Today Mod 1.4.0   
9. Global Headers Footers 1.4.1   
10. Post_and_Change_as_Alternate_User 1.0     
11. SMF 1.0.19 / 1.1.11 Update 1.0     
12. Internal_Links_Use_Same_Window 1.2     
13. Tidy Child Boards 1.1   [1.1 - 1.1.99]   
14. Treasury 2.36   [1.1-1.1.99] 
15. Google Verification META Tag 1.101     
16. reCAPTCHA for SMF 0.9.7     
17. Reply Button in All Posts 1.1     
18. Show Number of Errors at Top of Forum 1.0   
19. Add Domaintools to TrackIP 1.0   
20. Tar Game Uploader 1.0     
21. modVersion 1.0.0     
22. Custom Copyright 1.1   
23. Disable Right Click 4.0     
24. TinyPortal 1.099     
25. Signature Settings Mod 1.1     
26. SMF Arcade Category Select Mod 1.0.2     
27. User Email System 1.3 

Prior to the upgrade everything was running fine.  I have tried repair settings.php file and have looked repeatedly for anything that would guide me to getting my forum back up.

Any suggestions where to start other than a sledge hammer to my head to ease the pain? 

This is the only error I have found

Code Select Expand

Database Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/broom13/public_html/tp-files/tp-modules/TPShout/Sources/TPShout.php
Line: 489

and here is the line code it is referring to

Code Select Expand

$go=1;

[IchBin]

Did you search this site? Did you search the SMF site? I'm sure this has been asked before.

[sburke930]

This error has completely shut my site down. 

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@tiki-parlor.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


The information given to me does not help get us back up and running.

Help please.

Everything was fine prior to installing the upgrade.

[sburke930]

Sorry to double post...

The problem is directly related to the shoutbox itself.  Once I shut the shoutbox off the forum came back up immediately, albiet with errors galore!

If that helps any.....

[IchBin]

Did you read any of the posts I searched for you?

[sburke930]

Yes, I found none of them a direct help although, the phpmyadmin post about disable eval has helped.

I have a problem with my TPsubs.template.php file now which i cannot figure out.
error:

8: Undefined index: by
File: /home/broom13/public_html/Themes/default/TPsubs.template.php
Line: 92

line 92

Code Select Expand

<li style="margin: 0; list-style: none; line-height: 1.5em; padding: 4px 0;"><a href="'.$w['href'].'">'.$w['short_subject'].'</a> ', $txt['by'], ' ', $w['poster']['link'];


When I try to take out lines 87 to 105 I get a parsing error. 

NOTE:  It looks as though I have duplicate coding to an extent

Code Select Expand

// Output the topics
echo '
<ul class="middletext" style="line-height: 1.5em; ' , isset($context['TPortal']['recentboxscroll']) && $context['TPortal']['recentboxscroll']==1 ? 'overflow: auto; height: 20ex;' : '' , 'margin: 0; padding: 0;">';
foreach($what as $wi => $w){
echo '
if(!$w['new'])
echo ' <a href="'.$w['href'].'"><img src="'. $settings['images_url'].'/'.$context['user']['language'].'/new.gif" alt="new" /></a> ';

echo ' ['.$w['time'].']
</li>';
}
echo '
</ul>';
}
else
{
$what = tp_recentTopics($context['TPortal']['recentboxnum'], $bb, 'array');

// Output the topics
echo '
<ul class="recent_topics" style="' , isset($context['TPortal']['recentboxscroll']) && $context['TPortal']['recentboxscroll']==1 ? 'overflow: auto; height: 20ex;' : '' , 'margin: 0; padding: 0;">';
foreach($what as $wi => $w){
echo '
<li>
<span class="tpavatar"><a href="' . $scripturl. '?action=profile;u=' . $w['poster']['id'] . '">' , empty($w['poster']['avatar']) ? '<img src="' . $settings['tp_images_url'] . '/TPguest.png" alt="" />' : $w['poster']['avatar'] , '</a></span><a href="'.$w['href'].'">' . $w['short_subject'].'</a><br />
', $txt['by'], ' <b>', $w['poster']['link'],'</b><br />';
if(!$w['new'])
echo ' <a href="'.$w['href'].'"><img src="'. $settings['images_url'].'/'.$context['user']['language'].'/new.gif" alt="new" /></a> ';

echo '['.$w['time'].']
</li>';
}
echo '
</ul>';
}
}

Some of the code is different but I am not sure which is correct or if I should reinstall this file in it's entirelty.

[tweakNB]

Forgot I had an account here!

I came across this problem myself with TP Beta 5 and then with 5-1, after editing the source to fix it I finally found a chance to fix it properly.

Make sure that the collations of your database and tables are all the same, I found a mix of both utf_unicode_ci and utf_general_ci throughout my SMF install, once all were changed to just one (in theory just the tables in query need it but worth doing them all for later issues) it'll work fine.

So, basically, make sure all your tables are the same collation or it'll cause errors like you had.

Hope this helps!

[trench]

after my upgrade this is what I get.

'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/*********/public_html/********/Sources/TPortal.php
Line: 2153

[G6Cad]

after my upgrade this is what I get.

'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/*********/public_html/********/Sources/TPortal.php
Line: 2153

Cant really see the relevance to this topic on that post of yours Trench, please dont hijack another members topic, better to start your own after a search in the forum, think your issue have been discusssed before