URL to your eFiction: http://beyondcanon.brain-insane.com
Version of eFiction: 2.0 (in the process of upgrading to 3.0)
Have you bridged eFiction, if so with what?: No
Version of PHP: 2.7.0-pl2
Version of MySQL: MySQL 5.0.24
Have you searched for your problem: Yes (seen threads with similar syntax errors but none with the werid number thingy I am getting and they all seem to be post upgrade I am traped at step 2)
If so, what terms did you try: I have looked through all of the 3.0 support forums
Have you looked at the FAQs: theres not one for 3.0 that I have seen or found anyway
State the nature of your problem: Getting a werid syntax error when Upgrading 2.0 to 3.0. I'm have a 3.0 site with its own Database at http://amy.brain-insane.com and I didnt have any trouble with it so I am rather confused to this new problem...
anyway I get to step 2 of the upgrade and get:
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 ' '', '', , , , , 0, 0, , , '', , 1, , 0, 1, 10,
When I look at that I think it is a problem on my end and not with eFiction but if you give me some ideas of what the problem might be or why I would get it now and not with my other eFiction upgrade?
Ok it appears that I need to know what Collation to set the database to? This is new to me since this wasnt there when I changed over to the 3.0 beta over the summer... Help??
This seems like your config settings disappeared between step 1 and 2.
I had the same problem. See this thread for how to fix this, although it may be best to have Tammy or someone else official look it over first.
https://efiction.org/forums/index.php?topic=4183.0
Since your site is now up I'm going to assume you got it solved...and mark the thread accordingly.
