vBa CMPS 2.0 RC2 (vB 3.5) Released!

[Brian]

vBadvanced CMPS RC2 (vB 3.5) has just been released and is available for download in the 'Programs / Scripts' section of the site here. This is our newest version, designed to work with vBulletin 3.5. The options and features are the same as the 3.0 version with the emphasis placed on getting a stable version of the product with as few bugs as possible released. For those who are ready to upgrade, you will find instructions in the readme file included in the zip package.

[ConqSoft]

I noticed that the readme has this near the top:

"Tested and stable with vBulletin 3.01, 3.00, RC1, RC2, RC3." :)

[Brian]

Whoops... Can you tell I was in a hurry? :o

[Ogden2k]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLE adv_pages ADD meta TEXT NOT NULL, ADD displayorder SMALLINT(4) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'meta'
Error Number : 1060
Date : Sunday, July 10th 2005 @ 07:40:04 PM
Script : http://dev.techiehq.net/forums/admincp/vbacmps_install.php
Referrer : http://dev.techiehq.net/forums/admincp/vbacmps_install.php
IP Address : 69.173.155.251
Username : Admin
Classname : vb_database
Not sure what to do.

I had 3.0.7 and CMPS 1.0.1 on the dev board, upgraded to 3.5.0 B3 and now I'm attempting to upgrade CMPS. I have edited the files.

Edit: I'm able to update the templates and phrases, but still cannot upgrade the version.

[mholtum]

I get an error when installing:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NUL
Error Number : 1064
Date : Sunday, July 10th 2005 @ 04:44:51 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

[Shon]

So the 3.5 version still requires file modification?

[TTG]

Database error !?

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL' at line 1
Error Number : 1064
Date : Monday, July 11th 2005 @ 01:32:48 AM
Script : http://213.230.203.86/~thetechg/place/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 82.43.102.40
Username : The Tech Guy
Classname : vb_database

[Ian]

To solve that find "ALTER TABLE" and replace it with "ALTER TABLE " (note the space) using whatever text editor you prefer.

However, you'll get another one later that is to hard for me to figure out with my knowledge of MySQL.

Invalid SQL:
INSERT INTO plugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' ' = str_replace(
array(
'"login.php',
'"profile.php'
),
array(
'"' . Array['bburl'] . '/login.php',
'"' . Array['bburl'] . '/profile.php'
),

);

= str_replace('"forumdisplay.php', '"' . Array['bburl'] . '/forumdisplay.php', );', 'vbulletin', 'vba_error', 1);

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 'profile.php'
),
array(
'"' . Array['bburl'] . '/lo
Error Number : 1064

[Brian]

For anyone that's getting the invalid SQL errors, if you'll download the package from here again, uninstall, and then reinstall that should take care of the problem. I assume these have been installs on test boards, but if anyone was running the install on their live forum and doesn't want to uninstall please submit a support ticket and I will take care of things for you.

[RetroDreams]

I just downloaded it and I'm still getting the Alter SQL error listed:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL' a
Error Number : 1064
Date : Sunday, July 10th 2005 @ 10:01:58 PM
Script : http://localhost/irishenvy/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 127.0.0.1
Username : Svoboda
Classname : vb_database

[mholtum]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NUL
Error Number : 1064
Date : Sunday, July 10th 2005 @ 08:14:06 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

hmmmm

[RetroDreams]

Okay, fixed the space issue as mentioned above and now get:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
INSERT INTO plugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' ' = str_replace(
array(
'"login.php',
'"profile.php'
),
array(
'"' . Array['bburl'] . '/login.php',
'"' . Array['bburl'] . '/profile.php'
),

);

= str_replace('"forumdisplay.php', '"' . Array['bburl'] . '/forumdisplay.php', );', 'vbulletin', 'vba_error', 1);

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 'profile.php'
),
array(
'"' . Array['bburl'] . '
Error Number : 1064
Date : Sunday, July 10th 2005 @ 10:15:04 PM
Script : http://localhost/irishenvy/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 127.0.0.1
Username : Svoboda
Classname : vb_database

[euca]

seems the problem still exists...
plz help, Brian...

[RetroDreams]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NUL
Error Number : 1064
Date : Sunday, July 10th 2005 @ 08:14:06 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

hmmmm

Simply search for the ALTER in the installer and add a space on the two lines and that error will be resolved.

[mholtum]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:

CREATE TABLE testadv_modules (
modid smallint(5) unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
identifier varchar(100) NOT NULL default '',
filename text NOT NULL,
inctype varchar(20) NOT NULL default '',
modcol smallint(3) unsigned NOT NULL default '0',
displayorder smallint(5) unsigned NOT NULL default '0',
templatelist varchar(255) NOT NULL default '',
userperms varchar(255) NOT NULL default '',
parent varchar(255) NOT NULL default '',
active smallint(3) unsigned NOT NULL default '1',
colspan smallint(3) unsigned NOT NULL default '0',
formcode text NOT NULL,
cleanoutput smallint(3) unsigned NOT NULL default '0',
useshell smallint(3) unsigned NOT NULL default '0',
link varchar(255) NOT NULL default '',
options text NOT NULL,
PRIMARY KEY (modid),
KEY identifier (identifier)
) TYPE=MyISAM;

MySQL Error : Table 'testadv_modules' already exists
Error Number : 1050
Date : Sunday, July 10th 2005 @ 08:43:15 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2

Mind shootiing me your install file? mholtum@gmail.com

[datruth55]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:

CREATE TABLE testadv_modules (
modid smallint(5) unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
identifier varchar(100) NOT NULL default '',
filename text NOT NULL,
inctype varchar(20) NOT NULL default '',
modcol smallint(3) unsigned NOT NULL default '0',
displayorder smallint(5) unsigned NOT NULL default '0',
templatelist varchar(255) NOT NULL default '',
userperms varchar(255) NOT NULL default '',
parent varchar(255) NOT NULL default '',
active smallint(3) unsigned NOT NULL default '1',
colspan smallint(3) unsigned NOT NULL default '0',
formcode text NOT NULL,
cleanoutput smallint(3) unsigned NOT NULL default '0',
useshell smallint(3) unsigned NOT NULL default '0',
link varchar(255) NOT NULL default '',
options text NOT NULL,
PRIMARY KEY (modid),
KEY identifier (identifier)
) TYPE=MyISAM;

MySQL Error : Table 'testadv_modules' already exists
Error Number : 1050
Date : Sunday, July 10th 2005 @ 08:43:15 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2

Mind shootiing me your install file? mholtum@gmail.com

You need to uninstall first to stop getting that error. When you uninstall you need to manually remove the two phrasegroup_adv fields in the language table. Those two didn't uninstall for me automatically.

[mholtum]

Removed them all, now I get this:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NUL
Error Number : 1064
Date : Sunday, July 10th 2005 @ 08:56:29 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

[euca]

Okay, fixed the space issue as mentioned above and now get:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
INSERT INTO plugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' ' = str_replace(
array(
'"login.php',
'"profile.php'
),
array(
'"' . Array['bburl'] . '/login.php',
'"' . Array['bburl'] . '/profile.php'
),

);

= str_replace('"forumdisplay.php', '"' . Array['bburl'] . '/forumdisplay.php', );', 'vbulletin', 'vba_error', 1);

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 'profile.php'
),
array(
'"' . Array['bburl'] . '
Error Number : 1064
Date : Sunday, July 10th 2005 @ 10:15:04 PM
Script : http://localhost/irishenvy/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 127.0.0.1
Username : Svoboda
Classname : vb_database
does anyone know how to fix it?

[datruth55]

Removed them all, now I get this:

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLEtestlanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NUL
Error Number : 1064
Date : Sunday, July 10th 2005 @ 08:56:29 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database


That's answered farther up this thread. There are two "ALTER TABLE" that you need to add a space at the end of in the install script.

[mholtum]

That's answered farther up this thread. There are two "ALTER TABLE" that you need to add a space at the end of in the install script.



Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
INSERT INTO testplugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' ' = str_replace(
array(
'"login.php',
'"profile.php'
),
array(
'"' . Array['bburl'] . '/login.php',
'"' . Array['bburl'] . '/profile.php'
),

);

= str_replace('"forumdisplay.php', '"' . Array['bburl'] . '/forumdisplay.php', );', 'vbulletin', 'vba_error', 1);

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 'profile.php'
),
array(
'"' . Array['bburl'] . '/lo
Error Number : 1064
Date : Sunday, July 10th 2005 @ 09:15:30 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

God what a pain in the ass

[ConqSoft]

God what a pain in the ass

It's a beta add-on, for a beta forum. Problems should be expected at first.

[mholtum]

It's a beta add-on, for a beta forum. Problems should be expected at first.
Yea, I know.. Long day..

[RetroDreams]

Nevermind, it went back to my previous error.

[phlogiston]

I got it running :D

three or four attempts and a bit of jiggery pokery needed though.
In the admincp/vbacmps_install.php file I had to do a full search & replace for the ALTER TABLE" typos - there were more than two in the file I got.
Also the install had a problem adding a plugin automatically (see db error post#12 in this thread) - I couldn't figure out why the query wasn't working though so just commented it out in the install and added it myself :S

[RetroDreams]

Would you be as so kind to email me your install file? svoboda @ gmail dot com

[mholtum]

Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
INSERT INTO testplugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' ' = str_replace(
array(
'"login.php',
'"profile.php'
),
array(
'"' . Array['bburl'] . '/login.php',
'"' . Array['bburl'] . '/profile.php'
),

);

= str_replace('"forumdisplay.php', '"' . Array['bburl'] . '/forumdisplay.php', );', 'vbulletin', 'vba_error', 1);

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 'profile.php'
),
array(
'"' . Array['bburl'] . '/lo
Error Number : 1064
Date : Sunday, July 10th 2005 @ 10:19:30 PM
Script : http://www.ravensrealm.net/test/forums/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database


Did what you instructed, still getting this error.. Might you share your install file?

[RetroDreams]

Mumble. =)

[mholtum]

Mumble. =)
Yea I know, post #12.. I cant see how to fix it.. :confused:

[Zachery]

Since this is a release thread, please keep on topic, and use the forums for support.

[dafire]

I know it's evil to ask but any hint when the gallery will be available for 3.5 ? ;) Hours, Days, Weeks ? ;)

[PixelFX]

sweet I can finaly start messing with vbulletin 3.5 now :P .. "vbulletin without vbadvanced cmps 2.0 is like bread with out butter"

[dafire]

the installer contains some errors. some are easy to correct like alter table missing space but the hook is not so easy. I installed the cmps now without that hook for testing.

[PixelFX]

I fixed the alt table error based on info above, it install ed clean after that as far as I can tell. If admins want I can post file or wait for brian to do update, don't want to step on any toes, Just happy he released this :)

[dafire]

1. use your favourite text editor to replace "ALTER TABLE" with "ALTER TABLE " (doesn't matter if you add 2 spaces by accident so just replace all)

2. ok .. here is a fix for the mysql error:

find :


if (!$checkplug['devkey'])
{
$db->query_write("INSERT INTO " . TABLE_PREFIX . "plugin (title, hookname, phpcode, product, devkey, active) VALUES ('vBadvanced Error Replacements', 'error_generic' '$errormessage = str_replace(
array(
'\"login.php',
'\"profile.php'
),
array(
'\"' . $vbulletin->options['bburl'] . '/login.php',
'\"' . $vbulletin->options['bburl'] . '/profile.php'
),
$errormessage
);

$forumjump = str_replace('\"forumdisplay.php', '\"' . $vbulletin->options['bburl'] . '/forumdisplay.php', $forumjump);', 'vbulletin', 'vba_error', 1)");

$stepphrase .= 'Added plugin for vBa error messages.<br /><br />';

}




replace with:



if (!$checkplug['devkey'])
{

$db->query_write(
"INSERT INTO " . TABLE_PREFIX . "plugin SET
title = 'vBadvanced Error Replacements',
hookname = 'error_generic',
phpcode = '\$errormessage = str_replace( array( \\'login.php\\', \\'profile.php\\' ), array( \$vbulletin->options[\\'bburl\\'] . \\'/login.php\\', \$vbulletin->options[\\'bburl\\'] . \\'/profile.php\\' ), \$errormessage ); \$forumjump = str_replace(\\'forumdisplay.php\\', \$vbulletin->options[\\'bburl\\'] . \\'/forumdisplay.php\\', \$forumjump);',
product = 'vbulletin',
devkey = 'vba_error',
active = 1");


$stepphrase .= 'Added plugin for vBa error messages.<br /><br />';

}




I give no guarantee that the hook work as expected, thats what I read from the code. It seems to work for me :)

[kall]

Brilliant!

(You also need to replace all "ALTER TABLE" to "ALTER TABLE " and it works flawlessly)

[Mikaelweb]

get this error when i install
Database error in vBulletin 3.5.0 Beta 3:

Invalid SQL:
ALTER TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL;

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 'TABLElanguage ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL' a
Error Number : 1064
Date : Monday, July 11th 2005 @ 10:33:17 AM
Script : http://www.coderslabz.com/testbord/forum/admincp/vbacmps_install.php?do=install&step=2
Referrer :
IP Address : 213.113.58.241
Username : mikaelweb
Classname : vb_database

[Brian]

Ughhh... I fixed those problems in the install file last night, but apparently uploaded the wrong one. :o
I've just updated the install file, so those who were having problems should be able to download the package again, uninstall, and then reinstall.

[Mikaelweb]

Now it works thanks mate Ughhh... I fixed those problems in the install file last night, but apparently uploaded the wrong one. :o
I've just updated the install file, so those who were having problems should be able to download the package again, uninstall, and then reinstall.

[Kaelon]

So, I currently have vBa CMPS 1.0.1, and vB 3.0.7. Should I upgrade vB first, and then using the CMPS 2.0 RC2 for vB3.5, uninstall the old version, and install the new one?

[Brian]

Just upgrade vB, then upload all of the new CMPS files, go to the install file in your browser, and select the option to upgrade.

[TCB]

Great news :D

I am still waiting to upgrade vBa CMPS and te vBa Gallery, untill vbulletin releases an non-beta version of vbulletin 3.5.

Glad to see that you're ready also for this release...

[DSMrSinister]

brian I have tried two times to download the zip file and it will not unzip. The tar file works great.. Just a litle FYI for you...

[Brian]

Are you using a Mac to download the files? If so, then that is a known issue and exactly why we have the tar option available. :)

[DSMrSinister]

I do not own a mac pc. JUst windows here :(.............

[Abrel_Knezquawr]

That´s not an issue of vBA CMPS then. Try going to www.winzip.com, download/install winzip, and use winzip to unzip the .zip file.

:D

[Brian]

I don't *think* it would be a problem with the stuff here as nobody has ever mentioned having a problem with the zip files, other than those who are browsing on a Mac.

[chanhlinh]

How can i download it? many thanks!
Chanhlinh

[sub_ubi]

Just wanted to say that I held off trying vbulletin 3.5 until vba CMPS was released.

Thank you!

[Kaelon]

Just upgrade vB, then upload all of the new CMPS files, go to the install file in your browser, and select the option to upgrade.
Thanks, Brian. How will this impact the vBa Gallery and vBa Links packages that I have installed?

[pulsetoday]

I know it's evil to ask but any hint when the gallery will be available for 3.5 ? ;) Hours, Days, Weeks ? ;)
^^ I am really waiting for that :D