Bug Database error and Maintenance (in ACP) error

[Sunka]

This is Database error that come to my email every 10 minutes

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT 
		dbtech_thanks_likes,
		dbtech_thanks_liked,
		dbtech_thanks_thanks,
		dbtech_thanks_thanked
		FROM user
		WHERE userid = 1;

MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 21st 2011 @ 01:30:11 AM
Error Date    : Friday, January 21st 2011 @ 01:30:12 AM
Script        : http://www.pijanitvor.com/cron.php?rand=1295569810
Referrer      : http://www.pijanitvor.com/showthread.php?t=8839&p=118840
IP Address    : ***********
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

---------------------------------------------------------



Second error is in ACP in Maintenance section of Like/Thanks MOD
All 3 options are in loop. When you click on "Clean up", or "Recalculate"... it's just loading and loading forever and ever....

 

[Fillip H.]

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT 
		dbtech_thanks_likes,
		dbtech_thanks_liked,
		dbtech_thanks_thanks,
		dbtech_thanks_thanked
		FROM user
		WHERE userid = 1;

MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 21st 2011 @ 01:30:11 AM
Error Date    : Friday, January 21st 2011 @ 01:30:12 AM
Script        : http://www.pijanitvor.com/cron.php?rand=1295569810
Referrer      : http://www.pijanitvor.com/showthread.php?t=8839&p=118840
IP Address    : ***********
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

This is a bug in vBExperience's integration with APTL.

It is nothing I can fix.

Second error is in ACP in Maintenance section of Like/Thanks MOD
All 3 options are in loop. When you click on "Clean up", or "Recalculate"... it's just loading and loading forever and ever....

It's not forever, it will end eventually
It just has no output for you to read.

 

[Sunka]

This is a bug in vBExperience's integration with APTL.

It is nothing I can fix.

So, I should ask on vBExperience topic on vB.org for help

It's not forever, it will end eventually
It just has no output for you to read.

I have waiting for 5 minutes (to recalculate only 2000 users).

Try it your self, you have password for ACP

 

[Fillip H.]

You don't need to run Clean Up, and recalculate is moving along just fine for me

 

[Sunka]

When delete (empty) trash subforum on my forum, after that, I run all 3 options usually.

 

[Fillip H.]

For a future version we will add some output to the Cleanup function then

 

[Sunka]

OK, so for all 3 options, I just leave it untill finished?

It is strange for me, because in previous version it is take only 1 minute....

 

[Fillip H.]

Yeah pretty much

 

[Sunka]

OK!

I disabled "vBExperience's integration with APTL" for now. It is OK now - no errors (but not points for thanks/likes too)

-----------------------------

And for Maintenance in ACP, please put some results, not just static window....

---------------------------------------

Please look for pop-up error solution (another topic)

------------------------------------------

And please in another update, integrate option for link in menu (wit option which group see, and whish does not see) for statistics and entries

(http://www.********/thanks.php?do=statistics)

 

[Sunka]

Trying to do recalculating ==> 20 minutes so far and still running (2200 users on my forum)

 

[Sunka]

As I wrote here, Cosmic asked me to report bugs into this subforum, and Fillip H. tell that is better that every bug have own thread, so here it is... I just bump this thread because problem is stil alive and I hope that it will be fixed in new 2.0 version...

One part of problem (explain in this thread) still exist. Every time I need to do recalculating it is so long..... Even if I choose only 50 number of users to process per cycle. Please do not say that I do not need Recalculate, Clean Up and Rebuild Statistics, because I have to. When I delete lot of "off topic" post on my forum, I try to clean up statistics and also do Thanks Maintenance. It is so slow, very slow. Please read this topic again (error with xperience MOD is solved with uninstalling that Mod).

 

[Fillip H.]

Sorry, that is not an issue we're able to solve. Large forums will have large amounts of data to process, and large amounts of data takes a long time to process.