Upgrade problems from 9.1.2.5

[Ronin]

Hi all,

I tried to upgrade to cvs head last night on my ronin-tech.com site and ran into several issues. First was having to change from utf8 to null in config.php. Then I got a bunch of duplicate entry errors that look to be from table fields being too short. I kept refreshing and it seemed to get past them and finish but when accessing the site after installation seemed to be finished it wasn't working. After doing some searching it sounds like if I get any error I need to abandon the installation, restore the db, fix the problematic entry and start again. Is this correct or can I fix the problems on the fly during installation. They all seem to be from varchar fields being too short to contain the data even though the data looks to be in there. So I assume I just need to jack up the lengths to accommodate the text?

Ironically after restoring my db and old site code after it was getting too late to muck around, I couldn't start the old site back up?!? Makes no sense to me as it was working before the upgrade attempt. All I can think of is that after the failed upgrade attempt I simply dropped all the tables from the dragonfly db and restored them from my sql backup rather than nuking the whole db and then restoring it. Would something aspect of the db have been changed (not the tables which I restored) that would break an older version? I managed to edit the code to get the site up but the downloads pro module still isn't working. Apologies to those trying to get the new version of my dfmaps module.

[Dizfunkshunal]

Yea if you run into problems on install (upgrading). restore everything, fix what needs fixin, and try again.


cvs version is now PHP5 only, I think its also a min. MYSQL 5 to.

[Ronin]

Thanks man. My ronin-tech.com server is php/mysql 5. My big ATV site is what's in my sig with the older versions. I'll try again tonight with 9.2.1 and see what happens. Should I go with a more recent snapshot or just the old 9.2.1 release?

[NanoCaiordo]

9.2.1

Do you select the "drop tables" option when creating the database backup?

Detailed errors would also be appreciated.

[Ronin]

Yep, if I get stuck you can count on detailed errors Nano.

I do not use the "drop tables" option. Is this something I need to workaround?

[NanoCaiordo]

Then make sure to wipe off all db tables before restoring from backup.
Not an option in your case, its a must.

[Ronin]

Yeah, I was dropping all the tables from the DB before doing an import.

[NanoCaiordo]

Files backup are also tricky, and you should take into cosideration cache/* files.

Plus today there are quite few server using php accelerators looking for the "last modified" files property.

New 9.2 files will have a recent modified date then your backuped files, so when restoring from your files backup the accelerator will not bother to "update" its own cache since your files are older then files into the accelerator chace.

eAccelerator its good but only system adminis can menage it.
Bcompiler its different this is why I start supporting it.

In other words ask your sysadmin for any accelerator installed, if any tell them whats happening.

[Ronin]

I'm my own sysadmin on this server and I'm not using any accelerators.

Is the way through the installation duplicate entry errors to increase the varchar field length so the entries can become unique?

[NanoCaiordo]

I need errors details.

[Ronin]

OK, I guess I was right about all the duplicate entry errors. Increasing the varchar field lengths to the point where the entries became unique allowed 9.2.1 to install. I also ran a php script to change all of the tables to UTF. Post installation errors include:

Every page gives me:

Quote::

modules/Downloads/admin/adlinks.inc * Notice line 27: Undefined index: downloads * Notice line 30: Undefined index: downloads

Attempting to access the Downloads (pro) module gives me this error:

Quote::

includes/db/db.php * CMS Warning line 75: On /Downloads.html While executing query "SELECT lid, title, date FROM cms_downloads_downloads WHERE active=1 AND updated<=date ORDER BY date DESC LIMIT 0," the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 In: /var/www/html/modules/Downloads/index.php on line: 349

Turning on the admin block kills the site until I disable the block via the db. The error is:

Quote::

includes/db/db.php * CMS Warning line 75: On /admin.php?op=blocks While executing query "SELECT dirname FROM installs WHERE cpg_id=1" the following error occured: Table 'dragonfly.installs' doesn't exist In: /var/www/html/modules/coppermine/admin/adwait.inc on line: 20

After the upgrade there is no dragonfly.installs table in my db (named dragonfly).

On this server (http://ronin-tech.com) I am now running DF 9.2.1 with Apache 2.2.6, mySQL 5.0.45 (client: 5.0.45) and PHP 5.2.4.

[NanoCaiordo]

Clear your cache/ to, probably, resolve errors 1 and 3.

Upgrade ( or re-upload DownloadsPro/functions/* ) to, probably, resolve error 2.

[Ronin]

Clearing the cache didn't help 1 and 3. This was created from a completely clean directory so there were no cache leftovers.

I upgraded Downloads via the modules page which I had forgotten to do so now the db should be squared away but I still get:

Quote::

modules/Downloads/index.php * Notice line 349: Undefined index: front_rank includes/db/db.php * CMS Warning line 75: On /Downloads.html While executing query "SELECT lid, title, date FROM cms_downloads_downloads WHERE active=1 AND updated<=date ORDER BY date DESC LIMIT 0," the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 In: /var/www/html/modules/Downloads/index.php on line: 349

I've cleared the cache again with no effect.

Thanks for your help Nano!

[NanoCaiordo]

You having the db error because $dl_config is empty or its missing the [front_rank] index.

Make sure cms_config_custom have:
downloads | front_rank

if is_admin() print_r($MAIN_CFG) and check if [downloads][front_rank] is there.

[Ronin]

In cms_config_custom I do have:

downlo | front_rank | 5

The tables structure is:

cfg_name varchar(20)
cfg_field varchar(50)
cfg_value text

Is the cfg_name supposed to be "downloads" rather than "downlo"?

I added that code and I have front_rank but its inside "downlo":

Quote::

[downlo] => Array ( [anon_dl] => 0 [anon_dl_remote] => 1 [user_catparent] => 1 [def_sort] => 1 [dimension] => 1600 [dimension_thumb] => 200 [ext_file] => ace doc gtar gz pdf rar tar zip rtf [ext_image] => gif jpg jpeg png tif [front_rank] => 5 [im_spam_protect] => 0 [leech_local] => 1 [leech_remote] => 0 [path_file] => uploads/downloads [path_image] => uploads/downloads/images [perpage] => 10 [quality] => 80 [r_perpage] => 5 [r_active] => 1 [r_queue] => 0 [screen_active] => 1 [screen_max] => 10 [size_file] => 6097152 [size_image] => 3048576 [upl_file] => 1 [upl_image] => 1 [use_fetch] => 0 [use_fetch_remote] => 1 [watermark] => 0 [md5_local] => 1 [md5_remote] => 1 [pub_mirror] => 1 ) [Contac] => Array ( [update_monitor] => 1 )