SQL Error
- Stephen Estrada
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
11 years 1 month ago #349
by Stephen Estrada
SQL Error was created by Stephen Estrada
After installing and setting up for an Export, I receieved this error:
Error
Unknown column 'a11.' in 'on clause' SQL=SELECT `i`.`title`,`i`.`fulltext`,`a2`.`title`,`i`.`alias`,`i`.`introtext`,`i`.`created`,`a6`.`email`,`i`.`access`,`i`.`language`,`i`.`state`,`a10`.`id`,`a11`.`user_id`,`i`.`images`,`i`.`urls`,`i`.`metakey`,`i`.`metadesc`,`i`.`hits`,`i`.`metadata`,`i`.`featured`,`i`.`id`,`i`.`asset_id` FROM e69ft_content AS i LEFT JOIN `e69ft_categories` AS a2 on `i`.`catid` = `a2`.`id` LEFT JOIN `e69ft_users` AS a6 on `i`.`created_by` = `a6`.`id` LEFT JOIN `e69ft_users` AS a10 on `i`.`modified` = `a10`.`id` LEFT JOIN `e69ft_user_profiles` AS a11 on `i`.`modified_by` = `a11`.`` GROUP BY `i`.`id` ORDER BY `i`.`id` asc
"
aqny suggestions
Error
Unknown column 'a11.' in 'on clause' SQL=SELECT `i`.`title`,`i`.`fulltext`,`a2`.`title`,`i`.`alias`,`i`.`introtext`,`i`.`created`,`a6`.`email`,`i`.`access`,`i`.`language`,`i`.`state`,`a10`.`id`,`a11`.`user_id`,`i`.`images`,`i`.`urls`,`i`.`metakey`,`i`.`metadesc`,`i`.`hits`,`i`.`metadata`,`i`.`featured`,`i`.`id`,`i`.`asset_id` FROM e69ft_content AS i LEFT JOIN `e69ft_categories` AS a2 on `i`.`catid` = `a2`.`id` LEFT JOIN `e69ft_users` AS a6 on `i`.`created_by` = `a6`.`id` LEFT JOIN `e69ft_users` AS a10 on `i`.`modified` = `a10`.`id` LEFT JOIN `e69ft_user_profiles` AS a11 on `i`.`modified_by` = `a11`.`` GROUP BY `i`.`id` ORDER BY `i`.`id` asc
"
aqny suggestions
Please Log in to join the conversation.
- Stephen Estrada
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
11 years 1 month ago #350
by Stephen Estrada
Replied by Stephen Estrada on topic SQL Error
Ugh, User error.... I love the Extension!
Please Log in to join the conversation.