Another error 63

[andrea]

Ok, I have read through the forums and I am able to find lots of errors like this, but the fix is always, edit you config file. I have done that and as far as I can tell, it is correct. The file also exists and I have checked permissions on the directories and the file. I am so close, but I can't get past this error. Please help..

My Path in the config file

$PP_PATH = "/home/user/mainwebsite_html/gallery";

Error Message

Warning: main(/home/user/mainwebsite_html/gallery/languages/english/pp-inc.php): failed to open stream: No such file or directory in /home/virtual/site36/fst/var/www/html/gallery/pp-inc.php on line 63

Fatal error: main(): Failed opening required '/home/user/mainwebsite_html/gallery/languages/english/pp-inc.php' (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site36/fst/var/www/html/gallery/pp-inc.php on line 63

[Chuck S]

Your path is really this

/home/virtual/site36/fst/var/www/html/gallery

[andrea]

Great!! That gets me past that error.

Now I am getting a SQL error that looks strange to me. Here is the error:

Query: SELECT usergroupid,title,adminpermissions FROM usergroup

Result: Table 'domain_com_-_gallery.usergroup' doesn't exist

Database handle: Resource id #4

The error is correct, the table usergroup does not exist. The table is named usergroups not usergroup. If I try to rename the table, I get an unknown error rather than the usergroup error and it recreates a usergroups table. I have tried dropping all the tables and letting the installer set them up again, but I get the same errors again.

Any idea what is causing this error????

Thanks again for you help...

[Chuck S]

No No what are you integrating with?

usergroup may indeed by right if your trying to integrate with vb for instance. Most likely you forgot to put in a table prefix for your forum on the last step of install.

You may view your photopost settings table in phpmyadmin and change line 83 to the proper setting for that table prefix for the forum.

The only other issue would be if you entered the wrong database info to connect to the forum and its looking for the tables in the photopost database.

[andrea]

I am integrating with VB3. When I set up the forum and the gallery, I thought I read that I don't have to have them in the same database and if they were in separate databases, that I didn't need a prefix. So that is what I did. 2 different databases, no prefix. Will that work or do I need to reinstall VB3 with a prefix?

[andrea]

I figured out what the problem was. I still have 2 DB's with no prefix, but when I was specifying the DB names, I put the Photopost DB name in both the Photopost and User DB fields. I needed the forum DB name in the User DB field and didn't realize it because that option was set way before I selected whether it would be a Internal or External setup.

Anyway, it is working now. Thanks for you help!!

[Chuck S]

Originally Posted by omegatron

The only other issue would be if you entered the wrong database info to connect to the forum and its looking for the tables in the photopost database.

YEP THATS WHAT I SAID