Error adding news and error adding pages

[pilotconnor]

When i try to add news to my site it says There was an error adding the news item and when i try to add a page it says There was an error creating the file?!

[simpilot]

Not sure about the news error without more information but the page error is most likely a folder permissions issue on the pages foldwer. Check the permissions and make sure they are at least set to 0755

[pilotconnor]

they were set to 777 and it still does not work. TFDI my hosting company fixed it once he said that he cleared the template cache. how do i do that

[simpilot]

I am not aware of an option that resets a page template cache. There is a function in the admin panel to reset the general cache of the site but I do not beleieve it is going to do anything with the saving pages issue.

Admin > Site & Settings > Maintenance Options > Clear Cache

If your host was able to fix it before I would contact them again.

[pilotconnor]

it does not work he could not fix it

[t_bergman]

Are you adding pages with weird characters? Example FAQs works but F.A.Q.'s doesn't.

[pilotconnor]

nope for example "Staff Members"

[simpilot]

You are going to have to catch the error from the database. If you enable de-bugging and do not see it add this to your SiteData.class file in the addPage function temporarily, then try to add a page and see what it shows.

$sql = "INSERT INTO " . TABLE_PREFIX .
	 "pages (pagename, filename, postedby, postdate, public, enabled)
 VALUES ('$title', '$filename', '$postedby', NOW(), $public, $enabled)";
 $ret = DB::query($sql);
 if (DB::errno() != 0) return false;

make it look like this temporarily

$sql = "INSERT INTO " . TABLE_PREFIX .
	 "pages (pagename, filename, postedby, postdate, public, enabled)
 VALUES ('$title', '$filename', '$postedby', NOW(), $public, $enabled)";
 $ret = DB::query($sql);
 var_dump(DB::error());exit;
 if (DB::errno() != 0) return false;

I am guessing there is an apostrophe in the user name or the text somewhere that you don't realize is there.

What is the link to your site?