13 minutes ago, Randy Calvert said:

IPS\Db\Exception: Duplicate entry '156355-IPS\forums\Topic' for key 'id_class' (1062)

This seems to show there is a problem with your database when you restored it.  

Yes. I have some corruption issues. I'm looking to see if I can fix the corruption.

I've had to restore my server and now I face intermittent database issues. One is preventing access to a subforum:

The log entry was triggered by a guest (Guests)

REPLACE INTO `ibf_core_item_member_map` (map_member_id, map_item_id, map_latest_date, map_class) SELECT DISTINCT `author_id`, `topic_id`, UNIX_TIMESTAMP(), 'IPS\\forums\\Topic' FROM `ibf_forums_posts` AS `forums_posts` WHERE ( queued IN(0,2) ) AND ( topic_id IN(214816) )
IPS\Db\Exception: Can't find record in 'ibf_core_item_member_map' (1032)
#0 /home/nginx/domains/zzzzz/public/community/system/Db/Db.php(969): IPS\_Db->preparedQuery()
#1 /home/nginx/domains/zzzzz/public/community/system/Node/Statistics.php(295): IPS\_Db->replace()
#2 /home/nginx/domains/zzzzz/public/community/system/Node/Statistics.php(76): IPS\forums\_Forum->rebuildPostedIn()
#3 /home/nginx/domains/zzzzz/public/community/system/Node/Statistics.php(160): IPS\forums\_Forum->authorsPostedIn()
#4 /home/nginx/domains/zzzzz/public/community/system/Helpers/Table/Content.php(499): IPS\forums\_Forum->contentPostedIn()
#5 /home/nginx/domains/zzzzz/public/community/system/Helpers/Table/Table.php(489): IPS\Helpers\Table\_Content->getRows()
#6 /home/nginx/domains/zzzzz/public/community/applications/forums/modules/front/forums/forums.php(537): IPS\Helpers\Table\_Table->__toString()
#7 /home/nginx/domains/zzzzz/public/community/applications/forums/modules/front/forums/forums.php(38): IPS\forums\modules\front\forums\_forums->_forum()
#8 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Controller.php(101): IPS\forums\modules\front\forums\_forums->manage()
#9 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#10 /home/nginx/domains/zzzzz/public/community/index.php(13): IPS\_Dispatcher->run()
#11 {main}

Backtrace:

#0 /home/nginx/domains/zzzzz/public/community/system/Db/Db.php(969): IPS\_Db->preparedQuery()
#1 /home/nginx/domains/zzzzz/public/community/system/Patterns/ActiveRecord.php(733): IPS\_Db->replace()
#2 /home/nginx/domains/zzzzz/public/community/system/Patterns/ActiveRecord.php(761): IPS\Patterns\_ActiveRecord::_followers()
#3 /home/nginx/domains/zzzzz/public/community/system/Member/Member.php(1516): IPS\Patterns\_ActiveRecord::_followersCount()
#4 /home/nginx/domains/zzzzz/public/community/uploads/template_9_af46883c13caa197f9e387620d19e6ec_profile.php(3529): IPS\_Member->followersCount()
#5 /home/nginx/domains/zzzzz/public/community/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_profile->profileHeader()
#6 /home/nginx/domains/zzzzz/public/community/uploads/template_9_af46883c13caa197f9e387620d19e6ec_profile.php(4910): IPS\Theme\_SandboxedTemplate->__call()
#7 /home/nginx/domains/zzzzz/public/community/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_profile->userContent()
#8 /home/nginx/domains/zzzzz/public/community/applications/core/modules/front/members/profile.php(623): IPS\Theme\_SandboxedTemplate->__call()
#9 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Controller.php(90): IPS\core\modules\front\members\_profile->content()
#10 /home/nginx/domains/zzzzz/public/community/applications/core/modules/front/members/profile.php(73): IPS\Dispatcher\_Controller->execute()
#11 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\front\members\_profile->execute()
#12 /home/nginx/domains/zzzzz/public/community/index.php(13): IPS\_Dispatcher->run()
#13 {main}

LOADED HOOKS

• applications/chatbox/hooks/Dispatcher_Front.php
• applications/chatbox/hooks/Member.php
• applications/chatbox/hooks/core_File.php
• applications/chatbox/hooks/Item.php
• applications/chatbox/hooks/Comment.php

The other:

The log entry was triggered by a guest (Guests)

REPLACE INTO `ibf_core_follow_count_cache` ( `id`, `class`, `count`, `added` ) VALUES ( 156355, 'IPS\forums\Topic', 0, 1657065094 )
IPS\Db\Exception: Duplicate entry '156355-IPS\forums\Topic' for key 'id_class' (1062)
#0 /home/nginx/domains/zzzzz/public/community/system/Db/Db.php(969): IPS\_Db->preparedQuery()
#1 /home/nginx/domains/zzzzz/public/community/system/Patterns/ActiveRecord.php(733): IPS\_Db->replace()
#2 /home/nginx/domains/zzzzz/public/community/system/Content/Item.php(7996): IPS\Patterns\_ActiveRecord::_followers()
#3 /home/nginx/domains/zzzzz/public/community/system/Content/Item.php(8010): IPS\Content\_Item->followers()
#4 /home/nginx/domains/zzzzz/public/community/applications/forums/modules/front/forums/topic.php(555): IPS\Content\_Item->followersCount()
#5 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Controller.php(101): IPS\forums\modules\front\forums\_topic->manage()
#6 /home/nginx/domains/zzzzz/public/community/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#7 /home/nginx/domains/zzzzz/public/community/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute()
#8 /home/nginx/domains/zzzzz/public/community/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute()
#9 /home/nginx/domains/zzzzz/public/community/index.php(13): IPS\_Dispatcher->run()
#10 {main}

Backtrace:

#0 /home/nginx/domains/zzzzz/public/community/init.php(1015): IPS\_Log::log()
#1 [internal function]: IPS\IPS::exceptionHandler()
#2 {main}

LOADED HOOKS

• applications/chatbox/hooks/Dispatcher_Front.php
• applications/chatbox/hooks/Member.php
• applications/chatbox/hooks/core_File.php
• applications/chatbox/hooks/Item.php
• applications/chatbox/hooks/Comment.php

Any ideas? 

It looks like this has been broken for awhile.

On 9/2/2021 at 2:10 AM, Thomas P said:

Not every version of ES is compatible to Invision Community.

Afaik ES up to v7.6 is the version to go for Invision v4.5 and v4.6, works fine for us: the DB is significantly smaller without search index, search results are shown faster and processing power is offloaded; so for us a separate search engine is crucial. Before we used Sphinx with IPB, which worked also well in the past.

I downgraded to 7.6.2.  Did you delete the db search index?

On 1/5/2021 at 9:20 AM, bfarber said:

Downloads uses the friendly URL path of "/files". Do you happen to have an actual folder on your server named "files"? If so, Apache would route the request to that folder and the request would never make it to our software - the solution would be to rename that folder to something else.

Bingo! I had a related issue with an old app that I moved out of the folder as a copy. I would have never figured this out.

We have had someone complain about this too. 7M posts over time. Person says they are missing a bunch from various time periods. The compressed forum posts table are 3.3GB before and 3.8GB after. I don't know what the extra 500MB could possible be. At least it isn't smaller. 

Maybe there is a reason why they don't show?

On 8/31/2021 at 1:52 AM, Thomas P said:

Hi,

just use (i.e. upgrade to) Redis:

Second try elasticsearch (ES) instead of plain MySQL based Search, you can use it on the same server(s) or offload ES to an external service:

There are more tidbits in the a.m. article 😉

Works well for us, good luck,
Thomas

I paid for elastic search to be installed only to find it isn’t compatible.

8M posts. 1-2k online. I used to use memcache and now I'm hosed. I'm uncertain which one to use to regain my performance under heavy use. What do the Big Boards use with 4.6?

What I am finding is that we just need the option to link to the emojis on our keyboards directly. 

Can this be done? 

On 12/31/2020 at 12:34 AM, Fast Lane! said:

Use header bidding for the best of all world's. 

What are the chances you are a resource or you would be willing to teach this to me like I'm five? 😀

I actually know the basic ins and outs of all this, but the learning curve on this part seems to be significant. I have three advertisers: adsense, Amazon, and a third party. I don't know how to put them into admanager, rotate, and do the things described in this topic. I have always just pasted static code.

On 9/14/2020 at 11:18 AM, bfarber said:

We are going to tag the latest supported release in our software so you cannot enable ElasticSearch with a non-supported release for now, and we will be looking into the underlying bug for a future maintenance update.

Any updates on this?

On 12/28/2020 at 12:50 PM, Fast Lane! said:

Lots.  Also, if you ever have AdSense cut off (a million reasons why it can happen with a user gen content site) you will want that network in place to take up the slack while you resolve things. 

WAG on that improvement? 2x RPM? More less? 

I have been running adsense for 10-15 years without issue. 

What sorts of improvements do you see using these techniques over running straight adsense?

What happens if members have legacy points, say 9 points, and I make a new action that bans people for say 5 warning points?

I assume there isn't a retroactive crawl through the database that searches for every member with 5 or more points and bans them. Correct? Is the new action only activated on subsequent points?

On 8/26/2020 at 10:51 AM, Pavel Chernitsky said:

Well, I bet that's why it didn't work 😅

Let's say the post is not deleted (it can't be, our mods can only hide posts), how would one go about having the post appear in the warning? And please, talk to me like I'm a 2 year old monkey, and a pretty dumb one at that 🙂 

 

Did you ever get this figured out?

On 9/8/2020 at 9:55 AM, bfarber said:

Yes I couldn't remember the specific version where this broke. Thank you for confirming 7.6.2 is ok.

Is this going to be fixed?

I upgraded to 4.0.7 last night and it broke a lot of things. Unfortunately, I did not keep my previous version. Does anyone happen to have that version? I have pm’d the developer, but I am waiting for a response. In the meantime, I’m trying to fix some broken things.

Thanks. 

Ok, I have two 3.1.2 installs on the same server, one works and the other doesn't. No idea why. Both skins are just changes from the default skin and are almost exactly alike.

I let the scheduler run to complete the task, but nothing happened and no entries were made in the log. I'm pretty good at installing scripts, so I'm not a newbie here. I had it working previously in 3.0,x series, but now nothing.

when I try to manually run the task - I get a blank page. Any ideas?

but what happened to "preformatted" code? I can't find bbcode for a table of stats that I want to cut and paste and have the columns line up.

This functionality was needed like yesterday!

Too many calendars these days. No way do I want to type a new one just for my forum when all my other ones talk nicely to each other.