problem with database?

KAY9 · August 5th, 2008, 09:34 AM

Hello

Im having problems all of a sudden with my gallery loading, been like this for 3days now.

All I seem to be getting, is a blank white page.

Ive uploaded a back up copy of the database and still it is the same issue.

The gallery has been working fine for the past year, im using the same isp and laptop, so no changes have been made on that end.

Here is a copy of the database message after I tried to repair the table, for some reason this message does not fully display, yet it

seems to be the problem?

PhotoPost2.pp_photoviews repair note The storage engine for the table doesn't support r...

Any suggestions pls??

-------

PhotoPost2.pp_admingroups repair status OK
PhotoPost2.pp_admlog repair status OK
PhotoPost2.pp_cache repair status OK
PhotoPost2.pp_categories repair status OK
PhotoPost2.pp_comments repair status OK
PhotoPost2.pp_ecards repair status OK
PhotoPost2.pp_exif repair status OK
PhotoPost2.pp_extrafields repair status OK
PhotoPost2.pp_favorites repair status OK
PhotoPost2.pp_ipcache repair status OK
PhotoPost2.pp_iponline repair status OK
PhotoPost2.pp_laston repair status OK
PhotoPost2.pp_notify repair status OK
PhotoPost2.pp_photoextras repair status OK
PhotoPost2.pp_photos repair status OK
PhotoPost2.pp_photoviews repair note The storage engine for the table doesn't support r...
PhotoPost2.pp_searchids repair status OK
PhotoPost2.pp_settings repair status OK
PhotoPost2.pp_sort repair status OK
PhotoPost2.pp_sortmemb repair status OK
PhotoPost2.pp_usergroups repair status OK
PhotoPost2.pp_users repair status OK
-----------

Chuck S · August 5th, 2008, 10:31 AM

How about posting a link to your gallery and what type integration your doing

KAY9 · August 5th, 2008, 11:01 AM

Quote:

Originally Posted by Chuck S

How about posting a link to your gallery and what type integration your doing

is it ok to pm or mail you the url?

the thing is, the intergration and gallery has been working fine for the past year, and the problem has just occured since friday gone

Chuck S · August 5th, 2008, 11:55 AM

support at photopost dot com would work for email

KAY9 · August 5th, 2008, 10:30 PM

Quote:

Originally Posted by Chuck S

support at photopost dot com would work for email

Just sent mail, thanks for taking a look.

Chuck S · August 6th, 2008, 08:42 AM

Hello

Please check your server error logs for any errors. Your host would be able to assist with that. basically your issue could be several things depending on your server config. Your server is not displaying PHP errors so its hard to pinpoint one thing that might be wrong. I would suggest you verify both config files for photopost exist and in the config-inc.php file the proper database info exists to connect to mysql. In config-int.php I suggest you make sure the server path to vbulletin is correct. try turning off the 3 vb3 define switches does your gallery load?

KAY9 · August 7th, 2008, 05:48 PM

Quote:

Originally Posted by Chuck S

Hello

Please check your server error logs for any errors. Your host would be able to assist with that. basically your issue could be several things depending on your server config. Your server is not displaying PHP errors so its hard to pinpoint one thing that might be wrong. I would suggest you verify both config files for photopost exist and in the config-inc.php file the proper database info exists to connect to mysql. In config-int.php I suggest you make sure the server path to vbulletin is correct. try turning off the 3 vb3 define switches does your gallery load?

Hi chuck, thanks for swift reply

The gallery has been working fine since my last support post on here, which has been well over a year..!!

far as the gallery goes, I made no changes at all in the config settings via admin panel. It was on friday just gone that the gallery started to fail to load, and then by tuesday its now displaying bunch of errors, (if you can revist the link you should be able to see the errors )again with no changes done by me.

Quote:

Warning: main() [function.main]: open_basedir restriction in effect. File(/usr/share/pear/t/languages/english.php) is not within the allowed path(s): (/var/www/vhosts/xxxxxxx.com/httpdocs:/tmp) in /var/www/vhosts/xxxxxxx.com/httpdocs/gallery/pp-inc.php on line 177

Warning: main(t/languages/english.php) [function.main]: failed to open stream: Operation not permitted in /var/www/vhosts/xxxxxxxx.com/httpdocs/gallery/pp-inc.php on line 177

Warning: main() [function.main]: open_basedir restriction in effect. File(/usr/share/pear/t/languages/english.php) is not within the allowed path(s): (/var/www/vhosts/xxxxxxx.com/httpdocs:/tmp) in /var/www/vhosts/xxxxxxx.com/httpdocs/gallery/pp-inc.php on line 177

Warning: main(t/languages/english.php) [function.main]: failed to open stream: Operation not permitted in /var/www/vhosts/xxxxxxx.com/httpdocs/gallery/pp-inc.php on line 177

Fatal error: main() [function.require]: Failed opening required 't/languages/english.php' (include_path='.:/usr/share/pear') in /var/www/vhosts/xxxxxxx.com/httpdocs/gallery/pp-inc.php on line 177

I just needed confirmation as to what the problem might be, I have notified my hosters, so im waiting on that as well.

Chuck S · August 7th, 2008, 05:59 PM

Make sure to edit your config-inc.php file and make sure you set the proper server path to the gallery on the $PP_PATH line

/var/www/vhosts/xxxxxxx.com/httpdocs/gallery

KAY9 · August 9th, 2008, 08:24 AM

Quote:

Originally Posted by Chuck S

Make sure to edit your config-inc.php file and make sure you set the proper server path to the gallery on the $PP_PATH line

/var/www/vhosts/xxxxxxx.com/httpdocs/gallery

hello...

so you reckon that the server paths have changed? which are causing the problem?

Chuck S · August 9th, 2008, 02:05 PM

Thats what your error shows me yes.

KAY9 · August 11th, 2008, 01:59 PM

Quote:

Originally Posted by Chuck S

Thats what your error shows me yes.

Hello n thanks!

just another question to confirm.

my web hosts are saying its a problem with the coding

i dont see how, since ive made no changes, but here is a extract of the convo:

Quote:

PHP Fatal error: Cannot use assign-op operators with overloaded objects nor string offsets in /var/www/vhosts/xxxxxx.com/httpdocs/gallery/pp-inc.php on line 167

As this is a coding issue, we suggest contacting a programmer to get it fixed.

so i just change the paths in the pp-inc.php ? to resolve this?

Chuck S · August 11th, 2008, 03:06 PM

well your posting a different error now so what is the error? Most likely that error would be caused by some misedit of a file or setting.

A link to your site might help here. I posted a resolution to what your reported as an issue now your reporting some other error.

What is line 167 of your pp-inc.php file since your most likely using an older version of the software.

KAY9 · August 14th, 2008, 04:43 PM

Quote:

Originally Posted by Chuck S

well your posting a different error now so what is the error? Most likely that error would be caused by some misedit of a file or setting.

A link to your site might help here. I posted a resolution to what your reported as an issue now your reporting some other error.

What is line 167 of your pp-inc.php file since your most likely using an older version of the software.

hello

I checked the paths in the config file and the paths are still the same, i even comfirmed the paths with webhosts and they seem to be the same.

the error I posted was from the error log.

line 167 is:

Quote:

165: if ( VB3_INTEGRATION == "on" )
166: {
167: $Globals['TMPL_PATH'] .= "/vb3enhanced";

so it seems its a problem now with intergration? which is odd cause its been working fine for the whole year

i'll email the site url if thats ok.

Chuck S · August 14th, 2008, 04:48 PM

You can email site url admin login and ftp information here

http://www.photopost.com/ppost_contact.pl

KAY9 · August 16th, 2008, 05:38 PM

Quote:

Originally Posted by Chuck S

You can email site url admin login and ftp information here

http://www.photopost.com/ppost_contact.pl

Thanks Chuck,

Ive just sent the details through on the form.

Chuck S · August 17th, 2008, 06:45 AM

I did respond via email on this topic

KAY9 · August 17th, 2008, 12:17 PM

Quote:

Originally Posted by Chuck S

I did respond via email on this topic

Just about to check now, I'll respond by email..saves hassle coming back and forth.thanks

Chuck S · August 17th, 2008, 01:02 PM

Not a problem

KAY9 · September 23rd, 2008, 10:53 AM

Quote:

Originally Posted by Chuck S

Not a problem

Hello Chuck

This is well odd, Ive reinstalled a fresh copy from the original zip, all files have been replaced fully, fresh new database etc

standalone the gallery works fine.

yet last year, and previously the forum and gallery worked fine intergrated.
So its defo not a problem with the versions of vb or the gallery etc

So not sure why its not intergrating fully now, even after a fresh install.
I just keep getting a blank screen

Did reply to the email, but not sure if it went through.

Any help or pointers would be great.

Thanks

Chuck S · September 23rd, 2008, 06:50 PM

Make sure any paths your using are correct to the forum etc. If your not integrating correctly it has to be incorrect information on the install and if its a blank page check the last step where it says the server path to the forum.