PDA


View Full Version : Installation Stall

paul41598
06-03-2005, 04:01 PM
It looks like my upgrade stalled at step 2. Blank screen
paul41598
06-03-2005, 04:05 PM
I guess that means its done. I wish it said complete or something
mholtum
06-03-2005, 04:16 PM
that is what I thought too...
LEAD_WEIGHT
06-03-2005, 04:21 PM
I guess that means its done. I wish it said complete or something

Yep I saw that to & mine is working :D
paul41598
06-03-2005, 04:26 PM
so far so good! Im impressed :)
Brian
06-03-2005, 04:41 PM
Actually there are a couple of other steps that should be done. I'm not sure why it wasn't happening on my localhost before, but it looks like there was a small bug with the next step. For anyone that's ran the install before now, I would recommend running your forums and then running these 3 queries (separately though, not at the same time). I've also updated the install file on here so that others won't have the problem.


ALTER TABLE user ADD INDEX (posts)
ALTER TABLE thread ADD INDEX (lastpost)
ALTER TABLE post ADD INDEX (dateline)
paul41598
06-03-2005, 04:46 PM
what do the queries do? Just so I know... and what will happen if i dont run em
mholtum
06-03-2005, 04:48 PM
Seems I am missing the birthdays template as well
hmm
LEAD_WEIGHT
06-03-2005, 04:53 PM
what do the queries do? Just so I know... and what will happen if i dont run em

unless u want to uninstall then reinstall I think that is the last step in the install process. If u do not have perm. to run query then edit your config.php file and set your id to admin id # (1), that should let u do query entries.

So I assume this
1 Quey to enter: ALTER TABLE user ADD INDEX (posts)
2 Quey to enter: ALTER TABLE thread ADD INDEX (lastpost)
3 Quey to enter: ALTER TABLE post ADD INDEX (dateline)
Brian
06-03-2005, 04:56 PM
what do the queries do? Just so I know... and what will happen if i dont run em
They add indexes to some of your tables to ensure that the queries in the CMPS will be optimized.
Brian
06-03-2005, 04:57 PM
Seems I am missing the birthdays template as well
hmm
Edit the page and make sure the birthdays are active on that page.
LEAD_WEIGHT
06-03-2005, 05:02 PM
1 Quey to enter: ALTER TABLE user ADD INDEX (posts)
2 Quey to enter: ALTER TABLE thread ADD INDEX (lastpost)
3 Quey to enter: ALTER TABLE post ADD INDEX (dateline)

When I exected the queries I got this after each one, is this a concern.
1 Affected Rows: 2
2 Affected Rows: 15
3 Affected Rows: 69
Brian
06-03-2005, 05:19 PM
Threads: 16, Posts: 69, Members: 2

Looks right to me. :)