Skip to Content Skip to Menu

CBSubs Mailer Issue

  • nphic
  • nphic
  • OFFLINE
  • Posts: 203
  • Thanks: 25
  • Karma: 1
11 years 7 months ago #224368 by nphic
CBSubs Mailer Issue was created by nphic
Folks,

We migrated to J2.5 running CB 1.9 and CBSubs 3.0.0. Since the migration, I have not been able to run the Mailer program in CBSubs. When I go into Automation Setting and click the first link, the program returns 0 rows processed. I turned on debug and I am getting the following error message:

JDatabaseMySQL::query: 1054 - Unknown column 'alias' in 'where clause' SQL=SELECT id FROM m7alm_assets WHERE alias = 'root'

Any thoughts on how I resolve this issue?

Thanks,
Joe

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

  • nphic
  • nphic
  • OFFLINE
  • Posts: 203
  • Thanks: 25
  • Karma: 1
11 years 7 months ago #224377 by nphic
Replied by nphic on topic CBSubs Mailer Issue
Folks,

I installed ACL Manager and it is reporting that there is an "Ophan Asset" which happens to be com_cbsubs. Should I resolve the orphan asset and delete it? I'm not sure if I need to delete it or fix it. I attached a screenshot of the ACL Manager output. Any help would be greatly appreciated.

Thanks,
Joe
Attachments:

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
11 years 7 months ago - 11 years 7 months ago #224385 by krileon
Replied by krileon on topic CBSubs Mailer Issue
There's no query in the mailer to the _assets database table that I can see. Try creating a new mailer entry and see if it sends. If showing same error then disable non-core Joomla system plugins 1 by 1 until resolved. If still not resolved repeat this step with non-core CB plugins 1 by 1 until resolved.

I installed ACL Manager and it is reporting that there is an "Ophan Asset" which happens to be com_cbsubs. Should I resolve the orphan asset and delete it? I'm not sure if I need to delete it or fix it. I attached a screenshot of the ACL Manager output. Any help would be greatly appreciated.

I would be careful with this as I've no idea how it goes about doing this. Maybe you should review CBSubs and ensure you're not using a usergroup or view access level somewhere that no longer exists, but this still shouldn't cause your query error.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 11 years 7 months ago by krileon.

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

  • beat
  • beat
  • ONLINE
  • Posts: 2169
  • Thanks: 463
  • Karma: 352
11 years 7 months ago #224392 by beat
Replied by beat on topic CBSubs Mailer Issue
- CBSubs ACL is not orphan, it's just Joomla that does not see CBSubs for now. So the ACL Manager warning is a false positive and can be ignored. Do not delete that asset entry.

- Do you have a file and line number for where that query that fails is located ?
Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

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

  • nphic
  • nphic
  • OFFLINE
  • Posts: 203
  • Thanks: 25
  • Karma: 1
11 years 7 months ago #224450 by nphic
Replied by nphic on topic CBSubs Mailer Issue
Gents,

The problem is resolved by recreating the CBSubs Mailers. Something gets messed up when you migrate to J2.5. I deleted each Mailer, recreated and it works fine.

I'll see if I can get more details on the error.

The entry in the assets table was deleted by the vendor working with me. How do I restore it?

Thanks,
Joe

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

  • nphic
  • nphic
  • OFFLINE
  • Posts: 203
  • Thanks: 25
  • Karma: 1
11 years 7 months ago #224451 by nphic
Replied by nphic on topic CBSubs Mailer Issue
Gents,

I turned on the Joomla debugging and the attached file is the results.

Thanks,
Joe
Attachments:

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

Moderators: beat, nant, krileon
Powered by Kunena Forum