Community Support for OpenDocMan (Deprecated)
Plug-in: Individual file expiration date - Printable Version

+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: Plugins and Themes (https://forum.opendocman.com/forum-12.html)
+--- Thread: Plug-in: Individual file expiration date (/thread-417.html)

Pages: 1 2 3 4


Re: Plug-in: Individual file expiration date - jball - 06-27-2012

First, Many Thanks for submitting this Plug-in. What a great Idea. I plan to use it for Corrective Action and Internal Audits Reports in our ISO 9001 Quality Management System. :!:

Sadly I have a problem:
I FTP'd the files to my site. Installed and got the "DONE!" message. CHMod to 777 for the c_templates directory. Ran the script in: plug-ins/InExp/index.php (from the admin, plugin,InExp - Run file check now)

Error in query: SELECT a.id, a.date_expires, a.reminder, b.owner, b.realname, b.description FROM odm_data_addon as a, odm_data as b WHERE a.id=b.id AND a.date_expires < NOW() AND a.date_expires!='0000-00-00' AND b.status!=-1 AND b.publishable!=-1 AND b.publishable!=2 AND a.sent!=2Table 'koehlerf_odm736.odm_data_addon' doesn't exist

I'm runing on a LINUX server PHP 5.3.14

in File Details I get

Error in query: SELECT id, date_expires, date_reminder FROM odm_data_addon WHERE id='1'Table 'koehlerf_odm736.odm_data_addon' doesn't exist

Instead of the usual menu.

Thanks in advance for any help. Hope this helps improve your plug-in.


Re: Plug-in: Individual file expiration date - Mikeyy - 06-27-2012

Not really sure about this, I'll let Stephen take a look at this. Smile
I'm still using 1.2.6 beta and have no problems with plugin. What version are you using?


Re: Plug-in: Individual file expiration date - jball - 06-28-2012

OpenDocMan v1.2.6.1

This is a fairly new install.


Re: Plug-in: Individual file expiration date - Papershark - 10-31-2012

Mikeyy Wrote:Not really sure about this, I'll let Stephen take a look at this. Smile
I'm still using 1.2.6 beta and have no problems with plugin. What version are you using?

The installation script is buggy. :cry: The SQL statement is this:

Code:
CREATE TABLE IF NOT EXISTS `data_addon` (
  `id` int(11) NOT NULL,
  `date_expires` date NOT NULL,
  `reminder` int(11) NOT NULL,
  `date_reminder` date NOT NULL,
  `sent` tinyint(4) NOT NULL DEFAULT 0,
  UNIQUE KEY `id` (`id`),
  KEY `date_expires` (`date_expires`)
) DEFAULT CHARSET=utf8

Should be like this as the standard installation uses the prefix odm_
Code:
CREATE TABLE IF NOT EXISTS `odm_data_addon` (
....

Therefore the table is not found in the database. :roll:

As a workaround change the install script to use the appropriate prefix.

BTW: Why is the script forcing an INNODB scheme?

Regards,
Papershark


Re: Plug-in: Individual file expiration date - Stephen - 10-31-2012

Thanks Papershark, I will take a look at that.


Re: Plug-in: Individual file expiration date - mouburg - 04-26-2013

When installing this plugin I get the error 310 (net::ERR_TOO_MANY_REDIRECTS)
After that, all of ODM stops working.....
Any advise on this?


RE: Plug-in: Individual file expiration date - toolmanwill - 11-19-2015

Using ODM v 1.3.4 and InExp v 1.5
getting this error after uploading files

Notice: Undefined index: db_prefix in C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\data\localweb\plug-ins\InExp\InExp_class.php on line 59

line 59 is this

$stmt->execute(array(':table' => '%' . $_SESSION['db_prefix'] . 'odmsys' . '%'));


any ideas on how to fix this error?