Support Forums

f16eater · 05-02-2006, 10:00 PM

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='f16eater', review='', score=10, email='on SQL: INSERT INTO class_rating SET , added=NOW(), person='f16eater', review='', score=10, email='[email protected]' in /home/myzine2/public_html/asianfreeads/includes/classes/database/mysql.php on line 119

Hi there, i recieved an error when trying to put a review on myself on my test website. Please advise!

Thanks.

**Eric Barnes** · 05-03-2006, 12:15 PM

Did you get this error when adding a rating for a listing or a user?

f16eater · 05-03-2006, 09:16 PM

For a user.. you mean you can review an ad too??

**Eric Barnes** · 05-03-2006, 09:53 PM

Yes the module in v3.1 will allow you to review a member or a listing. It just depends on how you set it up.

f16eater · 05-03-2006, 11:11 PM

Ok.. .i paste the instructed html stuff into viewlisting.tpl.php... that was the error i got. my url

http://www.asianfreeads.com/

Maybe you can tell me whats wrong.

Thanks a million!

f16eater · 05-04-2006, 02:04 AM

Ah don't bother.. i think i might just know what is wrong. thanks!

Chaslie · 05-04-2006, 04:40 AM

f16eater,
Consider leaving your solution here. It may well help someone else.

f16eater · 05-04-2006, 11:12 AM

Well, user review codes can't be added to viewlisting.tpl.php.... it can only be added to the page that views the user profile...

**Eric Barnes** · 05-04-2006, 11:16 AM

What version are you running?

f16eater · 05-05-2006, 01:09 PM

3.1 dude.. only bought it recently

05-02-2006, 10:00 PM	#1
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	User review mod bug 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='f16eater', review='', score=10, email='on SQL: INSERT INTO class_rating SET , added=NOW(), person='f16eater', review='', score=10, email='[email protected]' in /home/myzine2/public_html/asianfreeads/includes/classes/database/mysql.php on line 119 Hi there, i recieved an error when trying to put a review on myself on my test website. Please advise! Thanks.

05-03-2006, 12:15 PM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,293 Rep Power: 124	Did you get this error when adding a rating for a listing or a user? __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

05-03-2006, 09:53 PM	#4
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,293 Rep Power: 124	Yes the module in v3.1 will allow you to review a member or a listing. It just depends on how you set it up. __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

05-04-2006, 04:40 AM	#7
Chaslie Moderator Join Date: Mar 2006 Location: Great Ocean Road - Australia Posts: 685 Rep Power: 29	f16eater, Consider leaving your solution here. It may well help someone else. __________________ Chaslie V4.1 dev 68 Classifieds Important Links Customer Area \| Issue Tracker \| User Manuals & Documentation HTML Help W3 Schools

05-04-2006, 11:16 AM	#9
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,293 Rep Power: 124	What version are you running? __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

05-03-2006, 09:16 PM	#3
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	For a user.. you mean you can review an ad too??

05-03-2006, 11:11 PM	#5
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	Ok.. .i paste the instructed html stuff into viewlisting.tpl.php... that was the error i got. my url http://www.asianfreeads.com/ Maybe you can tell me whats wrong. Thanks a million!

05-04-2006, 02:04 AM	#6
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	Ah don't bother.. i think i might just know what is wrong. thanks!

05-04-2006, 11:12 AM	#8
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	Well, user review codes can't be added to viewlisting.tpl.php.... it can only be added to the page that views the user profile...

05-05-2006, 01:09 PM	#10
f16eater Member Join Date: Apr 2006 Posts: 31 Rep Power: 16	3.1 dude.. only bought it recently

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SMF User Sharing?	Chad	Pre Sales Questions	4	02-07-2007 06:37 PM
User: See's Membership listing package	garysr	v3.1 Questions & Support	23	11-04-2006 02:08 PM
banned user - still able to place an ad	dawyatt	v3.1 Questions & Support	2	09-21-2006 09:43 AM
Direct link to user listing in contact email	SkGold	v3.1 Questions & Support	2	07-10-2006 03:42 PM

Support Forums

User review mod bug