General support topic for Aeva Media (Latest release: July 28, 2010)

[Arantor]

Change $amSettings['max_items_per_page'] to $amSettings['max_thumbs_per_page']...

[psixanwmalos]

Hey please help? 

When i click to a photo to preview it works fine. But when i click the link of the title of the photo to open the photo to its own page i get this error:

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/rakos/public_html/forum/Sources/Aeva-Subs.php
Line: 3676

Please can you help me solve it??

[PLAYBOY]

Also how can i change the page title of the gallery?

Nevermind i got it. Its in the modifications.english(or yourlanguage).php

[Arantor]

It's not related to that at all, Spuds. It's actually a bug where in SMF, the collation of SMF's own tables is set by the DB default while mod tables end up being a different collation.

Only way to fix it is to manually go into phpMyAdmin and revert the collation of Aeva's tables to match those of the rest of the system.

[Goad]

after installing Aeva-Lite-7.1.708.zip my forum loads blank pages.....even if its just to the root page or links to various threads.

tried different browsers, same results 

using a freshly upgraded 2.0 RC4

[Spuds]

It's not related to that at all, Spuds. It's actually a bug where in SMF, the collation of SMF's own tables is set by the DB default while mod tables end up being a different collation.

Thanks, I was not aware of that SMF bug ... well at least thats somewhat easy to fix (meaning the error in this case)

I was originally thinking that it might have been that old SQL bug where it returned the default DB collation in certain query's even though the tables were in specified in a different collation.

so for psixanwmalos, do what IncognitoMuse says, go in to phpmyadmin and see what your default db collation is and change aeva's tables to match.

[Goad]

after installing Aeva-Lite-7.1.708.zip my forum loads blank pages.....even if its just to the root page or links to various threads.

tried different browsers, same results 

using a freshly upgraded 2.0 RC4

I read this is a known issue, but if youre using PortaMX....which I am not. I am using EZportal.

I tried the suggested edit below, but had no luck:

Just some added info to add on the white screen issues on pages with embedded links in combination with PortaMx v0.990 and AEVA v1.4b...

Commenting the line of code below from aeva-subs.php and aeva-embed.php does solve the blank white page issue...

Code Select Expand

ob_start($obs && ($obs['name'] != 'default output handler') ? $obs['name'] : null);

[PLAYBOY]

I have 2 "markread.gif" buttons right next to each other on my "unseen items" page
One button directs to this adress
http://www.site.com/forum/index.php?action=media;sa=unseen;markseen;sesc=8f525fc9ee5ee8f024df294b352ef596
Second button directs to
http://www.site.com/forum/index.php?action=media;sa=unseen;pageseen=29751,29750,29749,29748,29747,29746,29745,29744,29743,29742;sesc=8f525fc9ee5ee8f024df294b352ef596
I use custom theme. I may have copied an extra code or file somewhere. What can i do about this?

1.1.12



Update:
Also number of unseen items doesnt show on the tab for any other members other than admin eventhough members can get in to unseen page.

[psixanwmalos]

It's not related to that at all, Spuds. It's actually a bug where in SMF, the collation of SMF's own tables is set by the DB default while mod tables end up being a different collation.

Thanks, I was not aware of that SMF bug ... well at least thats somewhat easy to fix (meaning the error in this case)

I was originally thinking that it might have been that old SQL bug where it returned the default DB collation in certain query's even though the tables were in specified in a different collation.

so for psixanwmalos, do what IncognitoMuse says, go in to phpmyadmin and see what your default db collation is and change aeva's tables to match.

thanks guys. i can go to phpmyadmin but i dont know how to see my default db collation and how can i change aeva's tables to match?

sorry but i am a noob at php as you can see :/

thanks in advance

[Arantor]

It's nothing to do with PHP, but MySQL.

Down the left you'll see the list of tables in the database. Click on each of the Aeva tables (they have aeva in the name) then on Operations, then look in Table Options. You'll see it mentions either utf8_unicode_ci or utf8_general_ci. Whichever one it is, change it to the other one, since the Aeva tables are currently wrong.

Then hit Go, and repeat this for all the Aeva tables.

[b4pjoe]

after installing Aeva-Lite-7.1.708.zip my forum loads blank pages.....even if its just to the root page or links to various threads.

tried different browsers, same results 

using a freshly upgraded 2.0 RC4

I read this is a known issue, but if youre using PortaMX....which I am not. I am using EZportal.

I tried the suggested edit below, but had no luck:

Just some added info to add on the white screen issues on pages with embedded links in combination with PortaMx v0.990 and AEVA v1.4b...

Commenting the line of code below from aeva-subs.php and aeva-embed.php does solve the blank white page issue...

Code Select Expand

ob_start($obs && ($obs['name'] != 'default output handler') ? $obs['name'] : null);

That was for AEVA 1.4b at the time and it was an incompatibility with PortaMx which was patched by the PortaMx author.

[psixanwmalos]

It's nothing to do with PHP, but MySQL.

Down the left you'll see the list of tables in the database. Click on each of the Aeva tables (they have aeva in the name) then on Operations, then look in Table Options. You'll see it mentions either utf8_unicode_ci or utf8_general_ci. Whichever one it is, change it to the other one, since the Aeva tables are currently wrong.

Then hit Go, and repeat this for all the Aeva tables.

hey mate. just did as you told me to. All Aeva Tables we utf8_general_ci and i changed them all to utf8_unicode_ci

Gallery's is fully working just like before, except when you click to an item.
Same Error Message as before.
-------------------------------------------------------------
Link:
http://mixingtips.org/forum/index.php?action=media;sa=item;in=1

Message:
Database Error

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/rakos/public_html/forum/Sources/Aeva-Subs.php
Line: 3676


----------------------------------------------------------
Any ideas?

[Arantor]

So what collation is being used for the smf_members table?

[psixanwmalos]

So what collation is being used for the smf_members table?

utf8_unicode_ci mate

[psixanwmalos]

A similar error exists when you press the "Unseen" button. I dont know if this will help you solve the problem:


Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/rakos/public_html/forum/Sources/Aeva-Gallery2.php   (different file)
Line: 381 

[Arantor]

So you still have one or more tables using utf8_general_ci. Check every one of the Aeva tables, and that every column in them is using utf8_unicode_ci.

[psixanwmalos]

So you still have one or more tables using utf8_general_ci. Check every one of the Aeva tables, and that every column in them is using utf8_unicode_ci.

just did it. every table and sub-table is set at utf8_unicode_ci. wtf is happening?

[Spuds]

And when you first go in to phpmysql (before you select a database) what does it say for MySQL connection collation?

[b4pjoe]

So you still have one or more tables using utf8_general_ci. Check every one of the Aeva tables, and that every column in them is using utf8_unicode_ci.

just did it. every table and sub-table is set at utf8_unicode_ci. wtf is happening?

You need to set each field that uses collation in all of the tables to your desired collation as showing in the first attachment below. Then you also need to set the collation for each table by clicking the table name in the left column in phpMyAdmin and then clicking the "Operations" button in the right hand side of phpMyAdmin like in attachment #2 below. Repeat for all fields in each table and for each table.

[psixanwmalos]

And when you first go in to phpmysql (before you select a database) what does it say for MySQL connection collation?

utf8_unicode_ci

So you still have one or more tables using utf8_general_ci. Check every one of the Aeva tables, and that every column in them is using utf8_unicode_ci.

just did it. every table and sub-table is set at utf8_unicode_ci. wtf is happening?

You need to set each field that uses collation in all of the tables to your desired collation as showing in the first attachment below. Then you also need to set the collation for each table by clicking the table name in the left column in phpMyAdmin and then clicking the "Operations" button in the right hand side of phpMyAdmin like in attachment #2 below. Repeat for all fields in each table and for each table.

thats what i did mate