URL to your eFiction: ffuniverse.ulmb.com/site/
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: no
Version of PHP: 5.3.6
Version of MySQL: mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $
Have you searched for your problem: yes
If so, what terms did you try: I searched all topics on the 'Version 3.0 Installation and Upgrade Support' forum, searched eFiction wiki and Google.
State the nature of your problem:
So, I have tried to install eFiction version 3.5.3 and when I failed at that I tried 3.5. I have encountered the same problem and obviously got no idea how to get past it. I'm not experienced with MySQL or PHP, so please bare with me. For some reason the eFiction install cannot create tables itself (I get errors such as A fatal MySQL error was encountered.
Query: INSERT INTO `fanfiction_panels` (`panel_name`, `panel_title`, `panel_url`, `panel_level`, `panel_order`, `panel_hidden`, `panel_type`) VALUES ('submitted', 'Submissions', '', '3', '5', '0', 'A'); Error: (1146) Table '21332_ffu.fanfiction_panels' doesn't exist), so when I tried doing it via 'automatic' an error always popped up. I got into phpMyAdmin and created the tables manually via Query. But once I got to step 4, I encountered this problem, after putting in CREATE TABLE `fanfiction_panels` (`panel_name`, `panel_title`, `panel_url`, `panel_level`, `panel_order`, `panel_hidden`, `panel_type`) VALUES ('submitted', 'Submissions', '', '3', '5', '0', 'A') : #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 ' `panel_title`, `panel_url`, `panel_level`, `panel_order`, `panel_hidden`, `pane' at line 1
Any help on this matter would be great. Thanks in advance.
Well, the first error INSERT INTO failed because the table did not exist (can't insert fields without a table). Then, after creating the table manually, you try to create the table again (CREATE TABLE). What you want to do is run the INSTERT INTO statement again, not the CREATE TABLE. This should populate the fields.
You may want to run each .SQL file in the docs folder of the install (starting with tables.sql) in phpmyadmin to manually create all the tables/fields.
efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/
