Upgrade problems from 9.1.2.5

NanoCaiordo · Posted: Wed Nov 26, 2008 2:21 am Post subject: Re: Upgrade problems from 9.1.2.5

Somehow config table entry is corrupted. Update cms_config_custom to use "downloads" and clear your cache to fix 1 and 2.

Ronin · Posted: Wed Nov 26, 2008 2:49 am Post subject: Re: Upgrade problems from 9.1.2.5

Crap. Looks like all the cfg_name fields got snipped to 6 characters in length in the cms_config_custom table. I've fixed that now and deleted the cache.

Now I'm also seeing this when I try to access posts in the forum:

Quote::

includes/db/db.php

* CMS Warning line 75: On /Forums/viewtopic/t=97.html While executing query "SELECT COUNT(*) FROM cms_cppictures AS p, cms_cpalbums AS a WHERE a.aid=p.aid AND a.category=10002 LIMIT 0,1" the following error occured: Table 'dragonfly.cms_cppictures' doesn't exist In: /var/www/html/modules/Forums/viewtopic.php on line: 900

cms_cppictures and cms_cpalbums should probably be cms_cpg_pictures and cms_cpg_albums. Something else got truncated?

Ronin · Posted: Wed Nov 26, 2008 2:58 am Post subject: Re: Upgrade problems from 9.1.2.5

OK, figured out that cms_cpg_installs dirname and prefix also got truncated to 6 chars in length. Hopefully there's not too much more. Wonder how this happened? The db fields were definitely greater than 6 chars at the start of the install.

Ronin · Posted: Wed Nov 26, 2008 2:31 pm Post subject: Re: Upgrade problems from 9.1.2.5

P.S. Here's the php script I used to get the collation of my DB sorted out. You just need to edit it with your own dbuser, dbpasswd and dbname, and change localhost to your mySQL server's name if it isn't on the same machine as your dragonfly site:

PHP:

<?php
mysql_connect("localhost","dbuser","dbpasswd");
mysql_select_db("dbname");

$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
    foreach ($row as $key => $table)
    {
        mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
        echo $key . " =&gt; " . $table . " CONVERTED<br />";
    }
}
?>