Support Forums

Katash · 12-29-2009, 06:38 AM

What version of 68 Classifieds are you running?
V4.1.6 Designer

What template are you using?
Any

Please describe in detail the issue you are having:

After an upgrade from v3.1.10 I get this error under Featured Listings section of the main page

Code:

Notice: Query failed: Unknown column 'id' in 'field list' SQL: SELECT id,title,price FROM class_products WHERE display = 'Y' AND expiration > NOW() AND featured = 'Y' ORDER BY rand() LIMIT 8 in /homepages/30/d217246015/htdocs/includes/classes/database/mysql.php on line 143

Have checked phpmyadmin and found the table class_products and all the column names appear to be prefixed with 'p'

Capture.JPG

Everything else appears to work ok bar this

Any ideas?

**Eric Barnes** · 12-29-2009, 12:13 PM

Try this. Delete everything from includes/classes/smarty/plugins/ folder and then reupload that folder from a stock download.

Then it should work.

Katash · 12-29-2009, 12:16 PM

Yes, this appears to have fixed it - Thanks once again.

12-29-2009, 06:38 AM	#1
Katash Member Join Date: Sep 2007 Posts: 31 Rep Power: 10	SQL Error In Featured Listings What version of 68 Classifieds are you running? V4.1.6 Designer What template are you using? Any Please describe in detail the issue you are having: After an upgrade from v3.1.10 I get this error under Featured Listings section of the main page Code: Notice: Query failed: Unknown column 'id' in 'field list' SQL: SELECT id,title,price FROM class_products WHERE display = 'Y' AND expiration > NOW() AND featured = 'Y' ORDER BY rand() LIMIT 8 in /homepages/30/d217246015/htdocs/includes/classes/database/mysql.php on line 143 Have checked phpmyadmin and found the table class_products and all the column names appear to be prefixed with 'p' Capture.JPG Everything else appears to work ok bar this Any ideas? Last edited by Katash; 12-29-2009 at 08:58 AM.

12-29-2009, 12:13 PM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,294 Rep Power: 124	Try this. Delete everything from includes/classes/smarty/plugins/ folder and then reupload that folder from a stock download. Then it should work. __________________ 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RSS of Featured Listings	akilar	Technical Support	1	10-26-2009 10:02 AM
Featured Listings	skekum	Technical Support	4	05-29-2009 10:08 AM
Featured Listings	tdisraeli	Technical Support	19	09-17-2008 11:16 AM
Featured Listings (again)	tdisraeli	Technical Support	3	09-16-2008 09:27 PM
Featured Listings	kama	Templates, HTML, CSS, and Design Help	1	05-22-2008 04:36 AM

12-29-2009, 12:16 PM	#3
Katash Member Join Date: Sep 2007 Posts: 31 Rep Power: 10	Yes, this appears to have fixed it - Thanks once again.

Support Forums

SQL Error In Featured Listings

This topic is resolved.