Archived > Click on ad gives sql error

I have it installed, set to my account, and it looks great. All the ads display as they should. However, if I click on an ad, it gives a sql error
www.4estgimp.com

Any ideas on how to fix this?

Thanks

edit** in the admin section, "add/remove", "report featured" and "report *NOT* featured" also give an error:

On /admin.php?op=amazon1
While executing query ""

the following error occured:

Never seen that before - something wacky in your db setup - what is the db error reported when a user tries to access.

The errors in my email today are:

On /index.php?name=Amazon&asin=B0001FGBUC While executing query "" the following error occured: Guest information: User id: Username: IP: 65.54.xxx.xxx Admin: No

and

On /index.php?name=Amazon While executing query "" the following error occured: Guest information: User id: Username: IP: 202.138.xxx.xxx Admin: No

and

On /index.php While executing query "" the following error occured: Guest information: User id: Username: IP: 202.138.xxx.xxx Admin: No

From what I can see, the error is arising in the Amazon1 block every time any amazon function is evoked. Could you disable that block and then see if the module and other blocks function correctly?

Did you fresh install all components of the 2.6.5cpg2a version or modify a previous version?

YES! You are a genious, or at least close enough I disbled block 1 and that fixed the problem.

I DID have the old module version installed but I thought I had uninstalled it. Perhaps I didn't uninstall it or maybe I didn't do so correctly. Would you have a suggestion on how to fix module one? Do I need to do some sort of uninstall/reinstall? I already did one uninstall/reinstall of the Nuke Amazon FILES from my server but I didn't delete the TABLES. Should I delete all tables that reference "amazon" and then renstall the module?

Thanks again Phoenix,

4est[/b]

Hopefully this reply will come from the new location at nukebiz.com.

If you delete the tables and then do a clean install in cpgnuke 8.2a, you will find that the auto-install function will fucntion and you just click 'INSTALL' when you go to Admin->Modules.