Update 1.0.0 to 1.0.1 on vb3.0.8 does not work

[jluerken]

Hi,

I tried to upgrade vba Links 1.0.0 to 1.0.1 and followed the upgrade instruction.

I changed /includes/init.php and /admincp/usergroup.php, uploaded all new files and ran the upgrade option.

I get the following error:

Database error in vBulletin 3.0.8:

Invalid SQL: UPDATE vb3_adv_setting SET optioncode = 'name', displayorder = '<select name=\"setting[$setting[varname]]\"> <option " . iif($setting[value] == 'name', 'selected=\"selected\"'). " value=\"name\">Name</option> <option " . iif($setting[value] == 'dateline', 'selected=\"selected\"'). " value=\"dateline\">Date Added</option> <option " . iif($setting[value] == 'lastpostdateline', 'selected=\"selected\"'). " value=\"lastpostdateline\">Last Post</option>' WHERE varname = 'links_deforder'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'name', 'selected=\"selected\"'). " value=\"name\">Name</option>

[Brian]

I've updated the files here to ensure that nobody else has this problem. To finish up your upgrade, just run this query and then edit your links settings and save them to update the cache and that should be it.

UPDATE adv_setting SET value = '1.0.1' WHERE varname = 'links_version';

[jluerken]

Thanks Brian but I had no links in the script so that I made an uninstall/install to bring the new version on :D

I will not announce the links script before I switched over to vB 3.5 :D

[Kaelon]

Looks like the recent update fubar'd the installation script:

Parse error: parse error, expecting `')'' in /home/httpd/vhosts/domain.com/httpdocs/forums/admincp/vbalinks_install.php on line 3547