Help - System Down - restore doesn't work..

[stokes]

Ok - I really need some help on this one. I was messing with the secuirty permissions on the forums and saved a page on the forum secuity page.
The backup file came out of the same database. I changed a couple fields (birthday for one) to not be required since the backup and a few config tweaks but that is all I know of.

HELP!

Suddenly, Everything was white pages. I figured I had hosed something in the database so I decided to restore a 3 day old version of it. I uploaded the backup SQL file to the server but it won't load via bigdump. It gives me the following error:

Error at the line 2954: );

Query: CREATE TABLE phpbb_force_read_users(
user varchar(255) NOT NULL,
read int(1) NOT NULL,
time int(10) NOT NULL
);


MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read int(1) NOT NULL, time int(10) NOT NULL )' at line 3

[Helter]

delete the entire force read users table from your backup sql and run again.
if it runs add force read users after the backup is successfull, then add the db info

Code: Select all

CREATE TABLE `phpbb_force_read_users` (   `user` varchar(255) NOT NULL DEFAULT '',   `read` int(1) NOT NULL DEFAULT '0',   `time` int(10) NOT NULL DEFAULT '0') TYPE=MyISAM;

more than likely the db was fine but one of your cache files was corrupted or not properly chmodded when your forum tried to alter it

[stokes]

Before I got your reply, I restored an earlier version of the DB and it went fine without being edited. I deleted the cache directory (off the root) and restored one from a previous backup (I don't know how else to clean it out). I checked the chmod's as well. I'm still getting white screens..

Also, Is there more to deleteing the cache than deleting/emptying the one cache folder off the root?
Forgive my ignorance, I'm new to the app, late for work and trying to get this going.
Thanks for your help ..

[Helter]

if editing profile fields caused your problem, you can restore them to default. Overwrite root/profilcp/def/def_* with new files from the integramod141 package

[stokes]

I will try that. It actually died after I added a new forum area and set some permissions..

[Helter]

have you installed advanced group color mod?

If so, open all the includes/def_*.php files and look for code at the beginning and end like this

Code: Select all

<some>

and delete it.

[stokes]

I don't think so. Only what came in the install package. I downloaded several different temples but no real mods.

I've got stuck on this white screen deal a couple times. Is there a doc or post on how to diagnose, repair and prevent these?

I'm currently restoring the file system from a earlier good backup. I assume that won't hurt.

[Helter]

many things can cause white screens. The most common is corrupted cache files. Check your chmods on all your files listed in the install
http://www.integramod.com/forum/web.php ... install_p1
If they appear correct in your ftp client, check a few from your hosting control panel because ftp programs have been known to incorrectly report file and folder chmods
Also any info, including blank lines after the php close "?>" can cause white screens

double check your chmods on

[stokes]

restoring my var_cache directoy fixed it. In the future, do I need to restore it or can I just ditch the content. Thanks for the help by the way

[Helter]

var_cache is for importal and you should be able to just empty it