By jamesho19 on
Hi I have done something wrong when I deleted the database from mysql command.
Aftert hat I got warning message that appear everytime when I into the menu item related to advertisment module.
The message is like below. Can someone help me here?
user warning: Table 'freetime_drpl1.ads' doesn't exist query: SELECT node.nid FROM node node LEFT JOIN ads ads ON node.nid = ads.aid WHERE (ads.adstatus IN ('active')) LIMIT 0, 99 in /home/freetime/public_html/web/includes/database.mysql.inc on line 172
Comments
If you have destroyed the
If you have destroyed the ads table then you will need to recreate an empty one or restore from backup.
To recreate, if the ads module supports the uninstall feature then disable the module and then hit the Uninstall tab. This will delete all data associated with the ads module. You can then re-enable the module and it will make the table(s) for you.
Otherwise look in the ads module's .install file for the SQL to create the ads table afresh (look in function ads_install() or whatever).
gpk
----
www.alexoria.co.uk
gpk
----
www.alexoria.co.uk
Thank you the problem is
Thank you the problem is solved, however I cannot
active the ads, can you please help me?
I got this error message call
"Image validation failed, unable to mark ad as active. Setting ad as pending. If you do not see any more errors, you should now be able to set your ad as active."
Thank you
Sorry I've not used this
Sorry I've not used this module (actually I'm not sure which one it is) - maybe someone else can help .........?
Good luck,
gpk
----
www.alexoria.co.uk
gpk
----
www.alexoria.co.uk