timestamp

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

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

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

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

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

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

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.

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

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>]...

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

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

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

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

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

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

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

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.

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

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

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