Bug Slows down forum dramatically

[JBlaze]

credits_transaction table

Hey, I have a major issue. I just moved my databaes ( fully restored via ssh) and credits_transaction table is missing so i cannot enable vbCredit, tried running installer again to fix it but that didn't work, got a solution for me?

 

[Mokonzi]

Can you access vbCredits at all via the AdminCP?

I'd suggest creating the table and then recalculating/counting the credits, though this will 'reset' everything. Other than extracting the data from a backup of your database, I don't see another solution.

 

[Darkwaltz4]

The installer will indeed create the table if it is actually missing. Are you saying you cant access the admincp to run the installer?

 

[JBlaze]

The installer will indeed create the table if it is actually missing. Are you saying you cant access the admincp to run the installer?

When I run the installer, loads for 2 min and that same database error comes up (missing transaction table). Should I tick over write?

 

[Darkwaltz4]

Disable vbcredits before running the installer again (with allow overwrite)

 

[Darkwaltz4]

After some extensive profiling with the help of mokonzi, I think I've ironed out the query causing all the lag. You'll have to run this query:

ALTER  TABLE `credits_transaction`  ADD  INDEX (`status` ,  `userid` ,  `timestamp`)

Be sure to add your table prefix if using one.
Give it a couple minutes, and see if the CPU load and/or rendering speed of your site has improved.
Let me know!

 

[Darkwaltz4]

For all the the guys who posted performance issues that have been merged into this thread, see the previous post on how to fix it!

 

[rootsxrocks]

For all the the guys who posted performance issues that have been merged into this thread, see http://www.dragonbyte-tech.com/thre...rum-dramatically?p=23904&viewfull=1#post23904 on how to fix it!

That link isn't working now, and I suddenly had issue with my secondary currency failing to work with vbookie creating a new event. this was without any other changes updates or additions. I am unsure if the server has had any updates that might have affected this. Has this Fix been integrated into the current install file ? or is there a new release that is coming soon ?

 

[Cosmic]

That link isn't working now, and I suddenly had issue with my secondary currency failing to work with vbookie creating a new event. this was without any other changes updates or additions. I am unsure if the server has had any updates that might have affected this. Has this Fix been integrated into the current install file ? or is there a new release that is coming soon ?

Could you create this as a new issue? This one is marked as fixed and it makes it much more likely that your post will be missed as a result.

Cosmic

 

[Darkwaltz4]

the link above the the post with the link contains the query you need to run.

it hasnt been put into the customer version, because i havent figured out a decent way to selectively apply such a query (it builds a new index), since i dont want to be needlessly reapplying that for every upgrade, but if you are affected by it you can apply it manually right away.