Slight Sql database error

Newbie Joined: Jun 13, 2006 Posts: 40

well im not sure if this is a major problem

I removed my reviews module and sql tables as i dont use the reviews module at all nor do i intend to.

My problem occured when i went to preview a test newsletter. (it also wouldnt send in a later test because of the same issue)
i got this error

Code:

ENCOUNTERED ERROR IN SQL: Table 'ped_ped.nuke_reviews' doesn't exist

SQL = SELECT * FROM `nuke_reviews`

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: Unable to retrieve Statistics for number of reviews

just thought idd let you know.

i had to dig out the original sql tables and reinstall them and its working again now.
Very Happy

Site Admin Joined: Jul 18, 2005 Posts: 387

Thanks for that.
Yeah I guess as the newsletter is trying to retrieve data from the reviews module, if those tables are missing it would get a little confused to say the least.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

Never had anyone delete core nuke tables before! Laughing

Here is the question: should site statistics be made to only provide statistics for those that have check marks in the "Include Latest Items"?

Second question: should site statistics have its own set of checkboxes as to which statistics should be shown?

Newbie Joined: Jun 13, 2006 Posts: 40

Not trying to cause you more work , but i think that option would be great.

as well as the option to add digital goods stats too !! lol joke Laughing

yeah i think thats a great idea giving the admin an option is always better !

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

Now just to find the time... Crying or Very sad