Looking for Customer Service & Support

IMPORTANT: This is a Community Forum. Answers are given by the community. If you are a Customer, please, Open New Issue to get access to the support service.

Customer Support is only provided through our ticketing system https://support.extly.com/. If you do not have a paid membership, please create a new topic in the community forum.

Error Code 1054 by clicking on "Channel"

More
2 years 2 months ago - 2 years 2 months ago #9675 by Fritz Ilg
Fritz Ilg created the topic: Error Code 1054 by clicking on "Channel"
After successful installing AutoTweetNG, I get the error message "1054 Unknown column 'scope' in 'where clause' SQL=SELECT * FROM `dbcl2_autotweet_channels` WHERE `published` = '1' AND `scope` = 'S' ORDER BY id ASC LIMIT 0, 100 by clicking on "Channel" in the Control Panel

Solution?

Joomla Version: 3.4.4
AutoTweetNG Version: 8.1.0

Thank you!
Last Edit: 2 years 2 months ago by Fritz Ilg.

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #9681 by Support Team
Support Team replied the topic: Error Code 1054 by clicking on "Channel"
Hi,

We have just answered your ticket #4283.

In some way, Joomla failed to execute a query to add the column. To add it, please, execute this query in your database:
ALTER TABLE `#__autotweet_channels` ADD `scope` VARCHAR(1) NOT NULL DEFAULT 'S' AFTER `channeltype_id`;

NOTE: remember to replace #_ with your db prefix.

Regards,

Please Log in or Create an account to join the conversation.

Time to create page: 0.109 seconds
Join the Club!

Access and support services to all Extly's extensions for 1-Year. The Extly Club is your source for all of our extensions.

Join Now