News: Welcome to the TinyPortal Support site.

Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

December 08, 2019, 03:06:35 PM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 189279
  • Total Topics: 20775
  • Online Today: 612
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 1
Guests: 463
Total: 464

Author Topic: If you upgraded from SMF1 to SMF2 with TP.  (Read 39736 times)

0 Members and 3 Guests are viewing this topic.

Offline Lucas3677

  • Newbie
  • *
  • Posts: 1
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #10 on: August 01, 2011, 12:44:40 AM »
Thank you, this worked for me. I was getting the problem "Duplicate column name 'id_member'"

Offline simpsonetti

  • Newbie
  • *
  • Posts: 2
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #11 on: August 21, 2011, 03:46:49 AM »
Hi, i ipgrade my site from smf 1 to smf2 final.
i have previously installed TP. now i want to install TP again and i get this error after i execute ...smf/tp_upgrade.php :

Quote
Database Error
Duplicate column name 'id_member'
File: /is/htdocs/27093450h_478hj67iGH2/www/xxxxxx/smf/tp_upgrade.php
Line: 316
Back
**EDIT**
Okay, after using this modified version it works !!
Thanks a lot !!
« Last Edit: August 21, 2011, 08:11:06 AM by simpsonetti »

Offline welshdog

  • Jr. Member
  • **
  • Posts: 18
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #12 on: November 07, 2011, 05:08:52 PM »
There should be a note with a link on the download page to here.

For the benefit of anyone who may use search to find this:

Unknown column 'value9' in 'smf_tp_variables'
File:  /Packages/temp/SMF2/tp_upgrade.php
Line: 347

Got that originally... so ran tp_upgrade.php

When I went back to the forum it returned

From tinyportal.net...
XML error: syntax error at line 1

... so I uninstalled (everything) and reinstalled rc2... but SMF returned the same error message.

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #13 on: November 08, 2011, 08:26:37 AM »
That error message looks like it's from older code or something. Are you sure your files are getting replaced when you install TP over your old install?

Offline vranx

  • Newbie
  • *
  • Posts: 1
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #14 on: November 08, 2011, 08:39:59 AM »
I am trying to install TP on SMF 2.0.1. After install I get this error:
Code: [Select]
Unknown column 'globaltags' in 'field list'
File: /home/badagui/public_html/Sources/TPortal.php
Line: 2951
No matter what page I try to go to I get that error. I tried the script at the top of this thread and it still gives that error.
badaguild.com/tp_upgrade.php

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #15 on: November 08, 2011, 09:43:34 AM »
After you run the tp_upgrade.php file, if you look at your database in the tp_modules table, can you post what columns you have in that table?

Offline mikehsg

  • Newbie
  • *
  • Posts: 4
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #16 on: November 12, 2011, 08:58:16 AM »
I'm getting this error with SMF 2 and being somewhat of a coding Luddite I could use a little "For Dummies" level help:

Database Error
Duplicate column name 'id_member'
File: /home/philisti/public_html/tp_upgrade.php
Line: 316

Online lurkalot

  • Administrator
  • *
  • Posts: 6355
    • Camera Craniums
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #17 on: November 12, 2011, 09:13:31 AM »
I'm getting this error with SMF 2 and being somewhat of a coding Luddite I could use a little "For Dummies" level help:

Database Error
Duplicate column name 'id_member'
File: /home/philisti/public_html/tp_upgrade.php
Line: 316

Hi, and welcome to TP support.

Did you upload and run the script that IchBin attached to the first post in this thread?

Offline tempuser

  • Newbie
  • *
  • Posts: 1
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #18 on: November 12, 2011, 05:18:56 PM »
Hi there,

I've got a serious problem after using the script from the first post:
I used webinstall.php to upgrade my SMF 1.1.15 to 2.0.1 and tried to install TP by uploading the .zip via the packet management. The TP-install-Test was fine and i hit "Install Now"; this left me with the error described in this thread. And then, after i used the attached script in the first post...

first this script doesn't work for me... leaving me with:
Quote
Notice: Undefined index: dl_wysiwyg in /srv/www/htdocs/XXXXX/smfforum/Sources/TPortal.php on line 333 Notice: Undefined index: dl_introtext in /srv/www/htdocs/XXXXX/smfforum/Sources/TPortal.php on line 334 Notice: Undefined index: dl_screenshotsizes in /srv/www/htdocs/XXXXX/smfforum/Sources/TPortal.php on line 342 Notice: Undefined index: art_imagesizes in /srv/www/htdocs/XXXXX/smfforum/Sources/TPortal.php on line 343

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.
Back

But even worst: when i try to open my forum, i get:
Quote
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
and can't even log in...

Kind regards
Oliver


//edit:
Ok, running webinstall.php again solved this issue... so far i don't get a db-error and can use the forum normally... but i don't dare to try tp_upgrade.php another time...

Online lurkalot

  • Administrator
  • *
  • Posts: 6355
    • Camera Craniums
Re: If you upgraded from SMF1 to SMF2 with TP.
« Reply #19 on: November 13, 2011, 02:48:03 AM »
Hi there,

I've got a serious problem after using the script from the first post:
I used webinstall.php to upgrade my SMF 1.1.15 to 2.0.1
 

Are you saying you actually upgraded SMF using webinstall?  That might be your problem.  The recommended way would be to use the large upgrade package when moving from one major version to another.  Webinstall is for installing from scratch. See here about upgrading, http://wiki.simplemachines.org/smf/Upgrading