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

[drfun]

drfun, that is a known bug in smf.
You will have to manually change the collations in your database, to either utf8_general_ci, or utf8_unicode_ci.
You may have to do this for other mods that create their own tables.
Good luck

@Sabre i checked my database using Phpmyadmin and i saw where i could either select utf8_general_ci, or utf8_unicode_ci.
and when i change it to utf8_unicode_ci. from utf8_general_ci, i was still getting the error. please what else can i do?

[drfun]

this is an old topic but might help you...
http://www.simplemachines.org/community/index.php?topic=341969.msg2305559#msg2305559

What I would suggest doing at this stage is a file refresh. This will clean up your forum back to a default SMF installation but will not affect your database (which contains all the post, topic and member information).

It will also uninstall all mods. They can then one reinstalled one at a time, making sure to check both forum functionality and the error log after installing each one and using it for a bit.

This would be the quickest and cleanest way

@ techno489 thanks for this old post,
I would love to try this, but how can i do the file refresh stuff if this will solve the problem.

[drfun]

except that it wont solve the problem at all


you need to go into phpmyadmin to change the database tables themselves

Thanks for this tips, But if am to change the database tables themselves, what am i changing them to?

[Oya]

you need to change every single table to utf8_general_ci

[T3CHN0]

As the message in quotes says.
What you want to do is download this zip:NOT THIS ONE IT IS OLD http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc1-2_upgrade.zip

Get this one http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_upgrade.zip

Extract the files from it on your desktop and load everything except upgrade.php into the correct locations.
in your forum.

This will replace everything but leave boards & members still there.
you will have to re-do everything /install MODS /Install Theme again.

At least you will have a fresh start over and not make the same error MOD install again.

you really need to know what you are doing when installing MODs if the MOD has error warnings on the install.

Make sure you back your complete forum before doing this encase you need to do a restore back to the last point of attack

[Oya]

the file refresh will NOT solve the db collation problem AT ALL because its the database at fault not the files!

[drfun]

you need to change every single table to utf8_general_ci

i am in my database right now and majority of my database table are in utf8_general_ci while about 14 of
the tables are in utf8_unicode_ci . should i change them to utf8_general_ci ?

[drfun]

you need to change every single table to utf8_general_ci

i am in my database right now and majority of my database table are in utf8_general_ci while about 14 of
the tables are in utf8_unicode_ci . should i change them to utf8_general_ci ?

the 14 of this table all belong to avea media

[Oya]

change all 14 to utf8_general_ci like i said

[drfun]

@oya sorry please, how can i change this collation. i have selected the fist table
which is smf_1ads and click on the collation but nothing is happening, no place to
even imput the utf8_general_ci

[Oya]

click on each table
click on operations
set collation to the right one
press go

[drfun]

@oya thanks, i was able to do this and i got this "Your SQL query has been executed successfully" and this "ALTER DATABASE `allstude_forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
But clicking on the database, the collation still remain utf8_uncode_ci. Is this how its suppose to be.

[drfun]

@oya thanks, i was able to do this and i got this "Your SQL query has been executed successfully" and this "ALTER DATABASE `allstude_forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
But clicking on the database, the collation still remain utf8_uncode_ci. Is this how its suppose to be.

After doing the above, nothing still change, i got the error still. i decided to uninstual the of my mod, which are
Simple portal
Country flag
i started with the simple portal and my forum crashed.

[The Domain Shop]

When installing Aeva media i get test failed errors. I need to change this but don't no how or where

Find

Code Select Expand


'mlist' => array(


Replace

Code Select Expand


// Aeva Media changes
'media' => array(
'title' => (isset($txt['aeva_gallery']) ? $txt['aeva_gallery'] : 'Media') . (!allowedTo('aeva_access_unseen') || empty($user_info['aeva_unseen']) || $user_info['aeva_unseen'] == -1 ? '' : ' [<b>' . $user_info['aeva_unseen'] . '</b>]'),
'href' => $scripturl . '?action=media',
'show' => allowedTo('aeva_access'),
'sub_buttons' => !allowedTo('aeva_access_unseen') || empty($user_info['aeva_unseen']) || $user_info['aeva_unseen'] == -1 ? array() : array(
'aeva_home' => array(
'title' => $txt['aeva_home'],
'href' => $scripturl . '?action=media',
'show' => true,
),
'aeva_unseen' => array(
'title' => $txt['aeva_unseen'],
'href' => $scripturl . '?action=media;sa=unseen',
'show' => true,
'is_last' => true,
),
),
),
// End Aeva Media changes


If someone tells me the file i need and then attach it here would someone be kind enough to do this for me so i don't screw my site up please.

[Oya]

that's subs.php you need to change

[Oya]

no that means you just changed the database

you need to go into each individual table TOO by clicking on the table name in the left panel then into operations for that table


and please do not post within an hour or so of your previous post - you can edit your previous post to include the new details

[The Domain Shop]

that's subs.php you need to change

Well.. That helps loads bit of an idea would be nice

[Kindred]

Please post mod support questions in the thread dedicated to supporting that specific mod, not in the general support area.

and the answer was actually exactly right. find the line in Sources/Subs.php and add the aeva code.

[The Domain Shop]

and the answer was actually exactly right. find the line in Sources/Subs.php and add the aeva code.

I never said he was wrong i just needed a bit more information to where that file was. You seem to forget that not all of us have been using smf or php for years in fact i have only been using it for about one week on my own server so obviously I'm still learning. :/

[Angelina Belle]

@TRAX

It can be confusing to learn where files are normally kept.
But computers are really useful for helping you keeping track of stuff like that.
You can keep a copy of all of your site's files on your desktop computer.

Then, you can go to the forum root and use the file search feature to find a file called Subs.php
If you ever need to search within files (for a function name, for example), you can use file search functions.
On a PC, you can start the command window, CD to your SMF directory, and use FIND  (find /? to learn more).

You can also use the tools right here to learn more about SMF -- http://support.simplemachines.org/ The function list is especially useful.

These tools will help you learn your way around out-of-the-box SMF, so you can more easily solve your mod problems.