Another error

[tazgal]

I installed a mod that crashed my site.  I can't access it all.  I have this error that pops-up now when I go to my site:

The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.

I have a back-up from 10/16/10. When I tried restoring it using phpmyadmin (version 5.2.12), I get this error:

SQL query:

CREATE TABLE `smf_tp_events` (
id int( 11 ) NOT NULL AUTO_INCREMENT ,
id_member int( 11 ) NOT NULL ,
date int( 11 ) NOT NULL ,
textvariable mediumtext NOT NULL ,
link mediumtext NOT NULL ,
description mediumtext NOT NULL ,
allowed mediumtext NOT NULL ,
eventid int( 11 ) ,
ON tinyint( 4 ) ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on tinyint(4),
PRIMARY KEY (id)
) TYPE=MyISAM' at line 10

How do I fix this?  MySQL version is 5.0.45.

[YogiBear]

Hi tazgal,

Firstly, a bit of groundwork. What mods do you have installed and which mod was it that caused the crash?

Also, which version of v2.0 are you using...RC3?

[Masterd]

Did you tried to restore a backup from Packages/backups?

[tazgal]

I couldn't log in to see what's installed.  I do have an old copy of the forum that I managed to install just a few minutes ago.  I deleted all the files off the server and uploaded the old files (smf 1.1.11).  Now, when I click on the admin tab I get this: Unable to load the 'GenericMenu' template.  I am trying one other thing to get it resolved -  basically upgrade it to 2.03. 

[tazgal]

It worked!