Administration/Moderation Concerns?

This is a part of our Cambodia forums to chat about anything Cambodia-related. This discussion forum is at the top of our site because it's usually the busiest part of the expat community chatter with random topics on just about everything, including expat life, Khmer politics, Cambodian blogs we have or have come across, or whatever else our members want to discuss. Whether you're an expatriate, tourist, Cambodian or random traveler just passing through South East Asia, you are welcome to talk about anything or start new topics yourselves.
User avatar
General Mackevili
The General
Posts: 17161
Joined: Tue May 06, 2014 5:24 pm
Reputation: 2129
Location: The Kingdom
Contact:
United States of America

Re: Administration/Moderation Concerns?

Post by General Mackevili »

pczz wrote:speeds gone back to variable again. mostly delay submitting a post
pczz wrote:just timed the above 9 seconds from click to finish submit
Yeah, thanks. Our next "big" project is getting CEO lightening fast. If all goes well, people will start reporting that it's too fast within a week.

We should have gotten on it this week, but we have done so many updates on it already, we decided to wait a bit to make sure step 1 of getting things fast went smooth.

"Life is too important to take seriously."

"Life does not cease to be funny when people die any more than it ceases to be serious when people laugh."

Have a story or an anonymous news tip for CEO? Need advertising? CONTACT ME

Cambodia Expats Online is the most popular community in the country. JOIN TODAY

Follow CEO on social media:

Facebook
Twitter
YouTube
Google+
Instagram
kptic
Expatriate
Posts: 229
Joined: Fri May 22, 2015 2:33 pm
Reputation: 56
Greece

Re: Administration/Moderation Concerns?

Post by kptic »

Normally, when I am on CEO but not logged in, and I want to reply to a thread, I click reply and it prompts me to log in then lets me respond. Today, CEO threw an exception. I had to log in and then navigate back to the post. I pasted the error message below. It seems that the maintenance the other day may have caused a regression bug.

"SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceo_phpbb_prod.q.question_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists."

Edit* Am I the only poster on here that doesn't bother to log in until I want to post something? This is like the third time I've found a bug that requires not being logged in to recreate the issue.
Last edited by kptic on Fri Feb 16, 2018 2:23 am, edited 1 time in total.
User avatar
General Mackevili
The General
Posts: 17161
Joined: Tue May 06, 2014 5:24 pm
Reputation: 2129
Location: The Kingdom
Contact:
United States of America

Re: Administration/Moderation Concerns?

Post by General Mackevili »

kptic wrote:Normally, when I am on CEO but not logged in, and I want to reply to a thread, I click reply and it prompts me to log in then lets me respond. Today, CEO threw an exception. I had to log in and then navigate back to the post. I pasted the error message below. It seems that the maintenance the other day may have caused a regression bug.

SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceo_phpbb_prod.q.question_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Thanks for the detailed report! I am able to replicate it exactly as you described, so I'll get this over to the developer and fairly certain they can get it sorted ASAP.
"Life is too important to take seriously."

"Life does not cease to be funny when people die any more than it ceases to be serious when people laugh."

Have a story or an anonymous news tip for CEO? Need advertising? CONTACT ME

Cambodia Expats Online is the most popular community in the country. JOIN TODAY

Follow CEO on social media:

Facebook
Twitter
YouTube
Google+
Instagram
User avatar
General Mackevili
The General
Posts: 17161
Joined: Tue May 06, 2014 5:24 pm
Reputation: 2129
Location: The Kingdom
Contact:
United States of America

Re: Administration/Moderation Concerns?

Post by General Mackevili »


kptic wrote:
Edit* Am I the only poster on here that doesn't bother to log in until I want to post something? This is like the third time I've found a bug that requires not being logged in to recreate the issue.
Haha, maybe so. I generally try to stay logged in, and I assume most do to, but this last one you described will definitely affect more people, as I assume a lot of new people click that when they first land on CEO, and then register.

I'll report back, but I assume that it can easily be fixed.
"Life is too important to take seriously."

"Life does not cease to be funny when people die any more than it ceases to be serious when people laugh."

Have a story or an anonymous news tip for CEO? Need advertising? CONTACT ME

Cambodia Expats Online is the most popular community in the country. JOIN TODAY

Follow CEO on social media:

Facebook
Twitter
YouTube
Google+
Instagram
kptic
Expatriate
Posts: 229
Joined: Fri May 22, 2015 2:33 pm
Reputation: 56
Greece

Re: Administration/Moderation Concerns?

Post by kptic »

General Mackevili wrote: Fri Feb 16, 2018 2:29 am
kptic wrote:
Edit* Am I the only poster on here that doesn't bother to log in until I want to post something? This is like the third time I've found a bug that requires not being logged in to recreate the issue.
Haha, maybe so. I generally try to stay logged in, and I assume most do to, but this last one you described will definitely affect more people, as I assume a lot of new people click that when they first land on CEO, and then register.

I'll report back, but I assume that it can easily be fixed.
I don't know php, but I use SQL a lot, so I think this could be the issue:

https://stackoverflow.com/questions/349 ... olumn?lq=1

Easy fix if so.
User avatar
General Mackevili
The General
Posts: 17161
Joined: Tue May 06, 2014 5:24 pm
Reputation: 2129
Location: The Kingdom
Contact:
United States of America

Re: Administration/Moderation Concerns?

Post by General Mackevili »

kptic wrote:
General Mackevili wrote: Fri Feb 16, 2018 2:29 am
kptic wrote:
Edit* Am I the only poster on here that doesn't bother to log in until I want to post something? This is like the third time I've found a bug that requires not being logged in to recreate the issue.
Haha, maybe so. I generally try to stay logged in, and I assume most do to, but this last one you described will definitely affect more people, as I assume a lot of new people click that when they first land on CEO, and then register.

I'll report back, but I assume that it can easily be fixed.
I don't know php, but I use SQL a lot, so I think this could be the issue:

https://stackoverflow.com/questions/349 ... olumn?lq=1

Easy fix if so.
Yeah, all that shit is Greek to me, but I think you're on the right track at least, as the dev was definitely messing with sql. I've already forwarded this to them, and hopefully they can get it sorted today sometime.

When we first started CEO I thought, "cool, I wanna learn php." Then Orange Dragon showed me a few "simple" things and I never thought of trying to learn it again. I don't get how any humans can do that stuff. Most of us have trouble using the [ bb ] quote function half of the time. :facepalm:
"Life is too important to take seriously."

"Life does not cease to be funny when people die any more than it ceases to be serious when people laugh."

Have a story or an anonymous news tip for CEO? Need advertising? CONTACT ME

Cambodia Expats Online is the most popular community in the country. JOIN TODAY

Follow CEO on social media:

Facebook
Twitter
YouTube
Google+
Instagram
User avatar
General Mackevili
The General
Posts: 17161
Joined: Tue May 06, 2014 5:24 pm
Reputation: 2129
Location: The Kingdom
Contact:
United States of America

Re: Administration/Moderation Concerns?

Post by General Mackevili »

kptic wrote:Normally, when I am on CEO but not logged in, and I want to reply to a thread, I click reply and it prompts me to log in then lets me respond. Today, CEO threw an exception. I had to log in and then navigate back to the post. I pasted the error message below. It seems that the maintenance the other day may have caused a regression bug.

"SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceo_phpbb_prod.q.question_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists."

Edit* Am I the only poster on here that doesn't bother to log in until I want to post something? This is like the third time I've found a bug that requires not being logged in to recreate the issue.
Fixed! That was a quick turnaround. Let us know if you see it again.
"Life is too important to take seriously."

"Life does not cease to be funny when people die any more than it ceases to be serious when people laugh."

Have a story or an anonymous news tip for CEO? Need advertising? CONTACT ME

Cambodia Expats Online is the most popular community in the country. JOIN TODAY

Follow CEO on social media:

Facebook
Twitter
YouTube
Google+
Instagram
User avatar
that genius
Expatriate
Posts: 4065
Joined: Wed Dec 06, 2017 7:53 am
Reputation: 960
Sweden

Re: Administration/Moderation Concerns?

Post by that genius »

General Mackevili wrote: Thu Feb 08, 2018 1:44 amYeah, thanks. Our next "big" project is getting CEO lightening fast. If all goes well, people will start reporting that it's too fast within a week.
Like albino speed? :stir:
User avatar
timmydownawell
Expatriate
Posts: 2586
Joined: Tue Mar 22, 2016 12:50 pm
Reputation: 721
Location: Phnom Penh
Cambodia

Re: Administration/Moderation Concerns?

Post by timmydownawell »

Hey I was unable to post a photo last night from my phone, using the imgur button. I could select the photo ok but it naver made it to my post. Now I see kgbagent is haviga problem as well (see Kampot thread).

Just trying from my laptop and I'm getting the same error as him:

error

Request to: /3/image failed with: "Array"
Internal Server Error
No matter how much it rains, the dirt never washes away.
User avatar
Duncan
Sir Duncan
Posts: 8151
Joined: Tue Jun 03, 2014 8:22 pm
Reputation: 2336
Location: Wonder Why Central

Re: Administration/Moderation Concerns?

Post by Duncan »

timmydownawell wrote: Sun Feb 18, 2018 1:38 pm Hey I was unable to post a photo last night from my phone, using the imgur button. I could select the photo ok but it naver made it to my post. Now I see kgbagent is haviga problem as well (see Kampot thread).

Just trying from my laptop and I'm getting the same error as him:

error

Request to: /3/image failed with: "Array"
Internal Server Error
Yea, join the dummys club with me.

posting.php?mode=quote&f=3&p=225235
Cambodia,,,, Don't fall in love with her.
Like the spoilt child she is, she will not be happy till she destroys herself from within and breaks your heart.
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post