Bug Type ID missing

[lespauldouble]

Seem to be having all kinds of issues using this program with 4.2.1

The create contest has no contest type in the drop down menu.

Still getting errors uploading the vbactivity-export file as well. Missing ID

 

[Fillip H.]

This is not a bug.

Please click "Repair Cache" in the left side menu before attempting any further actions.

 

[lespauldouble]

This is not a bug.

Please click "Repair Cache" in the left side menu before attempting any further actions.

Have ran the cache and repair tables several times, Create contest dropdown is still blank. Program worked flawlessly on first instal with 4.1.12

 

[Fillip H.]

Please check the contents of your dbtech_vbactivity_type database table - is that empty?

If so, you may have a cache system that interferes with normal operation of the site, such as an overzealous APC/XCache installation.

 

[lespauldouble]

Please check the contents of your dbtech_vbactivity_type database table - is that empty?

If so, you may have a cache system that interferes with normal operation of the site, such as an overzealous APC/XCache installation.

When you say table, you are not talking file size correct? Is there a way to check the table within vb?

 

[Fillip H.]

Under the Maintenance menu, hit Execute SQL Query and enter

SELECT * FROM dbtech_vbactivity_type

Ensure you add your table prefix if you use one (this can be found in config.php and is not used by default).

 

[lespauldouble]

Under the Maintenance menu, hit Execute SQL Query and enter

SELECT * FROM dbtech_vbactivity_type

Ensure you add your table prefix if you use one (this can be found in config.php and is not used by default).

Prefix on config is vBulletin where would that go on this string

 

[lespauldouble]

I went right up into the root directory and there is no table by that name at all. All the other ones appear to be there associated with the vbactivity

 

[Fillip H.]

In front of dbtech_vbactivity_type like so:

SELECT * FROM vBulletindbtech_vbactivity_type

That's assuming your config.php variable looks like this:

$config['Database']['tableprefix'] = 'vBulletin';

 

[lespauldouble]

In front of dbtech_vbactivity_type like so:

SELECT * FROM vBulletindbtech_vbactivity_type

That's assuming your config.php variable looks like this:

$config['Database']['tableprefix'] = 'vBulletin';

Just ran that query and it came back with 3 pages of info on it

 

[Fillip H.]

Okay, then the issue is most likely that you have another product of some description interfering with your datastore cache. Are you running vB Optimise Lite?

If so, please try flushing its cache.

 

[lespauldouble]

Its a bit weird becuase it worked perfectly before I put it on 4.2.1 but I had to delete all my files and do a fresh install of vbulletin and used a backup of a database I had which contained the vbactivity data. But once I uploaded a fresh copy of vbactivity you would think it would work fine

 

[Fillip H.]

I can't think of a reason why that would cause such an issue either :S