URL to your eFiction: http://fiction.spot-design.net/index.php
Version of eFiction: 2.0.6
Have you bridged eFiction, if so with what?: phpbb
Version of PHP: 4.4.4
Version of MySQL: 4.0.25
Have you searched for your problem: Yes
If so, what terms did you try: fatal MySQL error (under 3.0 upgrade support)
Have you looked at the FAQs: There is no FAQ for 3.0
State the nature of your problem:
When upgrading from 2.0.6 to 3.0 during step 2 I get this error:
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( '#@%&*', 'Spot Fiction', 'Fan Fiction Library', ' http://fiction.spot-design.net', '#@%&*', 'fic_', 'Spot Fiction', 'en', 1, 'stories', 'files', 1, 16000, 100, 1, 200, 300, 1, 1, '', 1, 1, 1, 90, 6, 10, 0 , 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, '', '', '', '');
Error: (2002) Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I censored my site info using #@%&* in this post.
I already had to add all the tables manually because it wouldn't work automatically. I password protected the install file for right now because I don't want anyone having access to it. If you need to access the upgrade let me know.
I think it's a problem with your host. That's usually the error you get when the mySQL server is down.
My host's mysql server isn't down. My other sites work and I can access mysql through phpMyAdmin. Do you still use dbconfig? because I cannot find the file and I cannot use localhost as the host because it won't work. The upgrade never asked me for the info.
I uploaded the dbconfig file (it had accidentally been deleted) and I have got it working. But now I am done with the upgrade (after a lot of problems with the sql) I have another error with my site which may be caused by the fact that the sql that was included with the upgrade kept getting errors because of incorrect syntax. Here is the error I am getting:
A fatal MySQL error was encountered.
Query:
Error: (1054) Unknown column 'member' in 'field list'
You have the featured author block installed. That's not a 3.0 block. It's a 2.0 block and is therefore breaking your site. Turn the block off. You'll need to edit the variables.php for your default skin to turn it off on that skin so you can get to your admin panel. There's another thread in this forum with the same problem, so I'll let you get the exact instructions from it.
