Getting Invalid SQL: Select * FROM 'swusers' error when viewing users

internut33

Hi all,

I'm out of the blue getting this error message when viewing users:

Wondering if something is corrupted in my DB possibly?

Today I also got that my CPU usage has spiked (this has not happened every in 10 years).

Wondering if they're related.

Any thoughts?

Error:

Invalid SQL: SELECT * FROM `swusers` AS users LEFT JOIN `swusergroups` AS usergroups ON (users.usergroupid = usergroups.usergroupid) LEFT JOIN `swuseremails` AS useremails ON (users.userid = useremails.userid) ORDER BY usergroups.title ASC LIMIT 0, 100;; (Got error 12 from table handler)

craigbrass · 11-03-2008, 03:44 PM

Try repairing the table swusers using the tool inside the administration area.

internut33 · 11-03-2008, 04:01 PM

Actually did this using PHP MyAdmin - just did it as well from the admin area.

Still showing the error.

craigbrass · 11-03-2008, 06:19 PM

Have you recently tried to upgrade?

internut33 · 11-03-2008, 06:56 PM

Nope - not in a while now. It was working some time ago. I just noticed it recently when going to view users / search.

Search works fine - does not display list off the start tho.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Invalid SQL: INSERT INTO `swauditlogs` ERROR	kevintufts	SupportSuite, eSupport and LiveResponse	5	24-01-2008 08:30 AM
Users Can Not Login - Invalid User Name and Password	zippohosting	SupportSuite, eSupport and LiveResponse	13	14-01-2008 10:48 AM
Invalid SQL: SELECT * FROM swticketpostlocks	Mark Worsnop	LiveResponse Desktop Application	7	27-01-2007 08:03 PM
Invalid SQL: INSERT INTO Error	fasttrak	SupportSuite, eSupport and LiveResponse	0	05-02-2006 03:24 PM

craigbrass Offline Senior Member Posts: 5,390 Join Date: Jun 2005 Location: Cumbria, UK	11-03-2008, 03:44 PM Try repairing the table swusers using the tool inside the administration area. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

internut33 Offline Member Posts: 231 Join Date: Apr 2004	11-03-2008, 04:01 PM Actually did this using PHP MyAdmin - just did it as well from the admin area. Still showing the error. -------------------------------------------- Love me an eSupport --------------------------------------------

craigbrass Offline Senior Member Posts: 5,390 Join Date: Jun 2005 Location: Cumbria, UK	11-03-2008, 06:19 PM Have you recently tried to upgrade? Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

internut33 Offline Member Posts: 231 Join Date: Apr 2004	11-03-2008, 06:56 PM Nope - not in a while now. It was working some time ago. I just noticed it recently when going to view users / search. Search works fine - does not display list off the start tho. -------------------------------------------- Love me an eSupport --------------------------------------------