Menu Content

Support

> Forums, FAQs & Paid Support
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 9 years, 10 months ago #48140

  • poca2k
  • OFFLINE
  • Posts: 2
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?
The topic has been locked.

Re: Problem with joomdocs update 4.0.4 9 years, 10 months ago #48141

  • sbigras
  • OFFLINE
  • Posts: 1
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;
The topic has been locked.

Re: Problem with joomdocs update 4.0.4 9 years, 10 months ago #48142

  • poca2k
  • OFFLINE
  • Posts: 2
Thanks it worked perfectly
The topic has been locked.

Re: Problem with joomdocs update 4.0.4 9 years, 10 months ago #48143

  • koraldon
  • OFFLINE
  • Posts: 3
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 ...
The topic has been locked.

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

  • framp
  • OFFLINE
  • Posts: 3
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: 9 years, 6 months ago by framp. Reason: typo
The topic has been locked.
  • Page:
  • 1
User Login Empty