Installing Step 2 Problem

[notanoob]

I'm receiving this message:

Invalid SQL:
CREATE TABLE adv_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 'adv_modules' already exists

What do I do?

[sean]

well as far as the error goes and as far as my knowledge goes for mysql, you already have a table name 'adv_modules', you probably had vba installed before and forgot to uninstall it, or that the uninstall did not get rid of that table. Another possibility could be that you submitted the step 2 page twice?

There might be other reasons that Brian or someone else might know, but what I recommend you to do before you run the install again, is to go and login to you phpMyAdmin and enter your forums database, and drop (delete) all the tables that start with "adv_", and then start a fresh install, hope that this will give you an idea of how to fix it.

[notanoob]

well as far as the error goes and as far as my knowledge goes for mysql, you already have a table name 'adv_modules', you probably had vba installed before and forgot to uninstall it, or that the uninstall did not get rid of that table. Another possibility could be that you submitted the step 2 page twice?

There might be other reasons that Brian or someone else might know, but what I recommend you to do before you run the install again, is to go and login to you phpMyAdmin and enter your forums database, and drop (delete) all the tables that start with "adv_", and then start a fresh install, hope that this will give you an idea of how to fix it.

Thankyou very much, I tried uninstalling, then reinstalled, and it worked. However, I'm getting a different error now. I'll C/P it here:


Warning: chdir(): SAFE MODE Restriction in effect. The script whose uid is 5500 is not allowed to access / owned by uid 0 in /webhost/washingmachine/www/index.php on line 22

Warning: main(): Unable to access ./global.php in /webhost/washingmachine/www/index.php on line 33

Warning: main(./global.php): failed to open stream: Permission denied in /webhost/washingmachine/www/index.php on line 33

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/local/lib/php')in /webhost/washingmachine/www/index.php on line 33

[mholtum]

what is your chdir line?

[notanoob]

what is your chdir line?
Well, my forum location is www.xxxxxxxxxxxxxxxxx.com/forums, so I put /forums/ as my chdir. Was that incorrect?

[sean]

np bud, as for your chdir problem or the error that you are getting right now, just open up your cmps_index.php and for the chdir put the "full_path" to your fourms, not just /forums/. So it should look like something like this /home/yoursite/public_html/forums hope that this will help.

[notanoob]

np bud, as for your chdir problem or the error that you are getting right now, just open up your cmps_index.php and for the chdir put the "full_path" to your fourms, not just /forums/. So it should look like something like this /home/yoursite/public_html/forums hope that this will help.

Just went and tried ./forums, and it worked. Now I have one more question. My icons on my index.php isnt showing, (red X boxes)

[sean]

hmm, try this, go to your style manager and put the full url to your icons directory and see if they will show up.

[notanoob]

Some of them dont have the red box, but now show up as a clear box.

[sean]

try this then, upload the vbadvanced installation file if you have deleted it, once there, click on update image paths and update the urls/path for your icons, give that a shot and see if it will fix it.

[notanoob]

try this then, upload the vbadvanced installation file if you have deleted it, once there, click on update image paths and update the urls/path for your icons, give that a shot and see if it will fix it.

Got it, thanks alot. One last question, how do I add a link onto the Nav Bar?

[sean]

no problem bud, by the navbar are you referring to vbulletin's navbar or vbadvancd's navbar?

[notanoob]

The vBadvanced one, but then knowing how to place links on the vB one as well wouldn't hurt.

[sean]

well as for the vbadvanced one, you can't manually add a link to some other page that you have created outside of vbadvanced. Basically what that module does is that it automatically inserts a link to each page that you create within the vbadvanced system. There are hacks that you can find in these forums that add more functionality to the navigation module, but I don't know if they have been updated to v2 version of vba.

As for vbulletin's navbar, you have to edit your "navbar" template under "Navigation/Breadcrumb Templates", just add your link in the appropriate area after <!-- nav buttons bar -->