Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4253
Latest: Ineedsmfhelp
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43242
Total Topics: 7516
Most Online Today: 126
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 107
Total: 107

Author Topic: database error  (Read 2897 times)

0 Members and 1 Guest are viewing this topic.

Offline Juan Carlos

  • Member
  • *
  • 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: 16428
    • 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

  • Member
  • *
  • 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: 16428
    • 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

  • Member
  • *
  • 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: 16428
    • 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

  • Member
  • *
  • 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: 16428
    • 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

  • Member
  • *
  • 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: 16428
    • 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

  • Member
  • *
  • 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: 16428
    • 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
11557 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
10469 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

22 Replies
13012 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
5 Replies
6830 Views
Last post January 22, 2010, 11:26:48 am
by SMFHacks
4 Replies
6276 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

is it possible to add support for odysee.com by SMFHacks
March 13, 2024, 10:53:28 pm

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Powered by EzPortal