Error Installing vBa Links Directory v3.0

[grahamsmythe]

Installed v3.0 this morning, upgrading from v2.0.2.

I uploaded the files as instructed, and also changed the links/links_config.php.new file.

As I ran the installation script, a number of errors came up (I can't remember what they were, but 'Warning in Array' rings a bell).

When I turned the forum back on through the ACP, a database error occured.

I then tried downloading all the v2.0.2 files again to go back to that version. No luck there.

I then completely uninstalled vBa Links, and tried to reinstall v3.0, but still I get a database error

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT links.*, links_categories.title FROM adv_links AS links
LEFT JOIN adv_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE links.valid = 1 AND links.suspended = 0
ORDER BY rand() DESC
LIMIT 10;

MySQL Error : Unknown column 'links.suspended' in 'where clause'
Error Number : 1054
Request Date : Saturday, June 28th 2008 @ 03:26:38 AM
Error Date : Saturday, June 28th 2008 @ 03:26:38 AM
Script : http://www.vincentownersclub.co.uk/forum/
Referrer :
IP Address : 86.11.104.115
Username : MyUserName
Classname : vB_Database
MySQL Version : 5.0.27-standard

If I try and upgrade again, I get these errors

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/admincp/vbalinks_install.php on line 144
vBadvanced Links Directory Upgrade
Database error
The The Vincent H.R.D. Owners Club database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.vincentownersclub.co.uk home page, then try to open another page.
Click the Back button to try another link.
The www.vincentownersclub.co.uk forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


So that's pretty much where I am - anyone got any ideas, as my forum is completely broke at the moment, and I'm desperate

Cheers

[CareyCrew]

Not sure what your problem is Graham but I would strongly suggest you edit your post, there is way too much critical info about your database there for anyone unscrupulous to see.

[grahamsmythe]

Not sure which parts of my post you think contain the critical information.

I had a look through to make sure I wasn't giving too much away.

Which parts do you consider to be 'dodgy'?

Regards

Graham

[Brian]

Looks like you have some type of hack or custom code for vBa Links on your vB forum home. If you find the code from that hack and remove this part, that should take care of the issue.

AND links.suspended = 0

[grahamsmythe]

Hi Brian

Thanks for the quick reply - it really is appreciated, as the whole forum is down!

Give me a clue as to which file I should be looking in for this bit of code?

All I can find is in my latestlinks.php module

}

$getlinks = $vbulletin->db->query("
SELECT $votequery links.*, links_categories.title FROM " . TABLE_PREFIX . "adv_links AS links
LEFT JOIN " . TABLE_PREFIX . "adv_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE links.valid = 1 AND links.suspended = 0 $privcats
ORDER BY $orderby
LIMIT $limit
");
while ($link = $vbulletin->db->fetch_array($getlinks))
{


Graham

[Brian]

Looks like that would be the one. Just remove the code in red:
$getlinks = $vbulletin->db->query("
SELECT $votequery links.*, links_categories.title FROM " . TABLE_PREFIX . "adv_links AS links
LEFT JOIN " . TABLE_PREFIX . "adv_links_categories AS links_categories ON (links.catid = links_categories.catid)
WHERE links.valid = 1 AND links.suspended = 0 $privcats
ORDER BY $orderby
LIMIT $limit

[grahamsmythe]

OK, well the main forum and homepage etc seems to work OK now, but the 'Latest Links' module on our home page has stopped appearing.

Also, if you now go to www.vincentownersclub.co.uk/links - it displays a database error box and we then get e-mailed an error as follows:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_adv_links AS phrasegroup_adv_links,
language.phrasegroup_prefix AS phrasegroup_prefix,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 24;

MySQL Error : Unknown column 'language.phrasegroup_adv_links' in 'field list'
Error Number : 1054
Request Date : Saturday, June 28th 2008 @ 04:24:14 PM
Error Date : Saturday, June 28th 2008 @ 04:24:14 PM
Script : http://www.vincentownersclub.co.uk/links/index.php
Referrer : http://www.vincentownersclub.co.uk/forum/
IP Address : xxxxxxxxxxx
Username :
Classname : vB_Database
MySQL Version :


We have also had this one emailed to us
From: webmaster@vincentownersclub.co.uk
Subject: vBulletin Database Error!
Date: 28 June 2008 23:22:18 BDT
To: webmaster@vincentownersclub.co.uk

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_adv_links AS phrasegroup_adv_links,
phrasegroup_adv_links_moderate AS phrasegroup_adv_links_moderate,
phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
phrasegroup_prefix AS phrasegroup_prefix,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_adv_links' in 'field list'
Error Number : 1054
Request Date : Saturday, June 28th 2008 @ 04:22:18 PM
Error Date : Saturday, June 28th 2008 @ 04:22:18 PM
Script : http://www.vincentownersclub.co.uk/links/browselinks.php?ltr=R&catid=23
Referrer :
IP Address : 66.249.72.137
Username :
Classname : vB_Database
MySQL Version :


Just for the record, once we removed that bit of code from the latest links module, I went back - downloaded the Latest Links v3.0 software again, carefully installed it, then tried installing it (it wouldn't let me do it), then I tried upgrading it (it also wouldn't let me do it).

[Brian]

It looks like the script was un-installed since the phrase group is missing... You can try running the install file again and see if that helps. If not, please submit a support ticket and I'll take a look at things for you.

[grahamsmythe]

I've already tried to run the install file again, but it recognises that it's already installed, so I'll have to submit a support ticket.