This may not be the appropriate area to ask this question, so bear with me.
We are in the middle of upgrading our eFiction to 3.3.1 from 2.0.7. The script is customized in a lot of areas, and that meant that we couldn't just upgrade in the traditional manner.
What we did was make a copy of the folder and database, upgraded the copy, and began making the necessary fixes/changes from there.
The problem is that our main site is still live, therefore people are still adding new stories, chapters, reviews, et cetera to the original database.
What I *tried* to do was make tables and just insert the new data and then "upgrade" that using the information from upgrade.php. For some reason, though, one of the SQL commands didn't work.
ALTER TABLE `reviewcopy` SET type = 'ST' WHERE item > 0
What is wrong there?
URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
Looks fine. What's the error? It may be something in the table not in the sql statement.
*blushes* That should have been "update," which works. Oops.
URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
