Error During Install.

[ECMatt90]

I keep getting an error. I have uninstalled and re-installed. Re-downloaded and so forth. Here's the error.

Database error in vBulletin 3.7.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile, datatype, product, validationcode, blacklist)
VALUES (
'vba_links_homeurl',
'version',
'',
'',
'',
'1000',
'0',
'1',
'free',
'adv_links',
'',
'0'
), (
'vba_links_title',
'version',
'',
'',
'',
'1010',
'0',
'1',
'free',
'adv_links',
'',
'0'
), (
'vba_links_addnavbar',
'version',
'',
'',
'',
'1010',
'0',
'1',
'free',
'adv_links',
'',
'0'
), (
'vba_links_addnavsearch',
'version',
'',
'',
'',
'1010',
'0',
'1',
'free',
'adv_links',
'',
'0'
);

MySQL Error : Duplicate entry 'vba_links_homeurl' for key 1
Error Number : 1062
Request Date : Tuesday, September 16th 2008 @ 10:47:39 AM
Error Date : Tuesday, September 16th 2008 @ 10:47:43 AM
Script : http://www.theburningreel.com/forums/admincp/vbalinks_install.php
Referrer : http://www.theburningreel.com/forums/admincp/vbalinks_install.php
IP Address : 71.2.232.246
Username : FairWeather
Classname : vB_Database
MySQL Version : 5.0.67-log

[ECMatt90]

and when I load my page www.*****.com/links I get this error

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_class.php on line 325

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_functions_cats.php on line 435

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_functions_cats.php on line 43

[Our Sponsors]

[Brian]

Thank you for pointing this out. Looks like the new vB settings that were added in 3.0.0 were not being deleted when uninstalling. I've just updated the forum/admincp/vbalinks_install.php file here correct this, so if you will download the files from here again and update that one on your server, you should then be able to use the Un-install option to remove those and then re-install.

[ECMatt90]

Brian,

I know have it installed right I think, but I have two issues..

1. I'm getting an error message at the top of the screen on only the main page.
2. The border on my page is getting cut off also, only on the main page (please see where arroow is).

Any assistance would be appreciated.

Here's a picture to help show you.

[Our Sponsors]

[ECMatt90]

No Worries Brian..

I got it!!! Thanks again!!!

[drynax]

What did you do to fix this error? I'm getting the same thing.

------------------------
No Worries Brian..

I got it!!! Thanks again!!!

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

Update: Brian wrote in another thread, "Sounds like you did not fully re-install. I would suggest using the vbalinks_install.php file to un-install and then re-install. If you still have the same error afterwards please submit a support ticket via the Members' Area here."

This fixed it.

[lostcode]

We just installed the latest code. www.unix.com/links

It was working fine, then it stopped working with these errors:

Getting these errors:


Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_class.php on line 325

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_functions_cats.php on line 435

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_functions_cats.php on line 43

Fatal error: Cannot use string offset as an array in /website/www/includes/vba_links_functions_cats.php on line 86


And CP errors in Main Index Page Options:

Warning: Invalid argument supplied for foreach() in [path]/includes/vba_links_adminfunctions.php on line 419

Errors come and go .....

[Brian]

Sounds like something may have become corrupted with the category cache. Try saving one of your categories through the Admin CP to update the cache and see if that takes care of the problem.

[lostcode]

Sounds like something may have become corrupted with the category cache. Try saving one of your categories through the Admin CP to update the cache and see if that takes care of the problem.

The problem seems to have been from our vBoptimize plugin (http://www.vbulletin.org/forum/showthread.php?t=199207). To stop the intermittent errors we have turned off datastore cache. Hopefully, this will stop the errors.

From the vBoptimize datastore cache settings description:

Currently, vBulletin has the ability for modification authors to allow datastore items to load at the start-up of vBulletin, this is useful for modification authors who use custom datastore data in existing areas of vBulletin. This addition however can cost users with any of these modifications an additional query on pages.

If you turn this setting to Yes, vB Optimise will take the custom datastore data and ensure it uses the proper datastore method that you have chosen to use in your vBulletin configuration, eliminating the extra query used on your pages. Note that if you have not set up your vBulletin installation to use any special means of vBulletin datastore (Filecache, XCache, etc..), or if you have no modifications that trigger this extra query then this setting will have no impact on your forums performance.

www.unix.com/links