Error logging into adm-index.php after new install

[mrsquid]

I'm installing PhotoPost onto my VB 3.5.4 site and everything's going alright until the end of the install. I'm seeing two errors...

#1 is on step 5 of the install at the "Photopost configuration verification" - I get an error at the top of the page that says:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tinastea/public_html/photopost/forums/vb3.php on line 460

#2 happens if I move on. The next page says that PhotoPost has been successfully installed and tells me to go to adm-index.php. But when I go there I get an error at the top of the page that says:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tinastea/public_html/photopost/forums/vb3.php on line 25

Adm-index.php still gives me the otpion to log into my site. (though it doesn't really take me anywhere except to URL/index.php/photopost/mixc.php)

Can anyone tell me what to do next? Thanks!

[Zachariah]

Hello,

Sounds like Table prefix's. Your tables on install may have a table prefix that was not filled out in the config files.

photopost/config-int.php
- config-int.php

EX:

Content visible to verified customers only.

[mrsquid]

You're kinda right... pp_ is the prefix, but that was already in the config files.

Other thoughts?

[Zachariah]

Your Tables for the forums do that have a prefix also ?
- If so use phpMyadmin pp_setting record 83 and add the prefix.

[KW802]

[ Moving to PhotoPost PHP Pro ]

[mrsquid]

Originally Posted by Zachariah

Your Tables for the forums do that have a prefix also ?
- If so use phpMyadmin pp_setting record 83 and add the prefix.

I just looked at my forum tables and they don't have a prefix.

I went into phpMyadmin and don't understand what I'm supposed to do with "pp_setting record 83 and add the prefix" - what's that mean? If I make that change, it won't hose up anything on my forum, will it?

[Chuck S]

If you get this

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tinastea/public_html/photopost/forums/vb3.php on line 25

Your issue can be only one of two things. I would suggest you rerun install.php and input the proper information.

1. You have entered the incorrect vbulletin database info on the config section under user database on Photopost Install

2. You did not enter the proper forum database table prefix on the next to last step of install where asked.

Your issue can only be one of these two things. It is up to you to determine which one is your issue here. Basically Photopost is not able to run queries against the vbulletin database. Both your vbulletin table prefix and database information is found in the vbulletin config.php file located in your forum includes directory.

[mrsquid]

OK - we're getting REALLY close. I no longer get those 2 original errors. But now when I make it through the install process and adm-index.php has me log into my, it still takes me to URL/index.php/photopost/misc.php. My site looks OK, but anything that's a graphic comes up as a boxed red X.

[Chuck S]

You would need to post a url here if you want us to suggest anything about graphics but I would assume here your using a custom vb style and as such you need to modify your style in vb admin and make sure you correct in the styles admin the relative image paths and make them full urls so photopost knows where to find the images.

As far as login on install did you properly enter the vb license number from the config file to your config in Photopost? If not you can correct this by entering it now in the config-inc.php file

Did you specify the proper vbulletin cookie prefix on install? By default it is bb and if you do not enter it you will not get into photopost admin cause we can not authenticate you since both the cookie prefix and license number along with user password make up the password cookie in vbulletin.

At this point you need to post a url so I can see where you are on install.

[mrsquid]

Originally Posted by Chuck S

You would need to post a url here if you want us to suggest anything about graphics but I would assume here your using a custom vb style and as such you need to modify your style in vb admin and make sure you correct in the styles admin the relative image paths and make them full urls so photopost knows where to find the images.

My question wasn't so much about graphics as it is about the fact that the login took me to URL/index.php/photopost/misc.php. That seemed like a strange path to me.

Originally Posted by Chuck S

As far as login on install did you properly enter the vb license number from the config file to your config in Photopost? If not you can correct this by entering it now in the config-inc.php file.

Yes - the license # is copied/pasted

Originally Posted by Chuck S

Did you specify the proper vbulletin cookie prefix on install? By default it is bb and if you do not enter it you will not get into photopost admin cause we can not authenticate you since both the cookie prefix and license number along with user password make up the password cookie in vbulletin.

This was the silver bullet. I added bb as the vbulletin cookie prefix and now I'm good. Thanks much!

[Chuck S]

Glad to help just made sure I covered ever aspect of your post and all questions