TCWT

Not really a fix but workaround. The new member always receives an email regardless of which setting previously.

In file:
/admin/applications/core/modules_admin/mycp/dashboard.php Find:
$online = $this->DB->buildAndFetch( array( 'select' => 'count(*) as rows', 'from' => 'sessions', 'where' => "running_time > {$time}" ) ); Change to:
$online = $this->DB->buildAndFetch( array( 'select' => 'count(*) as `rows`', 'from' => 'sessions', 'where' => "running_time > {$time}" ) ); Save and upload.

Support won’t login to your server and support for 3.X ended YEARS ago.  Off hand it sounds like when you moved servers you moved to a host that has a newer version of MySQL than what 3.3 supported. 
The 3.3.X line is 10+ years old and like 10 versions of PHP behind modern standards. 

I would HIGHLY recommend working with a 3rd party resource that specializes in legacy upgrades and move to an updated version. Otherwise IPS itself won’t be able to provide support. 
https://invisioncommunity.com/third-party/providers-directory/?advanced_search_submitted=1&content_field_231[4]=4&content_field_232[0]=0&content_field_232[1]=1

They don't offer any more support for the 3.x version. Also, the RECOVERY_MODE constant works only for 4.x, so it won't work for you on 3.3.
 
That said, your issue is that your MySQL (MariaDB) version is too new compared to the version required by the 3.3 version, and the "column name" rows throws an error because it's a reserved word now.
It can be changed to make it compatible, but I really suggest either downgrading your database version or updating the site to the latest 4.7 version. 🙄

Support for self-hosted clients is provided right here in this forum. It's currently after hours. While someone at Invision might happen to read this tonight, they usually aren't actively monitoring until they open in the morning.
At least it's running on the front end. I don't think it's going to be easy to upgrade from 3.3 to the latest release. You're gonna have to jump through some hoops.

Are you sure about this? I just installed this a few days ago...at first I installed v3 but then I got that error too--then I disabled v3, enabled v2 and regenerated a new key and now it works on my site.




To the developer,

Thank you for a wonderful application! My members love it! Does it cost money for a Bing API though? BING look more fluid in its map from what I've seen.


Ryan

The V2 API has been deprecated for about 3 years now, the V2 api will change into a V2/V3 hybrid in November.

I'll recap as although it's been mentioned on many pages in this topic this information has slipped back out of view. API Keys are available via the console. https://code.google.com/apis/console


You do require a Bing account to use the API, but they do have a free level that's pretty much the same (if not better) than the free Google Maps offering.

It's not in 2.x either.

I always find this area lacking in ipb.

PM low space warning
PM vacation messages

PM low space warning
PM vacation messages

IPB need to change the search as many have suggested.

I doubt forums will die anytime soon.

I doubt forums will die anytime soon.

I'm all for this too.

I never received any complaints about the search being too complicated. Why can't there be a simple and advanced mode like before? :( After all my suggestions to improve search, this is the outcome? :(

But posting "+1" is so much more fun!