Totally Messed up after Upgrade

[uticasoftball]

So I upgraded to SMF 2.0 RC3. I have no Idea what I did wrong but the forums work but noone knew can join and alot of other functions are screwed up ! Like if I click on someones name to get info on them it comes up "unknown column 'mem.pm_receive_from' in 'field list'
File: /home/uticasof/public_html/phpBB3/Sources/Load.php
Line: 993

I know I am missing files somewhere but have tried fixing this with no luck.

My question is would it be easier (even possible) to backup the database and then do a complete reinstall with the new updated version? or should I wait for help on here and attempt to correct the issues?

Thanks in advance for the help Im lost !! uticasoftball.com/phpBB3 its really not php

[Kindred]

did you run upgrade.php?

[uticasoftball]

Yes and it didnt help at all

[rd]

The only thing I can think of that's causing this error is because you didn't rewrite all the files and folders, please redo and make sure you use the LARGE UPGRADE package. After you upload go to yourdomain.com/phpbb/upgrade.php

[uticasoftball]

I tried that as well. I actually started with that one and then went to webinstall when that didnt work

[gbsothere]

When you uploaded the upgrade.php file into your forum's root and pointed your browser to it, did you also upload the upgrade sql files found in the zip?  Also, what version of SMF did you upgrade from?

[uticasoftball]

Unknown column 'mem.pm_receive_from' in 'field list'
File: /home/uticasof/public_html/phpBB3/Sources/Load.php
Line: 993

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0 RC3, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

Then I do the upgrade and it does nothing. SO what do you think I should do??

[kat]

When you uploaded the upgrade.php file into your forum's root and pointed your browser to it, did you also upload the upgrade sql files found in the zip?  Also, what version of SMF did you upgrade from?

[uticasoftball]

Yes I did but I will do it again now . Maybe I messed something up the 4 other times I tried it :].

Ok what upgrade are you saying I should use? maybe thats why i screwed it up so many times

[kat]

Also, what version of SMF did you upgrade from?

[uticasoftball]

i would assume 1.1.9 since thats what the database it.

OK so I am at the point of installing the large upgrade again and while upgrading i now have an error message of :

ERROR !!Table 'uticasof_smf1.smf_calendar_holidays' doesn't exist

What do I do now? there is no way to continue and I have no idea what to do

[Adish - (F.L.A.M.E.R)]

Go to phpMyAdmin
Open the database uticasof_smf1
Look for smf_calendar_holidays

Does that exist?

[uticasoftball]

Go to phpMyAdmin
Open the database uticasof_smf1
Look for smf_calendar_holidays

Does that exist?

NO it doesnt. smf_calendar is there but not smf_calendar_holidays.

Now What? Is there a way to add that?

[cicka]

Go to phpMyAdmin
Open the database uticasof_smf1
Look for smf_calendar_holidays

Does that exist?

NO it doesnt. smf_calendar is there but not smf_calendar_holidays.

Now What? Is there a way to add that?

Yes, run this query at phpmyadmin for the database of your forum.

Code Select Expand

CREATE TABLE smf_calendar_holidays (
  id_holiday smallint(5) unsigned NOT NULL auto_increment,
  event_date date NOT NULL default '0001-01-01',
  title varchar(60) NOT NULL default '',
  PRIMARY KEY (id_holiday),
  KEY event_date (event_date)
) ENGINE=MyISAM;

[uticasoftball]

ok thank you for that one BUT now that that is fixed i am getting this error message:

Error!
Unknown column 'eventDate' in 'where clause'

again any help would be great

[cicka]

ok thank you for that one BUT now that that is fixed i am getting this error message:

Error!
Unknown column 'eventDate' in 'where clause'

again any help would be great

ok thank you for that one BUT now that that is fixed i am getting this error message:

Error!
Unknown column 'eventDate' in 'where clause'

again any help would be great

Does it mention for which table?

[Adish - (F.L.A.M.E.R)]

Remove your smf_calendar_holiday table and try this one:

Code Select Expand

CREATE TABLE IF NOT EXISTS `smf_calendar_holidays` (
  `ID_HOLIDAY` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `eventDate` date NOT NULL DEFAULT '0001-01-01',
  `title` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_HOLIDAY`),
  KEY `eventDate` (`eventDate`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=168 ;

Then try upgrading.

[cicka]

(F.L.A.M.E.R) is right. I posted the table structure from Smf 2.0 rc3 but according to the error it looks for a column from Smf 1.1.11.

[uticasoftball]

I just tried it and got the same error

Error!
Unknown column 'eventDate' in 'where clause'

Again any help is great

[Adish - (F.L.A.M.E.R)]

Which version of SMF are you upgrading from?