- Forums
- Support and Presales
- Professional Members Support
- error when debug mode on entering my profile
error when debug mode on entering my profile
- jojo12
- OFFLINE
-
Platinum Member
- Posts: 1125
- Thanks: 132
- Karma: 25
12 years 10 months ago #166033
by jojo12
error when debug mode on entering my profile was created by jojo12
Hi,
I don't know where to put this question.
With no debug mode, all seems to work well. But when I try with debug on, and I try to enter my profile I get an error 500 with the text you can see in the attachement. I dont understand what it means because my english and my programmers language is not so well.
Can you give me a hint?
I don't know where to put this question.
With no debug mode, all seems to work well. But when I try with debug on, and I try to enter my profile I get an error 500 with the text you can see in the attachement. I dont understand what it means because my english and my programmers language is not so well.
Can you give me a hint?
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68549
- Thanks: 9094
- Karma: 1434
12 years 10 months ago #166088
by krileon
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.
Replied by krileon on topic Re: error when debug mode on entering my profile
This will be fixed with next release however. It is due to the SELECT query inside of the totalArticles function having additional selects beyond the COUNT without a GROUP BY specified. This means there is an aggregated function (COUNT(*)) mixed with non-aggregated selects (a.`id`).
This issue is not present on hosts with an up to date release of MYSQL (bug ticket for MYSQL regarding this issue is from 2007). I recommend having your host update their MYSQL.
This can also be fixed by editing the model file (joomla15.php in your case) and removing from the totalArticles function query all the selects except COUNT(*). At any rate is fixed for next release.
This issue is not present on hosts with an up to date release of MYSQL (bug ticket for MYSQL regarding this issue is from 2007). I recommend having your host update their MYSQL.
This can also be fixed by editing the model file (joomla15.php in your case) and removing from the totalArticles function query all the selects except COUNT(*). At any rate is fixed for next release.
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.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Support and Presales
- Professional Members Support
- error when debug mode on entering my profile
Time to create page: 0.185 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- error when debug mode on entering my profile