question about db with vb4 integration

[Mary303]

New install - have not yet run the install, trying to be sure I have the configs set up properly so hopefully it will be one & done.

I believe I have the option to provide the name of my vb4 forum db in the config-inc.php file. Does the pp-classifieds set up new tables inside that db if I do that?

Can I have a separate pp-classifieds db and still be integrated with vb4?

If I can use a separate db & still integrate with vb4, do I need to set up the db through my server host before I run the install?

thx!

[Chuck S]

If you run the install there are on the config portion of the install a place to specify the classifieds database info and the user database info (forum). They can be the same database or they can be separate. Does not matter which one you do it will not affect the integration.

[Mary303]

OK, for a new classifieds db, do I need to create a shell db before the install, or will the script do it?

Do I set the passwords in the instructions chmod 777 & chmod 755 in the server db manager, or in a file?

Thanks!

[Chuck S]

You need to actually create your database based on whatever procedures your server has you do. That stuff needs to exist and be correct what you input in the install

As far as when we talk permissions as the install instructions note those are file and directory permissions.

[Mary303]

I created a new db for the classifieds. It is empty. I went into the folder where I uploaded all the files, /pp-classifieds/, and got this error message:

"Database not properly setup - unable to read mhbclass_settings table. Contact administrator."

[Chuck S]

You actually have to run the install script. Your not just editing a config file and things are going to work. The install script will install all the database tables and do all the actions to make things be setup

There is an install text file in the actual documenations folder of the downloaded code but here is how you install

PhotoPost PHP Photo Sharing Photo Gallery Installation Guide

[Mary303]

Well, my point was that I could not get to the install script to run it. I have the config file pointing toward a new db name that I set up through my server admin panel. When I tried to access the install file, I was not able to get past /pp-classifieds/ because of the db error message.

[Chuck S]

well if you have done things as noted in the install instructions you should be able to install. That is provided of course the server allows php and mysql and your database information is correct.

The only error your posting here says your classifieds settings table does not exist. That is only going to come from the actual app not being installed because we can not find the settings table that is created when you run the install. You are not going to get that message running the install script.

http://www.yoursite.com/pp-classifieds/install.php

that is where you want to be

[Mary303]

Originally Posted by Chuck S

http://www.yoursite.com/pp-classifieds/install.php

that is where you want to be

As you suggested, I was able to use the url address to skip over the db error message and launch the install script.

However, I am stuck again at the screen attached below. When I click the button [configure photopost], I get the error message below. I've tried several times over the last few hours.


capture.jpg


button leads to a blue/white screen with the message
"We're sorry, but the system experienced an unrecoverable error. Please try again later."

[Chuck S]

Yes you need to run the install to successfully run the application as noted in our installation instructions

The reason your having issues is your inputing incorrect information where it is asked for. Your forum url should not include any script names /forum.php. It is the simply url to your forum

Likewise I doubt seriously that your forum database table prefix or cookie prefix is mhbclass_. You can look in your vbulletin config.php file for the proper information we are asked for. If you enter correct information your application should work.

[Mary303]

Originally Posted by Chuck S

Yes you need to run the install to successfully run the application as noted in our installation instructions

Obviously I am trying to do that, and that's why I'm posting questions when the install script stops. I am no expert in pp classifieds.

Originally Posted by Chuck S

The reason your having issues is your inputing incorrect information where it is asked for. Your forum url should not include any script names /forum.php. It is the simply url to your forum

On the last vb4 upgrade I ran, the url to my forum main page changed from /forums to /forums/forum.php. /forums does not go to the forums any longer, it switches to another page that is not the main page most members use. All the members had to change their bookmark url to forums/forum.php.

But I will drop that part if that's the only way the install script will run. It did not occur to me that the 'real' url would be a problem.

Originally Posted by Chuck S

Likewise I doubt seriously that your forum database table prefix or cookie prefix is mhbclass_. You can look in your vbulletin config.php file for the proper information we are asked for. If you enter correct information your application should work.

But when I input the variables in the config-inc.php and the config-intc.php file, I changed $pp_db_prefix to mhbclass_ in both the config files, and uploaded those. Is that not ok to edit? Isn't that why the install script has me fill those in in the screenshot I posted, instead of just using default values? There's nothing that says *not* to change prefix.

I will switch it back to pp_. Since I am thinking of having a adding a classified license for other forums I wanted to make it unique so I can distinguish which license/forum is generating what, but I guess that's not possible?

Is it ok to have set up the db as mary_mhbclassifieds, rather than ppclassifieds, which is the default that I edited? It seems to have accepted the new db name. My server host names all db's mary_something .

---------------------

I made the above change to the install screen, and changed the config files prefix back to pp_ . Now when I hit the "configure" to go ahead with the install script I get this error message:

"Failed MySQL Query: [Resource id #3]:UPDATE pp_settings SET setting='vb3' WHERE id=41
Error: "

Is this because I selected vb4 from the early dropdown in the install screen? My vb forum version is 4.0.8 pl 4.

Have set
Forums database table prefix = pp_ and changed the config files for $pp_db_prefix to match
Forum Cookie Prefix = bb

[Chuck S]

Mary I will try explaining this again. You do not at any point hand edit config files. These are the installation instructions

PhotoPost PHP Photo Sharing Photo Gallery Installation Guide

Basically you are entering the wrong information which is your issue. You need to simply upload the files set file and directory permissions as noted and run the install script. On the install script you would enter the correct database info for classifieds and the one for vb where asked. Now on step 4 where your posting screen shots you enter your forum information. You seem to be entering your classifieds table prefix etc where we are asking you what your forum mysql table prefix is.

You will not have a successful install until such time as you enter the correct information. Your vbulletin mysql table prefix is not pp_. When I say to check for the correct vbulletin information in your vb config.php file that is located in your forums includes directory. You can not get that information from your classifieds config-inc.php file which you seem to keep bringing up here and the heart of your issue.

[Mary303]

I finally had the chance to return to working on this install.

I started over and used un-modified config files, and was able to successfully complete the install.
- Switched to "on" the vb integrations to use the header & so forth.
- Also ran the upgrade scripts (starting with page "import language phrases") that came at the end of the install.

I followed the link to the admin panel given in the install
Login - PhotoPost Classifieds
It shows: Powered by: PhotoPost Classifieds 4.1

Since during the install I linked the login to my vb forum, I used my vb forum username & password. This brought me to a white screen with this error message:

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/mary/public_html/blabclassifieds/pp-classifieds/header-inc.php on line 57

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/mary/public_html/blabclassifieds/pp-classifieds/header-inc.php on line 58

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/mary/public_html/blabclassifieds/pp-classifieds/header-inc.php on line 58

Fatal error: require() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mary/public_html/blabclassifieds/pp-classifieds/header-inc.php on line 58

I'm sure something small is off ...

[Chuck S]

vBulletin Installation/Integration Common Issues and Resolutions.

Number 2 should assist you with that error.

[Mary303]

>Tried editing the config files, but there was no change in error message.

>Started over and did a re-install. I went through all the steps, including the upgrade steps.
>At the end I was able to log in to the user panel and to the admin panel. The admin panel shows "Classifieds 3.13 Update!" It will probably be this weekend before I am able to test and use it.

>Although I was able to log in at the end of the process, I did get some error messages during the upgrade portion of the install. After each step there was a message after the errors that the step was complete and I should continue on, so I did that each time. I hope the install/upgrade was ok.

After this step in the upgrade:
This install script will upgrade your 3.1 release to 3.11. Only run this upgrade if you have the 3.1 version of the database in place (either by previous upgrades or if upgrading in order to the latest).

Next screen was error message:
Preparing to update database...

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (240,'setting240','metakeys','photo gallery,photo sharing,photo uploads,gallery script,gallery,photopost,Photopost Classifieds,reviews,products',32,2);
Error: Duplicate entry '240' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (241,'setting241','metadesc','Photopost Classifieds software lets you review products and display reviews on your website.',33,2);
Error: Duplicate entry '241' for key 'PRIMARY'

Upgrade complete! You should continue to next step

So I continued to the next step ...
This install script will upgrade your 3.11 release to 3.2.
Result - Preparing to update database... Upgrade complete!


So I continued to the next step ...
This install script will upgrade your 3.2 release to 4.0.
Result -
Preparing to update database...

Error performing MySQL command: ALTER TABLE mhbclass_categories ADD ugnopay VARCHAR(255) NULL AFTER ugnopost
Error: Duplicate column name 'ugnopay'

Error performing MySQL command: ALTER TABLE mhbclass_products ADD reslimit float(12,2) NOT NULL default '0.00' AFTER reserve
Error: Duplicate column name 'reslimit'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (242,'setting242','cron','no',35,2);
Error: Duplicate entry '242' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (243,'setting243','crontime','1440',36,2);
Error: Duplicate entry '243' for key 'PRIMARY'

Error performing MySQL command: ALTER TABLE mhbclass_stats ADD cronupdate INT(12) NOT NULL DEFAULT '0'
Error: Duplicate column name 'cronupdate'


Upgrade complete! You should continue to next step


Since it said "you should continue to next step" I did so.
This install script will upgrade your 4.0 release to 4.01.
Result - Upgrade complete!

Next step:
This install script will upgrade your 4.01-4.03 release to 4.1.
Result:
Error performing MySQL command: CREATE TABLE mhbclass_searchids ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 15 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'mhbclass_searchids' already exists

Error performing MySQL command: INSERT INTO mhbclass_admingroups VALUES (15,'admgrp15');
Error: Duplicate entry '15' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (245,'setting245','searchreg','no',1,15)
Error: Duplicate entry '245' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (246,'setting246','searchmax','500',2,15)
Error: Duplicate entry '246' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (247,'setting247','searchto','30',3,15)
Error: Duplicate entry '247' for key 'PRIMARY'

Error performing MySQL command: INSERT INTO mhbclass_settings VALUES (248,'setting248','searchhold','7',5,15)
Error: Duplicate entry '248' for key 'PRIMARY'


Upgrade complete!
You are all done!!


Is everything ok, even with those messages? Thanks!

[Chuck S]

You tell me is everything okay? duplicate mysql errors are not an issue that just means you ran the upgrade already.

[Mary303]

Yep, it is up and running. Thank you for all your help!

[Chuck S]

Your welcome