URL to your eFiction: http://amothea.slashcity.com/db/index.php
Version of eFiction: 2.07 originally
Have you bridged eFiction, if so with what?: I hvae no clue what that means
Version of PHP: 4.1.22
Version of MySQL: 4.1.22
Have you searched for your problem: Yes
If so, what terms did you try: Every sql error message I got.
State the nature of your problem: First I tried to upgrade from 2.07 to 331. On step three of the upgrade it said something about making sure you used one of the skins provided in the 331 folder. However there was no next button so instead of stopping right there and coming over here to find out what's up with that. I went to the url and typed in 4 to skip ahead to next step. The rest of the installation went okay and then I went to my site and got some news error messages and my blocks were completely missing. I couldn't even see anything under settings. By now I'd already deleted all the files it said were safe to delete and chmod my config to the number it said to use. So last night I restored my database with the one I'd backed up from last week before I'd made any upgrades or changes. I moved back over all my files from 2.03 and now I got my directory filled with 3.31 files and 2.03 and when I go to my website I get these error messages.
Warning: include_once(_BASEDIRblocks/info/en.php) [function.include-once]: failed to open stream: No such file or directory in /home/amothea/public_html/db/blocks/info/info.php on line 5
Warning: include_once() [function.include]: Failed opening '_BASEDIRblocks/info/en.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/amothea/public_html/db/blocks/info/info.php on line 5
Fatal error: Call to undefined function dbrow() in /home/amothea/public_html/db/blocks/info/info.php on line 9
I don't want to screw things up even more since I obviously have no clue what I'm doing. Can someone please help me get my archive back to what it was before I started this upgrade?
Do you have a test account for us? I have no test account, though in retrospect I really need one.
edit: I deleted everything but my story folder and re-uploaded.
the error messages went away but I'm left with new problems I get this error message
Warning: fopen(messages/help.txt) [function.fopen]: failed to open stream: Permission denied in /home/amothea/public_html/db/admin/settings.php on line 32
anytime I try to change my settings like the welcome message for example. I've chmodded my config.php file to 666 so I have no clue why I keep getting this error message.
edit2: anytime I select on a category like http://amothea.slashcity.com/db/categories.php?catid=182 I get this error message.
A fatal MySQL error was encountered.
Query: SELECT stories.*, stories.title as title, author.penname, DATE_FORMAT(stories.updated, '%Y.%m.%d') as updatesort, DATE_FORMAT(stories.date, '%m/%d/%y') as date, DATE_FORMAT(stories.updated, '%m/%d/%y') as updated FROM fanfiction_authors as author, fanfiction_stories as stories WHERE FIND_IN_SET(182, stories.catid) > 0 AND stories.uid = author.uid AND stories.validated = '1'_ORDERBY LIMIT 0, 10
Error: (1064) 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 '_ORDERBY LIMIT 0, 10' at line 1
edit 3: in regards to edit 2 I found the problem and re-uploaded languages/en.php and en.js files and now I can access categories.
edit: 4 in regards to edit 1 I found the solution to the problem. My message folder needed to be chmoded to 755 and messages to 666. So that's working now.
in fact it looks like I solved all these problems. Solution to original problem was deleting everything but story folder and then re-upload the files.
I'm still not sure why the 2.07 isn't back but 2.05 isn't so bad.
