The table node_user_access was not created during the install of the module.
I didn't try to figure out why, but i created it manually :

CREATE TABLE IF NOT EXISTS `node_user_access` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `accesslog_node_uid` (`uid`),<code>
  KEY `accesslog_node_timestamp` (`timestamp`),
  KEY `accesslog_node_nid` (`nid`)
)

Hope this can help.

CommentFileSizeAuthor
#1 user_access_installer_repair_954198_1.patch575 bytesc-logemann

Comments

c-logemann’s picture

c-logemann
he/him
Primary language German
Location Frankfurt/M, Germany
commented
Title: Table not created » Table not created - Error in installation file
Priority: Normal » Major
Status: Active » Needs review
StatusFileSize
new user_access_installer_repair_954198_1.patch575 bytes

The functions user_access_install() and user_access_uninstall() and hook_uninstall() in the installation file are wrong. Look at the attached patch file.

mdupont’s picture

mdupont
Primary language French
Location Switzerland
commented
Priority: Major » Critical
Status: Needs review » Reviewed & tested by the community

Works well for me. Without this patch, the module can't be installed or uninstalled properly. Setting to critical.

WorldFallz’s picture

WorldFallz commented

I can verify the patch as well-- since this renders the module useless for the average user, it would be a really good idea to committ this asap.

theroyal’s picture

theroyal commented

yes I am facing the same problem,
I am getting tens of errors each minute on my live website logs.

‏Table 'mydatabase.node_user_access' doesn't exist query: INSERT INTO node_user_access (nid, uid, timestamp) VALUES (69278, 0, 1307794025) in /var/www/vhosts/example.com/httpdocs/sites/all/modules/user_access/user_access.module in line 29.

wondering if the module is stable after adding this patch?
if so, then why it is not committed til this moment? 7 months ?

theroyal’s picture

theroyal commented

ok after applying the patch it is working nicely.