phpwcms Support Forum

The varchar problem was definitely something to do with the DB upgrade from mysql 3.x to 4.x and charsets (the new mysqld was using an incorrect/old charset location). I think I'll leave the update to mysql 5.x till I'm sure I have a running system.

Everything appears to be correct at this stage ...

Ok, found the image problem. It seems that many tables did not get updated correctly during the upgrade.

Many of the varchar columns have not been increased in capacity. At a glance it looks like nearly all varchar(85) columns should have been upgraded to 255 etc.

In particular the phpwcms_file.f ...

Thanks flip-flop,
That was ok for 'unused' images.

I took a chance and just ended up deleting from 'phpwcms_file' and 'phpwcms_imgcache', and then deleting all images from /content/images and /phpwcms_filestorage (less the image_placeholder.png). The site is now clean (i.e. no images, which is what ...

Is there a safe way/script to delete all images/files and article references to them (mysql).

The update to the latest version left many images corrupted (possibly an IM or GD problem on my machine, but strange that many images were also ok?).

It would now be more simple to just remove all images ...

Thanks flip-flop,

It was a hidden level (not 'home', but one level down).

The upgrade was from a really old version, and required a few manual changes to some update scripts which did not set default values for various new columns.

The mysql DB was also upgraded from an equally ancient 3.x, so ...

Using 1.2.8: at http://www.provox.de

All sub-structure items are no longer visible in the main menu.

They are however visible in the article center and the structure designer.

I can access all pages and edit all content without a problem from the admin area. So any idea as to why these items are ...