Downloads Issues

[wilsy]

Hi all,

Im getting this in the downloads section at

http://atco-uk.com/index.php?action=tpmod;dl=cat25

Code Select Expand

Unknown column 'dlm.author_id' in 'where clause'
File: /home/atcoukco/public_html/Sources/TPSubs.php
Line: 2442


Any ideas?

[IchBin]

I'm guessing your db update didn't complete for your upgrade. Although, it's hard to tell because you didn't tell us what version of TP or SMF your running, and also whether you have upgraded or not...

[wilsy]

Hi Ich,

Its running SMF 1.1.11 and TinyPortal 1.0 beta 5-1. I ran an upgrade from 1.099.

[IchBin]

run the tp_install.php file and see if that updates the tables. I think the row name authorid was supposed to be renamed to author_id, thats why you get the error.

[wilsy]

Hi Ich,

I ran that file from the root and got the message:

table could not be updated

[IchBin]

Doesn't say which table or anything?

[wilsy]

Hi Ich,

Check it out: -

http://www.atco-uk.com/tp_install.php

[IchBin]

Does your database user have permission to alter tables?

[wilsy]

Not too sure I'm following you there?

[IchBin]

The user that you're using to connect to your database. It has to have permission to alter the tables in order to complete the operations in the tp_install.php file. There are several instances in that file where TP is trying to alter the tables to change/set the collation.

Code Select Expand

itpdb_query("ALTER TABLE `" . $tp_prefix . "articles` DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci") or die('table could not be updated');

You'll need to look at the permissions for your user in mysql to see if it has the ability to alter tables.