Plug-in: Individual file expiration date

[jball]

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.

[Mikeyy]

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?

[jball]

OpenDocMan v1.2.6.1

This is a fairly new install.

[Papershark]

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?

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

[Stephen]

Thanks Papershark, I will take a look at that.

[mouburg]

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?

[toolmanwill]

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?