TinyPortal

Development => Support => Installation => Topic started by: barpoet on June 07, 2008, 04:53:04 PM

Title: Help! smf_tp_variables doesn't exist! HELP
Post by: barpoet on June 07, 2008, 04:53:04 PM
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.....


QuoteTable '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.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: G6Cad on June 07, 2008, 05:00:21 PM
www.simplemachines.org holds your answers.
The packagemanager are their department.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: barpoet on June 07, 2008, 05:09:36 PM
I cannot do anything with my forum now... Since I uploaded TP I get the same database error.

Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: IchBin on June 07, 2008, 05:18:00 PM
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.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: barpoet on June 07, 2008, 05:45:30 PM
Quote from: IchBinâ,,¢ on June 07, 2008, 05:18:00 PM
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!
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: IchBin on June 07, 2008, 06:01:55 PM
Glad I could help.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: Murgen on June 10, 2008, 01:39:54 PM
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.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: IchBin on June 10, 2008, 03:55:18 PM
Then you should probably talk to the host and ask them why its not working. This script works for many people.
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: Murgen on June 10, 2008, 04:29:21 PM
mailed support this afternoon. My client is on a crappy host ...  :(
Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: Murgen on June 12, 2008, 08:57:54 AM
I exported the tp records from my development TP and tried to create the records in the operational database manually using phpmyadmin like this:


--
-- 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?

Title: Re: Help! smf_tp_variables doesn't exist! HELP
Post by: G6Cad on June 12, 2008, 10:46:40 AM
change host  www.tinyportalhosting.com