efiction transfer

the site key and the table prefix need to match. its the same procedure as restoring a backup

thank you, but how would i go about doing that?

I'm not sure, but try editing that row in the mysql database (fanfiction_settings row). Use something like the program phpMyAdmin to edit it. Rename the table to be brucas_efanfiction.fanfiction_settings through Operations, and then edit the row to use the sitekey
brucas_e.

And then of course, afterward it works, change them both to something else because you just told the world what your prefix is for your settings. 🙂

this is really complicated...i have a cpanel.  Is there a file that i can just edit and change the table name?

You can change the name of the table in your datatase. The database is not a file.

cpanel should have phpMyAdmin (mine does) under MySQL® Databases. Open it and try there, it should list phpMyAdmin somewhere at the bottom. Go the your database and open the fanfiction_settings part. Once opened, go to the Operations tab at the top and just rename it.

That helped big time but when I went to rename the table it said there was none in the first place so I created one.  However when I did I was not sure how many fields i needed or what info to fill out after it was created.  do you have some sort of idea?

The table might have a different name.

---

In eFiction32/docs/tables.sql it says:

--
-- Table structure for table `fanfiction_settings`
--

CREATE TABLE `fanfiction_settings` (
  `sitekey` varchar(50) NOT NULL default '1',
  `sitename` varchar(200) NOT NULL default 'Your Site',
  `slogan` varchar(200) NOT NULL default 'It''s a cool site!',
  `url` varchar(200) NOT NULL default ' http://www.yoursite.com',
  `siteemail` varchar(200) NOT NULL default 'you@yoursite.com',
  `tableprefix` varchar(50) NOT NULL default '',
  `skin` varchar(50) NOT NULL default 'default',
  `hiddenskins` varchar(255) default '',
  `language` varchar(10) NOT NULL default 'en',
  `submissionsoff` tinyint(1) NOT NULL default '0',
  `storiespath` varchar(20) NOT NULL default 'stories',
  `store` varchar(5) NOT NULL default 'files',
  `autovalidate` tinyint(1) NOT NULL default '0',
  `coauthallowed` int(1) NOT NULL default '0',
  `maxwords` int(11) NOT NULL default '0',
  `minwords` int(11) NOT NULL default '0',
  `imageupload` tinyint(1) NOT NULL default '0',
  `imageheight` int(11) NOT NULL default '200',
  `imagewidth` int(11) NOT NULL default '200',
  `roundrobins` tinyint(1) NOT NULL default '0',
  `tinyMCE` tinyint(1) NOT NULL default '0',
  `allowed_tags` varchar(200) NOT NULL default '<b><i><u><center><hr><p><br /><br><blockquote><ol><ul><li><img><strong><em>',
  `favorites` tinyint(1) NOT NULL default '0',
  `multiplecats` tinyint(1) NOT NULL default '0',
  `newscomments` tinyint(1) NOT NULL default '0',
  `logging` tinyint(1) NOT NULL default '0',
  `maintenance` tinyint(1) NOT NULL default '0',
  `debug` tinyint(1) NOT NULL default '0',
  `captcha` tinyint(1) NOT NULL default '0',
  `dateformat` varchar(20) NOT NULL default 'd/m/y',
  `timeformat` varchar(20) NOT NULL default '- h:i a',
  `recentdays` tinyint(2) NOT NULL default '7',
  `displaycolumns` tinyint(1) NOT NULL default '1',
  `itemsperpage` tinyint(2) NOT NULL default '25',
  `extendcats` tinyint(1) NOT NULL default '0',
  `displayindex` tinyint(1) NOT NULL default '0',
  `defaultsort` tinyint(1) NOT NULL default '0',
  `displayprofile` tinyint(1) NOT NULL default '0',
  `linkstyle` tinyint(1) NOT NULL default '0',
  `linkrange` tinyint(2) NOT NULL default '5',
  `reviewsallowed` tinyint(1) NOT NULL default '0',
  `ratings` tinyint(1) NOT NULL default '0',
  `anonreviews` tinyint(1) NOT NULL default '0',
  `revdelete` tinyint(1) NOT NULL default '0',
  `rateonly` tinyint(1) NOT NULL default '0',
  `pwdsetting` tinyint(1) NOT NULL default '0',
  `alertson` tinyint(1) NOT NULL default '0',
  `disablepopups` tinyint(1) NOT NULL default '0',
  `agestatement` tinyint(1) NOT NULL default '0',
  `words` text,
  `version` varchar(10) NOT NULL default '3.0',
  `smtp_host` varchar(200) default NULL,
  `smtp_username` varchar(50) default NULL,
  `smtp_password` varchar(50) default NULL,
  `anonchallenges` tinyint(1) NOT NULL default '0',
  `anonrecs` tinyint(1) NOT NULL default '0',
  `rectarget` tinyint(1) NOT NULL default '0',
  `autovalrecs` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`sitekey`)
) TYPE=MyISAM;

Create it, then edit it to have your info.

If the settings table is missing are the other tables missing?  You need to move the database as well as the files.

do you know how to move the mysql database settings aswell?

In the old database, you need to export the tables. You can try and export the whole thing, all the tables at once, but it might be too big. You should get text files, or sql files of the tables. Then, you log into the new one, and import all the tables.

If you need further instructions, there should be instructions for phpmyadmin online.

Dumping and restoring databases (scroll down almost half way)
http://software.newsforge.com/article.pl?sid=06/07/24/2034204&tid=72&tid=79&tid=138&pagenum=2

How can I restore (upload) my database or table using a dump? How can I run a ".sql" file? (scroll down to 6.5)
http://www.phpmyadmin.net/documentation/

http://www.phpmyadmin.net/documentation/#faqusing

http://drupal.org/node/81995

If you didn't do this before, you need to get ALL the tables, not just the settings one. The tables are what have your information about your site. The files themselves are just how the site runs- your files should be exactly like the files on my site, and everyone else's. It's the databse that has your authors and fics, and that makes your site unique.