Support Forums
04-30-2008, 06:34 AM
|
#1 |
|
Member
Join Date: Apr 2006
Posts: 39
Rep Power: 14  |
Site running weird SQL error.
I get the below error on my site http://www.findbandmates.com/us/index.php:
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 't matter what skill level.' AND owner='174'' at line 1 SQL: UPDATE class_products SET notified='Y' WHERE title='Need a drummer. Don't matter what skill level.' AND owner='174' in /home/findband/public_html/us/includes/MySQL.php on line 120 Has anyone expereienced anything like it? Could I please have a hand in fixing it? Many thanks. |
|
|
|
04-30-2008, 08:21 AM
|
#2 |
|
Coder
Join Date: Mar 2006
Posts: 4,564
Rep Power: 111 |
Whats happened is there is a field that isnt getting its punctuaion properly sanitized and its breaking the sql query.
If you have access to phpmyadmin, go in and look at the products table and edit the offending record and take out the apostrophe in the word "Don't" in the title. Should have an ownerid of 174 and the title is... 'Need a drummer. Don't matter what skill level. |
|
|
|
|
04-30-2008, 08:22 AM
|
#3 |
|
68 Classifieds Staff
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,118
Rep Power: 118 |
Hi,
Yes I have seen this and it was a bug in the v3.1.x line. I would recommend upgrading to v3.1.10 and it should be fixed. I think this comes from the includes/cron.php file.
__________________
Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area | Issue Tracker | Documentation | 68C Mods | Submit a Ticket | 68 @ Twitter | My Modules |
|
|
|
|
05-12-2008, 06:10 AM
|
#4 |
|
Member
Join Date: Apr 2006
Posts: 39
Rep Power: 14 |
Thanks.
How do I upgrade to the latest version? |
|
|
|
|
05-12-2008, 08:58 AM
|
#5 |
|
Coder
Join Date: Mar 2006
Posts: 4,564
Rep Power: 111 |
Log into 68c website customer area and download the new new version. Then follow the upgrade instructions in the manual.
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Urgent error! Please help. Query failed: You have an error in your SQL syntax | gabs | v3.0 Questions & Support | 3 | 01-29-2008 03:18 AM |
| SQL error ' no default value' please help | paulsra | v3.1 Questions & Support | 10 | 11-21-2007 04:57 AM |
| Something weird happened to my site | Bucketman | v3.0 Questions & Support | 3 | 02-26-2007 03:23 PM |
| SQL Image Error | djm | v3.1 Questions & Support | 2 | 10-23-2006 06:39 PM |
| Membership, listing packages & SQL error | akm | v3.1 Questions & Support | 6 | 06-26-2006 09:12 AM |
