Support Forums

PimMC · 10-13-2009, 06:04 PM

Hello,

When somebody post a new listing on my webpage, they get an error on checkout page:

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 'WHERE id=4' at line 1 SQL: UPDATE class_users SET WHERE id=4 in /usr/home/deb23894/domains/2eeigenaar.nl/public_html/includes/classes/database/mysql.php on line 134

Can somebody help me please??

Lhotch · 10-13-2009, 09:57 PM

some more info would be nice.

http://www.68classifieds.com/forums/...-me-first.html

PimMC · 10-14-2009, 02:10 AM

On the last checkout page you see the listing which post on de website.
On top of the page the error shows.

So if you place a free listing (no payment) and click on "OK", you go to the last checkout page and see the error on top of the page

Lhotch · 10-14-2009, 09:11 AM

http://www.68classifieds.com/forums/...-me-first.html

**Eric Barnes** · 10-14-2009, 10:38 AM

I would recommend upgrading to the latest release if you are not already on it.

PimMC · 10-14-2009, 02:48 PM

Ok guys,
I found the problem.

When I put some 'badwords' in the script. And give a 'replace-word' like : Hello = H*llo
Then the last checkout page shows the Query Error

I dropped my badwords-table and the error is gone!

10-13-2009, 06:04 PM	#1
PimMC Junior Member Join Date: Sep 2009 Location: Netherlands Posts: 19 Rep Power: 2	Checkout ERROR ::Query failed Hello, When somebody post a new listing on my webpage, they get an error on checkout page: 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 'WHERE id=4' at line 1 SQL: UPDATE class_users SET WHERE id=4 in /usr/home/deb23894/domains/2eeigenaar.nl/public_html/includes/classes/database/mysql.php on line 134 Can somebody help me please??

10-13-2009, 09:57 PM	#2
Lhotch Coder Join Date: Mar 2006 Posts: 4,915 Rep Power: 120	some more info would be nice. http://www.68classifieds.com/forums/...-me-first.html __________________ Larry Knowledge *learned* is more valuable than knowledge *given*.

10-14-2009, 09:11 AM	#4
Lhotch Coder Join Date: Mar 2006 Posts: 4,915 Rep Power: 120	http://www.68classifieds.com/forums/...-me-first.html __________________ Larry Knowledge *learned* is more valuable than knowledge *given*.

10-14-2009, 10:38 AM	#5
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,303 Rep Power: 125	I would recommend upgrading to the latest release if you are not already on it. __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

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

10-14-2009, 02:10 AM	#3
PimMC Junior Member Join Date: Sep 2009 Location: Netherlands Posts: 19 Rep Power: 2	On the last checkout page you see the listing which post on de website. On top of the page the error shows. So if you place a free listing (no payment) and click on "OK", you go to the last checkout page and see the error on top of the page

10-14-2009, 02:48 PM	#6
PimMC Junior Member Join Date: Sep 2009 Location: Netherlands Posts: 19 Rep Power: 2	Ok guys, I found the problem. When I put some 'badwords' in the script. And give a 'replace-word' like : Hello = H*llo Then the last checkout page shows the Query Error I dropped my badwords-table and the error is gone!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
failed transfers	redstar	Technical Support	3	09-23-2008 06:14 PM
query failed notice	early	v3.1 Questions & Support	3	03-05-2008 01:24 PM
Query	Unregistered	Pre Sales Questions	1	09-11-2006 02:00 PM
Upgrade failed	whithaydn	v3.1 Questions & Support	1	08-28-2006 09:33 AM

Support Forums

Checkout ERROR ::Query failed

This topic is resolved.