lionelm / tinycimm

Automatically exported from code.google.com/p/tinycimm
0 stars 0 forks source link

Error in TinyCIMM browser after install #26

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. I use prefix on table names in database
2. Configure TinyCIMM
3. Have error in tinycimm browser "Sorry, there was an error retrieving the
assets."

What problem? In unprefix table name in tinycimm_module.php with SELECT
MySQL query.

How this repair?
-----------------[OPEN]---------------------
/system/application/models/tinycimm_model.php
-----------------[FIND]---------------------
$result = $this->db->query('SELECT SUM(filesize) AS filesize FROM asset
WHERE folder_id = '.((int) $folder_id).' LIMIT 1')->row();
-----------------[REPLACE]---------------------
$result = $this->db->query('SELECT SUM(filesize) AS filesize FROM
'.$this->db->dbprefix.'asset WHERE folder_id = '.((int) $folder_id).' LIMIT
1')->row();

Original issue reported on code.google.com by A.V.Kaza...@gmail.com on 11 Sep 2009 at 11:54

Attachments: