Hundreds of failed to open stream: Permission denied errors

I won't post the whole sitemap generated report because it is hundreds of identical lines. I was checking to make sure my sitemaps were working properly (something I apparently should have done a long time ago because Google said I wasn't verified, even though I had the exact file it wanted me to put in my domain root). I am wondering why I didn't get any errors reported in the email I get every night when the sitemap is run automatically.

The only change I made to try to solve the problem was to CHMOD to 777 the /vbseo_sitemap/data folder, but it made no difference (it was originally 755) - I changed it back.

Any advice would be appreciated.

Code:

[homepage] [5,433.2Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,433.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 29, pages: 2 [5,433.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 112, pages: 6 [5,433.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 203, pages: 11 [5,435.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 82, pages: 5 [5,440.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 27, total threads: 85, pages: 5 [5,443.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 23, total threads: 279, pages: 14 [5,448.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 4, pages: 1 [5,467.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 28, total threads: 161, pages: 9 [5,473.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 41, total threads: 10, pages: 1 [5,484.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 31, total threads: 13, pages: 1 [5,489.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 13, total threads: 560, pages: 28 [5,490.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 35, total threads: 18, pages: 1 [5,514.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 29, pages: 2 [5,523.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 30, total threads: 45, pages: 3 [5,526.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 261, pages: 14 [5,528.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 4, total threads: 55, pages: 3 [5,540.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 3, total threads: 103, pages: 6 [5,547.3Kb mem used] [0s (+0s)]
[SECTION START] showthread [5,552.2Kb mem used] [0s (+0s)]

Warning: fopen(/home/ejm/public_html/tfpcom/community/vbseo_sitemap/data/sitemap_1.xml.gz) [function.fopen]: failed to open stream: Permission denied in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 769

Warning: fopen(/home/ejm/public_html/tfpcom/community/vbseo_sitemap/data/urllist.txt.gz) [function.fopen]: failed to open stream: Permission denied in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 775

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 786

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 797

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 800

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 797

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 800

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 797

Warning: fwrite(): supplied argument is not a valid stream resource in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/vbseo_sitemap_functions.php on line 800

R'gards,

Jim

I tried re-installing the vBSEO Sitemap 2.2 - uploaded the files and imported the XML, allowing overwrite - and now I am getting database errors:

Code:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT id,name FROM tfpfile_cats ORDER BY `order`;

MySQL Error   : Table 'ejm_tfpcom.tfpfile_cats' doesn't exist
Error Number  : 1146
Request Date  : Sunday, November 16th 2008 @ 05:47:31 AM
Error Date    : Sunday, November 16th 2008 @ 05:47:32 AM
Script        : http://www.thefloorpro.com/community/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.thefloorpro.com/community/vbseo_sitemap/index.php
IP Address    : 75.54.235.244
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

The generated sitemap page looks like this:

Code:

[homepage] [5,433.2Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,433.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 29, pages: 2 [5,433.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 112, pages: 6 [5,434.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 203, pages: 11 [5,436.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 82, pages: 5 [5,440.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 27, total threads: 85, pages: 5 [5,444.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 23, total threads: 279, pages: 14 [5,449.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 4, pages: 1 [5,467.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 28, total threads: 161, pages: 9 [5,474.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 41, total threads: 10, pages: 1 [5,484.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 31, total threads: 13, pages: 1 [5,490.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 13, total threads: 560, pages: 28 [5,491.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 35, total threads: 18, pages: 1 [5,514.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 29, pages: 2 [5,524.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 30, total threads: 45, pages: 3 [5,526.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 261, pages: 14 [5,529.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 4, total threads: 55, pages: 3 [5,540.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 3, total threads: 103, pages: 6 [5,547.6Kb mem used] [0s (+0s)]
[SECTION START] showthread [5,552.5Kb mem used] [0s (+0s)]
[SECTION START] albums [5,716.5Kb mem used] [1s (+1s)]
[addon module] vbseo_sm_downloads.php [5,716.7Kb mem used] [1s (+0s)]
 Database error 
The The Floor Pro Community database has encountered a problem. 

--------------------------------------------------------------------------------
 
Please try the following: 
Load the page again by clicking the Refresh button in your web browser. 
Open the www.thefloorpro.com home page, then try to open another page. 
Click the Back button to try another link. 
 
The www.thefloorpro.com forum technical staff have been notified of the error, though you may contact them if the problem persists. 
 
We apologise for any inconvenience.

---

Sorry, the reason for the database errors, apparently, was because I changed the permissions to these files in the data folder to 777 from their original 755:

sitemap_1.xml.gz
sitemap_index.xml.gz
urllist.txt.gz

I don't know where those files come from. They aren't part of the upload, as you know. So, now I am back to the errors I got un my original post. No more database errors. Still no joy though, either.

Jim

Oh jeez, I need to just go to bed. I've been up all night.

I guess it is still generating database errors:

Code:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT id,name FROM tfpfile_cats ORDER BY `order`;

MySQL Error   : Table 'ejm_tfpcom.tfpfile_cats' doesn't exist
Error Number  : 1146
Request Date  : Sunday, November 16th 2008 @ 05:52:20 AM
Error Date    : Sunday, November 16th 2008 @ 05:52:31 AM
Script        : http://www.thefloorpro.com/community/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.thefloorpro.com/community/vbseo_sitemap/index.php
IP Address    : 75.54.235.244
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Maybe there's an easy way to fix that missing table, but I won't be back to find out for about 4 or 5 hours. G'night.

there is no 'cats' table in vBulletin.

Looks like the problem is in 'vbseo_sm_downloads.php' which you have added to 'Addon Generator Modules' in vBSEO Sitemap Settings.

Thanks for your reply, woostar.

Removing the file you mentioned from the vBSEO Google/Yahoo Sitemap Generator Addon Generator Modules did not stop the database errors. That file, vbseo_sm_downloads.php, is part of the upload folder in vBSEO Sitemap. It also includes vbseo_sm_downloads2.php, vbseo_sm_vba.php and vbseo_sm_vba_links.php. I tried removing each of these. Once all of them had been removed, I got no more database errors. However, I still get hundreds of lines of errors, just as I reported in my first post.

Of those modules, I wonder if I should have at least vbseo_sm_vba.php because I use vBadvanced CMPS.

I clicked your link above and got an error:

Fatal error: Call to a member function query() on a non-object in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/addons/vbseo_sm_downloads.php on line 21

But I got virtually the same error when I used the file name of all of those modules:

downloads2 = Fatal error: Call to a member function query() on a non-object in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/addons/vbseo_sm_downloads2.php on line 21
vba = Fatal error: Call to a member function query_read() on a non-object in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/addons/vbseo_sm_vba.php on line 29
vba_links = Fatal error: Call to a member function query_read() on a non-object in /home/ejm/public_html/tfpcom/community/vbseo_sitemap/addons/vbseo_sm_vba_links.php on line 24

I'm clueless on those.

Thanks,

Jim

Removing the file you mentioned from the vBSEO Google/Yahoo Sitemap Generator Addon Generator Modules did not stop the database errors. That file, vbseo_sm_downloads.php, is part of the upload folder in vBSEO Sitemap. It also includes vbseo_sm_downloads2.php, vbseo_sm_vba.php and vbseo_sm_vba_links.php. I tried removing each of these. Once all of them had been removed, I got no more database errors. However, I still get hundreds of lines of errors, just as I reported in my first post.

You should remove them from vBSEO Sitemap Generator options->Addons list (not physically remove the files).

Originally Posted by Oleg Ignatiuk

You should remove them from vBSEO Sitemap Generator options->Addons list (not physically remove the files).

Hi Oleg,

Yes, that is what I did. The files are still in the folder. There are no Addon Generator Modules in the list in the vBSEO Google/Yahoo Sitemap Generator options. I get hundreds and hundreds of lines of those errors I showed above whenever I do a manual sitemap generation. Many of the errors are just repeated, but there are many that aren't on the short list I showed above. If I were to copy all them here, I'd break the place.

I reinstalled the sitemap, as I mentioned above, but that didn't fix anything.

Jim

Which messages do you mean - db errors or fopen/fwrite erros? To resolve fwrite issue you should make sure that permissions are setup correctly - 0777 for vbseo_sitemap/data/ folder and 0666 for all files inside data/ folder (if any).

Originally Posted by Oleg Ignatiuk

Which messages do you mean - db errors or fopen/fwrite erros? To resolve fwrite issue you should make sure that permissions are setup correctly - 0777 for vbseo_sitemap/data/ folder and 0666 for all files inside data/ folder (if any).

I was referring to the fopen/fwrite errors. I do have the vbseo_sitemap/data/ folder permissions set to 0777, but had to change all the files in it from 755 to 666. There was also another folder in there called "hits" and I thought that should be 777ed too and all the files in it 666ed.

Inside the vbseo_sitemap/data/ folder, there are several files I want to be clear that you want at 666 because they are not nnnnnnnnnn.log files. These files are:

downloads.dat
sitemap_1.xml.gz
sitemap_index.xml.gz
urllist.txt.gz

The downloads and the sitemap_index files have not been modified since Jan 4, 2008, but the other 2 have been modified 11/16/2008 5:47 AM (server time).

After changing the permissions to all the files, I did a manual run and this was the result:

Code:

[homepage] [5,433.4Kb mem used] [2s (+2s)]
[SECTION START] forumdisplay [5,433.4Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 15, total threads: 29, pages: 2 [5,433.5Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 16, total threads: 112, pages: 6 [5,434.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 11, total threads: 204, pages: 11 [5,436.2Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 17, total threads: 82, pages: 5 [5,440.6Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 27, total threads: 85, pages: 5 [5,444.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 23, total threads: 279, pages: 14 [5,449.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 38, total threads: 4, pages: 1 [5,468.0Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 28, total threads: 162, pages: 9 [5,474.4Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 41, total threads: 10, pages: 1 [5,485.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 31, total threads: 13, pages: 1 [5,490.7Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 13, total threads: 562, pages: 29 [5,491.5Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 35, total threads: 18, pages: 1 [5,516.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 43, total threads: 29, pages: 2 [5,525.8Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 30, total threads: 45, pages: 3 [5,528.4Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 14, total threads: 261, pages: 14 [5,531.0Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 4, total threads: 55, pages: 3 [5,542.3Kb mem used] [3s (+0s)]
[forumdisplay] forum_id: 3, total threads: 103, pages: 6 [5,549.5Kb mem used] [3s (+0s)]
[SECTION START] showthread [5,554.5Kb mem used] [3s (+0s)]
[SECTION START] albums [5,722.3Kb mem used] [11s (+8s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 5455 [5,440.4Kb mem used] [12s (+1s)]
[create sitemap in text format] part #2 [5,440.4Kb mem used] [12s (+0s)]
[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 1 [5,442.5Kb mem used] [12s (+0s)]
Sitemap has been created. Click here to return [5,442.9Kb mem used] [25s (+13s)]

The time stamp on those files I mentioned reflects the manual run I just did, 11/17/2008 11:27 AM. Looks like the problem is resolved. As long as my permissions are set up properly for those files I mentioned, I guess I am good to go.

Thank you, Oleg.

Jim

Yes, looks good now. I'm glad the issue is sorted!