Can someone help explain what is causing these dbase errors and help me fix it?

[Blue91]

I opened my Dbaseerrors.log.log file today to find a ton of these errors...

They started on May 31st and occur numerous times a day, up through now...

================================================== ===

Database error in vBulletin 3.8.2:

Invalid SQL:

INSERT INTO taggregate_temp_1245268560
SELECT threadid, COUNT(*) AS views
FROM threadviews
GROUP BY threadid;

MySQL Error : Can't find file: 'threadviews' (errno: 2)
Error Number : 1017
Request Date : Wednesday, June 17th 2009 @ 03:57:12 PM
Error Date : Wednesday, June 17th 2009 @ 03:57:12 PM
Script : http://www.pomoforacing.com/forums/cron.php?rand=1245268631
Referrer : http://www.pomoforacing.com/forums/search.php?searchid=132191
IP Address : 71.49.161.29
Username : Unregistered
Classname : vB_Database
MySQL Version :
================================================== ===

Database error in vBulletin 3.8.2:

Invalid SQL:

INSERT INTO taggregate_temp_1245272160
SELECT threadid, COUNT(*) AS views
FROM threadviews
GROUP BY threadid;

MySQL Error : Can't find file: 'threadviews' (errno: 2)
Error Number : 1017
Request Date : Wednesday, June 17th 2009 @ 04:56:57 PM
Error Date : Wednesday, June 17th 2009 @ 04:56:57 PM
Script : http://www.pomoforacing.com/forums/cron.php?rand=1245272217
Referrer : http://www.pomoforacing.com/forums/search.php?searchid=132198
IP Address : 71.49.161.29
Username : Unregistered
Classname : vB_Database
MySQL Version :
================================================== ===



I also notice a LOT of "vbupload" files have been created in my forums directory also. The names are random, but all start with vbupload. Example: vbuploadZkd5c9. If I try to download the file, it says permission denied. I'm thinking these are related, but the creation dates for these are very random and date back before the first entry in the dbase error log (May 31).

Can anyone tell me what is causing them? I haven't added any mods to my forums during this time and have received zero complaints from users about the forums.


Thanks in advance.

[Lynne]

Do you have a table called threadviews in your database?

[Blue91]

Hmm, I don't remember the exact date I updated to 3.8.2, but I wonder if this coincides with that. Hmm.

--------------- Added 1245276562 at 1245276562 ---------------

I cannot access mysql from here at work so unless there's a way to determine this via my vbadmincp, I cannot answer at the moment.

[Blue91]

According to my admincp area where I would go to backup the database, the "threadviews" is a table I have the option to back up. So yes.

However, in visiting this section of my admincp, I notice that I have a exactly 335 tables like shown below that shouldn't be there... this is related to the errors.

What the heck is causing these to show up?

[Lynne]

You need to fix your licensing issue.

***********
Blue91,

You are currently showing up as unlicensed.

To be able to download modifications and/or receive support here at vBulletin.org, we ask you to please click here (http://members.vbulletin.com/membersupport_priority.php) (vB-Germany users click here (http://members.vbulletin-germany.com/membersupport_priority.php), vB-Chinese users click here (http://members.vbulletin-china.cn/membersupport_priority.php)) and enter your email address. You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

To protect our customers privacy you will also need to Opt-In to license validation for all Support Sites. You must authorise vBulletin.org in order to validate your license status here. You can do this at the page linked above for your distributor. Make sure to set the permission to allow vBulletin.org to validate your status.

The update of your account can take up to one hour.

Thank you.

[Blue91]

I had changed my contact email here, so I had to go over to .com and update it there as well.

So back, to my issue. Looks like something is creating errors AND adding tables to my database. What the heck? My 3.8.2 files are dated 5/21/09 and I started having my issues on 5/31, so I wonder if it has something to do with my update to 3.8.2.

Let me know what else you'd like to look at or have access to in order to help. Thanks.

[Lynne]

Those are temporary tables, and vb creates them sometimes when doing queries. I'm not really up on them, but I have seen other users complain about them being left around due to some problem with their database also.

Have you tried running a repair/optimize on the threadviews table? Perhaps it has crashed (have you seen any errors about that in your many emails?).

[Blue91]

I repaired and optimized the threadviews table in the dbase. It shows there's no data in the threadviews table. My Jan backup had no data in this table also.

Crap, this sucks b/c I have no idea how to fix it. Those taggregate tables are adding a ton of tables to my dbase and it might be getting worse the longer I don't fix this issue... Right now, it's at 509 tables, with at least 335 being those crap tables. My backup from Jan has 89 tables, lol. FWIW, the normal tables say the "TYPE" is MylSAM. The taggregate table "TYPE" is "MEMORY". Not sure if that'll help someone looking at this.

Ugh. Any more recommendations? Should I post this in a different forum to get more views/opinions?

[Lynne]

This is the correct forum. If you posted it in another forum, it would just be moved here.

Have you thought about just putting in a support ticket at vb.com if you are worried about all the tables?

[Blue91]

I'm trying but due to my email change today, I cannot post over there right now. I can post here just fine though.

I did a search over there and found a few people who had issues with this with 3.6 and 3.7. Haven't seen anyone with 3.8 post about issues.

I think it has something to do with my change from 3.8.1 to 3.8.2. I'm going to try to go to 3.8.3 and see if they continue (as well as post up on vb.com as soon as they fix my access). I own two VB licenses... been a member since like 2002 and started out with VB 2.2.5, haha.