Re: [Tiki-devel] Error upgrading tiki 8.3 -> 9.0

[Jonny B. <jo...@ti...>]

Looks like an upgrade script from around tiki 6 or 7 hasn't worked - that tiki_acct (accounting feature) is all a bit experiment afaik (never used it).

Try looking through the installer/schema directory for sql files creating these tables and try running it manually (in phpmyadmin or something)

Good luck!

jb


On 20 Aug 2012, at 17:57, Gregor Adamczyk wrote:

> BUMP.
> 
> Nobody?
> 
> Am 29.07.2012 12:10, schrieb Gregor Adamczyk:
>> Hi,
>> 
>> After starting the upgrade from tiki 8.3 -> tiki 9.0 I get the following error at step 6:
>> 
>> Operations failed: 9 SQL queries. Display details.
>> During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.
>> 
>> ALTER TABLE tiki_acct_account convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_account' doesn't exist ALTER TABLE tiki_acct_bankaccount convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_bankaccount' doesn't exist ALTER TABLE tiki_acct_book convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_book' doesn't exist ALTER TABLE tiki_acct_item convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_item' doesn't exist ALTER TABLE tiki_acct_journal convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_journal' doesn't exist ALTER TABLE tiki_acct_stack convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_stack' doesn't exist ALTER TABLE tiki_acct_stackitem convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_stackitem' doesn't exist ALTER TABLE tiki_acct_statement convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_statement' doesn't exist ALTER TABLE tiki_acct_tax convert to character set DEFAULT COLLATE DEFAULT Table 'tiki.tiki_acct_tax' doesn't exist 
>> 
>> There is no table in my db starting with tiki_acc*. Should I create them manually?
>> 
>> Thx in advance
>> Gregor
>> 
>> 
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and 
>> threat landscape has changed and how IT managers can respond. Discussions 
>> will include endpoint security, mobile security and the latest in malware 
>> threats. 
>> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> 
>> 
>> _______________________________________________
>> TikiWiki-devel mailing list
>> 
>> Tik...@li...
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> 
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> TikiWiki-devel mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel