×

info

Dear guests,
You are currently on the old forum we kept as a knowledge base. You will find the new community forum here
Welcome, Guest
Username: Password: Remember me
Keyword
Please report any bugs or errors here.

TOPIC: Error 1054

Error 1054 6 years 5 months ago #67483

  • Anonymous user
  • ilayfd's Avatar
  • Posts: 5
  • Karma: 0
Hello! An error occured, when I try open the "user" menu:

Unknown column 'acymailingsubscribers.subid' in 'order clause' SQL = SELECT acysmsusers. *, Acysmsusers.user_id as receiver_id, CONCAT_WS ("", acysmsusers.user_firstname, acysmsusers.user_lastname) as receiver_name, acysmsusers.user_email as receiver_email, acysmsusers.user_phone_number as receiver_phone FROM ap9zw_acysms_user as acysmsusers ORDER BY acymailingsubscribers.subid desc LIMIT 0, 20

How can I fix it?
Thank you!
Please log in to post a reply

Re: Error 1054 6 years 5 months ago #67489

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Could you please send me a temporary account to your website at This email address is being protected from spambots. You need JavaScript enabled to view it. with "AcySMS SQL error" as subject ?

I will take a look at it tomorrow :)
Please log in to post a reply

Re: Error 1054 6 years 5 months ago #67510

  • Anonymous user
  • ilayfd's Avatar
  • Posts: 5
  • Karma: 0
Hello!

Done! See e-mail from This email address is being protected from spambots. You need JavaScript enabled to view it.

Thank you!
Please log in to post a reply

Re: Error 1054 6 years 5 months ago #67632

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Problem solved.
The patch will be included in our next release :)
Please log in to post a reply

Re: Error 1054 6 years 4 months ago #69640

  • Anonymous user
  • EOLGeorge's Avatar
  • Posts: 8
  • Karma: 0
Hi I just installed the latest version and got the 1054 error

1054 Unknown column 'stylesheet' in 'field list' SQL=INSERT IGNORE INTO `jos_acymailing_template` (`namekey`, `name`, `description`, `body`, `altbody`, `premium`, `ordering`, `styles`,`stylesheet`,`thumb`,`readmore`) VALUES ('newsletter-4','Notification template','','
Please log in to post a reply

Re: Error 1054 6 years 4 months ago #69644

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Hi,

I guess you're talking about AcyMailing isn't it ?
Please log in to post a reply

Re: Error 1054 6 years 4 months ago #69647

  • Anonymous user
  • EOLGeorge's Avatar
  • Posts: 8
  • Karma: 0
OOPS yep, sorry wrong forum, just by the search results.
Please log in to post a reply

Re: Error 1054 6 years 4 months ago #69663

  • Anonymous user
  • Adrien's Avatar
  • Posts: 20233
  • Karma: 681
Hi,

What version of Acy are you using? (I mean what version is displayed on the menu "update/about"?)
If it's still an old one and not the latest one, please delete the folder administrator/components/com_acymailing and reinstall AcyMailing.
Please have a look at our official documentation before posting a new message!

Do you like AcyMailing? We love your reviews!
We would appreciate if you could take 5 minutes to post a review on the Joomla! Extensions Directory.
We answered one of your question? Well, it's the best way to thank us!
Please log in to post a reply
Time to create page: 0.064 seconds
Powered by Kunena Forum