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

[OCJ]

SMF 2.0.4
Aeva Media 1.4w

I searched for the error message about key too long and the table name but nothing in this topic.
I want to reinstall the database and files in another location but cannot import the backup databases into the new database using phpmyadmin - fails after 9 tables imported only (last one ; smf_aeva_media)

So basically only option I have now is to delete all the aeva tables from the sql file and try reimporting it so I can get my forum working.

Any other way to get around the error easily? Manually making the same table with longer length (varchar( 255 ))?
This hasn't happened before but maybe I didnt have Aeva media installed last time.

Error

SQL query:

CREATE TABLE `smf_aeva_perms` (
`id_group` int( 11 ) NOT NULL default 0,
`id_profile` int( 11 ) NOT NULL default 0,
`permission` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id_group` , `id_profile` , `permission` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

[Arantor]

Making the table longer will not solve the problem. It will make it worse - and it'll still fail.

What it's telling you is the problem: the primary key is > 1000 bytes. 4 bytes for the id_group, 4 bytes for id_profile and (255 * 4) for the permission... is more than 1000. varchar(64) should do it, actually.

[OCJ]

Actually Im getting this on other smf database tables  after taking out Aeva media ones... newsletter field also.

I dont know much about this type of error actually. This is more than just Aeva. I never had this problem with the SMF database before though.

This doesnt look like a global setting but for each table with a problem?

Error

SQL query:

CREATE TABLE `smf_hcb_newsletter` (
`next_ltr_date` int( 10 ) unsigned NOT NULL default 0,
`email` varchar( 255 ) NOT NULL ,
`period` mediumint( 3 ) unsigned NOT NULL default 0,
PRIMARY KEY ( `email` ) ,
KEY `next_date` ( `next_ltr_date` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

[Dhayzon]

not shown copyright how to solve




fail in other theme

[Arantor]

Copyright will only be shown on pages where embedding or the gallery is used. That is entirely by design that it is not on that page since I don't see any embedding or gallery items.

[Kindred]

Actually, Arantor, since it appears to be the same page in both images, with the aeva copyright showing in one and not the other, I think there is an issue.

I just looked at the giggle theme...
The footer of that theme looks nothing like the footer in the image.  That suggests that the user altered the theme and probably the SMF copyright in the process - which caused the AEVA insertion to fail...
(even more specifically, I note that the SMF copyright in the giggle image is actually missing the | (pip) between the statements.)

[Arantor]

(even more specifically, I note that the SMF copyright in the giggle image is actually missing the | (pip) between the statements.)

No it isn't

Actually, Arantor, since it appears to be the same page in both images, with the aeva copyright showing in one and not the other, I think there is an issue.

It just means the copyright isn't showing for some random reason - you know as well as I know that it's not going to be fixed.

[Kindred]

lol...

Well, I was suggesting that there was an issue with his site/coding not with Aeva.   because the aeva insertion routine seems to work correctly on the giggle theme that I just installed and tested

[nax]

There seems to be a problem with the Vimeo site, whenever anyone on my forum posts a link to them they get what looks like a video about to play but the wording is "Sorry there was an error encountered when loading this video"  If a user clicks on the description below the image it opens a new window and the video loads correctly.  I am using the latest version 7.2 and my SMF files are up to date.

[Kindred]

do a searc. this has been answered.  Vimeo changed their connetion API

[ryan_dwight]

im confused about avi and mp3 files. is it playable in here?

because i tried uploading on the server and used the ftp import, when i tried to play it i just got an error "No plugins available to display this content"

i just search the forum and i got nothing.

thanks

[Arantor]

Lack of plugins to play the content is not Aeva's fault, it's because you don't have codecs set up for your browser to play them.

[ryan_dwight]

Lack of plugins to play the content is not Aeva's fault, it's because you don't have codecs set up for your browser to play them.

i checked the mod page and it indicates avi file(via divx)
so i installed divx in my browser but i got same result.
but when i tried uploading flv file via ftp its working.

edit:
i got an error when im trying to execute ftp import

Fatal error: Maximum execution time of 30 seconds exceeded in /home/ptcb/public_html/Sources/Errors.php on line 204

which is

global $settings, $modSettings, $db_show_debug;

another is on the post that i made with a link of the video

Fatal error: Maximum execution time of 30 seconds exceeded in /home/ptcb/public_html/Sources/Aeva-getid3/getid3.lib.php on line 45

which is

$truncatednumber = floor($floatnumber);

[Arantor]

-sigh- The error is telling you very specifically what the problem is. PHP scripts on your server have a time limit in which to operate - 30 seconds. If they are not done inside that time, they are closed down.

The FTP import took too long, as did the getting of the video information... and there's not really a lot you can do about that.

[ryan_dwight]

so there is no fix on this one?

[Arantor]

Not unless you can change PHP's configuration, which seems unlikely.

[ryan_dwight]

ok thanks for the help i think 60 is working fine and the error was already gone

[Tonyvic]

Hi all,
Does anyone know if it's possible to prevent 'comments' on photos from appearing as 'Unseen', apart from removing the ability to comment?
I have a few members who keep on commenting on friends pics to get them noticed more, and it's annoying others.

TIA

[Kindred]

no....   

That sort of behavior is something that you need to control on your own - usually by rules and enforcement of those rules with penalties (like temp ban, or removing the ability to comment altogether from the offending users)

[Tonyvic]

Many thanks Kindred, I guessed it wouldn't be straightforward!