New ERROR Msg

[theoscarspot.com]

I am getting the following error on my forum (I have recently changed hosts).

Unknown column 'ID_BOARD' in 'field list'
File: /hsphere/local/home/sixpack/theoscarspot.com/smf/Sources/Post.php
Line: 943

also...  when I perform a search...

Unknown column 'm.ID_BOARD' in 'where clause'
File: /hsphere/local/home/sixpack/theoscarspot.com/smf/Sources/Search.php
Line: 281

Just for the record, I have done a detailed check, everything is beta 5 except for my template (which all users must use) and it says it is BETA 4, becuase I backed it up off of my old one.  Thanks for your help in advance

[LancelowDowell]

Have you tried running the repair_paths.php utility yet?  Has this worked at all since you changed hosts?  It almost looks like part of your database didn't transfer since it can't find that specific field....  is there a chance you can run this sql statement in your sql manager?

describe smf_messages

just change smf_ to whatever your db prefix is.  Make sure that ID_BOARD is there, it should look like this:

Code Select Expand


ID_MSG int(10) unsigned PRI NULL auto_increment
ID_TOPIC mediumint(8) unsigned MUL 0
ID_BOARD smallint(5) unsigned MUL 0
posterTime int(10) unsigned MUL 0
ID_MEMBER mediumint(8) unsigned MUL 0
subject tinytext
posterName tinytext
posterEmail tinytext
posterIP tinytext MUL
smileysEnabled tinyint(4) 1
modifiedTime int(10) unsigned 0
modifiedName tinytext YES NULL
body text YES NULL
icon varchar(16) xx

[theoscarspot.com]

yeah.. I have run the repair settings utility.  That is how I got the board to work to this point (becuase it would not even show up before).  Unknown helped me get it to at least display.  I was stupid and did not test it out thoroughly before I changed over the name servers.

I will try this and get back with ya.  Thanks

[theoscarspot.com]

Ok,
I think my problem lies here: I ran the query as you wrote it and came up with the results that you said I would find.  Then I ran it again with the DB prefix of yabbse_ (becuase my board was orignally YaBBSE), and also came up with results - the ID_Board.

So.. I went back to repair settings and changed it over to smf_ (as a prefix) and tried the board.  It works, but it does not show up with my current database... it is the empty (fresh install).  Is there any way I can rename my DB prefix's on my old DB to smf_ without destroying it?  Or can I run the upgrade utility and rename it so my current DB works??

[LancelowDowell]

Well, it's probably not a name issue...  renmaing your yabbse_ prefix to smf_ won't fix it since smf doesn't care what the prefix is.  I'm going to have to do some more looking into this...

[theoscarspot.com]

Just to give you some (probably) needed info.  To switch to a new server I did the following:

1- downloaded the fresh install files (not the upgrade).
2- installed the package.
3- went into the repair settings.php file and pointed it to the DB of the backup that I made and installed on the new server.
4- Now I am here.

I am not SQL smart, but I think using the fresh install files, the package thinks that the db is using a smf_ prefix.  Currnetly (using the yabbse_ prefix) I can load the index.php page and see my board as it was when I did the backup, but cannot post or search.  If I go the repair settings and switch to the smf_ prefix, I see the "fresh install" version of the board where the only post is the "welcome to SMF" post, and I CAN post on this one.  I know it is hard to read... but this is a look at my current DB structure.


     Table        Action        Records        Type        Size        Overhead
    smf_attachments                        0     MyISAM        1.0 KB        -
    smf_banned                        0     MyISAM        1.0 KB        -
    smf_board_permissions                        64     MyISAM        3.3 KB        -
    smf_boards                        1     MyISAM        7.1 KB        -
    smf_calendar                        0     MyISAM        1.0 KB        -
    smf_calendar_holidays                        94     MyISAM        5.3 KB        -
    smf_categories                        1     MyISAM        3.0 KB        -
    smf_collapsed_categories                        0     MyISAM        1.0 KB        -
    smf_im_recipients                        0     MyISAM        1.0 KB        -
    smf_instant_messages                        0     MyISAM        1.0 KB        -
    smf_log_actions                        0     MyISAM        1.0 KB        -
    smf_log_activity                        2     MyISAM        4.0 KB        -
    smf_log_banned                        0     MyISAM        1.0 KB        -
    smf_log_boards                        1     MyISAM        2.0 KB        -
    smf_log_errors                        0     MyISAM        1.0 KB        -
    smf_log_floodcontrol                        1     MyISAM        3.0 KB        -
    smf_log_karma                        0     MyISAM        1.0 KB        -
    smf_log_mark_read                        0     MyISAM        1.0 KB        -
    smf_log_notify                        0     MyISAM        1.0 KB        -
    smf_log_online                        1     MyISAM        4.3 KB        -
    smf_log_polls                        0     MyISAM        1.0 KB        -
    smf_log_topics                        1     MyISAM        2.0 KB        -
    smf_membergroups                        8     MyISAM        3.3 KB        -
    smf_members                        1     MyISAM        10.1 KB        -
    smf_messages                        2     MyISAM        9.3 KB        -
    smf_moderators                        0     MyISAM        1.0 KB        -
    smf_permissions                        34     MyISAM        2.8 KB        -
    smf_poll_choices                        0     MyISAM        1.0 KB        -
    smf_polls                        0     MyISAM        1.0 KB        -
    smf_settings                        154     MyISAM        11.3 KB        -
    smf_smileys                        19     MyISAM        3.5 KB        -
    smf_themes                        28     MyISAM        3.0 KB        -
    smf_topics                        1     MyISAM        7.0 KB        -
    yabbse_attachments                        140     MyISAM        14.6 KB        -
    yabbse_banned                        4     MyISAM        2.3 KB        -
    yabbse_board_permissions                        392     MyISAM        19.4 KB        -
    yabbse_boards                        25     MyISAM        7.5 KB        -
    yabbse_calendar                        0     MyISAM        1.0 KB        -
    yabbse_calendar_holiday                        94     MyISAM        7.6 KB        -
    yabbse_calendar_holidays                        94     MyISAM        5.3 KB        -
    yabbse_categories                        7     MyISAM        3.2 KB        -
    yabbse_collapsed_categories                        8     MyISAM        2.0 KB        -
    yabbse_im_recipients                        1,579     MyISAM        59.0 KB        -
    yabbse_instant_messages                        1,579     MyISAM        469.9 KB        -
    yabbse_log_actions                        0     MyISAM        1.0 KB        -
    yabbse_log_activity                        387     MyISAM        14.7 KB        -
    yabbse_log_banned                        0     MyISAM        1.0 KB        -
    yabbse_log_boards                        2,437     MyISAM        50.8 KB        -
    yabbse_log_errors                        1,134     MyISAM        250.6 KB        -
    yabbse_log_floodcontrol                        1     MyISAM        3.0 KB        -
    yabbse_log_karma                        0     MyISAM        1.0 KB        -
    yabbse_log_mark_read                        606     MyISAM        13.9 KB        -
    yabbse_log_notify                        1,115     MyISAM        29.9 KB        -
    yabbse_log_online                        2     MyISAM        5.0 KB       636 Bytes
    yabbse_log_polls                        286     MyISAM        8.2 KB        -
    yabbse_log_topics                        33,223     MyISAM        745.9 KB        -
    yabbse_membergroups                        10     MyISAM        3.4 KB        -
    yabbse_members                        784     MyISAM        205.8 KB        -
    yabbse_messages                        30,818     MyISAM        13.2 MB        -
    yabbse_moderators                        2     MyISAM        2.0 KB        -
    yabbse_permissions                        135     MyISAM        9.1 KB        -
    yabbse_poll_choices                        106     MyISAM        4.6 KB        -
    yabbse_polls                        23     MyISAM        3.6 KB        -
    yabbse_settings                        179     MyISAM        13.6 KB       80 Bytes
    yabbse_smileys                        19     MyISAM        3.5 KB        -
    yabbse_themes                        203     MyISAM        15.9 KB        -
    yabbse_topics                        2,835     MyISAM        292.4 KB        -
    67 table(s)     Sum    78,640    --      15.5 MB      716 Bytes

[LancelowDowell]

Were you at beta 4 or beta 5 before the move?  If you were beta 4, did you ever run the upgrade process to beta 5?

[Grudge]

NO. The upgrade.php script wasn't ran, hence why the column is missing. Run Upgrade.php and you'll be fine.

[theoscarspot.com]

As always... you guys have helped me through my next crisis.  Thanks to all of you for on-point professional help.  The forum is up and running again!

[Grudge]

In the next version, database errors will be more helpful too! They check if you're database and forum are the same version, and if not tell you to run Upgrade.php - so in future no-one should have this problem