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) |
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. 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. The installation script is buggy. :cry: The SQL statement is this: Code: CREATE TABLE IF NOT EXISTS `data_addon` ( 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? |