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

Recent

Welcome to TinyPortal. Please login or sign up.

March 28, 2024, 07:55:09 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: 64
  • Total: 64

[SMF1.1.2 + TP0.97] Upgrade to 0.983 problem [solved]

Started by Paid2Hyip, March 28, 2007, 01:22:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Paid2Hyip

I have tried installing the TP0.983 upgrade, and it uploaded fine, said that there were no errors whatsoever, but when I went and installed it, I got a mysql error.

Now, all I get is the following;

Unknown column 'art.shortname' in 'field list'
File: /home/content/*/*/html/Sources/TPortal.php
Line: 575

Any help would be greatly received. I have looked at the manual installation procedure, and it does not look like something that I feel confident in doing.

TIA

G6Cad

Is this on SMF 1.1.2 ? And from what TP version did you upgrade ?

Paid2Hyip

Yes, this is version 1.1.2 and I am upgrading from TP0.97 as mentioned in the topic title.

G6Cad

Should work just fine, do you have any other mods installed beside TP ?  Any thing regarding member, membergroups that have changed the members ID.
The line 575 in TPortal.php is where it calles for members, groups and so on.

Paid2Hyip

I don't think I have any mods installed that would have changed either member or membergroups ID. I guess that if a mod was going to make such a change then I would have been informed.

G6Cad

Well, lets try to get your forum to work with TP.

Start bu downloading the BIG upgrade package from SMF forums.
Extract the files on your local machine, then take the upgrade.php and the 2 .sql files out from the folder, and upload them to your forum root dir.
Point the browser and let it upgrade your DB again.

Then you try and install TP through the manager again and see if you get pass that error

Offcourse with the forum set to all defaults,SMF Default Core theme, and English language

Paid2Hyip

#6
I followed your instructions and am presented with the following message;

Install / Upgrade TinyPortal v0.9.8 beta


Upshrink table created
Settings table created2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
File: /home/content/*/*/html/Packages/temp/tp_install.php
Line: 169

This is the same message as I received earlier.

EDIT: Sorted it. For some strange reason, it worked after me installing it a second time.

G6Cad

You need to upgrade your DB with the database installer from the BIG upgrade package on Simplemachines.org

Download the package, extract the files on your local PC, then take out the upgrade.php and the 2 .sql files from there, upload them to your forum root and point the browser to the upgrade.php

When the upgrade of the DB is done, try and install TP again.

Paid2Hyip

As I edited, it's all working now :) Which is great! Just a few things to sort out first. Now where did I see that post....

G6Cad

Search will be your best friend for a day or two now ;)

Glad you got it sorted.