Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
forum database error message
Old 03-13-2007, 04:23 AM forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
I put a PunBB forum on my website here - then made the mistake of trying to put another database for another forum on my host space. Chaos ruled. I discovered that PunBB forums interfere with each other if on the same space so I moved the new one and someone helped me sort out the mix ups - but now I can't access the admin board to change settings on the original forum. I get a message

please make sure PHP has write access to the directory cache

do you know what this means and what I should do?
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
 
Register now for full access!
Old 03-13-2007, 05:11 AM Re: forum database error message
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
You can have two lots of forum tables on one database provided you change the table prefix to identify which is which.

A Google Search gets this
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-13-2007, 05:12 AM Re: forum database error message
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
The forum software seems to use a directory to cache some pages generated.
Try to look in the installation notes if you can spot it.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 03-13-2007, 03:27 PM Re: forum database error message
Learning Newbie's Avatar
Defies a Status

Latest Blog Post:
Astounding Republican Paranoia
Posts: 5,662
Name: John Alexander
Trades: 0
And in the future, use a transaction when you do something "dangerous." This way you can commit if everything works, or roll back when chaos reigns.
Learning Newbie is offline
Reply With Quote
View Public Profile
 
Old 03-14-2007, 05:09 AM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
thank you - I'm out of my depth here but I'm wandering around in phpbuilder trying to understand your answers!
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 03-14-2007, 03:27 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Found it! Thanks all.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 03-31-2007, 02:04 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Hi, remember this message? Sorry, I'm a slow learner. Now the same thing has happened on my other site, here I get the message 'please make sure PHP has write access to the directory cache' when I try to access the forum page... and I can't remember where to find the file that lists write access. Please can someone give me a clue?
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 03-31-2007, 02:33 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
Quote:
Originally Posted by Kay G View Post
'please make sure PHP has write access to the directory cache'
I think you just need to adjust the directory permissions for that directory (i.e. cache).

You should be able to do so via FTP. 6 stands for "read and write" on a Linux based system; you can find full details here: http://en.wikipedia.org/wiki/File_system_permissions

If you're still stuck - let us know what FTP client you're using and what the cache directory is currently set to.
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 03-31-2007, 03:10 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Thank you. What do you mean by which client? I've got Windows XP on my system, the database is on Supanames hosting and I'm uploading to it via SamrtFTP. I confess I shovelled all the files for the forum onto it without really understanding them all. There is a file called cache.php is that what we're talking about? It includes this:

Output ban list as PHP code
$fh = @fopen(PUN_ROOT.'cache/cache_bans.php', 'wb');
if (!$fh)
error('Unable to write bans cache file to cache directory. Please make sure PHP has write access to the directory \'cache\'', __FILE__, __LINE__);

fwrite($fh, '<?php'."\n\n".


...which is presumably what created the error message I'm getting.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 03-31-2007, 03:58 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
No - not talking about the file cache.php - there's a directory (folder) called cache PHP that you'll find in your hosting space.

Take a look here: http://www.siteground.com/tutorials/ftp/ftp_chmod.htm

You need to set the 'write' permission so that the web server (PHP) has access to write new files to the cache directory.

Login to your hosting space via FTP and right-click on the cache directory, select Properties / CHMOD as shown in the screenshot on that link above...

Should hopefully be obvious from there. However, you only need to do this for the directory itself - not for "subfolders and files" - so no need to have that option ticked..
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 03-31-2007, 04:03 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
I should add that the 'write' option is available for 3 different "levels" (assuming a Linux hosting server):

User / Group / Others

In many cases, PHP runs as a completely separate user on the system to your own FTP user. This means that the setting for User (first number) has no relevance here and should be left alone... you probably need to change "Others" to have "write" permission - but please try changing "Group" first if this doesn't already have "write" permission.

You want to ensure that this permission is as limited as possible, and setting "others" to "write" potentially allows anyone to write to this directory (i.e. including other users on the same server at your web host). If it works with "group" set to "write", this restricts to other users in the same group only (depends on your host's configuration as to what users this actually includes).
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 04-01-2007, 06:21 AM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Hmm, I found that - thanks for the excellent directions! But it hasn't made any difference.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 04-01-2007, 10:03 AM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
What are the permissions set on the cache directory at the moment?
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 04-01-2007, 01:47 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
The same as the screenshot you showed in the link above - Users/Group/others for Read, Write and Execute checked UID GIP and Sticky unchecked - but I tried all combinations of the write permissions with no change.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 04-01-2007, 01:52 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
From my understanding of the error message, it sounds like there's a config. file that it's trying to write to - maybe that already exists rather than needing to create it, and therefore the permissions error is on that file?

I'm guessing (on the basis of the PHP you posted earlier) that it would be called cache_configuration.php perhaps? Check if that file exists in the cache directory, and if it does then try making that writable.

If it doesn't exist - perhaps provide a listing of the files in the cache directory (but don't post a list of hundreds of files!! - not without using the [ code ] tag or something anyway!).
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 04-01-2007, 02:04 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
I've got config.php - it is already checked as writable. I've tried giving write permissions on all the php files I can find ... no change.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 04-01-2007, 02:13 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
Based on the information in this thread on the punBB forums, I think you may be able to fix this by deleting everything in the cache directory.

Give that a try (at your own risk!), and if that doesn't fix it I'd recommend your best place for more help on this may be the punBB forums (link above) as obviously people around there actually have some experience with it
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Old 04-01-2007, 04:08 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Thank you.

Quote:
Originally Posted by damien_ls View Post
No - not talking about the file cache.php - there's a directory (folder) called cache PHP that you'll find in your hosting space.
Can you tell me where to look for this?
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 04-01-2007, 05:04 PM Re: forum database error message
Experienced Talker

Posts: 31
Name: Kay Green
Location: Hastings, UK
Trades: 0
Well it's changed - I now get 'Firefox can't find the server at www.eflorum.co.uk' - it can find all the other pages of the site.
Kay G is offline
Reply With Quote
View Public Profile Visit Kay G's homepage!
 
Old 04-01-2007, 05:14 PM Re: forum database error message
damien_ls's Avatar
Layershift

Posts: 474
Name: Damien
Trades: 0
Did you delete ALL files - or just files within the cache directory?
__________________

Please login or register to view this content. Registration is FREE
:: DDS & Dedicated, UK & USA-based
Please login or register to view this content. Registration is FREE
, Reseller & Shared Hosting
Experienced Parallels Platinum Partners (Plesk since 2001, Virtuozzo since 2003)
damien_ls is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to forum database error message

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.61818 seconds with 12 queries