* user warning: Table 'mysouds.node_limit_role' doesn't exist query: SELECT * FROM node_limit_role ORDER BY rid ASC in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 348.
* user warning: Table 'mysouds.node_limit_user' doesn't exist query: SELECT nu.*, u.name FROM node_limit_user as nu INNER JOIN users as u ON (nu.uid = u.uid) ORDER BY nu.uid ASC in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 352.
* user warning: Table 'mysouds.node_limit_role' doesn't exist query: SELECT * FROM node_limit_role ORDER BY rid ASC in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 348.
* user warning: Table 'mysouds.node_limit_user' doesn't exist query: SELECT nu.*, u.name FROM node_limit_user as nu INNER JOIN users as u ON (nu.uid = u.uid) ORDER BY nu.uid ASC in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 352.

Comments

sanluca’s picture

Version: 6.x-1.x-dev » 6.x-0.1

I also installed the latest version but still errors, I can not use it why?

thanks

* user warning: Table 'mysouds.node_limit' doesn't exist query: SELECT (MAX(lid)+1) AS lid FROM node_limit in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 444.
* user warning: Table 'mysouds.node_limit' doesn't exist query: INSERT INTO node_limit VALUES('1', 'blog', '10', 'limita il blog', '0') in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 408.
* user warning: Table 'mysouds.node_limit' doesn't exist query: SELECT * FROM node_limit ORDER BY weight ASC in /home/web/mysouds.com/sites/all/modules/node_limit/node_limit.module on line 230.

davedelong’s picture

Do you get any errors while installing the module?

Dave

sanluca’s picture

no error during installation, I looked in the database but does not create the table, how can I do to create it by hand?

sanluca’s picture

anyone help me?

thanks

jcmarco’s picture

I did an upgrade from previous version, and I didn't get any message about creating any table.
What I see it is that previous schema had node_limit_role and node_limit_user tables, but new release works only with the role_limit table (I haven't yet activated the node limit user module)
So the issue is with the .install script, it needs an upgrade function, it should delete or convert old tables into the new table, or at least create the new table, and delete all ones.

user warning: Table 'drupal6.node_limit' doesn't exist query: SELECT * FROM node_limit ORDER BY weight ASC in XXXXXXXXXXXXXX\modules\node_limit\node_limit.module on line 230.

The only way to work is with a clean install (desactivate modules, uninstall module and install again module).

jcmarco’s picture

More questions, once uninstalled and installed, it created the new table. (leaving old ones, BTW)
But the module need to have active some render limit function that only comes with the node_limit_user module.
As there is no requirements for the module to work neither any control about the existence of other module with function it doesn't work.
Probably it could come by default with the role restrictions because it looks the most standard, and user an OG as option.

warning: Invalid argument supplied for foreach() in xxxxxxxxxxx\sites\all\modules\node_limit\node_limit.module on line 279.

davedelong’s picture

With regards to the old tables, you're right! I'm putting in the commands to drop the old tables before installing new ones. I hadn't intended to put them in, primarily because the first release was a -dev version and wasn't intending to push out an upgrade path. When I commit the updated module, with the new node_limit_role submodule, it'll be in there.

I've also fixed the issue in comment #6

Dave

sanluca’s picture

I solved it works now but it disappeared the settings for the roles?

davedelong’s picture

Version: 6.x-0.1 » 6.x-0.2
Assigned: Unassigned » davedelong
Status: Active » Needs review

I added an upgrade from the -dev version to the current (0.2) version. It's working fine for me on a clean install of D6, but let me know if you have problems with it.

Dave

duaelfr’s picture

Status: Needs review » Closed (fixed)

Cleaning issues list
See 6.x-0.3