Admin settings not sticking.

hamster · 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.

testy1 · Involved Joined: Apr 06, 2008 Posts: 483

Was this an upgrade?

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

yes.

7.8 downgrade to 7.6, then over to raven.

testy1 · Involved Joined: Apr 06, 2008 Posts: 483

export all your user tables and pm me a link

Note: Structure Only - No User Data Please

Palbin · Posted: Wed Apr 22, 2009 5:28 am

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

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

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.

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

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?

Palbin · 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.

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

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

duck · Worker Joined: Jul 03, 2006 Posts: 247

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!

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

Stickied... Wink