Issue With Seo Links, Joomla 1.7 And Php 5.3 [solved] Options

[dlb]

Errors

JDatabaseMySQL::query: 1054 - Unknown column 'w.typeid' in 'on clause' SQL=SELECT w.*, cc.title AS category, cc.published AS cat_pub, cc.access AS cat_access FROM j17_seolinks AS w LEFT JOIN j17_categories AS cc ON cc.id = w.typeid WHERE w.id = 0
Information


Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /var/www/vhosts/plantdex.com/httpdocs/administrator/index.php:47
2 JComponentHelper::renderComponent() /var/www/vhosts/plantdex.com/httpdocs/administrator/includes/application.php:153
3 require_once() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/application/component/helper.php:156
4 JController->execute() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/seolinks.php:16
5 SeolinksController->display() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/application/component/controller.php:679
6 JController->display() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/controller.php:78
7 SeolinksViewSeolink->display() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/application/component/controller.php:645
8 SeolinksViewSeolink->_displayForm() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/views/seolink/view.html.php:22
9 JView->get() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/views/seolink/view.html.php:48
10 SeolinksModelSeolink->getData() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/application/component/view.php:348
11 SeolinksModelSeolink->_loadData() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/models/seolink.php:38
12 JDatabase->loadObject() /var/www/vhosts/plantdex.com/httpdocs/administrator/components/com_seolinks/models/seolink.php:239
13 JDatabaseMySQL->query() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/database/database.php:937
14 JError::raiseError() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/database/database/mysql.php:512
15 JError::raise() /var/www/vhosts/plantdex.com/httpdocs/libraries/joomla/error/error.php:215

Profile Information
Application 0.008 seconds (+0.008); 1.06 MB (+1.062) - afterLoad
Application 0.179 seconds (+0.171); 7.15 MB (+6.085) - afterInitialise
Application 0.198 seconds (+0.019); 7.56 MB (+0.411) - afterRoute
Memory Usage
8.8 MB (9,226,064 Bytes)
13 Queries Logged

SELECT `data`
FROM `j17_session`
WHERE `session_id` = 'trj9kj6evjrm5f1pbkobmh3hq4'
SELECT extension_id AS "id", element AS "option", params, enabled
FROM j17_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM j17_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SHOW FULL COLUMNS
FROM `j17_users`
SELECT *
FROM j17_users
WHERE id = 62
SELECT g.id, g.title
FROM j17_usergroups AS g JOIN j17_user_usergroup_map AS m
ON m.group_id = g.id
WHERE m.user_id = 62
SELECT id, home, template, params
FROM j17_template_styles
WHERE client_id = 1
SELECT template, s.params
FROM j17_template_styles as s
LEFT JOIN j17_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
INSERT INTO `j17_rokadminaudit` (`user_id`,`ip`,`session_id`,`option`,`task`,`page`,`referrer`,`title`)
VALUES ('62','216.80.20.135','trj9kj6evjrm5f1pbkobmh3hq4','com_seolinks','add','/administrator/index.php','http:// www.plantdex.com /administrator/index.php?option=com_seolinks','')
SELECT template
FROM j17_template_styles
WHERE id=0
SELECT extension_id AS "id", element AS "option", params, enabled
FROM j17_extensions
WHERE `type` = 'component'
AND `element` = 'com_seolinks'
SELECT w.*, cc.title AS category, cc.published AS cat_pub, cc.access AS cat_access
FROM j17_seolinks AS w
LEFT JOIN j17_categories AS cc
ON cc.id = w.typeid
WHERE w.id = 0
UPDATE `j17_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1315871606;s:18:\"session.timer.last\";i:1315871648;s:17:\"session.timer.now\";i:1315871656;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2010-12-03 21:51:12\";s:13:\"lastvisitDate\";s:19:\"2011-09-12 23:35:13\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:18:\"{\"timezone\":\"UTC\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:8:\"timezone\";s:3:\"UTC\";s:16:\"mc_default_style\";N;s:11:\"admin_style\";N;}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a798494d9ba86feb4aa79e7d4ce91bc3\";}', `time` = 1315871656
WHERE `session_id` = 'trj9kj6evjrm5f1pbkobmh3hq4'

12 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM j17_extensions
1 × SELECT template, s.params FROM j17_template_styles as s LEFT JOIN j17_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT template FROM j17_template_styles
1 × SELECT w.*, cc.title AS category, cc.published AS cat_pub, cc.access AS cat_access FROM j17_seolinks AS w LEFT JOIN j17_categories AS cc ON cc.id = w.typeid
1 × SELECT id, home, template, params FROM j17_template_styles
1 × SELECT g.id, g.title FROM j17_usergroups AS g JOIN j17_user_usergroup_map AS m ON m.group_id = g.id
1 × SELECT folder AS type, element AS name, params FROM j17_extensions
1 × SELECT * FROM j17_users
1 × SELECT `data` FROM `j17_session`

OTHER Tables:

1 × UPDATE `j17_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1315871606;s:18:\"session.timer.last\";i:1315871648;s:17:\"session.timer.now\";i:1315871656;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2010-12-03 21:51:12\";s:13:\"lastvisitDate\";s:19:\"2011-09-12 23:35:13\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:18:\"{\"timezone\":\"UTC\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:8:\"timezone\";s:3:\"UTC\";s:16:\"mc_default_style\";N;s:11:\"admin_style\";N;}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a798494d9ba86feb4aa79e7d4ce91bc3\";}', `time` = 1315871656
1 × INSERT INTO `j17_rokadminaudit` (`user_id`,`ip`,`session_id`,`option`,`task`,`page`,`referrer`,`title`) VALUES ('62','216.80.20.135','trj9kj6evjrm5f1pbkobmh3hq4','com_seolinks','add','/administrator/index.php','http://www.plantdex.com/administrator/index.php?option=com_seolinks',''
1 × SHOW FULL COLUMNS FROM `j17_users

[Web Design Seo]

dlb, Is this with free version of Seo links or is Seo Links Pro?

[dlb]

dlb, Is this with free version of Seo links or is Seo Links Pro?

Pro

[Web Design Seo]

Please, check Your version. We need exact version (like 1.5.2 for example). You can see version at page

Код

administrator/index.php?option=com_installer

-> click on Components

Than read this and give here more details about version of joomla, server and host.

[Web Design Seo]

Try to uninstall extension, than delete extension tables in database and install Seo links again.

[dlb]

I uninstalled and manually removed the tables, and reinstalled. Same issue.

The version of seolinks is:

1.6.1 Pro

and content/k2 are both 1.5

My full Joomla info:
PHP Built On Linux
Database Version 5.1.58
Database Collation utf8_general_ci
PHP Version 5.3.6
Web Server Apache/2.2.3 (CentOS)
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 1.7.0 Stable [ Ember ] 19-Jul-2011 14:00 GMT
Joomla! Platform Version Joomla Platform 11.1 Stable+Modified [ Ember ] 01-Jun-2011 06:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2

This post has been edited by dlb: Sep 13 2011, 04:13 PM

[Web Design Seo]

The only way to see and resolve Your problem is this way.

If possible, create one temporary admin account for us to see problem in your site and send login data to our email or send us PM with login from here.

Edit: issue is solved - next version 1.6.2 and over fix this bug

Reason for edit: release of 1.6.2