URL to your eFiction: fanfictionwriters.com
Version of eFiction:3.5.3
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.7, but my host upgraded to 5.3.x
Version of MySQL: 5.0.37
Have you searched for your problem: (yes/no)Yes
If so, what terms did you try:MYSQL error, different versions of php.
State the nature of your problem: Before I switched webhosts, I made sure all my databases remained on their server just in case I wanted to return. The only thing I did, I deleted the tables from my test database - my fanfiction archive remained intact. I then switched to a different provider. Big mistake. Anyway, I returned recently to my original webhost provider, but when I tried to upload the saved database tables to my test archive. I get this error message.
MySQL said:
#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 'PK' at line
I only get the error message when I try uploading in a zip format. When I try uploading using text or winwar format, the server times out. I'm only guessing, but could the different version in php be causing the problem? I had saved my databases when the webhost was using version 4.4.7, now my host has upgraded to 5.3.x.
Do you have a test account for us?No, because I cannot get the tables to load for the problem database.
Thanks for replying Sue. I wished I had found the link before I switched web providers.
