Go Back   vb.org Archive > vBulletin Modifications > Premium Modifications > ibProArcade
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Can't access to Arcade Details »»
Can't access to Arcade
Version: , by gnrx gnrx is offline
Developer Last Online: Aug 2022 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-28-2019 Last Update: Never Installs: 0
 
No support by the author.

Today, one user indicate to me that are a problem,
In some posts of some threads, at the top of site appears this error:
Code:
PHP Warning: Illegal string offset 'type' in ..../includes/class_postbit.php(345) : eval()'d code on line 57
Only in some pages of some threads.

But now, I can't access to arcade, if click to access appears this error:
Code:
PHP Warning: mysqli_query(): (42000/1055): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydatabase.c.champ_gid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in ..../arcade/functions/dbclass_mysqli.php on line 193

PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in ..../arcade/functions/dbclass_mysqli.php on line 512

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned
mySQL query error: SELECT c.champ_gid AS GID, c.champ_mid AS MID, c.champ_name AS name, COUNT(c.champ_mid) AS total, g.opentag AS prefix, g.closetag AS suffix
FROM games_champs AS c
LEFT JOIN user AS m ON (m.userid=c.champ_mid)
LEFT JOIN usergroup AS g ON (g.usergroupid=m.usergroupid)
GROUP BY MID 
ORDER BY total DESC LIMIT 3

mySQL error: 
mySQL error code: 
Date: Monday 28th 2019f January 2019 11:47:36 PM

mySQL query error: SELECT c.champ_gid AS GID, c.champ_mid AS MID, c.champ_name AS name, COUNT(c.champ_mid) AS total, g.opentag AS prefix, g.closetag AS suffix
FROM games_champs AS c
LEFT JOIN user AS m ON (m.userid=c.champ_mid)
LEFT JOIN usergroup AS g ON (g.usergroupid=m.usergroupid)
GROUP BY MID 
ORDER BY total DESC LIMIT 3

mySQL error: 
mySQL error code: 
Date: Monday 28th 2019f January 2019 11:47:36 PM

We apologise for any inconvenience
I reupload the files of the product and reinstall the product, but continue the problem.

In admincp-arcade click in Game List, appears this error lines:
Code:
PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589

PHP Warning: A non-numeric value encountered in ..../admincp/arcade.php on line 589
Thanks and regards.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 02-15-2019, 09:35 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fine, thanks to stangger!

...and gnrx: don't touch the database again and mess it up
Reply With Quote
  #13  
Old 02-18-2019, 03:29 PM
gnrx gnrx is offline
 
Join Date: Apr 2009
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That I thought at the beginning, that the problem was that "touch" the database, but no ... that was not the problem.
Coincidentally coincided with server migration, and this mod is the only one I have installed (as well as vb) which is, in the configuration of mysql on the server, incompatible with sql_mode = only_full_group_by
So I had to make the appropriate modifications to the mysql configuration for this mod to work.
That's right, until I found out that the problem was that ... I thought it was what I "had touched", xD
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:52 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03503 seconds
  • Memory Usage 2,214KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete