I was logged in as admin yesterday looking at my settings. Today, I get the login successful screen and then takes me back to the gallery page there are none of the admin or upload photos menus. So I can't go into the admin menu.
Using phpmyadmin I looked at the pp_users table and although the structure is there there seems to be no data. I cannot browse that table. I'm assuming that's where I would have settings showing me and my registered users.
My pp_usergroup table looks ok to me.
I integrate with phpbb2. I show up as administrator in my phpbb2 tables and can get into the administration site for that.
Although my gallery is up and people can view it I need to fix this problem.
I'm also wondering why I'm having some of the problems I've had. I do no mods and have kept updates fairly current for both Photopost and phpbb2.
I cannot get into my admin area. The problem I have today is that although I get a login successful screen it really doesn't log me in. I go back to the same screen with "login" as the menu item rather than a logged in site where there is "admin", upload photos" and "logout" as menu items.
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: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.