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

Recent

Welcome to TinyPortal. Please login or sign up.

February 16, 2025, 09:33:19 AM

Login with username, password and session length
Members
  • Total Members: 3,946
  • Latest: Sparo
Stats
  • Total Posts: 195,481
  • Total Topics: 21,261
  • Online today: 148
  • Online ever: 6,457 (November 30, 2024, 02:40:09 PM)
Users Online
  • Users: 1
  • Guests: 99
  • Total: 100
  • @rjen

art.author_id Error after install

Started by ZWarrior, June 17, 2011, 08:09:07 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ZWarrior

Link to my site:  http://www.ambushsite.com
SMF version: SMF 2.0
TP version: TP v1 RC2
Default Forum Language: English
Theme name and version: Default
Browser Name and Version: Firefox 4.0.1
Mods installed: Tiny Portal 1rc2
Related Error messages:
Unknown column 'art.author_id' in 'field list'
File: /home/ambush/public_html/Sources/TPortal.php
Line: 2319

I had our site working with SMF 1.1.14 and TP1 previously, and just updated to SMF 2.0.  I then installed the new TP.  Now not matter what page I hit I get the standard top menu for SMF, but above error is the body.

I apologize for the broken link for my site address, but the forum would not allow me to post this because I did not have rights to post links to external sites. :D

IchBin

Can you attach your Sources/TPortal.php file. I want to make sure it is updated as the line number doesn't match up for me. Thanks.

mrph

#2
Link to my site: farmaceuti.com
SMF version: SMF ver. 2.0
TP version: TP 1.0 rc2
Default Forum Language: English
Theme name and version: Default
Browser Name and Version: Firefox 2.0.0.20
Mods installed: TP 1rc2
Related Error messages: Error message here




I got the same error, my TPortal.php is in here -> sendspace.com/file/pheejd

The screenshot of tportal.php and code on line 1435 is here -> imageshack.us/photo/my-images/84/84851778.jpg/

I upgrade smf from 1.1.13 to smf2.0 without any problems but after install TP 1.0 rc2 i got above error on line 1435.

I install TP through package manager.

I had earlier tp 0.98 installed.

In IE8 i got database error.

After I check and repair database, the error is still there.

edit -> i reupload tportal.php and now its looks like this -> sendspace.com/file/hzmrzt


when i try to access tp admin panel and add new article i get this error :
QuoteUnknown column 'subtype2' in 'where clause'
File: /home/farmaceu/public_html/forum/Sources/TPortalAdmin.php
Line: 3542

mrph


IchBin

Looks like the TP tables aren't getting updated properly for the latest TP when upgrading from older versions. I will take a look and see if I can fix these. Please post back if you don't see anything within a couple days. Thanks.

mrph

Ok, other problem is that tp doesn't show previous existing blocks, just new ones.
It is set that on front page should be left and right panel and that guests should see them.

But they see just the new ones.

On tp admin panel option for activating block doesn't work, screenshot -> imageshack.us/photo/my-images/683/tp2s.jpg/

It isn't clickable. And somehow tp changes type of previous activate articles on bbc and i'm 100% sure that on tp 0.98 those articles was set as html type.


and i get this error
QuoteUnknown column 'var4' in 'field list'
File: /home/farmaceu/public_html/forum/Sources/TPortalAdmin.php
Line: 3327

raid

#6
the problem is still there, I updated the smf from 1.1.14 (with tp rc2) to 2.0 and installed once again tp rc2, and the table field "authorid" isn't converted to "author_id" on tp_article and tp_dlmanager. I did it by hand on phpmyadmin
SMF 2.0 + TP RC2

IchBin

Just haven't had time to fix things yet.

mrph

Please find some time because this is serious problem and my site is literally crippled because articles are very important part of whole site.

Can we use previous stable version and will it work with smf 2.0?

IchBin

A temporary fix has already been posted. You can go in and change the column name in the tp_downloads and tp_articles table authorID to author_id.