Admin settings not sticking.

Hangin' Around Joined: Mar 19, 2009 Posts: 42

The Edit Users settings fail to stick.
There is this warning:

ERROR: YOU NEED TO UPDATE YOU DATA BASE TABLE NOW!!
Run rnya.php from the root of your phpnuke installation, update the database tables, and delete the file afterwards!
The version of the module is 2.30.01 and the version of your data base table is (blank)

Also admin/block settings..
In the who can view, it says "View must be SET to Groups Only", but Visitors where able to view them previously. I switch it to "groups only" and 'save block'. Go back and it's set to "All Visitors" again.

Involved Joined: Apr 06, 2008 Posts: 484

Was this an upgrade?

Posted: Tue Apr 21, 2009 11:10 pm

yes.

7.8 downgrade to 7.6, then over to raven.

Posted: Wed Apr 22, 2009 1:26 am

export all your user tables and pm me a link

Note: Structure Only - No User Data Please

Posted: Wed Apr 22, 2009 5:28 am

Are you using two different values for $prefix and $user_prefix?

Posted: Wed Apr 22, 2009 9:48 am

As a temporary fix, I deleted the database and went back to 7.6/3.5 phpnuke. A few issues there too, but working for the most part.

I'm going to start over with the database downgrade process for Raven. Be back shortly.

Posted: Wed Apr 22, 2009 11:25 am

I've got the 7.8 database imported.

In the forums page there is a groups link. There are 4 groups to choose from. 3 of them work fine. The 4th, and largest, gives this alert.

Quote:

Error getting user list for group

DEBUG MODE

SQL Error : 1064 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 'ORDER BY u.username' at line 7

SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = '4' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 797
File : groupcp.php

Is this something that should be remedied before moving on?

Posted: Wed Apr 22, 2009 1:26 pm

try doing search for fixgroup script here and try that.

There is currently a bug when installing with $prefix & $user_prefix set to different values. So if possible use the same value.

Posted: Wed Apr 22, 2009 2:15 pm

I dumped that bbgroup from myphpadmin. That part is fixed.

Involved Joined: Jul 03, 2006 Posts: 273

Palbin wrote:

There is currently a bug when installing with $prefix & $user_prefix set to different values. So if possible use the same value.

Well perhaps you guys could include a note in the config.php file in the package for now. This bloody thing had me banging my head for almost 2 hours shouting WTF!!! lol Also perhaps stickying this would be a good idea!

registered · Posted: Sat May 30, 2009 12:22 pm

Stickied... Wink