[Tikipro-support] [ tikipro-Bugs-1223930 ] Cant run TikiPro after Upgrade

[SourceForge.net <no...@so...>]

Bugs item #1223930, was opened at 2005-06-20 16:43
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=630083&aid=1223930&group_id=101599

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Install
Group: Clyde
Status: Open
Resolution: None
Priority: 8
Submitted By: Peter Moore (moooooooo)
Assigned to: Nobody/Anonymous (nobody)
Summary: Cant run TikiPro after Upgrade

Initial Comment:
After doing an upgrade from TikiPro (Bonnie) to Clyde,
it's apparent that some tables are droppped but not
recreated. In this case its <prefix>tiki_files
where prefix is your prefix, if any.

I'll use this as a "master record" as once i fix this,
there's another table which has issues (i've done this
previously but not documented it properly until now).



[ - Clyde v3-BETA 2 - ] [ Mon Jun 20 10:43:21 2005 ]
  #### USER AGENT: Mozilla/5.0 (X11; U; Linux i686;
en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
  #### ACCT: User unknown
  #### URL: http://localhost/tikipro/
  #### REFERRER:
http://localhost/tikipro/install/upgrade.php
  #### HOST: localhost
  #### IP: 127.0.0.1
  #### SQL: select uu.*, uu."login" AS "user",
tf_ava."storage_path" AS "avatar_storage_path",
tf_por."storage_path" AS "portrait_storage_path",
tf_logo."storage_path" AS "logo_storage_path"   , tc.*
, uu."user_id" AS "uu_user_id"        FROM
"iiiusers_users" uu       LEFT OUTER JOIN
"iiitiki_attachments" ta_ava ON (
uu."avatar_attachment_id"=ta_ava."attachment_id" )    
  LEFT OUTER JOIN "iiitiki_files" tf_ava ON (
tf_ava."file_id"=ta_ava."foreign_id" )       LEFT OUTER
JOIN "iiitiki_attachments" ta_por ON (
uu."portrait_attachment_id"=ta_por."attachment_id" )  
    LEFT OUTER JOIN "iiitiki_files" tf_por ON (
tf_por."file_id"=ta_por."foreign_id" )       LEFT OUTER
JOIN "iiitiki_attachments" ta_logo ON (
uu."logo_attachment_id"=ta_logo."attachment_id" )     
 LEFT OUTER JOIN "iiitiki_files" tf_logo ON (
tf_logo."file_id"=ta_logo."foreign_id" )        LEFT
OUTER JOIN "iiitiki_content" tc ON (
uu."content_id"=tc."content_id" )        WHERE
uu."user_id"=-1
  #### ADODB: Errno: -1  Message: ERROR:  relation
"iiitiki_files" does not exist


    }}}}}}}}}}}}    -> tiki_error_string(Array[7])
    }}}}}}}}}}}} LINE:   33,
/usr/local/apache/htdocs/tikipro/kernel/tiki_error_inc.php
    }}}}}}}}}}}    -> tiki_error_handler(postgres7,
EXECUTE, -1, ERROR:  relation "iiitiki_files" does not
exist, select uu.*, uu."login" AS "user",
tf_ava."storage_path" AS "ava..., false,
Object:adodb_postgres7)
    }}}}}}}}}}} LINE:  859,
/usr/local/apache/htdocs/tikipro/util/adodb/adodb.inc.php
    }}}}}}}}}}    -> adodb_postgres7::_execute(select
uu.*, uu."login" AS "user", tf_ava."storage_path" AS
"ava...)
    }}}}}}}}}} LINE:  818,
/usr/local/apache/htdocs/tikipro/util/adodb/adodb.inc.php
    }}}}}}}}}    ->
adodb_postgres7::adodb_postgres7::execute(select uu.*,
uu."login" AS "user", tf_ava."storage_path" AS "ava...,
Array[1])
    }}}}}}}}} LINE:  349,
/usr/local/apache/htdocs/tikipro/kernel/TikiDB.php
    }}}}}}}}    ->
adodb_postgres7::adodb_postgres7::tikidb::query(select
uu.*, uu.`login` AS `user`, tf_ava.`storage_path` AS
`ava..., Array[1], -1, -1, -1)
    }}}}}}}} LINE:  188,
/usr/local/apache/htdocs/tikipro/kernel/TikiBase.php
    }}}}}}}    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::query(select
uu.*, uu.`login` AS `user`, tf_ava.`storage_path` AS
`ava..., Array[1])
    }}}}}}} LINE:  123,
/usr/local/apache/htdocs/tikipro/users/TikiUser.php
    }}}}}}    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::tikiuser::load(true,
null)
    }}}}}} LINE:   23,
/usr/local/apache/htdocs/tikipro/users/TikiPermUser.php
    }}}}}    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::tikiuser::tikipermuser::load(true)
    }}}}} LINE:  116,
/usr/local/apache/htdocs/tikipro/users/tiki_setup_inc.php
    }}}} LINE:  820,
/usr/local/apache/htdocs/tikipro/kernel/TikiSystem.php
    }}}    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::tikiuser::tikipermuser::tikisystem::scanpackages()
    }}} LINE:  101,
/usr/local/apache/htdocs/tikipro/kernel/setup_inc.php
    }}    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::tikiuser::tikipermuser::tikisystem::require_once(/usr/local/apache/htdocs/tikipro/kernel/setup_inc.php)
    }} LINE:    5,
/usr/local/apache/htdocs/tikipro/tiki_setup_inc.php
    }    ->
adodb_postgres7::adodb_postgres7::tikidb::tikipermuser::tikiuser::tikipermuser::tikisystem::require_once(/usr/local/apache/htdocs/tikipro/tiki_setup_inc.php)
    } LINE:   19,
/usr/local/apache/htdocs/tikipro/index.php


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=630083&aid=1223930&group_id=101599