Database Error vbactivity 3.1.4
We are running into an issues with the activity feed part of vbactivity, When a user clicks the activity feed we end up getting a database error so we recently disabled the activity feed and haven't gotten a database error since then. Any Idea's on what the issue...
activityactivityfeed
ajax
auto
avatar
bug
color
cron
database
database error
duplicate
error
feed
font
forum
full
image
number
post
style
ten
user
vbactivity
window
We have been experience site performance issues with vBulletin. I have inquired with our system administrator and this is what he said:
"I'm seeing a TON of slow queries on DB01 (master), and there are some queries running related to vbShop points logs which are using up alot of resources...
My MySQL server has gone away for a short time and later is appeared this voice in the Activity Feed.
DonVinc user has not write any entry in the blog.
How can I delete that entry in the Activity Feed?
Thank!
Hey All,
I just noticed that when I go to recent changes on VB Activity home that Achievements has over 10000 pages and Activity feed has over 600000. Is there a way to set any limitations as to how much info (1 day, 1 week, 1 month, 1 year, lifetime, etc) is shown?
I really don't need...
Hi,
I noticed that in my database there is a very large table named dbtech_vbactivity_pointslog: it is growing up quickly and it is now more than 500MB large. My entire forum database, without that table, would be of 100MB. Is there any chances to reduce that space? Or to archive the points from...
My points log table in my_sql is HUGE!!!
My server admin believe this is causing a lockup on MySQL when too many users are trying to access the forum at once.
How can I fix this issue? Any help will be appreciated.
activityactivityfeed
admin
database
delete
disable
dragonbyte tech
feed
forum
help
issue
mysql
only
options
points
prefix
server
settings
stats
timestamp
vbactivity
vbulletin
How remove year 1970 from activity feed? I run all recalculate stats and maintains in vbactivity settings in admincp ...but still shows 1970.
will attach picture ...
regards
bosss
After clicking activity and then clicking activity feed http://i.imgur.com/VFiGabF.png the whole site seems to go down, something clearly takes up a huge amount of processor.
this only lasts for about 30 sec but it is still quite significant
I tested this with 3.0.2 and then upgraded to 3.0.3...
Under Stats > Achievements tab
The Activity Page only displays the most recent page feed, no matter which page number you click on. It basically just refreshes the first page.
I tried repairing the cache.
I also noticed there have been no backups created. Could this be why?
Or could it just...
Activity Feed option dosn't work
the error is:
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT
pointslog.*,
user.*
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height...
That would be nice if "Activity Feed" could be turned into an "Activity Stream" that is integrated with the rest of your mods as well.
Example
XYZ was tagged in the thread Thread Title
XYZ was quoted in the post Thread Title#Post
XYZ was mentioned in Thread
XYZ mentioned ABC in Thread
XYZ...
4.2
activityactivityfeed
avatar
bbcode
block
cool
currency
design
feature
feed
flag
forums
html
live
mods
more
new
options
php
post
thread
vbaa
vbactivity
wall
widget
Out of the blue began receiving the following MySQL error:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT
pointslog.*,
user.*
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS...
Hello,
We were wondering if you currently have a mod somewhere or are developing a mod where we can set up a full paged facebook like activity feed and have the user land on it when they click on "forums" from our site.
This page would be dedicated just to having a full page facebook like list...
While we past month we had to disable this mod because when cron action ( I think that it is the cause) were starting around 12:10 the site was inaccessible for everyone
How could we fix it? We tried to disable "Activity Feed" but without success
activityactivityfeed
addon
amount
block
box
chat
color
config.php
cron
database
database error
disable
error
feed
free
group
help
hivelocity
issue
members
money
more
only
php
points
post
posts
pro
server
sql error
topic
upload
url
view
whm
I've installed the latest version and turned of the Enable Activity Feed thinking the dbtech_vbactivity_pointslog table would be deleted or emptied. But it is still 50MB with more than 500.000 records.
Can I delete it?
Hi gang,
Just updated likes/thanks to pro and latest version... 1.1.2
Now likes/thanks etc dont add to a users points, do not show in their profiles or display in the activity feed.
I also get this error when recalculation points.
Database error in vBulletin 3.8.6:
Invalid SQL:
SELECT *...