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

Recent

Welcome to TinyPortal. Please login or sign up.

February 06, 2025, 12:08:08 PM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,471
  • Total Topics: 21,258
  • Online today: 76
  • Online ever: 6,457 (November 30, 2024, 02:40:09 PM)
Users Online
  • Users: 0
  • Guests: 62
  • Total: 62

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.

mrph

No, that doesn't solve anything.

There is another error then:

Unknown column 'art.type' in 'field list'
File: /home/farmaceu/public_html/forum/Sources/TPortal.php
Line: 620

Then when try to access through TP admin panel to my articles, there is this error:

Unknown column 'locked' in 'field list'
File: /home/farmaceu/public_html/forum/Sources/TPmodules.php
Line: 640


And again this error after trying to add article:

Unknown column 'subtype2' in 'where clause'
File: /home/farmaceu/public_html/forum/Sources/TPortalAdmin.php
Line: 3542

IchBin

Did you look at your database to see if those fields exist?
'type' should be a column in the articles table.
'locked' should also be a column in the articles table.
'subtype2' should be a column in the variables table.

None of these columns changed between the last version of SMF. The only thing that changed as far as naming in the database is the authorID to author_id, and the ID_THEME to id_theme.

For all of the database problems you've reported it is likely some other problem. Did you try and run the tp_upgrade.php file from the SMF2 folder in the TP package?

mrph

No, i don't have those fields and in tp_variables table i have just sybtype field.

When i try to run tp_upgrade i get those errors:

Warning: html_entity_decode() [function.html-entity-decode]: charset `ISO-8859-2' not supported, assuming iso-8859-1 in /home/farmaceu/public_html/forum/Sources/TPortal.php on line 334

Warning: html_entity_decode() [function.html-entity-decode]: charset `ISO-8859-2' not supported, assuming iso-8859-1 in /home/farmaceu/public_html/forum/Sources/TPortal.php on line 1890

Warning: html_entity_decode() [function.html-entity-decode]: charset `ISO-8859-2' not supported, assuming iso-8859-1 in /home/farmaceu/public_html/forum/Sources/TPortal.php on line 1896

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

IchBin

At this point I can only suggest you temporarily change your language character set to 8859-1 and try the tp_upgrade.php file again.

Assuming you are running it in your browser?

mrph

Yes, in browser, what is the other way?

I now still get this error:

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


It is clear that certain filed are not inserted  into tables in database and something is wrong with tp interactions with database.

But what is the solution?

IchBin

If I knew the solution I would have already given it to you. If I could produce the same problem that you have on my setup, I could probably find out why it's doing this. But I cannot get all the same errors that you do.

I do get the problem with the columns not getting renamed. But I have never got a duplicate column name error. $smcFunc['db_add_column'] should update the column if it exists. So it shouldn't care that it's looking for a duplicate field.

So, I'm assuming you changed your character set? Did the other table rows get updated and inserted properly even though you got the duplicate field error?

IchBin

Please try this file and let me know if there are any errors.

mrph

Now i get this:


Database Error
No database selected
File: /home/farmaceu/public_html/forum/tp_upgrade.php
Line: 316

Seems that this is problem always :
$smcFunc['db_add_column']($smfprefix . $table, $column);

it wont add column.

Is there a way to manually add those columns through phpmyadmin?

edit - and there isn't any new columns added to table.

IchBin

Thanks for trying the update mrph. I've posted another update here. Please give it a try and report back in that topic.
http://www.tinyportal.net/index.php?topic=34150.0

ZWarrior

@IchBin.  Sorry for the delay in getting back to the thread.  Work gets in the way quite frequently.

Anyway, I tried the updated file you posted in the thread regarding upgrading from SMF1 to SMf2 and that seems to have fixed the problem.

Thanks!