Support Forums

Old 01-05-2008, 04:29 PM   #1
Senior Member
 
Join Date: Aug 2006
Posts: 129
Rep Power: 15
spaceboy is on a distinguished road
Default Ad Review Mod problem - please help!

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!
__________________
Lindsay

developer v3.1.5 and v4
abletrader.com
spaceboy is offline   Reply With Quote
Old 01-05-2008, 04:41 PM   #2
Coder
 
Join Date: Mar 2006
Posts: 4,568
Rep Power: 111
Lhotch is just really niceLhotch is just really nice
Default

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?
__________________
Larry.
Lhotch is offline   Reply With Quote
Old 01-05-2008, 11:32 PM   #3
Senior Member
 
Join Date: Aug 2006
Posts: 129
Rep Power: 15
spaceboy is on a distinguished road
Default

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"
__________________
Lindsay

developer v3.1.5 and v4
abletrader.com
spaceboy is offline   Reply With Quote

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Page Problem. URGENT!!! Pierce v3.1 Questions & Support 2 10-02-2007 02:12 PM
Host or Script problem? Grebogreen v3.1 Questions & Support 3 05-08-2007 09:49 AM
Admin icons problem Sinisa v3.1 Questions & Support 4 01-18-2007 10:54 AM
3.1.5b admin login problem Sinisa v3.1 Questions & Support 14 01-07-2007 10:15 AM
File Upload Feature Problem sporthorsebreeder v3.1 Questions & Support 9 07-27-2006 09:34 AM


All times are GMT -4. The time now is 12:57 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0