|
|
| View previous topic :: View next topic |
| Author |
Message |
doncharlie
Joined: 01 Jan 1970
Posts: 2
 |
Posted: Sun Apr 01, 2007 5:41 am
Post subject: pretty nasty error with meta tag generator
|
 |
|
DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c, jos_categories AS cc, jos_sections AS s LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid = cc.id AND cc.section = s.id AND s.scope = 'content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0, 30
Keyword Tool by ijoomla.com
any ideas? |
|
| Back to top |
|
|
gsm
Joined: 01 Jan 1970
Posts: 2
|
Posted: Sun Jun 03, 2007 2:03 am
Post subject:
|
|
|
| I think they changed the database a little for Joomla 1.012 and I think this module does not work. They should probably take it down for download, but hey it is a free component. |
|
| Back to top |
|
|
buzzworkers
Joined: 01 Jan 1970
Posts: 1
|
Posted: Thu Jun 14, 2007 12:45 am
Post subject: Any idea about this ?
|
|
|
I'm running Joomla! 1.0.12 Stable, PHP: 5.2.2
MySQL: 5.0.27 - when installing metatag generator, everything seem to work fine
even going the settings works normal, the message i have when saving is good (it saved)
then wen i go /index2.php?option=com_metataggenerator to insert the metakeys and metadesc i get the following :
| Code: | DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c, jos_categories AS cc, jos_sections AS s LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid = cc.id AND cc.section = s.id AND s.scope = 'content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0, 50 |
witch make the component un-usable, anyone have any tips and tricks to overcome this problem would be much appreciated, Thanks in advance ! |
|
| Back to top |
|
|
Coach
Joined: 01 Jan 1970
Posts: 1
|
Posted: Thu Jun 21, 2007 8:38 am
Post subject: Problem still exists, any solution?
|
|
|
IJoomla: Any news yet about this bug, it's driving me crazy! It was such a nice tool, and there's no way of using it anymore.
Joomla 1.0.12, PHP 5.2.3, mySQL 5.0.41-log |
|
| Back to top |
|
|
andrew2u
Joined: 01 Jan 1970
Posts: 2
|
|
| Back to top |
|
|
|
|
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 vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
|
|
|
Shopping Cart
|
FAQ
Search
Register
Log in
