#1 By: kriskd Subject:Installing a new message forum Time: 29.Apr.06 22:06:02
In a few weeks, I will be starting a brand new message forum. I just want to verify that 3.0 is still the version to go with and that everything is easily available for a fresh install.
I haven't installed a new message forum since last summer (I think) so I might be a bit rusty. A refresher of the common problems people experience might be useful, not only for me, but for people who stumble across this thread.
Any updates on 3.5 yet?
#2 By: Datarunner Subject:Installing a new message forum Time: 02.May.06 21:53:06
There is a new admin interface that has been programmed by me and there is going to be a better installer. However, I am currently very much involved with an own mod I am programming, and I am writing my final test for industrial clerk in 5 months, so I do not know how much time I am going to have. Certainly there is going to be a better cookie handling.
Datarunner
#3 By: imagineopenes Subject:Installing a new message forum Time: 04.May.06 21:15:36
Hey Kris...
If you plan to use 3.0 you should be fine, I tried reinstalling a 3.0 board a short time back and had no problem.
Avoid PHP 5 if you can. Usually making sure your files are writable like Settings.php and templates are the biggest problems. Other problems include not setting up directories or paths correctly. Just make sure you type in the correct paths and follow the examples.
Templates also seem to be an issue for some people, make sure you specify a logo in the template you plan to use.
#4 By: kriskd Subject:Installing a new message forum Time: 07.May.06 15:51:37
Related to this project, I want to lock down my existing message forum once the new one is launched. I'm going to lock all the boards and turn off registrations. I also want to turn off PM usage. If I check the "Restrict All IM usage" checkbox will that prevent people from being able to view current PMs? Will it delete the PMs or anything?
Also, if I'm missing anything else that should be down to "lock down" the message forum, give me a shout.
#5 By: kriskd Subject:Re:Installing a new message forum Time: 07.May.06 15:52:43
Okay, just spotted the "Allow IM viewing only" checkbox. That sounds like what I want. Still, I'd like to know the effects of restricting IM use when you've allowed IMs all along.
#6 By: webmaster Subject:Installing a new message forum Time: 07.May.06 23:48:15
affects? there shouldnt be. Your simply just turning them off. You can let us know tho.
Still no word if I have that new job.. Every day I am sending out resumes.. this job i am in was a very big mistake for me to take.. And chances are I will be out of work as of the 15th.. That?s the deadline they are giving me to become as good as they expect me to be, which is pretty dammed good.. I've found out through this experience that the way I learned php .. by remodeling existing code.. Is not the way to learn PHP.. So I been struggling and frankly I don?t think I'll cut the muster.. So.. if I don?t land a new position before the end of the week I will be returning home to south bend.. My fianc??s daughter/husband/kids are moving into the house so we'll have them to help us recover from all this.. Meanwhile taken and I both will be out of work looking for something new.. I may end up falling back to driving a semi truck.. That?s the worst scenario ahead of me.. if it happens, her and I would go over the road together.. So many things are up in the air right now and the stress and pressure of it all is crushing.. I seriously regret making the decision to leave the good job i had.. It didn?t pay as much and just about every day I spent the entire day doing nothing.. but I was safe.. my home was safe.. my life was safe.. Now because of me jumping ship.. my fianc? turned in her resignation and her job is eliminated.. And I can?t go back to work with my previous employer, they saw this as a way for them to save money... Believe, I begged my previous boss to take me back. Now her and I are both in precarious positions.. And after next week I may end up not having a means to support our home other than the rent her daughter will make on it. Taken and I will still have to make up the difference to make the mortgage and bills. And we gave up most of our house furnishings to make room for her daughter?s stuff.. Our intentions were to resettle here in Virginia and buy new goods.. So this is what?s happening.. I wished I had friends that could help.. Some people who could spend some serious time with my brain and build my abilities up on PHP.. Or something.. a grace from God right now. A phone call from a company ready to put me to work in what I do best and ready to put me to work right now..
Please pray.. I don?t know if prayer will help but if God is listening and is able to intervene amongst all of the other agonies and concerns of people that are going on in this world.. Maybe just maybe something will bring me back out of this perfect storm we?re facing..
#7 By: kriskd Subject:Installing a new message forum Time: 08.May.06 02:38:38
Wiz,
Thanks for the update. I had no idea things weren't going well at your new job. Take some time and get everything in order. I can work through my small issues and hopefully get some help with the other SM experts!!
Anyway, I am trying out dreamhost because I expect this new message board to be successful and hopefully grow fast and therefore needed the space and transfer that they offer. I got SM300 installed pretty quick, but am running into db trouble and can't even look at my db via phpmyadmin. I got a support ticket in with the webhost. Here's an example of the errors I'm running into:
Unknown column 'm.ID_MEMBER' in 'on clause'
File: /home/.cutiekins/sprechereast/sprechereast.com/forum/Sources/MessageIndex.php
Line: 358 |
|
Tips are appreciated while I wait to hear back to the host about how I can get into the guts of my db.
#8 By: webmaster Subject:Installing a new message forum Time: 08.May.06 03:17:07
That indicates your table members, column ID_MEMBER is missing.. but it shouldnt be! go take a look..
#9 By: kriskd Subject:Installing a new message forum Time: 08.May.06 03:24:57
That indicates your table members, column ID_MEMBER is missing.. but it shouldnt be! go take a look..
|
|
First, I can get into my db! [clap]
I checked the table and it's there. Here are the settings for it:
Field: ID_MEMBER
Type: int(10)
Collation:
Attributes: UNSIGNED
Null: No
Default:
Extra: auto_increment
#10 By: webmaster Subject:Installing a new message forum Time: 08.May.06 12:39:16
Look at this line in messageindex.php, line 355
FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2
for sake of experiment change that to:
FROM ({$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2)
also look for column ID_MEMBER in tables messages, members and topics.
IF the change in code makes the code work then the problem is PHP or MySQL version conflict. If that is the case contact Datarunner, he has been updating the code base. Have hime give you his codebase with his database structure. You would need to drop yours and add his the apply the updates. If he's not able to do so I can pass on to you what he and I had accomplished. But what I have on file may not be fully complete, allthough I went through it throughly.
#11 By: imagineopenes Subject:Installing a new message forum Time: 08.May.06 13:13:41
It is definitely the messages table, if the error it gave you is correct.
if your error message says
Unknown column 'm.ID_MEMBER' in 'on clause'
File: /home/.cutiekins/sprechereast/sprechereast.com/forum/Sources/MessageIndex.php
Line: 358
The code shows:
{$db_prefix}messages as m
Then the problem is that it cannot identify this column, either because it doesn't exist or because your mysql engine is having a problem processing the query. Perhaps try adding (inserting) a dummy entry to the message table? I am assuming you didn't modify the install script and remove the default entry.
#12 By: kriskd Subject:Installing a new message forum Time: 09.May.06 01:08:02
Then the problem is that it cannot identify this column, either because it doesn't exist or because your mysql engine is having a problem processing the query. Perhaps try adding (inserting) a dummy entry to the message table? I am assuming you didn't modify the install script and remove the default entry.
|
|
I tried Wiz's suggestion and it didn't work.
Took a closer look at the messages table and found a problem with the "dummy" entry. ID_MEMBER should be 2 not 1. I (admin) am member #1 and the dummy post has been made by member #2 (Wiz). Changed it in the table, but I'm still getting errors. I also changed it in the topics table for ID_MEMBER_STARTED AND ID_MEMBER_UPDATED. Are there any other places where the member ID is simply wrong?
I'm heading out for the evening and will look forward to your comments later!
#13 By: kriskd Subject:Re:Installing a new message forum Time: 09.May.06 01:14:55
I'm also running into trouble with ID_LAST_TOPIC
Unknown column 'b.ID_LAST_TOPIC' in 'on clause'
File: /home/.cutiekins/sprechereast/sprechereast.com/forum/Sources/Recent.php
Line: 47
#14 By: webmaster Subject:Installing a new message forum Time: 09.May.06 01:36:43
erm.. I've always been a shadow admin (strickly for support if needed) on SM installs. My member presence has never given anyone a problem.
#15 By: imagineopenes Subject:Installing a new message forum Time: 09.May.06 01:43:34
I don't know if it will work, but something that has fixed database problems for people in the past.
Try running the SuperModUpdate script on your board over top of the installed board.
+
You can also run a db repair in mysqladmin\use the admin panel to run a check for db errors. T
+
Just in case those don't work try backing up Recent.php and MessageIndex.php from your working site and then use the one that currently works from your running board, if that still fails let us know. - my board worked from the download distro sometime back, so if this works for you then something got changed by someone and you should let us know...
#16 By: kriskd Subject:Installing a new message forum Time: 09.May.06 03:55:57
Ugh... none of this is working. I'm willing to give admin/ftp access and if you fix it you just have to tell me what you did! 
#17 By: imagineopenes Subject:Installing a new message forum Time: 14.May.06 01:57:55
I have been sick with a UTI - kidneys, and kidney stones, otherwise I would love to help but I can barely stand staring at this computer for more then a few minutes. Hopefully someone else will volunteer before I get better, otherwise I would love to help at that time.
#18 By: kriskd Subject:Installing a new message forum Time: 14.May.06 16:02:12
No worries. My latest install is for a project that is down the road a bit so I'm not in a big rush. I will likely be wiping what I started on that domain and try a fresh install elsewhere. I'm sort of wondering if it's an issue with a host as I switched webhosts. When I really get into my next project, I'll try a fresh install of SM on my original webhost and see if that works.
So, everyone please take care of yourselves. You all know I'm not shy about posting when I need help! 