Skip to main content
Recent Posts
25
Support / Re: Error thrown on login - preventing all users from viewing forum
Last post by Spuds -
You can also try as a test ...

Edit your Db-mysql.class.php  which will be in your sources/database directory.

Towards the top you will find:
Code: [Select]
		self::$_db->_connection = $connection;
around line 83

After that add the following
Code: [Select]
		self::$_db->query('', '
SET SQL_BIG_SELECTS = 1',
array(
)
);

That should be the workaround as suggested by the error you are seeing, so that may help in the short term.

In my quick reading about that error, it seems like your host is providing pretty limited resources.  Many hosts are setup for static sites and do a poor job hosting dynamic ones including forums, CMS and ...
26
Support / Re: Error thrown on login - preventing all users from viewing forum
Last post by Spuds -
I've not personally seen that error before ...

What version of MySQL is you site running ?  You can find that from Admin -> Main -> Support and Credits 
Also let us know the version of PHP you are running. 
One other thing would be to is enable the query in the error log ... Admin -> Security and Moderation -> General -> Include database query in the error log If we are lucky we may catch where that error is being thrown from.
27
Support / Error thrown on login - preventing all users from viewing forum
Last post by jmilholen87 -
Greetings all. Hoping I can get some help with an error that is plaguing me.

Some quick background:
I recently inherited ownership of an online web forum from a friend who could no longer devote the time to owning the forum/community. The forum has been around for quite a few years now. It is hosted on a domain that it shares with a front end website, a wiki, and a backend db as well as the forum itself. The version of the forum is: ElkArte 1.1.8 | SimplePortal 1.0.1

Up until a few days ago, everything was running swimmingly. But, as early as January 15th (first reported incident from user base to me), users have begun to encounter a white screen of death when trying to access any page on the forum. They can access the main site, they can access the wiki, but the forum leads to an error screen. IMPORTANT NOTE: this only happens if the user was already logged in. If the user is NOT logged in, they can access the main forum page, and any posts on the forum. BUT, when they try to log in, they get the same error. The error that appears is as follows:

QuoteWarning: Trying to access array offset on value of type null in /customers/6/a/e/uss-theurgy.com/httpd.www/forum/sources/database/Db-mysql.class.php on line 545 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Has anyone encountered this particular error before? I was able to find the Db-mysql.class.php file through the domain backend browser, but the code line in question is simply the code for throwing an error when something doesn't work. And nowhere in the php file did I see any select query. This is keeping anyone from accessing and posting on our forums. The Domain host tech support suggesting posting the issue here. I would have reached out sooner but it took a while for my account registration confirmation email to show up.

My apologies if this is the wrong part of the community to post this. We've got almost 200 users (though not that many active these days) and I'd like to restore services to them as swiftly as I can. So, many thanks in advanced.
28
Chit Chat / Re: Docker, mysql, apache and connection
Last post by emanuele -
Well... I did what I'm best at doing: I screwed up everything and had to restart from zero.:joy:

then, I realized the only issue was I used entirely different networks when I should have just used the same and set different IPs.
Well, me and networks are not exactly friends. :D
29
Addons / Re: [ADDON] PDF Print
Last post by Spuds -
This ElkArte addon replaces the default print button with a create PDF.   Clicking the PDF button will output a PDF to the browser of the current topic, including images, attachments, and links.  The user can then print or save the PDF.

The package file is large due to the included TTF fonts, so your server will need to support uploads of 5M ... if not use the download from addons site option as outlined below.

Here is what is new in V1.2.1

  • Address various issues with PHP 8.2
  • Update tfdpf library to the latest (improved PHP 8.2 support)
  • Improved processing / formatting of ILA and Gallery images
  • Change to use DomDocument instead of the simple dom php library

To get the addon you can do one of two things:
  • You can download the file from the Addons site and then upload that file to your server
    • Admin > Packages > Upload > Select the zip file you just downloaded > Upload
  • Or Download it directly to your site
    • Admin > Packages > Download Package > click "Browse" by "ElkArte Third-party Add-ons Site", expand Enhancement > Print to PDF > [Download] (use the button)
30
Chit Chat / Re: Docker, mysql, apache and connection
Last post by Spuds -
I should note, in that setup the  $db_server  would be:drum:  db  that is what you would use in something like Settings.php
when to use adminer you would navigate to 123.123.123.123:8080
and sphinx server would be:drum:  sphinx
and mailhog (a way to test smtp) would be at 123.123.123.123:8025 and you would setup the mail server as 123.123.123.123 port 1025 in the ACP