URL to your eFiction:
http://www.always-fanfic.net/eFiction/
Version of eFiction:
1.1 to 3.0.2
Have you bridged eFiction, if so with what?:
no
Version of PHP: can be found out from your host
4.4.4
Version of MySQL: can be found out from your host
4.1.21-standard
Have you searched for your problem: (yes/no)
yes
If so, what terms did you try:
unknown column sitekey, unknown column, sitekey and got nothing relevant to my problem
State the nature of your problem: Copy and paste any errors you are receiving.
Sigh, I changed hosts replaced my files and I got this error at step 2
A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'TFke9sUwNE', 'always-fanfic.net', 'Not your ordinary Website', 'always-fanfic.net', 'webmistresses@always-fanfic.net', 'ff_', 'bluepurple', '', 0, 'stories', 'mysql', 1, 0, 0, 0, 200, 200, 0, 0, '* ', 1, 1, 1, 0, 1, 15, 0 , 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, '', '', '', '');
Error: (1054) Unknown column 'sitekey' in 'field list'
Do you have a test account for us?
?? no but if you mean on efiction, I can create one now.
You don't have the 3.0 files up on the site.
Hm, that's wierd cause I do, maybe I'm missing a few. Will upload it again, thanks.
Well I don't think the index.php is the 3.0 version because if it was, you'd be automatically taken to the upgrade script.
I'm still getting the error, Tammy and I uploaded all my 3.0 files. And if you go to the index page its says that it sees the 1.1, what is going on.
A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'L9tMeZduJc', 'always-fanfic.net', 'Not your ordinary Website', 'always-fanfic.net', 'webmistresses@always-fanfic.net', 'ff_', 'bluepurple', '', 0, 'stories', 'mysql', 1, 0, 0, 0, 200, 200, 0, 0, '* ', 1, 1, 1, 0, 1, 15, 0 , 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, '', '', '', '');
Error: (1054) Unknown column 'sitekey' in 'field list'
nevermind I'm working on something, trying to do the settings automatically instead of manually.
Okay this is driving me crazy and has for like weeks now dont know what to do. I tried go back to the index and when I did it automatically I got this error message.
A fatal MySQL error was encountered.
Query: RENAME TABLE ff_fanfiction_settings TO ff_fanfiction_settings_old
Error: (1050) Table 'ff_fanfiction_settings_old' already exists
Now I do have the ff settings there cause when I changed hosts, I moved everything as is. So I just re uplaoded my saved database. here's what I ahve
* Browse fanfiction_authors
* Browse fanfiction_categories
* Browse fanfiction_characters
* Browse fanfiction_comments
* Browse fanfiction_favauth
* Browse fanfiction_favstor
* Browse fanfiction_genres
* Browse fanfiction_news
* Browse fanfiction_ratings
* Browse fanfiction_reviews
* Browse fanfiction_settings
* Browse fanfiction_settings_old
* Browse fanfiction_stories
* Browse fanfiction_warnings
* Browse ff_fanfiction_authorfields
* Browse ff_fanfiction_authorinfo
* Browse ff_fanfiction_authorprefs
* Browse ff_fanfiction_authors
* Browse ff_fanfiction_categories
* Browse ff_fanfiction_characters
* Browse ff_fanfiction_comments
* Browse ff_fanfiction_favauth
* Browse ff_fanfiction_favstor
* Browse ff_fanfiction_genres
* Browse ff_fanfiction_news
* Browse ff_fanfiction_ratings
* Browse ff_fanfiction_reviews
* Browse ff_fanfiction_settings
* Browse ff_fanfiction_settings_old
* Browse ff_fanfiction_stories
* Browse ff_fanfiction_warnings
* Browse settingsfanfiction_settings
* Browse sl18_category
* Browse sl18_chapters
When I tried to do the settings manually I get this same error:
', 1, 1, 1, 0, 1, 15, 0 , 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, '', '', '', '');
Error: (1054) Unknown column 'sitekey' in 'field list'
I'm completely at a loss, I havent the faintest clue anymore.
You started over part way through the upgrade without restoring your database back to where it started. Delete the extra tables (You've got 2 sets plus the settings_old tables in both) Then start over.
Okay redid it and just when I think we were getting somewhere, i got this:
Fatal error: Call to undefined function: strrchar() in /home/**/public_html/eFiction/install/upgrade11.php on line 915
Are you using an old copy of the .zip? That was fixed in the 3.1 update.
Nevermind, I did a search Tammy for this error message and I saw where youhad to take out the a out of strrchar and it works!!
FINALLY, now I'm going to delete the files that it told me to and chmod the config file to 644, thank goodnesslol.
