in mysql database, i deleted log_activity, now forum won't upgrade

[Johnnymushio]

i deleted the table since it was corrupted for some reason.

when i create the table log_activity, what values do i put in it?

right now i get this error when upgrading

This query:

    UPDATE MBlog_activity
    SET date = '0001-01-01'
    WHERE date = '0000-00-00';

Caused the error:

    Table 'MBlog_activity' doesn't exist

[JimM]

What version of SMF are you trying to upgrade from and to?

[Johnnymushio]

im upgrading to the newest one, from the second newest one. not 2.0

[JimM]

What version of SMF are you trying to upgrade from and to?

[SlammedDime]

'newest' isn't a version... be specific about version numbers.

[Johnnymushio]

version number doesnt matter, given my database table problem.

and seriously? by newest i mean the newest version that is out.

"newest isn't a version" thanks for that, ill write that down

[busterone]

You must not seriously want any help with answers like that.
There are two "newest versions" and the db is different between them in many respects.
1.1.13, or 2.0 RC5 are both newest versions.

[Quexinos]

Well he said not 2.0 so I'm assuming he means 1.1.13 but yeah, no need to be rude about it *goes back to lurking*

[SlammedDime]

version number doesnt matter, given my database table problem.

and seriously? by newest i mean the newest version that is out.

"newest isn't a version" thanks for that, ill write that down

Version number does make a difference, as we'll have to go into the install package for your version, look at the SQL file, find the Schema for that table, and copy it here for you (or you could just do this since you seem to know what you're talking about)

[Johnnymushio]

i said the newest version, and
i already said its not 2.0, so that leaves what?

one point one point thirteen

for example,

if you have three things, a b and c.
the answer is not a or b.
what is the answer?
(it's c)

and how would i go about copying the database table when i dont have it? (hence, why i posted here)

[SlammedDime]

Thanks for that lesson in deduction, I'll be sure to pass that along to my college professors who forgot to teach me that...

Here is your SQL:

Koodi [Valitse] Laajenna

#
# Table structure for table `log_activity`
#

CREATE TABLE MBlog_activity (
  date date NOT NULL default '0001-01-01',
  hits mediumint(8) unsigned NOT NULL default '0',
  topics smallint(5) unsigned NOT NULL default '0',
  posts smallint(5) unsigned NOT NULL default '0',
  registers smallint(5) unsigned NOT NULL default '0',
  mostOn smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY (date),
  KEY hits (hits),
  KEY mostOn (mostOn)
) ENGINE=MyISAM;


Since you taught me something, let me teach you something...

• Go to our downloads page (http://download.simplemachines.org)
  
• Download the 'newest' version installer package
  
• Open it up with your favorite unzipping utility.
  
• Open the SQL file in your favorite text editor
  
• Use the 'Find' feature (it's similar to a google search, but only works on local files)
  
• Search for the database table name you're looking for
  
• Copy the schema, changing the db_prefix to match your database prefix
  
• Run the SQL in your favorite database administration tool.
  
  There, was that so hard?

[Johnnymushio]

thanks, all is well now.

thanks 4 yor leson larning is fun

the bullets made is especially easy to follow

[JimM]

If this is solved, please mark it solved by clicking the Mark Topic Solved link at the bottom left.

[Johnnymushio]

i need a bulleted list explaining how to do that. please.

[Johnnymushio]

i wanted to do it...