user warning: Table 'magic_database.uc_restrict_qty_products' doesn't exist query: SELECT * FROM uc_restrict_qty_products WHERE nid = 343 AND model = 'FreeTrial' in /www/magic/public_html/sites/all/modules/uc_restrict_qty 2/uc_restrict_qty.module on line 151.

user warning: Table 'magic_database.uc_restrict_qty_products' doesn't exist query: INSERT INTO uc_restrict_qty_products (pfid, nid, model, qty, lifetime) VALUES (6, 343, 'FreeTrial', 1, 1) in /www/magic/public_html/includes/common.inc on line 3467.

Comments

abemonkey’s picture

abemonkey commented

I'm getting the same errors here. I really need to get this site up with quantity restrictions so any help would be appreciated. Thanks.

jalane81’s picture

jalane81 commented

Just tested after posting the bug and verified that the product was NOT restricted.

Stanto’s picture

Stanto commented

To fix it, it's pretty easy.
Just open the file uc_restrict_qty.install, and remove line 19 :
'unsigned' => TRUE,
You could also remove line 20.

The serial type is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE so there is no need to repeat that again.

      'rqpid' => array(
        'type' => 'serial',
      ),

Should be enough.

abemonkey’s picture

abemonkey commented

Did exactly as you said and it didn't fix the warning. Any other ideas?

raulmuroc’s picture

raulmuroc commented
Issue summary: View changes
Status: Active » Closed (fixed)

Closing due to lack of activity. If you are still working on this application, you should fix all known problems and then set the status to "Needs review". (See also the project application workflow).