URL to your eFiction: http://www.athenewolfe.com/justrewards/
Version of eFiction: 2.06 upgrade to 3.2
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4
Version of MySQL: 4.0.27-standard
Have you searched for your problem: (yes/no) yes,
If so, what terms did you try: 1064, 2 WHERE nid = 1'
State the nature of your problem: Copy and paste any errors you are receiving.
A fatal MySQL error was encountered.
Query: UPDATE fangfanfiction_news SET comments = '2 WHERE nid = 1
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 ''2 WHERE nid = 1' at line 1
I thought I did everything right, I searched but I don't understand what this means and what I need to do to fix it. Please help!
In addition - I have been searching and wondered if somehow the problem was just an error (Because I can pull up my site) however when I hit the back button and tried again it said
A fatal MySQL error was encountered.
Query: alter table fangfanfiction_categories drop index category;
Error: (1091) Can't DROP 'category'. Check that column/key exists
So Still no clue how to handle this - any solutions or ideas would be lovely!
There's a missing single quote on line 241 of install/upgrade20.php
Replace it with this:
dbquery("UPDATE ".$tableprefix."fanfiction_news SET comments = '".$n['count']."' WHERE nid = ".$n['nid']);
HI! I replaced the text however I am now getting this
A fatal MySQL error was encountered.
Query: alter table fangfanfiction_categories drop index category;
Error: (1091) Can't DROP 'category'. Check that column/key exists
Where do I do that? Sorry to be such a bother but I can't seem to figure it out
You can't go back in the update. It's giving you that error because it's already deleted that index. You can try continuing on, but you may have to restore from your backup and start over.
Thank you Tammy.
Hy!
I would like edit my bio, but when I snap down to submit, display, that fatal mysql error...
Query: UPDATE fanfictionfanfiction_authors as author SET realname='', email='k.anna91@gmail.com', bio='', image='' WHERE uid = '1'
Error: (1064) You have an error in your SQL syntax near 'as author SET realname='', email='k.anna91@gmail.com', bio='', image='' WHERE ui' at line 1
what can I do something?
Please go read the instructions for posting a help request in the sticky threads at the top of this forum.
1. New problems go in new threads. Your problem is completely unrelated to this thread.
2. There is specific information requested when making a help request. Please include it.
