I'm attempting to use another mod's existing points; vbexperience to be exact. I noticed that they are stored in two different locations. Once in the user table, and another in 'xperience_stats' > 'points_xperience'. However when I choose the xperience_stats as the Points Table the points do...
Invalid query: Duplicate entry '28804' for key 'PRIMARY'56
When I click certain threads/categorys I get the above error.
I had Vbulletin look into the problem and they didn't know what it was. They suggested I disable SEO and remove the SEO code in .htaccess and the problem went away.
I am...
Upon importing the latest version of the mod, i received the following message:
Database error in vBulletin 4.2.2:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT IGNORE INTO dbtech_thanks_recententry
(`entryid`, `varname`, `userid`, `contenttype`, `contentid`...
I am having a problem when installing vBNotifications to my server.
When importing the xml file I get the following errors...
Warning: mysqli_query() [function.mysqli-query]: (HY000/2006): MySQL server has gone away in ..../includes/class_core.php on line 1393
So you can see what line 1393...
We're having very similar problems to http://www.dragonbyte-tech.com/f37/absolutely-abysmal-performance-14410/ but I didn't want to hijack his thread.
We've added quite a few indexes to the dbtech_thanks_entry table to get it perform acceptably, however now that we're well over 7.5 million...
123
404
comment
copy
count
database
dbtech_thanks_entry
different
forums
group
help
issue
monster
more
performance
post
query
server
specific
ten
test
thread
threads
timestamp
url
vboptimise
We had extremely high hopes for this addon but it absolutely crippled our database. We have roughly 8 million 'thanks' in our system and upon activating this product, we went from 0% CPU usage on our DB server to 25% nearly instantly. Eventually the connections piled up and the database server...
addon
amount
count
database
extremely
forum
help
instance
issue
money
mysql
new
number
performance
post
posts
query
request
server
specific
support
ten
test
thread
Hi
I have lot of this on error_log:
[07-Mar-2014 12:11:24 Europe/Berlin] PHP Warning: preg_match() [<a href='function.preg-match'>function.preg-match</a>]: Compilation failed: missing terminating ] for character class at offset 102 in...
Hi,
i post all of it here
http://www.dragonbyte-tech.com/f239/no-automatic-sitemap-generation-after-upgrade-1-0-4-a-14122/
and i reduce the number of items and test it (5000 and a day later 500) but no chance.
Do you have any ideas?
class_core
database
dbseo
download
error
fatal error
help
issue
logs
news
number
only
php
post
posts
query
sitemap
size
test
upgrade
upload
url
vbulletin
Hi Fillip H.,
sorry to bother you in another place but in my quest for vbseo removal I need to take care of thanks/vbseo likes. I've successfuly installed the lite version of the plugin and imported the vbseo likes. Recreated statistics and turned the plugin on. But the load on mysql server...
4.2
count
database
dbtech_thanks_entry
feature
forum
large forum
lite
mysql
number
only
performance
post
posts
query
question
server
statistics
stats
ten
test
thread
topic
vbseo
version
Found these in my slow query Log:
Not sure if this is vbulletin Tags or the advanced tags????
Feel free to delete if nothing to do with this modification :)
# Time: 140225 9:23:19
# User@Host: ****** @ [127.0.0.1]
# Thread_id: 317407 Schema: vb44 QC_hit: No
# Query_time: 10.502251...
Parse error: syntax error, unexpected $end in /home2/public_html/forum/dbtech/thanks/actions/admin/search.php on line 55
Line 55 is a blank line...
I am testing this on my local host before I move to my production board.
admin
button
cache
copy
copyright
dbtech_thanks_entry
error
features
forum
hidden
html
install
issue
more
only
php
prefix
pro
query
request
server
upload
view
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...
Fatal error: Call to a member function query_write() on a non-object in /home3/maxces/public_html/global.php(29) : eval()'d code on line 133
When I put the info in the htaccess file I get this error if clicking on any forum section
I can send any admin my htaccess if needed
I have vbseo and installed dbseo and imported the older vbseo setting so now-
1) mark forms read does not work I just get a white page
2) some links work and some don't link this one- 400 Bad Request
I'm using the default htppacess file
need help asap!
attachment
characters
dbseo
display
error
fatal error
folder
forms
forum
forums
help
html
issue
member
new
php
post
pro
query
request
test
url
user
vbseo
If got to view transaction log and get error : /vbshop.php?do=transactionlog
Warning: mysqli::query() [mysqli.query]: (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1 AND dateline...
Was running vbseo and vb3.8 previously and recently upgraded to vb4.2.2 and DBseo.
I installed a cert and urls should be https.... performed the vBseo import and disabled the plug in.
So tot he best of my knowledge I should be squared, however I getting db error the appear to pointing to http...
ajax
attachment
attachments
cache
dbseo
error
forum
help
htaccess
images
import
more
number
php
post
query
template
thread
vb4.2
vb4.2.2
vbseo
vbulletin
version
getting an error when trying to install reviews lite.
everything seems to be going fine,
then it starts upgrading to 1.0.0
It rebuilds the styles and then it comes up with:
Invalid SQL (this is huge and it never posts when I paste it in here, so it's in the attached .txt file)
MySQL Error...
admincp
attachment
away
class_core
comment
documentation
error
forums
html
import
install
language
lite
mods
mysql
number
php
posts
query
question
server
styles
update
upgrading
url
version
window
Hi Mokonzi,
First off thank you very much for the notification system - I love that, that will be so helpful!!!
Just a quick one regarding the notification system.
I have to explain that since the early betas I have had one item awaiting moderation in the queue but there is nothing that...
I've tried to transfer my forum from vbseo to dbseo tonight, but there was a significant increase in database load and had to revert the procedure. There was a huge spike in query numbers with dbseo and althought the queries themselves didn't seem to be very intensive - the sheer number of them...
apc
big board
caching
copy
count
database
datastore
dbseo
dbseo load
different
forum
memcache
memcached
more
number
only
optimize
performance
php
post
query
server
threads
transfer
vbseo
Hi Mokonzi,
Found this little error in my php-error logs.
As said in another thread this might be something to do with my site, but thought I would report it :)
Call to a member function query_first() on a non-object in /**********/forum/dbtech/classifieds_pro/hooks/notifications_list.php...