Community Support for OpenDocMan (Deprecated)

Full Version: Plug-in: Individual file expiration date
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4
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.
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?
OpenDocMan v1.2.6.1

This is a fairly new install.
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
Thanks Papershark, I will take a look at that.
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?
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?
Pages: 1 2 3 4