Zikula Community

I get this error:

Unable to update _users

I've been getting a few errors like the one above for different tables. I've been going through the pn7.php and debugging the inserts for each problem, but this one is stumping me. I cannot find any line of code in any install file which would produce this error for me!

Notice that the table prefix is missing. Anyone else had this problem?[/b]

Hi everybody,
I've the same problem. When I try to upgrade rogue .703 to phoenix 0.722 I get a "unable to update rogue_hooks". When I drop the update code for the _hooks table I stuck with the _users table ( without prefix as well). I've been searching the forums at post-nuke.net, postnuke.de and here and up to now couldn't find any solution.

Hopefully this issue will be solved.

Anyway thanx for all your work and your good peace of software


Marc

I had the same problem with hooks as well. I found a syntax error in one of the inserts. Look at the end of the inserts, just before the "or die" code starts. All the inserts should be ending with )") but one of them is missing a )

Try this to fix the table prefix problem:

http://sourceforge.net/tracker/index.php?func=detail&aid=636295&group_id=27927&atid=392228

Thanks for the help. That fixed it right up. Now I'm basking in the glory that is 0.7.2.2!

Any chance you could send me your modified pn7.php please, to show your gratitude? :wink:

I managed to sort out the 'blank table prefix' problem but I've not managed to fix the _hooks issue and whatever other syntax errors that are lurking in there!

cheers,

Chris

[chris*at*bluefuton.com]

Same problem here! I tried to use the SF fix posted but the string:
global $dbconn, $pntable, $prefix, $pnconfig;
include_once 'install/pntables71.php';
Already exists....

Any solution out there with this table prefix problem?
Thanks

I had the same problem too. After screwing around with it for a day or so. I found that the include_once 'install/pntables71.php'; is broken in pn71.php and I could not force it to accept the "nuke" prefix.

The problem is with the include_once statement in the pn71.php script. It works fine when it is not called after pn7.php script (don't know why).

To get around the problem I performed the following steps.

edit install.php and comment out line 382,

example....

#do_upgrade71($dbhost, $dbuname, $dbpass, $dbname, $prefix, $dbtype);

Now run the upgrade for .7 The upgrade script should now run without errors and your files will now be up to the .71 standard.

Wait, your not done yet. Now you need to run the install.php one more time... This time select the .71 upgrade and it should execute without any errors.

That's how I fixed/upgraded my system.

Grumpfish

I just added a bug to SF regarding the "unable to update _users". The tracking number is [ 652337 ]

FYI.... I'm not sure if my hack completely fixes the problem(s). You can read more about it here: http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&p=16412#16412

Anybody else run across this problem?

OK.. the good news is, is that I finally figured out a way to get an error free upgrade from .703 --> .722. The bad news is that the hack I posted above creates more problems than it's worth and should be ignored.

After scouring the forums and bug reports and figured out how to patch the upgrade scripts and run it without error (and your not not forced to re-run the install script either). I just upgraded my old system and have not found any obvious problems.

Here is the recipe:

STEP 1:

Start with a clean copy of your DB (.7 version)

Make sure you have a clean copy of your pn722 install scripts (no hacks)

Download cvs update for pn7.php and install it in you /install dir. You can download the file here: http://developers.postnuke.com/cgi-bin/viewcvs.cgi/postnuke-devel/html/install/pn7.php

STEP 2:

Add $pnconfig to the list of globals at the start of /install/pn7.php

Like this:

global $dbconn, $pntable, $prefix, $pnconfig;
include_once 'install/pntables71.php';

The missing $pnconfig variable is what caused the "unable to update _users" error. This fixes that problem.

STEP 3

Edit /install/pn71.php and comment/remove the line that reads (it should be on line 47):

$dbconn->Execute("ALTER TABLE $pntable[stories] ADD pn_format_type tinyint(1) unsigned NOT NULL DEFAULT '0'") || die(""._NOTUPDATED."$pntable[stories]");

This statement has already been performed in the /install/pn7.php script and causes an error when you try to run it again.

STEP 4

Run the install.php script again and everything should work. It did for me.


Have fun,

Grumpfish

The link http://developers.postnuke.com/cgi-bin/viewcvs.cgi/postnuke-devel/html/install/pn7.php does not work anymore?
Couls someone post it here please I have been trying to upgrade this site for weeks now.
TIA,
RC

just a tip, as this thread seems to be getting old now. .726 will be out in about (very rough estimate!), 2 weeks, so if you can hold on that long then i think any probs will be sorted in that version.

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide