timestamp

  1. H

    Question Slow Queries

    This particular query started running really slow today: # User@Host: root[root] @ [10.0.0.3] # Thread_id: 443035 Schema: lipstick_forum QC_hit: No # Query_time: 979.511385 Lock_time: 781.017818 Rows_sent: 0 Rows_examined: 0 SET timestamp=1398816291; DELETE FROM dbtech_thanks_recententry...
  2. J

    Bug performance issues on big-boards with lots of thanks/likes

    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...
  3. J

    Bug Weird Code on Members page likely related to Shout

    Hi, Installed vBShout at the weekend and today a member is saying hes getting weird code when viewing the forum home page. I've attached the code as a txt file but to me it looks like some sort of programming code like java but rather than parsing its getting displayed instead of the html...
  4. M

    Bug Slow MYsql Query

    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...
  5. mrderanged

    Question Error Uploading Files

    Trying to upload the files for the lite version of classifieds to test it out. Everything uploads fine except for dbtclassifieds.php & dbtclassifieds_gateway.php I keep getting "critical file transfer error" "could not start transfer" I just downloaded the package, not sure what's going on...
  6. Nirjonadda

    Bug Invalid SQL

    Do I Restart MySQL Server than continue receiving emails from Database error . As same user and Script/Referrer. Database error in vBulletin 4.2.2: Invalid SQL: INSERT INTO vbcredits_pending (eventid, actionid, userid, timestamp, checkstamp, amount, referenceid, forumid, ownerid, multiplier...
  7. H

    Question Expired item: Invalid shop ID: After upgrade to 3.1.1

    I started getting this error during the Item Duration cron job after upgrading to the latest version of the shop. It causes such a huge load spike on the server I had to disable the shop. Any idea what caused it and how to fix it? Every item in the shop generates an Invalid shop ID error message.
  8. bzcomputers

    Legacy Ability to view more detailed Sitemap Statistics

    I would like to be able to view more detailed sitemap statistics. Currently there is just a log of sitemap hits, for when a spider views a sitemap .xml. It would be more useful if there was a sitemap statistics view where users could see stats from each sitemap build with a build date/time...
  9. neounix

    Bug Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96

    FYI: [15-Dec-2013 11:13:02] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96 [15-Dec-2013 11:13:02] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]...
  10. bzcomputers

    Bug When publishing CMS article I get a 500 server error and 28 posts get created in db

    I did see this happen about a week ago when I created a CMS article and it just happened again a few minutes ago. I then retested and got the same thing. I can't say for certain it's DBSEO but I don't believe I've changed anything on the server other than DBSEO updates and the recent...
  11. D

    Bug Recalcuale user accounts problem

    Hello, i have a database error on recalculate user accounts: Database error in vBulletin 4.2.2: Invalid SQL: DELETE FROM credits_transaction t WHERE userid = 2025 AND timestamp >= 1320887100 AND timestamp <= 1384554120 AND eventid IN (19, 25, 37, 35, 36, 28, 29, 18, 24, 20, 21, 34, 33, 23...
  12. B

    Question Errors when importing games (ibpro)

    Hello Have board 4.2.2 (new installation) and your latest arcade. When import games get this errors in my admincp: Warning: Only variables should be passed by reference in ..../dbtech/vbarcade/systems/ipa.php on line 248 Warning: Only variables should be passed by reference in...
  13. Jonty

    Question AOP with Load balanced servers (EC2)

    Hi there, I've purchased vBShout, and i'm keen to install it on my forums. The trouble is, the forums are load balanced EC2 instances, i.e. multiple file systems. This is fine for most of your plugins, as most dont write to the file system, but this one appears to. The problem is with the...
  14. A

    Bug Viewing of credits transaction in admincp - Database error.

    Hi, After upgrading to the latest vbcredits version. When I try re-calculate users accounts and click on a username to view their transaction. It shows me this error message: Please rectify? Thanks. Database error in vBulletin 4.2.1: Invalid SQL: SELECT * FROM credits_transaction WHERE...
  15. overlord

    Bug Undefined offset?

    I'm getting the following errors in my php error log (I've taken of the timestamp and shortened the path for easier reading) PHP Notice: Undefined offset: 1 in <home Directory>/core/packages/dbtechvbshout/api/vbshout/shoutbox.php on line 652 PHP Notice: Undefined index: dbtech_vbshout_pm in...
  16. Bounce

    Bug Database Errors

    Hi Guys, I'm getting database errors whilst my users use this.... Database error in vBulletin 4.2.1: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid...
  17. Bullmama DeLano

    Question Database points log

    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.
  18. P

    Bug vBActivity - Build Points Cache scheduled task crashing DB

    Support, We have a major problem with inefficiencies in the DBTech plugins. Specifically, the VbActivity plugin is crashing our site/DB every day when the "DragonByte Tech: vBActivity - Build Points Cache" scheduled task runs. The table it is locking is 7.5GB with 40.5 million rows. Whenever...
  19. T

    Bug Database error

    Hello, We found this email: Could you please investigate this error? Thank you
  20. Davagator

    Question import errors

    On a fresh install of VB and the arcade, when I try to import a .tar game I get: Warning: asort() expects parameter 1 to be array, null given in [path]/dbtech/vbarcade/functions_arcade.php on line 328 Warning: Invalid argument supplied for foreach() in...
Back
Top