prefix changing

Hangin' Around Joined: Nov 14, 2006 Posts: 32

hello,

i had to change the prefixes from nuke to ravennuke.
because, i have another nukeinstallation on database, and two with same prefix does not work Wink

so i did it, and run the installer, first i always got error-message at step1 with the core files, there an error near line 1....
so i changed the sql-file in the install-sql and change all from nuke to ravennuke.
installer made same errormessage.
so i imported it in phpmyadmin manually.
step 2 and 3 works fine then with changed prefixes in the installer.

so the system works, but when i try to change in the nuke-admin-menue to change the general settings, maybe standardtheme or other things, it will not change, when i look in the database (phpmyadmin) there is always the old stuff in the table ravennuke_config.
other things works good, maybe to create news or such things, so this things will be written in the database.

can anyone help me please, where the error is? or how i must change in files?

thx

registered · Posted: Tue Nov 14, 2006 7:19 pm

Did you change config.php?

Posted: Wed Nov 15, 2006 2:13 am

you mean the prefix and userprefix in config.php?

yes i did.

Posted: Wed Nov 15, 2006 8:36 am

The prefix problem you referenced occurred in early releases of RN2.02 in some of the SQL load files. It had hard coded the prefix to "nuke" but that was fixed later so it would be picked up from config.php.

The config table is updated by the program /admin/modules/settings.php. I just looked at it and down toward the bottom where it updates the config table it is correctly using prefix. I'm wondering if you have a version that doesn't have that. The line in question is down in the configsave case section toward the bottom and reads:

Code:

 $db->sql_query("UPDATE ".$prefix."_config SET sitename='$xsitename', nukeurl='$xnukeurl', site_logo='$xsite_logo', slogan='$xslogan', startdate='$xstartdate', adminmail='$xadminmail', anonpost='$xanonpost', Default_Theme='$xDefault_Theme', foot1='$xfoot1', foot2='$xfoot2', foot3='$xfoot3', commentlimit='$xcommentlimit',

it goes on from there to update the rest of the config values. You might want to compare your file to that and/or refresh it with one from a newer distribution.

Posted: Wed Nov 15, 2006 8:47 am

hmm, i downloadet it befor some days here,
and it is the same code as you wrote.

so i think it is new version or not?

Posted: Wed Nov 15, 2006 8:50 am

i downloaded this one

http://www.ravenphpscripts.com/modules.php?name=Downloads&d_op=viewdownloaddetails&cid=26&lid=242&ttitle=RavenNuke76_v2.02.02_FULL_-_A_distro_with_all_patches_and_NukeSentinel_and_More#dldetails

Posted: Wed Nov 15, 2006 9:21 am

Well if you look in the INSTALLATION/sql directory at rn76_core_pl32.sql and it has

Code:

DROP TABLE IF EXISTS `nuke_authors`;

then you have the old version and if it has

Code:

DROP TABLE IF EXISTS $prefix.`_authors`;

as the first line then you have the correct version.

I'd probably re-upload the settings.php program I referenced earlier if you have the correct version. Then try again.

Posted: Wed Nov 15, 2006 10:54 am

DROP TABLE IF EXISTS `ravennuke_authors`;

i changed this before manually.

so i have old version?
hmm but its the latest i found here on site

Posted: Wed Nov 15, 2006 11:35 am

This is strange. You want 2.02.02 full and that's the link you gave before. But I downloaded that for testing purposes just a week or two ago and it's the correct one. It's not possible that you downloaded 2.02.00 is it? Could you redownload it and just make sure and then check that SQL file out again and post back here?

As I said before I have copies of 2.02.00 and 2.02.02 on my home computer and when I looked at the former it had nuke_authors hard coded whereas the latter had the prefix correctly.

Posted: Wed Nov 15, 2006 11:42 am

i downloaded it again some minutes before, and its the same.

after that i downloaded 2.02.00 too and there is the same too.

the version i found is from 20.4.06, this is the one i installed, and it´s 2.02.02.

hmm confous!

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

The v2.02.02 download is the same one that has been out there since 4/20/2006. $prefix was not available in that version. It is available in the upcoming v2.10.00

Posted: Wed Nov 15, 2006 4:03 pm

hmm ok, but when i do it with nuke i have by step1 this message:

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 'column' at line 1

Posted: Wed Nov 15, 2006 4:23 pm

Oh my! I realize what happened and I apologize. I edited my rn76_core_pl32.sql file after I had downloaded it from the site (here) to substitute prefix in for nuke. I can tell because my editor creates a backup file. The backup is dated from last April and the "fixed" file is dated from September when I was testing this.

Unfortunately the "nuke" prefix thing is throughout all the SQL files, including the compressed ones that come in the SQL directory (for IP2country). Could you possibly use two databases rather than have two sets of tables in one? That way you could use the Nuke prefix in both.

Again, I'm sorry for the confusion. As Raven states, RN2.10 will fix this situation once and for all.

Posted: Wed Nov 15, 2006 5:52 pm

Have you read this thread?

http://www.ravenphpscripts.com/postx8147-0-0.html

Posted: Thu Nov 16, 2006 2:00 am

no,
but i solved it, imported the case-db manually in phpmyadmin and the rest works with the installer.

thx