Installing a second site on one database

Argus · Client Joined: Oct 06, 2003 Posts: 81

Hi there,

I installed a second 7.2 site onto one database. I editted my nuke.sql and changed every instance of nuke to another prefix. In installed the site, the chatserv patch and then ran an sql query on the .sql. The site comes up fine and there are a whack of things that work properly (I haven't tested everything yet), but the big problem is that I can't save any information in Preferences. I 2checked all my CHMOD settings and that wasn't the problem that I could see.

Any ideas?

Thanks,

-Arg

chatserv · Posted: Wed Jul 28, 2004 12:41 pm

Make a copy of the admin/modules/settings.php file, on one of the copies locate case "ConfigSave": near the end of the file and change it to:

Code:

case "ConfigSave":
global $prefix, $db;
$xsitename = htmlentities($xsitename, ENT_QUOTES);
$xslogan = htmlentities($xslogan, ENT_QUOTES);
$xbackend_title = htmlentities($xbackend_title, ENT_QUOTES);
$xnotify_subject = htmlentities($xnotify_subject, ENT_QUOTES);
$xsingleaccountname = htmlentities($xsingleaccountname, ENT_QUOTES);
$squery = "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', anonymous='$xanonymous', minpass='$xminpass', pollcomm='$xpollcomm', articlecomm='$xarticlecomm', broadcast_msg='$xbroadcast_msg', my_headlines='$xmy_headlines', top='$xtop', storyhome='$xstoryhome', user_news='$xuser_news', oldnum='$xoldnum', ultramode='$xultramode', banners='$xbanners', backend_title='$xbackend_title', backend_language='$xbackend_language', language='$xlanguage', locale='$xlocale', multilingual='$xmultilingual', useflags='$xuseflags', notify='$xnotify', notify_email='$xnotify_email', notify_subject='$xnotify_subject', notify_message='$xnotify_message', notify_from='$xnotify_from', moderate='$xmoderate', admingraphic='$xadmingraphic', httpref='$xhttpref', httprefmax='$xhttprefmax', CensorMode='$xCensorMode', CensorReplace='$xCensorReplace'";
$db->sql_query($squery);
echo "$squery";
break;

Upload this new file to the server and try to change the settings, post the results which will appear on a white page then make a backup of your $prefix_config db table (structure only) and post it as well.

Argus · Client Joined: Oct 06, 2003 Posts: 81

Code:

UPDATE cdg_config SET sitename='Disc Golf Canada', nukeurl='', site_logo='', slogan='', startdate='', adminmail='', anonpost='0', Default_Theme='DeepBlue', foot1='', foot2='', foot3='', commentlimit='0', anonymous='', minpass='0', pollcomm='0', articlecomm='0', broadcast_msg='0', my_headlines='0', top='0', storyhome='0', user_news='0', oldnum='0', ultramode='0', banners='0', backend_title='', backend_language='', language='english', locale='', multilingual='0', useflags='0', notify='0', notify_email='', notify_subject='', notify_message='', notify_from='', moderate='0', admingraphic='0', httpref='0', httprefmax='0', CensorMode='0', CensorReplace=''

Argus · Client Joined: Oct 06, 2003 Posts: 81

Is this what you wanted for structure?

Code:

Field Type Attributes Null Default Extra Action
sitename varchar(255)    No       Change Drop Primary Index Unique Fulltext
cdgurl varchar(255)    No       Change Drop Primary Index Unique Fulltext
site_logo varchar(255)    No       Change Drop Primary Index Unique Fulltext
slogan varchar(255)    No       Change Drop Primary Index Unique Fulltext
startdate varchar(50)    No       Change Drop Primary Index Unique Fulltext
adminmail varchar(255)    No       Change Drop Primary Index Unique Fulltext
anonpost tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
Default_Theme varchar(255)    No       Change Drop Primary Index Unique Fulltext
foot1 text    No       Change Drop Primary Index Unique Fulltext
foot2 text    No       Change Drop Primary Index Unique Fulltext
foot3 text    No       Change Drop Primary Index Unique Fulltext
commentlimit int(9)    No 4096    Change Drop Primary Index Unique Fulltext
anonymous varchar(255)    No       Change Drop Primary Index Unique Fulltext
minpass tinyint(1)    No 5    Change Drop Primary Index Unique Fulltext
pollcomm tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
articlecomm tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
broadcast_msg tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
my_headlines tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
top int(3)    No 10    Change Drop Primary Index Unique Fulltext
storyhome int(2)    No 10    Change Drop Primary Index Unique Fulltext
user_news tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
oldnum int(2)    No 30    Change Drop Primary Index Unique Fulltext
ultramode tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
banners tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
backend_title varchar(255)    No       Change Drop Primary Index Unique Fulltext
backend_language varchar(10)    No       Change Drop Primary Index Unique Fulltext
language varchar(100)    No       Change Drop Primary Index Unique Fulltext
locale varchar(10)    No       Change Drop Primary Index Unique Fulltext
multilingual tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
useflags tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
notify tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
notify_email varchar(255)    No       Change Drop Primary Index Unique Fulltext
notify_subject varchar(255)    No       Change Drop Primary Index Unique Fulltext
notify_message varchar(255)    No       Change Drop Primary Index Unique Fulltext
notify_from varchar(255)    No       Change Drop Primary Index Unique Fulltext
moderate tinyint(1)    No 0    Change Drop Primary Index Unique Fulltext
admingraphic tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
httpref tinyint(1)    No 1    Change Drop Primary Index Unique Fulltext
httprefmax int(5)    No 1000    Change Drop Primary Index Unique Fulltext
CensorMode tinyint(1)    No 3    Change Drop Primary Index Unique Fulltext
CensorReplace varchar(10)    No       Change Drop Primary Index Unique Fulltext
copyright text    No       Change Drop Primary Index Unique Fulltext
Version_Num varchar(10)    No       Change Drop Primary Index Unique Fulltext

chatserv · Posted: Wed Jul 28, 2004 1:15 pm

A structure only backup will be easier to compare with the results from the other test.

Argus · Client Joined: Oct 06, 2003 Posts: 81

Code:

# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 28, 2004 at 03:22 PM
# Server version: 4.0.20
# PHP Version: 4.2.3
#
# Database : `generalm_nuke1`
#

# --------------------------------------------------------

#
# Table structure for table `cdg_config`
#

CREATE TABLE `cdg_config` (
`sitename` varchar(255) NOT NULL default '',
`cdgurl` varchar(255) NOT NULL default '',
`site_logo` varchar(255) NOT NULL default '',
`slogan` varchar(255) NOT NULL default '',
`startdate` varchar(50) NOT NULL default '',
`adminmail` varchar(255) NOT NULL default '',
`anonpost` tinyint(1) NOT NULL default '0',
`Default_Theme` varchar(255) NOT NULL default '',
`foot1` text NOT NULL,
`foot2` text NOT NULL,
`foot3` text NOT NULL,
`commentlimit` int(9) NOT NULL default '4096',
`anonymous` varchar(255) NOT NULL default '',
`minpass` tinyint(1) NOT NULL default '5',
`pollcomm` tinyint(1) NOT NULL default '1',
`articlecomm` tinyint(1) NOT NULL default '1',
`broadcast_msg` tinyint(1) NOT NULL default '1',
`my_headlines` tinyint(1) NOT NULL default '1',
`top` int(3) NOT NULL default '10',
`storyhome` int(2) NOT NULL default '10',
`user_news` tinyint(1) NOT NULL default '1',
`oldnum` int(2) NOT NULL default '30',
`ultramode` tinyint(1) NOT NULL default '0',
`banners` tinyint(1) NOT NULL default '1',
`backend_title` varchar(255) NOT NULL default '',
`backend_language` varchar(10) NOT NULL default '',
`language` varchar(100) NOT NULL default '',
`locale` varchar(10) NOT NULL default '',
`multilingual` tinyint(1) NOT NULL default '0',
`useflags` tinyint(1) NOT NULL default '0',
`notify` tinyint(1) NOT NULL default '0',
`notify_email` varchar(255) NOT NULL default '',
`notify_subject` varchar(255) NOT NULL default '',
`notify_message` varchar(255) NOT NULL default '',
`notify_from` varchar(255) NOT NULL default '',
`moderate` tinyint(1) NOT NULL default '0',
`admingraphic` tinyint(1) NOT NULL default '1',
`httpref` tinyint(1) NOT NULL default '1',
`httprefmax` int(5) NOT NULL default '1000',
`CensorMode` tinyint(1) NOT NULL default '3',
`CensorReplace` varchar(10) NOT NULL default '',
`copyright` text NOT NULL,
`Version_Num` varchar(10) NOT NULL default '',
PRIMARY KEY (`sitename`)
) TYPE=MyISAM;

#
# Dumping data for table `cdg_config`
#

INSERT INTO `cdg_config` VALUES ('PHP-cdg Powered Site', 'http://yoursite.com', 'logo.gif', 'Your slogan here', 'March 2004', 'webmaster@yoursite.com', 0, 'DeepBlue', '<a href="http://phpcdg.org" target="blank"><img src="images/powered/powered5.jpg" border="0" Alt="Web site powered by PHP-cdg" hspace="10"></a> ', 'All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2002 by me.', 'You can syndicate our news using the file <a href="backend.php">backend.php</a> or <a href="ultramode.txt">ultramode.txt</a>', 4096, 'Anonymous', 5, 1, 1, 1, 1, 10, 10, 1, 30, 0, 1, 'PHP-cdg Powered Site', 'en-us', 'english', 'en_US', 0, 0, 0, 'me@yoursite.com', 'NEWS for my site', 'Hey! You got a new submission for your site.', 'webmaster', 0, 1, 1, 1000, 3, '*****', 'Web site engine code is Copyright © 2003 by <a href="http://phpcdg.org">PHP-cdg</a>. All Rights Reserved. PHP-cdg is Free Software released under the <a href="http://www.gnu.org">GNU/GPL license</a>.', '7.2');

chatserv · Posted: Wed Jul 28, 2004 4:47 pm

After comparing both it shows they match in field numbers so that is not the cause, for the next test copy the contents of the foot lines to a file and save for later, in the preferences section empty the foot lines and try to save the settings.

Argus · Client Joined: Oct 06, 2003 Posts: 81

You'll have to explain what you need. Sorry - In the preferences section, there are no foot lines. It's empty.

chatserv · Posted: Wed Jul 28, 2004 5:50 pm

Footer Lines 1, 2 & 3 are empty? odd, the test we ran first showed content being sent for the 3.

Argus · Client Joined: Oct 06, 2003 Posts: 81

Hmm this is strange - one sec - I'll show you a screen cap

Argus · Client Joined: Oct 06, 2003 Posts: 81

Argus · Client Joined: Oct 06, 2003 Posts: 81

The whole form is blank and all radio buttons are set at No. Yet it looks like the default prefs are showing,

chatserv · Posted: Wed Jul 28, 2004 6:14 pm

Thanks for the screenshot that explains it a lot better, it's clear for some reason data is not getting pulled from the db table, please check if the table has content in its fields (click on browse through phpMyAdmin), if the data is there (i.e. the foot lines) then we need to find out why it is not getting read, for that i would need to check the files and db myself so if you decide upon this last option pm me the login data for both.

Argus · Client Joined: Oct 06, 2003 Posts: 81

Heya,

So since our pm's, I re-installed all the files minus the patch. I re-installed the database and I still have the same problem. Is it possible that it is somehow related to the sub-domain?

Thanks,

-Arg

Argus · Client Joined: Oct 06, 2003 Posts: 81

Well, I deleted the sub-domain and it's still the same. I also manually chmodded everything to 644 and 755. Situation No Change.

Argus · Client Joined: Oct 06, 2003 Posts: 81

What a funny thing....

Ok so I have the solution. On line 956 of nuke.sql there is a field in the $prefix_config table called nukeurl_varchar.

Thinking it would be easy, originally when renaming my prefixes from nuke to XXX I did a replace all. My bad as this field name was changed also and so that section didn't work anymore.

Thanks for the help.

-Arg