RNYA Error Message After Upgrade FIXED

Theme Guru Joined: Nov 01, 2003 Posts: 1006

I have upgraded a website for someone who was running 7.0 to RN 2.3.

There are a few issues that have arisen.

The site seems to function well now with only a few bugs.

When going to the RNYA admin section I see the following message.

Code:




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 4.4.2 and the version of your data base table is ['version']

I can see all of the options and it seems to be there, but I would like to get rid of this message. There is, as you know, no rnya.php file in RN 2.3. So, what shouold I do?

Your help is appreciated, in advance. Razz

Posted: Sun Feb 08, 2009 3:56 pm

First thing to do is find line 331 of modules/Your_Account/includes/functions.php

Code:




. _YA_UPDATEYOUTABLE1 . ' ' . $ya_config . '[\'version\'] </center></td>';

Change it to this:

Code:




. _YA_UPDATEYOUTABLE1 . ' ' . $ya_config['version'] . '</center></td>';

Then post back on what the error message is after that.

Most likely you are going to have to go into phpmyadmin and go into the nuke_user_config table and change the version field to 2.3.0.

Please post back with what is currently in the field. I would like to know because we probably have a bug.

Posted: Sun Feb 08, 2009 4:05 pm

When making this change in functions.php I receive the following error.

Parse error: syntax error, unexpected '<' in /home2/****/public_html/modules/Your_Account/includes/functions.php on line 325

Posted: Sun Feb 08, 2009 4:08 pm

I corrected the change mentioned above. I forgot a ' before the <.

Posted: Sun Feb 08, 2009 4:09 pm

The nuke_config table was reading the version number incorrectly. It read, rn2.02.00, but making the code change you mentioned caused that parse error.

Posted: Sun Feb 08, 2009 4:12 pm

Alright, I made the change now and I see no errors at all. However, the same message is listed when clicking the admin icon for RNYA. I do not have a nuke_users_config table. I do have nuke_users and in it there is no field for version.

Posted: Sun Feb 08, 2009 4:16 pm

Well, now I can see when comparing this db to another one that is 2.3 also, this one is missing several of the nuke_user tables. It seems to be missing

nuke_users_config
nuke_users_fields
nuke_users_field_values
nuke_users_temp_field_values

Posted: Sun Feb 08, 2009 4:16 pm

How did you upgrade? You just ran rndb_upgrade.php?

Posted: Sun Feb 08, 2009 4:20 pm

You need to read the "From Other Versions of PHP-Nuke " in the Upgrading section of the HowToInstall guide.

Posted: Sun Feb 08, 2009 4:25 pm

I did that and I followed it quite carefully. Apparently something went wrong during one of the steps. I have dropped the db and I am redoing it now. I will report back if that does not correct the issue. I have done this so many times and I have never had any issues. I appreciate your help as without it, I may not have discovered that the tables were missing.

Posted: Sun Feb 08, 2009 4:39 pm

I have redone the changes to the db. It seems to have all "taken" this time. Thank you again, Palbin. Very Happy

I had not noticed that the update had failed to create some tables. Everything seems to be working correctly now except for the issue with the Nuke Supporters module which has nothing to do with the upgrade, but rather the server change.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Okay, I'm confused here. Are you saying that you dropped the database and then reran the same script(s) with no changes and it worked?

New Member Joined: Feb 10, 2006 Posts: 18

Getting something along similar lines...

Code:

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

This comes up in user options of the admin section and prevents configuration. Changes will not stick.
This is a clean instal on a new server.
I have tried re-running the database/table setup with no resolution.
At this time you cannot even register on the site due to this.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Can you check the database to see if you have any user tables? It's missing at least the users_config table, and maybe others.

Posted: Tue Feb 24, 2009 1:04 am

kguske wrote:

Can you check the database to see if you have any user tables? It's missing at least the users_config table, and maybe others.

Thats what i couldnt understand, they all apear to be there as far as i can tell.

Code:

 nuke1_authors 


 nuke1_autonews 


 nuke1_banned_ip 


 nuke1_banner 


 nuke1_banner_clients 


 nuke1_banner_plans 


 nuke1_banner_positions 


 nuke1_banner_terms 


 nuke1_bbattachments 


 nuke1_bbattachments_config 


 nuke1_bbattachments_desc 


 nuke1_bbattach_quota 


 nuke1_bbauth_access 


 nuke1_bbbanlist 


 nuke1_bbcategories 


 nuke1_bbconfig 


 nuke1_bbconfirm 


 nuke1_bbdisallow 


 nuke1_bbextensions 


 nuke1_bbextension_groups 


 nuke1_bbforbidden_extensions 


 nuke1_bbforums 


 nuke1_bbforum_prune 


 nuke1_bbgroups 


 nuke1_bbposts 


 nuke1_bbposts_text 


 nuke1_bbprivmsgs 


 nuke1_bbprivmsgs_text 


 nuke1_bbquota_limits 


 nuke1_bbranks 


 nuke1_bbsearch_results 


 nuke1_bbsearch_wordlist 


 nuke1_bbsearch_wordmatch 


 nuke1_bbsessions 


 nuke1_bbsessions_keys 


 nuke1_bbsmilies 


 nuke1_bbthemes 


 nuke1_bbthemes_name 


 nuke1_bbtopics 


 nuke1_bbtopics_watch 


 nuke1_bbuser_group 


 nuke1_bbvote_desc 


 nuke1_bbvote_results 


 nuke1_bbvote_voters 


 nuke1_bbwords 


 nuke1_blocks 


 nuke1_comments 


 nuke1_config 


 nuke1_confirm 


 nuke1_counter 


 nuke1_downloads_categories 


 nuke1_downloads_downloads 


 nuke1_downloads_editorials 


 nuke1_downloads_modrequest 


 nuke1_downloads_newdownload 


 nuke1_downloads_votedata 


 nuke1_encyclopedia 


 nuke1_encyclopedia_text 


 nuke1_faqanswer 


 nuke1_faqcategories 


 nuke1_gcal_category 


 nuke1_gcal_cat_group 


 nuke1_gcal_config 


 nuke1_gcal_event 


 nuke1_gcal_exception 


 nuke1_gcal_rsvp 


 nuke1_groups 


 nuke1_groups_points 


 nuke1_headlines 


 nuke1_hnl_categories 


 nuke1_hnl_cfg 


 nuke1_hnl_newsletters 


 nuke1_journal 


 nuke1_journal_comments 


 nuke1_journal_stats 


 nuke1_legal_cfg 


 nuke1_legal_docs 


 nuke1_legal_text 


 nuke1_legal_text_map 


 nuke1_links_categories 


 nuke1_links_editorials 


 nuke1_links_links 


 nuke1_links_modrequest 


 nuke1_links_newlink 


 nuke1_links_votedata 


 nuke1_mail_config 


 nuke1_main 


 nuke1_message 


 nuke1_modules 


 nuke1_nsngr_config 


 nuke1_nsngr_groups 


 nuke1_nsngr_users 


 nuke1_nsnst_admins 


 nuke1_nsnst_blocked_ips 


 nuke1_nsnst_blocked_ranges 


 nuke1_nsnst_blockers 


 nuke1_nsnst_cidrs 


 nuke1_nsnst_config 


 nuke1_nsnst_countries 


 nuke1_nsnst_excluded_ranges 


 nuke1_nsnst_harvesters 


 nuke1_nsnst_ip2country 


 nuke1_nsnst_protected_ranges 


 nuke1_nsnst_referers 


 nuke1_nsnst_strings 


 nuke1_nsnst_tracked_ips 


 nuke1_pages 


 nuke1_pages_categories 


 nuke1_pollcomments 


 nuke1_poll_check 


 nuke1_poll_data 


 nuke1_poll_desc 


 nuke1_public_messages 


 nuke1_queue 


 nuke1_related 


 nuke1_reviews 


 nuke1_reviews_add 


 nuke1_reviews_comments 


 nuke1_reviews_main 


 nuke1_seo_config 


 nuke1_seo_disabled_modules 


 nuke1_seo_feed 


 nuke1_seo_subscriptions 


 nuke1_session 


 nuke1_stats_date 


 nuke1_stats_hour 


 nuke1_stats_month 


 nuke1_stats_year 


 nuke1_stories 


 nuke1_stories_cat 


 nuke1_subscriptions 


 nuke1_topics 


 nuke1_users_config 


 nuke1_wiw_m 


 nuke_users 


 nuke_users_fields 


 nuke_users_field_values 


 nuke_users_temp 


 nuke_users_temp_field_values

p.s. im running 2.3.1, didnt notice the new section for it until after i posted Rolling Eyes

Posted: Tue Feb 24, 2009 2:30 am

Not trying to jump in here, but...

It looks like its using different prefixes, I see nuke and nuke1, did you perhaps change the prefix in the original install and then try to add the missing tables?

If you havent done anything major to the site yet, I would start over with the install by dropping all tables.

If thats not an option drop the tables using nuke_ and change the missing tables to nuke1 before you run the sql.

Posted: Tue Feb 24, 2009 11:42 am

Using different prefixes is fine.

Posted: Tue Feb 24, 2009 11:54 am

spiritwulf, You said that this is a new instillation so I am not sure how you are getting this, but go into nuke_users_config and see what is set under version. It should say 2.30.01.

Posted: Tue Feb 24, 2009 1:36 pm

Palbin wrote:

spiritwulf, You said that this is a new instillation so I am not sure how you are getting this, but go into nuke_users_config and see what is set under version. It should say 2.30.01.

it shouldnt matter but just to clarify:

nuke1 would be the db table prefix
nuke would be the user db table prefix

nuke_users_config does not exist

nuke1_users_config does exist and shows version 2.30.01

Posted: Tue Feb 24, 2009 1:50 pm

I'll look into it.

Posted: Tue Feb 24, 2009 5:43 pm

Try to upload Your_Account again from the 2.30.01 files. The only reason I can think of for a blank at the end of the error is that you are running old files.

Code:




... your data base table is

Posted: Tue Feb 24, 2009 7:19 pm

Palbin wrote:

Try to upload Your_Account again from the 2.30.01 files. The only reason I can think of for a blank at the end of the error is that you are running old files.

Sorry, lost me there... Your_account?

And it is not possible for there to be old files unless they were in the Distro, this was a new server for me.

Ill try a few things on my own though and let you know if i have any luck.
Any assist is apreciated though.

Posted: Tue Feb 24, 2009 7:46 pm

Try reuploading the the modules/Your_Account folder.

Posted: Tue Feb 24, 2009 8:15 pm

The blank value for the version means that it couldn't find the nuke_users_config table.

What is the value of $user_prefix in your config.php file? If it's not defined or isn't equal to 'nuke' try changing that value in your config.php file.

You might also try renaming the tables to match the user_prefix, but much easier just to change $user_prefix value.

Posted: Wed Feb 25, 2009 3:53 am

kguske wrote:

The blank value for the version means that it couldn't find the nuke_users_config table.

What is the value of $user_prefix in your config.php file? If it's not defined or isn't equal to 'nuke' try changing that value in your config.php file.

You might also try renaming the tables to match the user_prefix, but much easier just to change $user_prefix value.

Yeah thats one of the things i was going to try.
And I did just try this. Dropped all tables to be sure. Changed config.php so the prefix's matched. Reinstalled the databases again.

Site is up and you can now register an account. But now you cant access the admin section. Get a message stating 'Sorry, this Module isn't active!'.
Bang Head

How can the Admin section NOT be active ?!?!?! ARG! lol