Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12124
Latest: HousepfReviews2
New This Month: 15
New This Week: 1
New Today: 0
Stats
Total Posts: 38842
Total Topics: 6838
Most Online Today: 71
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 77
Total: 77

Author Topic: database error  (Read 393 times)

0 Members and 2 Guests are viewing this topic.

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
database error
« on: February 17, 2018, 10:50:15 am »
I just reinstalled for a clean hithub and now I have this error when clic in "Gallery":

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #1 on: February 17, 2018, 11:46:48 am »
If possible can you disable "ONLY_FULL_GROUP_BY" IN mysql sql mode that will fix that error
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by
if you're running MySQL 5.7.5+ is to edit your my.cnf file and remove the ONLY_FULL_GROUP_BY option from sql_mode.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
Re: database error
« Reply #2 on: February 17, 2018, 12:17:14 pm »
Sorry but I dont know how to do that.

The strange is that I dont change anything in my database that is MySQL 5.5

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #3 on: February 17, 2018, 12:31:52 pm »
It's a setting in the my.ini or my.cnf for mysql

If not we will have to modify the gallery to include this line
Code: [Select]
SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));
But there will be an extra query on each gallery call.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
Re: database error
« Reply #4 on: February 17, 2018, 01:02:32 pm »
I installed the "lite version" and is working without errors.

Where I need to insert that code?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #5 on: February 17, 2018, 01:18:50 pm »
Open sources/gallery2.php
Find
Code: [Select]
function GalleryMain()
{
global $sourcedir, $currentVersion, $context, $gallerySettings, $txt, $modSettings, $boarddir, $boardurl, $scripturl;

Add after
Code: [Select]
global $smcFunc;

$smcFunc['db_query']('', "SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''))");

Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
Re: database error
« Reply #6 on: February 17, 2018, 01:31:53 pm »
OK,

Thank you very much, now is working.

Now I going to try to install download pro, crosing fingers  :D

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #7 on: February 17, 2018, 01:32:17 pm »
You will probably have do the same for that as well.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
Re: database error
« Reply #8 on: February 17, 2018, 05:20:54 pm »
yes. can you tell me in wich file I need to made the change for this?

Now I have this error too

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #9 on: February 17, 2018, 07:25:18 pm »
Open sources/admin.php
find
Code: [Select]
'downloads' => array(
'label' => $txt['downloads_admin'],
'file' => 'Downloads2.php',
'function' => 'DownloadsMain',
'custom_url' => $scripturl . '?action=admin;area=downloads;sa=adminset;sesc=' . $sc,
'icon' => 'server.gif',
'subsections' => array(
'adminset' => array($txt['downloads_text_settings']),
'approvelist' => array($txt['downloads_text_moderationcenter']),
'creditssystem' => array($txt['downloads_text_credits_system']),
'filespace' => array($txt['downloads_filespace']),
'catpermlist' => array($txt['downloads_text_catpermlist2']),
'batchftp' => array($txt['downloads_ftp2']),
'import' => array($txt['downloads_txt_import']),
'logs' => array($txt['downloads_txt_download_logs']),
),
),),
change to
Code: [Select]
'downloads' => array(
'label' => $txt['downloads_admin'],
'file' => 'Downloads2.php',
'function' => 'DownloadsMain',
'custom_url' => $scripturl . '?action=admin;area=downloads;sa=adminset',
'icon' => 'server.gif',
'subsections' => array(
'adminset' => array($txt['downloads_text_settings']),
'approvelist' => array($txt['downloads_text_moderationcenter']),
'creditssystem' => array($txt['downloads_text_credits_system']),
'filespace' => array($txt['downloads_filespace']),
'catpermlist' => array($txt['downloads_text_catpermlist2']),
'batchftp' => array($txt['downloads_ftp2']),
'import' => array($txt['downloads_txt_import']),
'logs' => array($txt['downloads_txt_download_logs']),
),
),),
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Juan Carlos

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 22
    • View Profile
Re: database error
« Reply #10 on: February 17, 2018, 07:57:31 pm »
Thanks, all appear that work now.

Apart of that errors another minor problem is that I cant to see the icons, the "drive icon" in main menu, "help" in config and the squares in rating.

I cant find them. Attach a screen

(may be this message would be in Download forum), sorry

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14450
    • View Profile
Re: database error
« Reply #11 on: February 17, 2018, 08:22:17 pm »
Will look into those yeah please keep that in downloads pro support.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
5811 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
4 Replies
3369 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
Database error

Started by davejo « 1 2 » Support

15 Replies
9528 Views
Last post March 23, 2013, 03:13:33 am
by davejo
3 Replies
2471 Views
Last post December 01, 2013, 05:37:43 pm
by SMFHacks
23 Replies
4117 Views
Last post February 23, 2015, 12:41:27 pm
by Mike Barrio

+- Recent Topics

Admin View in Member's Profile of Dates for Accepting of PP and Reg Agreement by HDB
June 16, 2018, 02:05:40 pm

SA Facebook? by Winslow
June 16, 2018, 11:23:22 am

Should I be concerned? by SMFHacks
June 15, 2018, 11:04:55 pm

[Mod]GDPR Helper by SMFHacks
June 13, 2018, 04:11:14 pm

Block to Tell who was online in last 24 hours by mtalks
June 09, 2018, 09:39:49 pm

Emoji Pro Released by Ross
June 08, 2018, 02:17:41 pm

Emojis or images? by SMFHacks
June 08, 2018, 10:17:03 am

Simple Audio/Video Embedder copyright removal by Ross
June 07, 2018, 02:38:09 pm

Is this the correct way to cache? by shuban
June 06, 2018, 12:18:05 pm

GDPR Pro 2.0 Released for SMF by SMFHacks
June 05, 2018, 09:32:16 am

Powered by EzPortal