After installing the 1.0 version, when i go to admin/settings/node_limitnumber I get the following error:

user warning: Table 'askfordesign_net_site.node_limitnumber_rules' doesn't exist query: node_limitnumber_get_all /* admin : node_limitnumber_get_all */ SELECT * FROM node_limitnumber_rules WHERE class = 'role' in /var/www/html/sites/all/modules/node_limitnumber/node_limitnumber.inc on line 130.

Comments

jdwfly’s picture

jdwfly commented
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

I just installed this module on a fresh drupal install, but I can't reproduce the error.

Could you post exactly how this happened and if it always happens? The error says that the table does not exist. I would try disabling the module, and then uninstalling it and then re-enabling it. You would of course lose all stored limits when you uninstalled, but from what it sounds like the table isn't there to begin with.

jdwfly’s picture

jdwfly commented
Assigned: Unassigned » jdwfly
Category: support » bug

I'll leave it as bug report until I get more information

00110000’s picture

00110000 commented

I installed this on two sites recently (6.13 & 6.14), it is working perfectly for me so far, just thought I mention it.

mairav’s picture

mairav commented

It seems that it didn't creat the node_limitnumber_rules table
I looked for it the database but its not there. I tried to disable the module, delete it, and start from scratch, but nothing.
Any ideas?

jdwfly’s picture

jdwfly commented

Is the node_limitnumber.install present?

mairav’s picture

mairav commented

If you mean the node_limitnumber.install file inside the node_limitnumber folder, yes it's there.
I had some time ago, the module for drupal 6 created by users, and then I disabled and deleted it cause the node_limit was more acuratte for my needs.

The module doesn't have the option to uninstall, so I think it left the original reference to the module in the system table, so when I installed it again it thought the table was created, and didn't want to create it.

I deleted the entry in the system table calling to the module, went to the modules pages, enable it again, and now the table has been created.

I recommend you add a Uninstall feature to the module that deletes the table and the entry of the module in the system table.

Thanks, I'll be checking the module with the coming features.

jdwfly’s picture

jdwfly commented
Title: user warning: Table 'xxx.node_limitnumber_rules' doesn't exist query » Make sure that the uninstall schema function is being called
Status: Postponed (maintainer needs more info) » Active

I'll check on this

jdwfly’s picture

jdwfly commented
Status: Active » Closed (fixed)

Worked fine for me. Going to mark this as closed.