Error on submission of new structure level

Use GitHub to post bug reports and error descriptions for phpwcms. Describe your problem detailed!
Locked
User avatar
jsw_nz
Posts: 907
Joined: Fri 2. Apr 2004, 02:42
Location: New Zealand

Error on submission of new structure level

Post by jsw_nz »

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:

Code: Select all

if($result = mysql_query($sql, $db) or die("error"))
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
Pieter
Posts: 54
Joined: Sat 20. Mar 2004, 18:08

Post by Pieter »

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.
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

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
Pieter
Posts: 54
Joined: Sat 20. Mar 2004, 18:08

Post by Pieter »

Apparently that did the trick.
Why doesn't the upgrade.php do that for you ?
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

not sure.
User avatar
Oliver Georgi
Site Admin
Posts: 9919
Joined: Fri 3. Oct 2003, 22:22
Contact:

Post by Oliver Georgi »

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 Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

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?
User avatar
Oliver Georgi
Site Admin
Posts: 9919
Joined: Fri 3. Oct 2003, 22:22
Contact:

Post by Oliver Georgi »

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
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
Locked