The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 13 posts ] 
Author Message
PostPosted: Fri Dec 16, 2005 12:49 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Nov 08, 2005 3:15 pm
Posts: 46
Location: UK
Can anyone help with this?...

I noticed that there was nothing listed in the 'Latest Events' module on my site so I went to take a look at the list of events in the admin panel and got this:

'DB function failed with error number 1054
Unknown column 'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname FROM jos_events AS a, jos_categories AS cc LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access WHERE a.catid=cc.id ORDER BY a.catid LIMIT 0,30'

I don't know what to do next???


Top
 Profile  
 
PostPosted: Fri Dec 16, 2005 9:22 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Thu Aug 18, 2005 4:10 pm
Posts: 644
Location: Canada
velocity wrote:
Can anyone help with this?...

I noticed that there was nothing listed in the 'Latest Events' module on my site so I went to take a look at the list of events in the admin panel and got this:

'DB function failed with error number 1054
Unknown column 'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname FROM jos_events AS a, jos_categories AS cc LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access WHERE a.catid=cc.id ORDER BY a.catid LIMIT 0,30'

I don't know what to do next???


Have you gone to the Forums for the Component in question? Which "events" component are you using?

Les


Top
 Profile  
 
PostPosted: Mon Dec 19, 2005 11:18 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Nov 08, 2005 3:15 pm
Posts: 46
Location: UK
It the 'Events Calendar' component from Mamboforge:

http://mamboforge.net/projects/events/

...and no I haven't posted on their forum as they tend to be less active than this one.


Top
 Profile  
 
PostPosted: Mon Dec 19, 2005 12:15 pm 
Joomla! Intern
Joomla! Intern
Offline

Joined: Tue Nov 08, 2005 7:08 pm
Posts: 92
Looks like there might be differences between the column name in the calendar script and the actual column in the db.
If you have some sort of mysql-admin interface you can search the tables and see if there is such a difference.

_________________
http://www.screenpartner.no
http://www.doitright.no


Top
 Profile  
 
PostPosted: Mon Dec 19, 2005 12:37 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Nov 08, 2005 3:15 pm
Posts: 46
Location: UK
The error message is mostly jargon to me but am I correct in thinking that it's looking for a column titled 'a.checked_out' in the table 'jos_events'?  In which case it doesn't exist, but 'checked_out' column does.


Top
 Profile  
 
PostPosted: Mon Dec 19, 2005 12:42 pm 
Joomla! Intern
Joomla! Intern
Offline

Joined: Tue Nov 08, 2005 7:08 pm
Posts: 92
Back up the file and try removing the "a" from the events script. See what breaks ;-)

_________________
http://www.screenpartner.no
http://www.doitright.no


Top
 Profile  
 
PostPosted: Mon Dec 19, 2005 2:23 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Nov 08, 2005 3:15 pm
Posts: 46
Location: UK
Progress so far...

I've edited admin.events.main.php at the following point:

Code:
$database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname"
      . "\nFROM #__events AS a, #__categories AS cc"
      . "\nLEFT JOIN #__users AS u ON u.id = a.checked_out"
      . "\nLEFT JOIN #__groups AS g ON g.id = a.access"
      . (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
      . "\nORDER BY a.catid"
      //. "\nAND a.state ASC"
      . "\nLIMIT $limitstart,$limit"
   );


Obviously changing a.checked_out for checked_out and a.access for access.

The result is that I can now access the list of events in admin backend (& not receive an error), BUT the 'Latest Events' module is still displaying nothing in the frontend.

Strangely, this component & module were previously working fine.  I *think* the problems coincided with an installation of 'Community Builder'.


Top
 Profile  
 
PostPosted: Tue Dec 27, 2005 2:56 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Dec 23, 2005 3:40 pm
Posts: 5
I am having trouble with the same error.

Funny thing is that on my local machine everythings runs just fine
- Same Joomla version, installed using the same files
- Same events component, installed using the same files

It appears to be a MySQL syntax problem or something. If I change the configuration to a test database on a MySQL v4.1.14 database server, all is fine. The production database is on MySQL 5.0.15 server and produces this error. Trying to work it out, but no luck so far...


Last edited by arvidi on Tue Dec 27, 2005 3:35 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Fri Jan 20, 2006 10:42 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Jan 20, 2006 1:41 am
Posts: 8
velocity wrote:
Progress so far...

I've edited admin.events.main.php at the following point:

Code:
$database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname"
      . "\nFROM #__events AS a, #__categories AS cc"
      . "\nLEFT JOIN #__users AS u ON u.id = a.checked_out"
      . "\nLEFT JOIN #__groups AS g ON g.id = a.access"
      . (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
      . "\nORDER BY a.catid"
      //. "\nAND a.state ASC"
      . "\nLIMIT $limitstart,$limit"
   );


Obviously changing a.checked_out for checked_out and a.access for access.

The result is that I can now access the list of events in admin backend (& not receive an error), BUT the 'Latest Events' module is still displaying nothing in the frontend.

Strangely, this component & module were previously working fine.  I *think* the problems coincided with an installation of 'Community Builder'.


Am I looking in the wrong place for this file? I've been hunting in my com_events folder on my server, but there isn't any admin.events.main.php file or much other than the general PHP file and 2 or three others. Should I be looking elsewhere?

Thanks!

-Stead Halstead


Top
 Profile  
 
PostPosted: Sat Jan 21, 2006 3:54 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Dec 23, 2005 3:40 pm
Posts: 5
steadhouse wrote:

Am I looking in the wrong place for this file? I've been hunting in my com_events folder on my server, but there isn't any admin.events.main.php file or much other than the general PHP file and 2 or three others. Should I be looking elsewhere?

Thanks!

-Stead Halstead


You're probably in the wrong place yes. Check this folder :

\administrator\components\com_events


Top
 Profile  
 
PostPosted: Thu Jun 22, 2006 2:51 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu Jun 22, 2006 2:49 pm
Posts: 1
velocity wrote:
Can anyone help with this?...

I noticed that there was nothing listed in the 'Latest Events' module on my site so I went to take a look at the list of events in the admin panel and got this:

'DB function failed with error number 1054
Unknown column 'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname FROM jos_events AS a, jos_categories AS cc LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access WHERE a.catid=cc.id ORDER BY a.catid LIMIT 0,30'

I don't know what to do next???


Actually the fix is very small. Just brackets around the from clause in admin.events.main.php line 227 (in version 1.11 that is):
. "\nFROM (#__events AS a, #__categories AS cc)"

cheers


Top
 Profile  
 
PostPosted: Sat May 05, 2007 4:34 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Dec 19, 2005 7:13 pm
Posts: 2
That simple fix worked fine for me!  Thanks!


Top
 Profile  
 
PostPosted: Sun Jul 29, 2007 9:11 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon May 22, 2006 10:16 pm
Posts: 16
fix works for me also

super !!!!!!

thanx


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 



Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group