Revo 2.2.5 (Adv) File Media Source Errors

Hi,

I have upgraded our Advanced Revo install from version 2.2.4 to version 2.2.5. There were no errors displayed during the upgrade process however the error log is now filling up with the follow error:



and this one:



The errors are occurring approx every 10sec and the error log is growing by 5mb a day.

I have two media sources setup. The default filesystem and one other that limits certain users to a specific folder in the filesystem. The website, manager and both media sources appear to be operating correctly.

Could anyone advise what is wrong or what could be causing the error?

Many Thanks

Can you try reuploading the 2.2.5 files, and rerunning setup?

Same problem here. I tried to reupload all files and rerun the setup, after that i'm having much much more (other) errors in the error log my backup was gone, now i have to start from scratch again. Luckily not very much content, but much other things to recreate. I took the "Traditional Setup" as always

[2012-10-14 13:34:58] (ERROR @ /index.php) sources.modMediaSource::getSelectColumns() is not a valid static method.
[2012-10-14 13:34:58] (ERROR @ /index.php) Error 42S22 executing query: SELECT `modSnippet`.`id` AS `modSnippet_id`, `modSnippet`.`source` AS `modSnippet_source`, `modSnippet`.`property_preprocess` AS `modSnippet_property_preprocess`, `modSnippet`.`name` AS `modSnippet_name`, `modSnippet`.`description` AS `modSnippet_description`, `modSnippet`.`editor_type` AS `modSnippet_editor_type`, `modSnippet`.`category` AS `modSnippet_category`, `modSnippet`.`cache_type` AS `modSnippet_cache_type`, `modSnippet`.`snippet` AS `modSnippet_snippet`, `modSnippet`.`locked` AS `modSnippet_locked`, `modSnippet`.`properties` AS `modSnippet_properties`, `modSnippet`.`moduleguid` AS `modSnippet_moduleguid`, `modSnippet`.`static` AS `modSnippet_static`, `modSnippet`.`static_file` AS `modSnippet_static_file`, `` FROM `modx_site_snippets` AS `modSnippet` LEFT JOIN `modx_media_sources` `Source` ON `modSnippet`.`source` = `Source`.`id` WHERE `modSnippet`.`name` = ? ORDER BY `modSnippet`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column '' in 'field list'
)

[ed. note: blubb1 last edited this post 12 years, 4 months ago.]

Quote from: markh at Oct 13, 2012, 01:35 AM

Can you try reuploading the 2.2.5 files, and rerunning setup?

Hi Mark,

I have reuploaded the 2.2.5 files, rerun setup and the error is still appearing at the same rate in the error log.

One thing I did notice this time, during install the following warning was flagged:

Error updating table for class modResource
Array
(
[0] => 42000
[1] => 1061
[2] => Duplicate key name 'cache_refresh_idx'
)

Do you think it is related?

Many Thanks

Now i reinstalled from scratch. The errors are gone, until - yeah until i test my own snippet again. It throws errors like the ones upon. I think its not the same problem so i'm out of this thread now the strange thing is it throws exactly the same error

I was getting this error on one of our sites, re-uploaded the files and ran setup again and the error is gone so far.

I'm gonna ask the question... did you FTP the unpacked modx2.2.5-pl.zip contents to the server?

It can't find something it's supposed to find, so it stands to reason that it's missing.

Grab a fresh copy of MODX 2.2.5, and try to install again, but without FTP (if you did use it).

OK, I spoke too soon about it not appearing. Went back to the site today and the error was there again, over and over. This error is sporadic, occurred for five hours then stopped appearing again.

[2012-10-16 00:54:34] (ERROR @ /index.php) Could not get table name for class: modFileMediaSource

I overwrote every file except the assets, core/config and core/packages (I did upload core package separately) folders and re-ran setup.

We use Rackspace Cloud Sites for this site which is HORRIBLE with its MODX support. 2.2.5 appears to be running fine so far but turning off flock caused sites to go down. RS Cloud Sites doesn't allow shell access so FTP or SFTP is the only option.

Now i am here again it's not my own snippet, i am getting this errors again and again. Don't know the cause...

Any update here? I'm still having this issue, the error log grows and grows please help