vBa CMPS 2.0 RC2 (vB 3.5) Released!

***Brian*** · #1 07-10-2005, 07:10 PM

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 · #2 07-10-2005, 07:20 PM

I noticed that the readme has this near the top:

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

***Brian*** · #3 07-10-2005, 07:23 PM

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

Ogden2k · #4 07-10-2005, 07:42 PM

Code:

 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/admin...ps_install.php
Referrer	 : http://dev.techiehq.net/forums/admin...ps_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 · #5 07-10-2005, 07:46 PM

I get an error when installing:

Quote:

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/foru...install&step=2
Referrer :
IP Address : 68.99.209.240
Username : mholtum
Classname : vb_database

Shon · #6 07-10-2005, 07:57 PM

So the 3.5 version still requires file modification?

TTG · #7 07-10-2005, 08:34 PM

Database error !?

Code:

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 · #8 07-10-2005, 08:46 PM

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.

Code:

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*** · #9 07-10-2005, 10:35 PM

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 · #10 07-10-2005, 11:03 PM

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

Code:

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/v...install&step=2
Referrer     : 
IP Address   : 127.0.0.1
Username     : Svoboda
Classname    : vb_database

mholtum · #11 07-10-2005, 11:15 PM

Code:

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/foru...install&step=2
Referrer     : 
IP Address   : 68.99.209.240
Username     : mholtum
Classname    : vb_database

hmmmm

RetroDreams · #12 07-10-2005, 11:15 PM

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

Code:

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/v...install&step=2
Referrer     : 
IP Address   : 127.0.0.1
Username     : Svoboda
Classname    : vb_database

euca · #13 07-10-2005, 11:23 PM

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

RetroDreams · #14 07-10-2005, 11:23 PM

Quote:

Originally Posted by mholtum

Code:

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/foru...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 · #15 07-10-2005, 11:44 PM

Code:

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/foru...install&step=2

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

datruth55 · #16 07-10-2005, 11:49 PM

Quote:

Originally Posted by mholtum

Code:

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/foru...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 · #17 07-10-2005, 11:57 PM

Removed them all, now I get this:

Code:

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 · #18 07-10-2005, 11:57 PM

Quote:

Originally Posted by RetroDreams

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

Code:

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/v...install&step=2
Referrer     : 
IP Address   : 127.0.0.1
Username     : Svoboda
Classname    : vb_database

does anyone know how to fix it?

datruth55 · #19 07-11-2005, 12:07 AM

Quote:

Originally Posted by mholtum

Removed them all, now I get this:

Code:

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 · #20 07-11-2005, 12:16 AM

Quote:

Originally Posted by datruth55

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.

Code:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vBadvanced CMPS 2.0 RC2 Released!	Brian	Announcements	20	12-16-2005 10:13 PM
vBadvanced CMPS 2.0 RC1 Released!	Brian	Announcements	107	07-21-2005 12:27 AM
vBadvanced CMPS 2.0 RC1 Released!	JimBeam	Troubleshooting & Problems	6	06-18-2005 01:47 PM
vBadvanced CMPS RC2 Released!	Brian	Announcements	29	10-29-2004 10:27 AM
vBadvanced CMPS Released!	Brian	Announcements	28	06-13-2004 01:02 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)