Manual Install error

[Kyousuke]

SMF version: 2 RC4
Related Error messages: Table 'xxx_xx.smf_tp_settings' doesn't exist

Hi, im trying to install manually TP for smf 2 rc4 but when i try to enter to the forum i got this error.
Table 'xxx_xx.smf_tp_settings' doesn't exist

How i can fix it?

[IchBin]

If you are doing the install manually, you need to import the tables manually. It looks like I forgot to include that file in the install package in the last update. You'll have to import the sql file in this zip through something like phpMyAdmin.

[Kyousuke]

Thanks for the help.
I tried to import the .sql in phpmyadmin but i got this error:

Error
SQL query:

- -- Table structure for table `smf_tp_articles` -- CREATE TABLE IF NOT EXISTS `smf_tp_articles` ( `id` int(11) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', `body` text, `intro` text, `useintro` tinyint(4) NOT NULL default '1', `category` smallint(6) NOT NULL default '0', `frontpage` tinyint(4) NOT NULL default '1', `subject` text, `author_id` int(11) NOT NULL default '0', `author` text character set latin1, `frame` tinytext character set latin1, `approved` tinyint(4) NOT NULL default '1', `off` tinyint(4) NOT NULL default '0', `options` text character set latin1, `parse` smallint(6) NOT NULL default '0', `comments` tinyint(4) NOT NULL default '0', `comments_var` text character set latin1, `views` int(11) NOT NULL default '0', `rating` text character set latin1, `voters` text character set latin1, `id_theme` smallint(6) NOT NULL default '0', `shortname` tinytext character set latin1, `sticky` tinyint(4) NOT NULL default '0[...]

MySQL says:

#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 '-
-- Table structure for table `smf_tp_articles`
--

CREATE TABLE IF NOT EXISTS ' at line 1

[IchBin]

It looks like the first line has a problem. Delete the single "-" character. MySQL requires a double "--" for it to be a comment line.

[Kyousuke]

Thank you very much.
It works!!


Problem solved. 

[mav1234]

I apologize, but where is the .sql file for uploading?  I suck at this. >.<  Can't click on the attachment from earlier, but can't find it in the recent download.

[IchBin]

Give this one a run.

[mav1234]

There we are Thanks.

Thought I was crazy when I couldn't find it in the package.

[IchBin]

We lost some attachments when the server crashed about a month ago. I've removed the on above so nobody else gets freaked out again.

[mav1234]

edit: figured out my problem, somehow half the manual database changes completed earlier on a previous error, so now causing more of them. >.<