fresh install/upgrade

registered · Posted: Tue Aug 10, 2004 12:30 pm

I have a few issues with my site.

I was thinking about doing a fresh install of 7.4 (or whatever is recommended) into a folder on my site.

Once that is done I can make my mod changes and work on the site till I am done. Right now I am using 7.1 and I wonder if I can have the 7.4 fresh install and the 7.1 current site share the same database. I can continue to work on the 7.4 folder untill it is up and going correctly then just change over.

Is this a good way to get a clean site that is up to date and maybe get away from some of the bugs I am facing?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

You will need to run the separate database updates 7.1-7.2, 7.2-7.3, 7.3-7.4. Replace all your files with the 7.4patched d/l from here.

Posted: Tue Aug 10, 2004 12:44 pm

I don't want the main site down. Is there a way I can do this without interrupting my site for a long peroid of time? Like duplicate my current database or something?

Posted: Tue Aug 10, 2004 12:48 pm

Sure. You can export your current database and import it back with a different prefix. For help on large database restores, you might want to look at this http://www.hotscripts.com/Detailed/20922.html

Posted: Tue Aug 10, 2004 12:57 pm

I wish I would have known about this script when I was uploading my database to the server last week! LOL!

Quote:

$linespersession = 3000; // Lines to be executed per one import session
$delaypersession = 0; // You can specify a sleep time in milliseconds after each session

You have a recommendation on those two settings?

Posted: Tue Aug 10, 2004 1:05 pm

I would say that you could safely bump the 3000 to 6000, but net congestion, etc, can play in. The other one, well, I haven't used the script so here again, try stuff and find out. Keep in mind that 1000ms = 1 second.

Posted: Tue Aug 10, 2004 1:12 pm

Here is a load for ya to think about.

I really think there is an entry in my database somewhere that is causing some problems. I doubt I could ever find it.

If I copy this database then I probably won't get rid of my problems. I don't want to loose forum posts, downloads stats and setup and total page views. I have attachment mod running and loosing all of those is no big deal with me.

I'm just not sure what the best option is on this. I really need a clean installation. Is there a script out there that will compare my current database to a default one and print out what is different for me to determine if there is a database problem. At least with that all I have to worry about is re-modding everything once I do a 7.4 install.

Can I have my cake and eat it too?

Posted: Tue Aug 10, 2004 1:18 pm

It would be easier to state the nature of the problem and let's see if we can fix it.

Posted: Tue Aug 10, 2004 1:24 pm

It's the user permissions in forums admin. I can't assign moderator status normally. I can't remove forums admin on anyone. I don't get errors of any kind. The page just updates but when I open up permissions on that user my changes did not take.

Posted: Wed Aug 11, 2004 6:59 am

I installed 7.4 into a temporary folder and used that script to upload the database.

That is a script I would offer on the hosting side, Raven. It was very easy to use and did the job in less than a minute. All 12megs.

I went strait to forums admin and tried to change the user permissions and it wouldn't change. Wouldn't that mean that it is for sure a database issue and not a file issue?

Is there any way of knowing where the entry in the database is? At least a general location?

Of course, I haven't added all the mods that go along with the database so maybe that is why the problem is still there. I dunno, my head hurts now.

Posted: Wed Aug 11, 2004 10:01 am

Quote:

went strait to forums admin and tried to change the user permissions and it wouldn't change. Wouldn't that mean that it is for sure a database issue and not a file issue?

What user permissions?

Posted: Wed Aug 11, 2004 11:58 am

I can't change to 'is moderator'. When I go back into that users permissions the changes didn't take.

Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Hey I just posted this very same problem in Sentinel bug reports cos it only happened after I upgraded to Sentinel 2.0.1

Sorry for posting it in there BEFORE I read this thread.

It must be something causing it, for 2 people to have the same problem.

Well it is with the mod permissions, I also have issues with user permissions and demoting admin to mods and setting all permissions.

It keeps changing permissions without me doing anything.

Posted: Wed Aug 11, 2004 4:05 pm

It would have to be a database entry doing it if it is Sentinel.

Posted: Wed Aug 11, 2004 4:22 pm

I was thinking maybe it was something to do with the mainfile url folder we had?

I just dont know, but it was after sentinel 2.0.1 and the mainfile url folder went up that the problem started so it could be either or neither.

lol

I'll put a link to this thread in the thread I put in Sentinel Bugs if it helps.

Posted: Wed Aug 11, 2004 4:30 pm

You know, I'm having this problem on the fresh install site and I haven't installed the Sentinel files yet. Of course the database with the Sentinel tables is there.

Posted: Wed Aug 11, 2004 4:37 pm

Hmmmm

I wish I was more techy and understood more.

Let's hope one of the gurus here can suss it out for us.

Here's the link to the thread I posted in Sentinel Bug Reports if you wanna read it

http://www.ravenphpscripts.com/postt2597.html

Posted: Wed Aug 11, 2004 5:09 pm

Sentinel installs no code that would cause this. To verify that, just comment out the include statement in mainfile.php. Let me know. What is the error that you are receiving?

Posted: Wed Aug 11, 2004 5:11 pm

I'm not receiving any errors Raven

The forum permissions are changing by themselves for users and groups and some you can't change at all to what they should be.

It's crazy

Posted: Wed Aug 11, 2004 5:12 pm

Did you comment out the Sentinel include statement and try it?

Posted: Wed Aug 11, 2004 5:14 pm

no hang on I've only got a 28k dial up connection lol

give me 5 mins

Posted: Wed Aug 11, 2004 5:20 pm

No it made no difference
and when I checked a user permissions there's no disallow box where there should be 'allow' 'disallow'

still couldnt change permissions

put the includes line back in mainfile now

Posted: Wed Aug 11, 2004 5:28 pm

I have had this issue before with userpermissions in forums. It has always been because of a database entry in the nuke_users table that was causing the problem.

Posted: Wed Aug 11, 2004 5:33 pm

So you dont think it could be the latest nuke patched updates?

something conflicting somewhere.

strange it's just us 2 have the same problem

Posted: Wed Aug 11, 2004 5:35 pm

Have you installed anything that edited your database in the last couple of weeks/since you last messed with user permissions?