Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12188
Latest: thereisaway
New This Month: 10
New This Week: 0
New Today: 0
Stats
Total Posts: 39137
Total Topics: 6892
Most Online Today: 47
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 50
Total: 51

Author Topic: database error  (Read 507 times)

0 Members and 1 Guest 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: 14594
    • 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: 14594
    • 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: 14594
    • 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: 14594
    • 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: 14594
    • 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: 14594
    • 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
5864 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
4 Replies
3410 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
Database error

Started by davejo « 1 2 » Support

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

+- Recent Topics

Error in log with Export Data by Rivilis
Today at 10:23:55 am

More regular expression match for search by Michel68
September 23, 2018, 02:42:08 pm

SMFBlog problem by SMFHacks
September 21, 2018, 08:10:59 pm

GDPR Pro 2.0 Released for SMF by SMFHacks
September 21, 2018, 02:17:11 pm

[Mod]Dynamic Memberlist by SMFHacks
September 17, 2018, 05:00:59 pm

Pretty URL caches Url Permanently by SMFHacks
September 17, 2018, 11:57:44 am

[Mod]Guest Post No Email Field by SMFHacks
September 13, 2018, 10:41:07 pm

Can I redirect Pretty URL topics to another? by SMFHacks
September 13, 2018, 04:39:54 pm

Aeva Conversion - How to? by SMFHacks
September 12, 2018, 12:12:02 pm

Hide categories by language. 2. Multi lingual title by SMFHacks
September 12, 2018, 12:15:13 am

Powered by EzPortal