TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 08:03:26 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,104
  • Total Topics: 21,212
  • Online today: 143
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 98
  • Total: 98

Table 'smf.smf_tp_settings' doesn't exist

Started by thomaswebb, June 04, 2011, 05:04:50 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

thomaswebb

Link to my site: http://www.eve-blackarmada.com
SMF version: SMF 2.0 RC5 / SMF 1.1.13
TP version: TP 1.1 RC1
Default Forum Language: English
Theme name and version: Default
Browser Name and Version: Google Chrome /IE9
Mods installed: None
Related Error messages: Table 'smf.smf_tp_settings' doesn't exist

I am at an impass here. I cannot figure out what is causing this error. I have MySQL 5 installed, the username used to install SMF has dba permissions, everything else gets modified just fine, however now matter what I do, I always get this error after installing TP. It says that everything installed successfully, however this always comes up.

If it helps, its running off IIS in windows server 2008 RC2, I have php 5, MySQL 5.5, and I have tried it with both SMF 2.0 RC5, and SMF 1.1.13.

Any suggestions?

P.S - When I look at the SQL db, there is no table for smf_tp_settings.. Is there an error in the installation script causing it not to create the DB properly?

IchBin

It seems to be a problem with certain server setups. I posted a sql file that one can run on the SMF site in the TinyPortal support topic which you can import into the database to fix it. I've rewritten the code since then and it shouldn't have the same problem on the next version. If you can't find the file at SMF post back and I'll attach it here when I get a chance.

lurkalot

Just a side note:

This also applies to anyone trying to install TP on a local setup using the latest version of Xampp / Wamp.  ;) 

thomaswebb

Awesome, I ran the script in phpmyadmin today, and it created the tables and everything is working great!

Thanks!

candyman

i have the same problem.. i imported database from old SMF 2.0 to a fresh 2.0 install.. i need this script

IchBin

Try the php file I posted in the support board as a sticky for those that upgrade. It should at least create the table if it doesn't exist.

DukeOfAwesome

Hi,

I am getting the "Table 'smf.smf_tp_settings' doesn't exist" error. I tried your updated version of the tp_update.php file and still no luck. I am using SMF 2.04 with TP v1.0.

I had to install theTP manually after the install package failed.

Is there just a SQL script somewhere I can run to create the database tables manually to get around this problem?

Thanks

Duke

IchBin

Please start a new topic in the future. Resurrecting topics that are 2+ years old is not something we want here. If you need to, link to any topic that is related to your topic. If you can't get the tables to install on a fresh install, I'm not sure what to tell you. This will give you the structure of the table, but I'm betting you'll have more problems after getting the table installed. This assumes that you have smf_ as the prefix to your database tables.

CREATE TABLE IF NOT EXISTS `smf_tp_settings` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
)

DukeOfAwesome

Hi,

Thanks for that. That worked, but now I get the error:

Table 'smf.smf_tp_articles' doesn't exist

Can you please provide me with a script that creates the entire database required by Tiny Portal?

Many thanks

Duke

IchBin

This is not going to help you. If you are missing the tables, what about all the data that gets set by default when TP installs? There are a ton of settings that TP sets as well as some default data that will be missing if you only create the tables that are needed. You need to figure out why your host is not allowing TP to install properly.