Ad Review Mod problem - please help!

[spaceboy]

I just set up a new site and after I added the listing review module I keep getting this error code after the review is submitted in the pop-up window:


Notice: Query failed: Table 'loflin5_beta4.class_rating_settings' doesn't exist SQL: SELECT id, name, value FROM class_rating_settings in /home/loflin5/public_html/beta4/includes/classes/database/mysql.php on line 135

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' added=NOW(), person='spaceboy', review='blah', score=6, email='lindsayloflin@ho' at line 1 SQL: INSERT INTO class_rating SET , added=NOW(), person='spaceboy', review='blah', score=6, email='[email protected]',approved="Y" in /home/loflin5/public_html/beta4/includes/classes/database/mysql.php on line 135

I'm running v3.1.1

Here's a link

Any help would be greatly appreciated!

[Lhotch]

Im not familiar with that module but the error seems to indicate the database to hold the ratings doesnt exist. Did you carefully follow the installation instructions that came with the module?

[spaceboy]

thx Larry. The only instructions in the readme file say to add this code:

For listing rating add the following code in your viewlistings.tpl.php file
{assign var="rating" value=$smarty.const.FILESYSTEM_PATH}
{include file="$rating/modules/member_rating/templates/listing_rating.tpl.php"}

...There is nothing about creating a new database. my database is called "loflin5_beta4"