Fatal Error: Line 114 of vbacmps_install.php

[Pirotess]

I'm having trouble getting vbAdvanced 2.0 RC2 for vBulletin 3.5 to properly upgrade my development board. I was able to successfully update the vBulletin software from 3.0.7 to 3.5 Beta 4 but I get the error listed in the title when I try to upgrade from vbAdvanced 1.0.0 to 2.0 RC2. Do I need to upgrade from 1.0.0 to 2.0 before I upgrade the vBulletin software? I have verfied my edits to the global.php file are complete and accurate.

[Brian]

I've just updated the install file in the package here. If you'll download it again and replace your install file with the one in the package then that should take care of the problem.

[Pirotess]

Made it a little further this time but bombed out on a SQL statement.

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
UPDATE phrase SET phrasetypeid = 1000 WHERE phrasetypeid = 9000 AND varname LIKE 'adv_portal%';

MySQL Error : Duplicate entry 'adv_portal_cant_remove_default-0-1000' for key 2
Error Number : 1062
Date : Friday, July 15th 2005 @ 02:32:23 PM
Script : http://XXXX.XXXXXXXXX.XXX/forums/admincp/vbacmps_install.php?do=upgrade&step=2
Referrer : http://XXXX.XXXXXXXXX.XXX/forums/admincp/vbacmps_install.php
IP Address : XXX.XXX.XXX.XXX
Username : XXXXXXX
Classname : vB_Database

Thanks for your help with this.

[Brian]

Looks like you made it *just* about to the end, but because you were updating from an older version it's running into problems. I've updated the install script in the package here to hopefully prevent anyone else from having a problem. To finish up your installation, go back to the install file and select the option to install only the templates from the main page. Then run this query through your Admin CP or phpMyAdmin:
UPDATE adv_setting SET value = '2.0 RC2 (vB 3.5)' WHERE varname = 'portal_version';

Next, edit your CMPS settings through the admin cp and save them. You don't actually have to change anything, just hit the save button so that the cache will be updated. Then, do the same thing with your phrases - Just edit and save one so that your language cache will be updated as well, and then you should be good to go.

[Pirotess]

Ok followed your instructions to the letter and got into the admin cp and refreshed both the phrases and CMPS settings. Unfortunately though there are still some pretty serious issues. Now I did make a backup of my DB from immediately after the successful upgrade to 3.5 Beta 4 so if you would like me to revert back to that to start fresh I can do that without much trouble. Anyway without reloading my database and following the instructions in post #4 I get the following errors in no particular order.

Bottom two sections under "Add Page" in vBa CMPS section have no text.

Clicking into any vBa CMPS section gives me the following error:

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /admincp/vba_cmps_admin.php on line 196

I should take this moment to tell you Im running PHP 5.0.4 which I believe is what causes those errors.

Clicking "Edit Pages" gives:


Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
SELECT * FROM adv_pages ORDER BY displayorder;

MySQL Error : Unknown column 'displayorder' in 'order clause'
Error Number : 1054
Date : Friday, July 15th 2005 @ 03:12:30 PM
Script : http://xxxxxxxxxxxxxxxxxxxx/forums/admincp/vba_cmps_admin.php?do=listpages
Referrer : http://xxxxxxxxxxxxxxxxxxx/forums/admincp/index.php?do=nav
IP Address : XXX.XXX.XXX.XXX
Username : XXXXXXX
Classname : vB_Database


Clicking the very bottom section which has no text produces

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
SELECT pageid, title, parentid, userperms FROM adv_pages ORDER BY displayorder;

MySQL Error : Unknown column 'parentid' in 'field list'
Error Number : 1054
Date : Friday, July 15th 2005 @ 03:13:58 PM
Script : http://XXXXXXXXXXXXXXXXXX/forums/admincp/vba_cmps_admin.php?do=permissions
Referrer : http://XXXXXXXXXXXXXXXXXXXXX/forums/admincp/index.php?do=nav
IP Address : XXXXXXXXXXX
Username : XXXXXXXX
Classname : vB_Database

[Pirotess]

Ok I just restored my DB to after the 3.5 Beta 4 upgrade when vBadvanced CMPS was still at 1.0.0. I then used the 3:18pm vbacmps_install.php to upgrade and it went through entirely clean. The only unexpected thing that happened is instead of providing the screen that links you to the admin cp it told me this:

"You are running a version of vBadvanced CMPS prior to 1.0.0. Please upgrade to 1.0.0 or 1.0.1 before continuing."

I just went to my admin cp and poked around and all the errors I listed in the above post are entirely gone and my home page loads clean. Looks like a pretty minor error left to fix and your installer is gtg.

[Brian]

Was the error message the only thing shown, or did it print out some other stuff (like "Updating Templates...", "Updating Phrases...", etc)?

[Pirotess]

The error message was just where the screen stopped. Before it got to that point, I got all the Updating Messages. Those went through clean and the dev site is working fine. I've been clicking around it for a good 30 minutes with no problems.