Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Problem with joomdocs update 4.0.4
(1 viewing) (1) Guest
Support forum for users using free edition of JoomDOC. These forums are mainly for mutual help between users.

NOTE: Due to our capacity limitations, ARTIO does not monitor this forum category regularly. If you want direct support from ARTIO, please start a ticket at Support Dashboard. If you have no support ticket available, you need to purchase it.
  • Page:
  • 1

TOPIC: Problem with joomdocs update 4.0.4

Problem with joomdocs update 4.0.4 7 years, 11 months ago #48140

ive just updated joomdocs from 4.0.3 to 4.0.4 and have this error when creating a document on the backoffice.
1146 Table 'cm-portimao.#__joomdoc_user' doesn't exist SQL=SELECT notifications FROM #__joomdoc_user WHERE user_id = 718 AND document_id = 0

what can i do?

Re: Problem with joomdocs update 4.0.4 7 years, 11 months ago #48141

Had the same problem, seems to be a new table that comes with 4.0.4 but the upgrade script does not create it. I used PHPMYADMIN and created the table using the following code (where <table prefix> is the prefix used by your Joomla installation :

CREATE TABLE IF NOT EXISTS `<table prefix>_joomdoc_user` (
`user_id` int(11) unsigned NOT NULL,
`document_id` int(11) unsigned NOT NULL,
`notifications` tinyint(1) NOT NULL,
UNIQUE KEY `user_id_document_id` (`user_id`,`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Re: Problem with joomdocs update 4.0.4 7 years, 11 months ago #48142

Thanks it worked perfectly

Re: Problem with joomdocs update 4.0.4 7 years, 11 months ago #48143

Thanks for the tip, but I assume it should have also populated the table if it is an existing installation?
The migration seems to be lacking, so I'm holding off ...

Re: Problem with joomdocs update 4.0.4 7 years, 7 months ago #48651

Same for me. @spigras: Thanks for sharing the sql statement. Looks like this fixed the issue - crossing fingers :-). But anyhow that's a bug in the upgrade installer ...
Last Edit: 7 years, 7 months ago by framp. Reason: typo
  • Page:
  • 1
User Login Empty