PhotoPost Community - View Single Post

mwaite49 · October 31st, 2006, 09:43 AM

Chuck,

Here are some of the things I did yesterday.

I contacted my isp and asked how to find my server logs, and how to show errors. At that time I could not get into my admin area of Photopost.

My isp replied " you can edit the file: /etc/php.d/99user.ini
and change: display_errors
to On (at the bottom of the file), then restart your VDS from the VDS Manager to update this change."

I did that. My server log was filled with messages errors about two tables that had crashed last week. I had found those tables and repaired them, thanks to your help on another thread last week and my gallery was up again.

Here is what the server log says since the tables were repaired:
061023 18:06:27 [Note] Found 0 of 1 rows when repairing './mikewaite/pp_cache'
061030 14:17:21 [Note] /usr/sbin/mysqld: Normal shutdown

061030 14:17:21 [Note] /usr/sbin/mysqld: Shutdown complete

061030 14:17:22 mysqld ended

061030 14:17:24 mysqld started
061030 14:17:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.24' socket: '/var/lib/mysql/mysql.sock' port: 3306 dedicated variant

I was also looking in phpmyadmin for signs that other tables may have problems. The only problem I saw was in the pp_cache table. The primary and index keys were both refering to the same field and the table showed this as a problem. I changed the index key to refer to the timestamp field and left the primary key refering to the id field.

After that I was in the process of reuploading my files. I had reuploaded the templates, the phpbb2 forum file and earlier in the day had reuploaded the uploadphoto.php file. Uploading was slow yesterday and I had not gotten to the other files to re-upload.

I made a test login for you to use as you instructed in a previous message.

When I went to the site to test the test login there was no gallery at all as you've seen.

I'm back to where I was early last week when I had no gallery. I know you have a good solid program that should be working. I have no idea what caused two of my tables to crash which seems to have been a source of some of the problems. I haven't uploaded images for a month, nor made any major changes as administrator. When I upgraded I upgraded from 5.31 to 5.5.

Where do I go now? Re-upload the files and run upgrade again? I appreciate the help I've been given.

Mike

October 31st, 2006, 09:43 AM	#12 (permalink)
mwaite49 Junior Member Verified Customer Join Date: Sep 2005 Location: Southwest Mississipp Posts: 18	Gone from bad to worse Chuck, Here are some of the things I did yesterday. I contacted my isp and asked how to find my server logs, and how to show errors. At that time I could not get into my admin area of Photopost. My isp replied " you can edit the file: /etc/php.d/99user.ini and change: display_errors to On (at the bottom of the file), then restart your VDS from the VDS Manager to update this change." I did that. My server log was filled with messages errors about two tables that had crashed last week. I had found those tables and repaired them, thanks to your help on another thread last week and my gallery was up again. Here is what the server log says since the tables were repaired: 061023 18:06:27 [Note] Found 0 of 1 rows when repairing './mikewaite/pp_cache' 061030 14:17:21 [Note] /usr/sbin/mysqld: Normal shutdown 061030 14:17:21 [Note] /usr/sbin/mysqld: Shutdown complete 061030 14:17:22 mysqld ended 061030 14:17:24 mysqld started 061030 14:17:25 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.24' socket: '/var/lib/mysql/mysql.sock' port: 3306 dedicated variant I was also looking in phpmyadmin for signs that other tables may have problems. The only problem I saw was in the pp_cache table. The primary and index keys were both refering to the same field and the table showed this as a problem. I changed the index key to refer to the timestamp field and left the primary key refering to the id field. After that I was in the process of reuploading my files. I had reuploaded the templates, the phpbb2 forum file and earlier in the day had reuploaded the uploadphoto.php file. Uploading was slow yesterday and I had not gotten to the other files to re-upload. I made a test login for you to use as you instructed in a previous message. When I went to the site to test the test login there was no gallery at all as you've seen. I'm back to where I was early last week when I had no gallery. I know you have a good solid program that should be working. I have no idea what caused two of my tables to crash which seems to have been a source of some of the problems. I haven't uploaded images for a month, nor made any major changes as administrator. When I upgraded I upgraded from 5.31 to 5.5. Where do I go now? Re-upload the files and run upgrade again? I appreciate the help I've been given. Mike