User warnings after installation
| Project: | lm_paypal |
| Version: | 6.x-1.0 |
| Component: | LM Paypal Subscriptions |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I have just installed LM Paypal and looking at the saved IPNs tab I get:
user warning: Table 'elanpreview_co_uk_million.lm_paypal_ipns' doesn't exist query: SELECT COUNT(*) FROM lm_paypal_ipns in /var/www/html/client/mi/sites/all/modules/lm_paypal/lm_paypal.module on line 1066.
user warning: Table 'elanpreview_co_uk_million.lm_paypal_ipns' doesn't exist query: SELECT id, timestamp, txn_type, custom FROM lm_paypal_ipns ORDER BY timestamp DESC LIMIT 0, 50 in /var/www/html/client/mi/sites/all/modules/lm_paypal/lm_paypal.module on line 1066.
Looking at the subscriptions tab I get:
user warning: Table 'elanpreview_co_uk_million.lm_paypal_subscriptions' doesn't exist query: SELECT subid, item_name, description, status, kind, rid FROM lm_paypal_subscriptions ORDER BY subid ASC in /var/www/html/client/mi/sites/all/modules/lm_paypal/lm_paypal_subscriptions.module on line 1476.
Any help appreciated
#1
Looks like your database tables didn't get created, for some reason. Was there any errors at install-time? Which DB are you using?
#2
There were no errors at install-time, I am using a mysqli database.
Thanks for your help.
#3
I have no idea then. The warnings say that your "lm_paypal_ipns" table and "lm_paypal_subscriptions" tables don't exist, and these are created during installation. You could create them manually, I suppose - but the underlying problem is likely to be bigger than this.
You could try disabling _and uninstalling_ (from the uninstall tab) the modules, and trying again?
#4
Hey,
I have got the same problem too, however it used to work before, but now the install file doesn't seem to create the tables in the database. And the uninstall tab does not carry the module (lack of uninstall hook) so I had to manually delete the tables and then try to enable them again with no luck.
Update me in any progress.
Thanks.
#5
What do you mean "no uninstall hook"?
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/lm_paypal/l...
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/lm_paypal/l...
Both appear to have uninstall hooks. And nothing much has changed in either file since the module was updated to Drupal 6.