TinyPortal

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?

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.

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

Quote
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

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

Thank you very much.
It works!!


Problem solved.  ;)

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.

Give this one a run.

There we are :) Thanks.

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

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. :)

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