vb.org Archive - Major Additions - ibProArcade

There is a SQL error.

You can contact the board administrator by clicking here 



Error Returned



mySQL query error: SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3



mySQL error: 

mySQL error code: 

Date: Tuesday 17th 2018f July 2018 09:48:46 PM



We apologise for any inconvenience

I can't downgrade MySQL to 5.6, only if I restart full backup of my VPS...

Its possible solved this?

Thanks and regards!

BirdOPrey5

07-18-2018 08:16 AM

I don't see a particular reason why

Code:

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

Would fail on MySQL 5.7, I wonder if the table was properly upgraded. Try running that exact command from phpmyadmin and see if it works or if an error message comes back. Check you can browse the table games_champs.

gnrx	07-18-2018 09:28 AM

Hello.
Thank for your reply and help.

I run the exact command from phpmyadmin:

Code:

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

In phpmyadmin-SQL-Execute queries.
This is the result:

Code:

Error

consulta SQL: Documentaci?n



SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3



MySQL ha dicho: Documentaci?n



#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'MYUSER_MYDB.games_champs.champ_gid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After this, continue the issue.
And yes, by phpmyadmin, can browse the table games_champs.

Regards!!

BirdOPrey5

07-18-2018 10:31 PM

I don't know what other ramifications it might have but the logical conclusion from that error message is to disable the sql_mode "only_full_group_by."

Instructions on how to do this: https://stackoverflow.com/questions/...-full-group-by

Judith2

07-19-2018 06:25 PM

This error message I get when I open arcade :

"Call to undefined function print_cp_header() on line 1046 in C:\inetpub\vhosts\animalhelpeurope.de\httpdocs\vbf orum\arcade.php
#0 {main}"

gnrx	07-19-2018 08:19 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2595629)

I made this change in my.cnf, I disable the sql_mode "only_full_group_by", and now, work perfect, again work perfect!

Thanks for you attention and help!! :)

fookaa

08-17-2018 01:46 PM

removed...........

Judith2

08-17-2018 06:16 PM

I've done the update, but Admin cp and Arcade are blank.

All times are GMT. The time now is 07:34 AM.

Page 746 of 758

746

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09841 seconds Memory Usage 1,741KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: