Help! smf_tp_variables doesn't exist! HELP

[barpoet]

I'm trying to go from a regular SMF to TP.... I uploaded the TP 0.9.8 install throught the package manager, and now this is what it says.....

Table 'mypage.smf_tp_variables' doesn't exist
File: /home/content/b/a/r/barpoet/html/forums/Sources/TPortal.php
Line: 92

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.5, while your database is at version 1.1. The above error might possibly go away if you execute the latest version of upgrade.php.

any idea's...
oh yeah, and i have a limited amount of knowledge of this stuff.

[G6Cad]

www.simplemachines.org holds your answers.
The packagemanager are their department.

[barpoet]

I cannot do anything with my forum now... Since I uploaded TP I get the same database error.

[IchBin]

In the downloads section, download the manual_tp_install.php file, put it in the root of your SMF folder, then open from your browser like this.

http://www.yoursitename.com/path_to_forum/manual_tp_install.php

See if that will fix your problem.

[barpoet]

In the downloads section, download the manual_tp_install.php file, put it in the root of your SMF folder, then open from your browser like this.

http://www.yoursitename.com/path_to_forum/manual_tp_install.php

See if that will fix your problem.

dude, your awesome! thanks!

[IchBin]

Glad I could help.

[Murgen]

Same problem but allthought the manual install scripts says it was a succes the tables havent been created ...

I'm puzzled, I tested it all on my own host. Now I need to work on the host from my client and nor auto nor manual install creates the records. Back to the drawingboard.

[IchBin]

Then you should probably talk to the host and ask them why its not working. This script works for many people.

[Murgen]

mailed support this afternoon. My client is on a crappy host ... 

[Murgen]

I exported the tp records from my development TP and tried to create the records in the operational database manually using phpmyadmin like this:

Code Select Expand


--
-- Tabel structuur voor tabel `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` longtext NOT NULL,
  `intro` text NOT NULL,
  `useintro` tinyint(4) NOT NULL default '1',
  `category` smallint(6) NOT NULL default '0',
  `frontpage` tinyint(4) NOT NULL default '1',
  `subject` text NOT NULL,
  `authorID` int(11) NOT NULL default '0',
  `author` text NOT NULL,
  `frame` tinytext NOT NULL,
  `approved` tinyint(4) NOT NULL default '1',
  `off` tinyint(4) NOT NULL default '0',
  `options` text NOT NULL,
  `parse` tinyint(4) NOT NULL default '0',
  `comments` tinyint(4) NOT NULL default '0',
  `comments_var` text NOT NULL,
  `views` int(11) NOT NULL default '0',
  `rating` text NOT NULL,
  `voters` text NOT NULL,
  `ID_THEME` smallint(6) NOT NULL default '0',
  `shortname` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;


The returned error Is that AUTO_INCREMENT=14 cannot be executed on the mysql version running on the crappy host.

My development site runs at:
Version Information:
Forum version: SMF 1.1.5
Current SMF version: SMF 1.1.5
PHP version: 4.3.10
MySQL version: 4.1.15-log
Server version: Apache/2.0.51 (Fedora)
GD version: bundled (2.0.28 compatible)
Help Common Support & Issues

Crappy client host at:
Version Information:
Forum version: SMF 1.1.5
Current SMF version: SMF 1.1.5
PHP version: 4.4.4-8+etch4
MySQL version: 4.0.24_Debian-10sarge2-log
Server version: Apache/2.2.3 (Debian) mod_jk/1.2.18 mod_python/3.2.10 Python/2.4.4 PHP/4.4.4-8+etch4 mod_ssl/2.2.3 OpenSSL/0.9.8c
GD version: 2.0 or higher

So, here I am, blocked, by a limited client's hoster.

Any suggestions? Please?