SimplePortal
Support => English Support => Topic started by: 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
-
Still no help :| And no solution!
-
did you try the database upgrade that comes with SMF 1.1.11?
-
How do I do that? I search and found nothing :|
-
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)
-
Ok, done that and I still get the same error!
-
Chackan,
Did you attempt to run the install1-1.php?
-
Yes, it was prolly the first thing I did :P
-
You are still getting the database upgrade error?
Have you tried re-running the database upgrade that came with SMF?
-
I think that i only ran the install1-1.php if I recall correctly.
Is it the same thing?
-
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?
-
Honestly? I don't really know how to do that :X
-
You set up your database somehow. How'd you do it?
-
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...
-
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.
-
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.
-
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.
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.
-
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.
-
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.
-
Won't promise anything but will try lol
Will post if any further development appears.
-
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 (http://dev.mysql.com/doc/refman/5.0/en/charset-column.html) (from the MYSQL 5.0 manual)