Support Forums

shaggy · 03-30-2009, 10:59 AM

I am running version 4.1.2, after new account creation and then upon first login I receive the following error:

Notice: Query failed: Table 'placefi1_placefi1.class_listingstats' doesn't exist SQL: SELECT title, lid, COUNT(*) AS total FROM class_listingstats LEFT JOIN class_listings AS l ON lid=l.id WHERE owner = 1 AND viewdate > '2009-02-28%' AND viewdate < '2009-03-30 23:59:59' GROUP BY lid ORDER BY total DESC LIMIT 10 in /home/placefi1/public_html/includes/classes/database/mysql.php on line 143

Any ideas?

***Eric Barnes*** · 03-30-2009, 11:07 AM

That appears to be a bug in a module. I think from the error it is from the listing stats module. Can you try deactivating it and see if it fixes it.

shaggy · 03-30-2009, 11:11 AM

Sure will try it now...

shaggy · 03-30-2009, 11:29 AM

I deactivated the listing stats module and re-logged in, the error was not there, it does appear to be a small bug.

03-30-2009, 10:59 AM	#1
shaggy Junior Member Join Date: Mar 2009 Posts: 16 Rep Power: 1	SQL Error Upon login I am running version 4.1.2, after new account creation and then upon first login I receive the following error: Notice: Query failed: Table 'placefi1_placefi1.class_listingstats' doesn't exist SQL: SELECT title, lid, COUNT(*) AS total FROM class_listingstats LEFT JOIN class_listings AS l ON lid=l.id WHERE owner = 1 AND viewdate > '2009-02-28%' AND viewdate < '2009-03-30 23:59:59' GROUP BY lid ORDER BY total DESC LIMIT 10 in /home/placefi1/public_html/includes/classes/database/mysql.php on line 143 Any ideas?

03-30-2009, 11:07 AM	#2
*Eric Barnes* 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 4,779 Rep Power: 110	That appears to be a bug in a module. I think from the error it is from the listing stats module. Can you try deactivating it and see if it fixes it. __________________ 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

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
Hash incorrect error when trying to login	ycc2006	v3.1 Questions & Support	7	02-05-2008 11:06 AM
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
Error on Login	barrysmith	v3.1 Questions & Support	4	08-15-2007 11:43 AM
Member Register with Database Error and then with same email error HELP	mplsuhome	v3.1 Questions & Support	1	06-23-2007 02:56 AM
Admin Login Error!	bzell99	v3.1 Questions & Support	2	11-21-2006 11:37 AM

03-30-2009, 11:11 AM	#3
shaggy Junior Member Join Date: Mar 2009 Posts: 16 Rep Power: 1	Sure will try it now...

03-30-2009, 11:29 AM	#4
shaggy Junior Member Join Date: Mar 2009 Posts: 16 Rep Power: 1	I deactivated the listing stats module and re-logged in, the error was not there, it does appear to be a small bug.