View Full Version : Major Troubles
February 8th, 2006, 01:56 AM
I am having issues with my server and one of the techies decided to do some database work without my backing up first (he assured me it would not make any difference and I was at work). I have most of my site back up, but the gallery still won't work. They want $250 an hour to fix it.
Here is all that happens now:
Any thoughts on how to fix this?
February 8th, 2006, 08:55 AM
Can you log-into the admin of the gallery @ all ?
Are the forums and the gallery connected via style and database, or is the gallery standalone ?
Do you have the gallery and forums in the same database?
February 8th, 2006, 12:10 PM
I can't log in at all b/c that part of the page doesn't load (I can go in through my V-Deck if I knew what to do once in there though). I had Chuck from here install this 2 years ago so I don't know for sure if they are the same database, but I do know that my members don't have to log in twice. They can go from the forums to the gallery no problem.
February 8th, 2006, 02:08 PM
[ Moving from vBGallery to PP Pro ]
February 8th, 2006, 03:46 PM
In phpmyadmin run this command
REPAIR TABLE iponline
or pp_iponline if your table prefix is pp_
February 8th, 2006, 05:01 PM
I tried both but it tells me that there is no database selected. I am totally dumb about this stuff.
February 8th, 2006, 05:12 PM
Well you need to be viewing your photopost database in phpmyadmin and run the command noted to repair that table.
In the left pane window of phpmyadmin you can select the proper database
February 8th, 2006, 05:35 PM
That's the problem. The only two that are there are my store and my forums. Is is the forums one?
And I should mention that the techie did the repair option on all my databases and that's what caused the problem in the first place.
I have backed up though today so we can try anything.
February 8th, 2006, 05:58 PM
View the forums table and see if there is a pp_iponline table there and repair it
That is why your header is just repeating and repeating
You can drop the pp_iponline table if the repair does not work and create a new one
CREATE TABLE pp_iponline (userid VARCHAR(128) NOT NULL default '', ipaddr VARCHAR(75) NOT NULL default '', date INT(11) UNSIGNED, what VARCHAR(64) NOT NULL default '',item VARCHAR(16) NOT NULL default '', PRIMARY KEY (ipaddr)) TYPE=MyISAM
February 8th, 2006, 07:19 PM
This is really just too far over my head. I pasted the line above into the create new table area and it won't allow me to save it. How much would it cost for me to pay you guys to fix it?
February 8th, 2006, 07:32 PM
You can PM me your phpmyadmin access and url
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.