phpwcms Support Forum

Got this error using RC4, upon submitting a new structure level in the admin section. When I hit the submit button,sending the page to this address:

URL:
"http://localhost/phpwcms/include/inc_ac ... ucture.php"

I get this Error (Displayed in browser):
"error"

The error is likely emanating from line 53 on the sql insert statement:
UPDATE:

I did a fresh install of RC4 and my DB, manually copy and pasting page layout and template data across from my old install to new install, and seems to have fixed this problem. Apparaently I had one too many hacks in my RC3 files. Seems to work OK now. Cheers

I have the same problem.
Is a reinstall the only option?

To my knowledge, I have not used any hacks, so that couldn't be the problem.

this may occur if you have not ALL the correct db tables.
you should first try applying ALL the Upgrade.sql files from the versions you were using to the version you are currently using inclusive.
eg. If you went from RC2 >RC4 then you must still apply RC3 upgrade.sql

Apparently that did the trick.
Why doesn't the upgrade.php do that for you ?

not sure.

It makes lot of work to check against every possible problem during upgrade. I can only do it for 1 release to another release. But future releases will have own sql files for every step.

It's not neccessary to do a fresh install when upgrade - check all *.sql files in setup folder (not the phpwcms_init.sql) and do it manually. Mosts steps are described.

Oliver

Oliver: just a question.. I know you can add/drop tables, you can.. if table exists > drop > add. can you.. if exists > do nothing else add?

I can - but you have to check also if table existis -> if field exists - or field description/name is changed. Lots of tests - I have no time to develop this. Makes no sense - is much faster done manually by checking the *.sql files.

Oliver