Question Installation tips for those with large post tables?

[Morrus]

We had a similar problem with vBShop, but managed to persuade it to install after repeated tries. vBCredits is refusing to play ball, though - installation times out every time.

It's not a bug with the mod, but I assume I'm not the only person ever to try installing on a board with a large post table. Anyone got any tips on how they managed to get it working?

 

[Fillip H.]

Is this a first-time installation or an upgrade from a previous version of vBCredits?

 

[Morrus]

Good question - I did install it on my 3.8 board a couple of years back, but the hardware wasn't up the the task at the time and it slowed the board down too much. Since then the board has been upgraded to 4.2 and moved to a bigger server. So I'm not 100% sure whether any remnants of the old installation are still in the database.

Is there a way the post table alterations can be done manually via command line or something? And if so, will the import script then skip those alterations if I tried to run it again?

 

[Fillip H.]

This mod does not alter the post table in any way, so it's not that.

From what I recall with vBShop, your usergroup table also had major issues. How big is that?

 

[Morrus]

That one's about 130K users. Quite a big table.

 

[Fillip H.]

You have one hundred and thirty thousand usergroups?

You should look for the following columns:
user table: credits
user table: creditspermissions
usergroup table: creditspermissions
administrator table: creditspermissions

 

[Morrus]

You have one hundred and thirty thousand usergroups?

No, users. A dozen or so usergroups, which isn't many.

 

[Morrus]

Incidentally, I know you saw the other thread where I posted where the installation of vbshop stalled - it's not the same in this case. I'm not even getting the first item on the list - it just goes blank white pretty quick.

 

[Fillip H.]

There is no list during the installation of vBCredits, Darkwaltz4 opted to not include progress reports in his installer for some reason.

 

[Morrus]

Well, we're no closer to getting this thing to play ball.

The only thing I can think of is to do it manually by command line. Will that work? Will the install then skip the table adjustments part?

 

[Fillip H.]

No, the installer was created in such a way to attempt to be self-repairing, i.e. if the definition of a column changed, the installer will alter the existing column if it exists, or create a new one if it doesn't exist.

I don't believe it's possible to install a product via CLI either.

Can you please let me know the results of the investigation into what table alterations had been completed successfully as per my post listing the various vB tables and their columns?

 

[Morrus]

You have one hundred and thirty thousand usergroups?

You should look for the following columns:
user table: credits
user table: creditspermissions
usergroup table: creditspermissions
administrator table: creditspermissions

Sorry about the delay here. I was getting PHYMYADMIN installed so I could look.

NO -- user table: credits
YES -- user table: creditspermissions
YES -- usergroup table: creditspermissions
YES -- administrator table: creditspermissions

 

[Fillip H.]

Can you also check for these tables:
credits_action
credits_currency
credits_display
credits_event
credits_transaction
credits_pending

Some of those tables should be populated as well, namely display, action and event.

Also run this:

ALTER TABLE user ADD credits DOUBLE NOT NULL default '0'

Remember to add your table prefix if need be.

Once we've sorted out all the MySQL stuff, we'll just have you remove the installer code from the XML file entirely so that you will be able to install the product

 

[Morrus]

I have those and some more:

credits_action
credits_conversion
credits_currency
credits_display
credits_event
credits_payment
credits_pending
credits_redemption
credits_transaction

We're slighly outside my competency zone now, so I'm not sure how to check if any are populated. I clicked on action, and it showed a bunch of rows (actionid, title, description etc.) and a message saying "MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0002 sec )"

 

[Fillip H.]

Yeah, that's what I meant - if they are populated, they'd not show the empty result set message.

 

[Morrus]

Yeah, that's what I meant - if they are populated, they'd not show the empty result set message.

Ah, well in that case it looks like they're not populated.

 

[Fillip H.]

Are you able to provide me with access to phpMyAdmin? If so, I can manually sync up the tables with our installation.

 

[Morrus]

So I ended up paying someone to manually install it rather than use the XML file. It appears to be working now!