Several Errors I cant seem to figure out
| Project: | Advertisement |
| Version: | 6.x-2.x-dev |
| Component: | ad module |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Hey Jeremy,
Im going to be honest and tell you this is a problem I have been struggling with, and may be caused from overlapping issues. If you could send me in the right direction, I would be gratefull.
I am getting the following errors when I install the latest dev version
user warning: Table 'xxx.drup_ad_owners' doesn't exist query: SELECT oid FROM drup_ad_owners WHERE aid = 448 AND uid = 1 in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 377.
user warning: Table 'xxx.drup_ad_owners' doesn't exist query: INSERT INTO drup_ad_owners (aid, uid) VALUES(448, 1) in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 378.
user warning: Table 'xxx.drup_ad_owners' doesn't exist query: SELECT oid FROM drup_ad_owners WHERE aid = 448 and uid = 1 in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 399.
user warning: Table 'xxx.drup_ad_permissions' doesn't exist query: DELETE FROM drup_ad_permissions WHERE oid = 0 in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 400.
user warning: Table 'xxx.drup_ad_permissions' doesn't exist query: INSERT INTO drup_ad_permissions VALUES(0, 'access statistics|,|access click history|,|access activity log|,|set status from approved to active|,|set status from approved to offline|,|set status from active to offline|,|set status from offline to active|,|manage ad html|,|manage ad text') in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 401.
user warning: Table 'xxx.drup_ad_hosts' doesn't exist query: SELECT hostid FROM drup_ad_hosts WHERE uid = 1 in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 411.
user warning: Table 'xxx.drup_ad_hosts' doesn't exist query: INSERT INTO drup_ad_hosts (uid, hostid) VALUES (1, '093523d695b93607e972ef56415e7dcc') in /home1/xxx/public_html/modules/ad/owners/ad_owners.module on line 414.
Thanks,
Dave

#1
In addition, here is the code copied from the page source
again thanks
dave
#2
Where there any errors when you enabled the ad_owners module? Had you previously had the ad module installed on this server, or was this an upgrade?
Your best bet is to disable and then uninstall the ad_owner module, and then to enable it again which should cause these tables to be properly installed. I have confirmed that on a new installation these tables are correctly created.