Author Topic: Shoutbox Error! (Read 7117 times)

Chackan · « **on:** July 07, 2010, 05:56:07 PM »

I added the shoutbox block and I get this error:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/otherwor/public_html/Sources/Subs-Portal.php
Line: 1112

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Any idea? :S

SMF version 1.1.11
Simpleportal version 2.3.2
Forum: www.otherworld.eu

Chackan · « **Reply #1 on:** July 11, 2010, 09:20:34 AM »

Still no help

And no solution!

AngelinaBelle · « **Reply #2 on:** July 13, 2010, 11:17:39 AM »

did you try the database upgrade that comes with SMF 1.1.11?

Chackan · « **Reply #3 on:** July 13, 2010, 11:37:49 AM »

How do I do that? I search and found nothing

Nathaniel · « **Reply #4 on:** July 20, 2010, 03:12:28 AM »

Extract the install1-1.php file from the SimplePortal package, then upload it into the same folder that contains your forum's Settings.php file. Then load the page with your browser. (the url will look something like www.forum.com/install1-1.php)

Chackan · « **Reply #5 on:** July 20, 2010, 05:06:48 AM »

Ok, done that and I still get the same error!

AngelinaBelle · « **Reply #6 on:** August 27, 2010, 08:34:22 AM »

Chackan,

Did you attempt to run the install1-1.php?

Chackan · « **Reply #7 on:** August 27, 2010, 08:38:26 AM »

Yes, it was prolly the first thing I did

AngelinaBelle · « **Reply #8 on:** August 27, 2010, 10:17:54 AM »

You are still getting the database upgrade error?
Have you tried re-running the database upgrade that came with SMF?

Chackan · « **Reply #9 on:** August 27, 2010, 10:28:45 AM »

I think that i only ran the install1-1.php if I recall correctly.

Is it the same thing?

AngelinaBelle · « **Reply #10 on:** August 27, 2010, 11:16:09 AM »

Since you confirm that you ran SimplePortal's install1-1.php, and that all went well with that, I am looking again at your error message Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.2

This implies that the database upgrade did not go correctly when you did the SMF upgrade. But the routine that produced this error message may or may not be correct. If there was an SMF database upgrade problem, simplemachines.org would be the best place for advice on fixing it.

Another possibility is that a problem occurred during a MYSQL upgrade (if there has been one on your database server

I'm looking at the other interesting error message:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT)
I googled this. Other MYSQL users have run into the situation where tables suddenly got latin1_swedish collation for no discernable reason. They solved it by creating a script to fix the data on the tables and the tables themselves.

Using you database admin interface, what information can you find out about the tables {$db_prefix}members and {$db_prefix}sp_shouts, and, specifically, about the fields members.realName and sp_shouts.memberName?

Chackan · « **Reply #11 on:** September 06, 2010, 03:42:51 PM »

Honestly? I don't really know how to do that :X

AngelinaBelle · « **Reply #12 on:** September 06, 2010, 07:00:53 PM »

You set up your database somehow. How'd you do it?

Chackan · « **Reply #13 on:** September 07, 2010, 05:22:16 AM »

Well, it was kind of an automatic process. Either it was created during the SMF installation or it was created by the host.

Either way it was more than 2 years ago lol, since I don't know squat about DB administration...

AngelinaBelle · « **Reply #14 on:** September 09, 2010, 04:17:19 PM »

Please check with the information your host provides on how you could do DB administration, if you wanted to. Whatever tool is provided, you can use it to find out information about the database tables.

Chackan · « **Reply #15 on:** September 10, 2010, 10:40:55 AM »

Well, just talked with my host support team and they say it's not a problem with the host database itself but with some database in smf.

AngelinaBelle · « **Reply #16 on:** September 10, 2010, 11:22:47 AM »

Please find out how to find out what the collations are on the tables and/or columns that are involved in the "illegal mix of collations" error.

Then, you can fix the problem tables.

I don't think this problem was caused by SimplePortal. It might not have been caused by SMF, either, but I cannot know for sure. But MYSQL is not happy that different fields in the SQL query are alphabetized differently.

Quote from: AngelinaBelle on August 27, 2010, 11:16:09 AM

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT)
I googled this. Other MYSQL users have run into the situation where tables suddenly got latin1_swedish collation for no discernable reason. They solved it by creating a script to fix the data on the tables and the tables themselves.

Chackan · « **Reply #17 on:** September 10, 2010, 11:32:24 AM »

And isn't there anything I can do about this:

llegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/otherwor/public_html/Sources/Subs-Portal.php
Line: 1112

I searched that file but I just can't find anything related to the problem or anything.

AngelinaBelle · « **Reply #18 on:** September 10, 2010, 11:39:57 AM »

The problem is on your database, not in the php file.

When the query on line 1112 is run, the database is unhappy that some fields have different dictionary orders (collations) than others.

It is possible, using your database admin tools, to find out which tables or fields have the wrong dictionary order and fix them.

You need to learn how to use your database admin tools.

Chackan · « **Reply #19 on:** September 10, 2010, 11:45:10 AM »

Won't promise anything but will try lol

Will post if any further development appears.

AngelinaBelle · « **Reply #20 on:** September 10, 2010, 11:53:26 AM »

Great. When you learn how to look for the details of fields/columns on your tables, look specifically for information on collation.

http://dev.mysql.com/doc/refman/5.0/en/charset-column.html (from the MYSQL 5.0 manual)

Simple Portal Archived Forum

User Info

Who's Online

Shoutbox

Team Blog

Recent Posts

Author Topic: Shoutbox Error! (Read 7117 times)